quilhasoft / jasperphp Goto Github PK

On a report with two detail bands, the first one have a field that stretchs with its contents, the expected behavior is to move the following band down but it gets overwritten.

Looks like the stretched field isn't stretching its parent band

Image of sample is attached.

Is conditional color supported? tried to add directly via html <font color"red">
however without success, I would like to know what is the recommended way to work with conditional colors, for example I wanted to display a zebra listing with conditioned color.

I'm working here, trying to start support for the table component, when generating initial support, can we work together to optimize support?

Oi galera do JasperPHP, como posso ajudá-los?

conditional print how to use?
I have reports that I basically use two functions for.
New Boolean and the AND() and OR() functions all native to jasper report, I realize that JasperPHP doesn't work I would like to know what is the recommendation to work with conditional print and how I can adapt my example:
printWhenExpression:

AND(new Boolean($F{invoice_bar_code} != null), new Boolean($F{invoice_payment_form_id} != 4) )

I have been using the rectangle component, but it does not respect the application of the border, how can we check to solve this? or am i doing something wrong?

Grettings,

I have a iReport file with 3 pages wich contains some fields and controls but when i test the report in pdf generation this shows the fields with another position, i make a video for a better explain, this is the link https://youtu.be/yKdgeFYh7dI.

I hope, you can help me because i'm workin in this project some weeks and i need finish this work.

Thakns,

Omar

Currently only supported dbData is an array of objects.

It should be possible to accept an array of arrays and an object that is Traversable/Countable/ArrayAccess ... this is very common on Laravel's Eloquent ORM.

Will be submitting soon a PR that adjusts this.

how to work with this type of parameter, used for example to pass sql statements, I know it may be a failure for sql injector but it will not be used for parameter edited by the user and in jasperReporta it works normally. I wanted to know how to adopt in your api.

select * from pessoa where ($P!{p_where})

??

When using groups on jasper file it doesn't group the records accordingly.

I have a "cidades" listing grouped by "mesoregioes" and "estados"

Following image shows the output of jaspersoft studio and jasperphp repesctively:

I've tested without the nested groups, same problem.

What is the best way (is supported any) to format monetary numbers and dates on the report?

When using the band Title there is an unknown variable being referenced: $rowIndex.

I do not know what is expected, I changed my local code to point to the first record if datasource is an array:

diff --git a/src/Title.php b/src/Title.php
index 121b256..c94f406 100644
--- a/src/Title.php
+++ b/src/Title.php
@@ -20,8 +20,7 @@ class Title extends Element {
         $recordObject = array_key_exists('recordObj', $arrayVariable) ? $arrayVariable['recordObj']['initialValue'] : "stdClass";
         // echo  $recordObject;
         //var_dump($obj);
-        $row = ( is_array($dbData) ) ? (array_key_exists($rowIndex, $dbData)) ? $dbData[$rowIndex] : null : $obj->rowData;
-        //$obj->rowData = $row;
+        $row = ( is_array($dbData) ) ? (array_key_exists(0, $dbData)) ? $dbData[0] : null : $obj->rowData;
         if ($row) {
             switch ($row) {
                 case (is_object($row)):

hey there, here mysql database working fine without any problem but how can i use JSON data and here JASPER Variable like report count does not work

Look guys, I'm facing a problem of misconfiguring the positioning of the text fields when generating in jasperphp I would like to know if there is any detail to be done to avoid this, the report generated in jasper studio and jasperphp is attached.

Does this library support PHP 7?

After try this I can see items and fields on page header, column header and detail but I can't see items on Column footer band or page footer band

PDF generated by app

I have tried with "composer require quilhasoft/jasperphp" but it doesn't work.

I am using PHP 8.0 and getting following errors, is there a known issue to run under php 8.0?

Fatal error: Uncaught Error: Non-static method JasperPHP\StaticText::formatPen() cannot be called statically in /var/www/html/reports/MyCode/jasperPHP_20211007/quilhasoft/jasperphp/src/StaticText.php:204 Stack trace: #0 /var/www/html/reports/MyCode/jasperPHP_20211007/quilhasoft/jasperphp/src/StaticText.php(62): JasperPHP\StaticText::formatBox() #1 /var/www/html/reports/MyCode/jasperPHP_20211007/quilhasoft/jasperphp/src/Band.php(26): JasperPHP\StaticText->generate() #2 /var/www/html/reports/MyCode/jasperPHP_20211007/quilhasoft/jasperphp/src/Element.php(174): JasperPHP\Band->generate() #3 /var/www/html/reports/MyCode/jasperPHP_20211007/quilhasoft/jasperphp/src/ColumnHeader.php(37): JasperPHP\Element->generate() #4 /var/www/html/reports/MyCode/jasperPHP_20211007/quilhasoft/jasperphp/src/Element.php(174): JasperPHP\ColumnHeader->generate() #5 /var/www/html/reports/MyCode/jasperPHP_20211007/quilhasoft/jasperphp/src/Report.php(668): JasperPHP\Element->generate() #6 /var/www/html/reports/MyCode/Report001/report.php(26): JasperPHP\Report->generate() #7 /var/www/html/reports/MyCode/Report001/report.php(59): TJasper->outpage() #8 {main} thrown in /var/www/html/reports/MyCode/jasperPHP_20211007/quilhasoft/jasperphp/src/StaticText.php on line 204

internationalization

automate support to decimal and thousand points
use php internationalization classes to get names off month, week days and number names

When using php 8.2 tcpdf have some failures with the bad use of strpos inverting the parameters.

Solution appears to be update to recent tcpdf

Boa Tarde,

Acho que não entendi a documentação.

Mais eu baixei a pasta descompactei, edite o dev.ini criei um arquivo.php com o contéudo da documentação, criei um template.jrxml somente com texto(sem acesso no banco de dados) apenas pra teste mesmo; coloquei o e chamei no browser o arquivo.php, mais acusa:

localhost não consegue atender a esta solicitação no momento.

Desde já agradeço

Dear,

How to send print direct to printer?

header page inside the subreport does not repeat when we have more than 1 (one) page, is there how we can handle this to force repeat inside the subreport?

Hello, this project has gotten better and better, and it will really make reporting a lot easier, especially for those who don't want to rely on java generators.

And I hope it gets better and better!
See only COLUMN HEADER is supported in JASPERPHP generator, but there is a behavior that we could improve, the COLUMN HEADER in its default behavior is repeated on all pages (in JASPER STUDIO), but in JASPERPHP this does not happen, how could we implement this behavior? wouldn't it be possible to make HEADER COLUMN REPEAT?

Estimados amigos,

Quisiera su ayuda, no se de que manera podría resolver el problema de que al momento de utilizar una expresión lógica en un campo de mi reporte JasperReport, al presentar se en PDF se visualiza la formula, cuando debería presentarse el contenido.

He utilizado variables para poder realizar la evaluación lógica antes de usar el campo directamente, pero aun así se da el problema.

Cabe indicar que he actualizado la librería con la ultima versión de Julio-2021.

Visualización del PDF

Visualización del Preliminar en JasperStudio 6

Agradezco de antemano por su ayuda.

Saludos,

Omar Noboa

Grettings,

I've implemented your class in my project, when i process the pdf no shows images.
Please tell me how can i do for shows the images.

Thanks,

Omar Noboa

There is the possibility of adding support to the frame element, as I use it to group elements within the report and allowing, for example, to apply a specific placement in the frame and it auto-adjusts to the content that contains them

i want to integrate this library in my project.but i can't,can u please help me

Estimados todos, tengo un problema al querer exportar un reporte que contiene Sub-reportes, en el Jasper Report 6.0 no me presenta ningún problema, se muestra correctamente, pero al momento de ejecutarlo en la aplicación, me aparece el error que indica que no se encuentra el archivo, he intentado poniendo solo el nombre del reporte (que esta en el mismo directorio que el principal) y poniendo la ruta completa del archivo, pero de ninguna de las dos maneras muestra el reporte.

Adjunto el mensaje de error:

Fatal error: Uncaught JasperPHP\Exception: File http://localhost:8089/hrmedic/jasperphp/report/rpthisrec.jasper not found!! in C:\xampp\htdocs\hrmedic\JasperPHP\src\Report.php:47 Stack trace: #0 C:\xampp\htdocs\hrmedic\JasperPHP\src\Subreport.php(40): JasperPHP\Report->__construct('http://localhos...', Array) #1 C:\xampp\htdocs\hrmedic\JasperPHP\src\Band.php(26): JasperPHP\Subreport->generate(Object(JasperPHP\Report)) #2 C:\xampp\htdocs\hrmedic\JasperPHP\src\Element.php(174): JasperPHP\Band->generate(Object(JasperPHP\Report)) #3 C:\xampp\htdocs\hrmedic\JasperPHP\src\GroupHeader.php(40): JasperPHP\Element->generate(Array) #4 C:\xampp\htdocs\hrmedic\JasperPHP\src\Element.php(174): JasperPHP\GroupHeader->generate(Object(JasperPHP\Report)) #5 C:\xampp\htdocs\hrmedic\JasperPHP\src\GroupHeader.php(40): JasperPHP\Element->generate(Array) #6 C:\xampp\htdocs\hrmedic\JasperPHP\src\Detail.php(44): JasperPHP\GroupHeader->generate(Object(JasperPHP\Report)) #7 C:\xampp\htdocs\hrmedic\JasperPHP\src\Element.php(174): JasperPHP\Detail->ge in C:\xampp\htdocs\hrmedic\JasperPHP\src\Report.php on line 47

En Jasper Report 6.0 Preview

Olá amigos estou tentando por a logo nos carnês mas o parâmetro logoPath não funciona, alguém sabe de uma solução para isso? obrigado

Building a title with elements in the same report I have no problem, but as I work with a standard header I decide to work with subreport, in the subreport I just left the band title and left the subreport page extremely small, I also reduce the size of the subreport in the main report. title band, however it generates an empty space in the title region, see the image, there is something that can be done for this, because the idea of using a subreport in the title makes it much easier.

Mestre,

Estou tentando usar o JasperPHP no Laravel, coloquei um report de teste dentro da pasta public, e a pasta config com a configuração do BD pra teste e ao tentar imprimir recebo o seguinte erro:

[2020-05-04 14:29:52] local.ERROR: JasperPHP\Element::__construct(): Node no longer exists {"exception":"[object] (ErrorException(code: 0): JasperPHP\Element::__construct(): Node no longer exists at E:\Web_Projetos\teste-boleto\vendor\quilhasoft\jasperphp\src\Element.php:28)

laravel-2020-05-04.log

Minha classe pra carregar os reports:

LoadReport.php.txt

e o método que chama o report:
public function teste4() {
TTransaction::open("dev");
TTransaction::setLogger(new TLoggerHTML("log.html"));
$jasper = new LoadReport("reports/testeCS.jrxml", array());
$jasper->outpage();

}

desde já agradeço a atenção recebida.

Barcode element doesn't respect the position defined on XML

The sample attached have two elements, a rectangle and a barcode, both with same position and dimensions, but barcode ends outside the defined on the report.

Barcode "Code Expression" property is not interpreted before rendering, so it works only with static codes.

Olá, Rogério. Gostaria de saber se o JasperPHP oferece suporte a filtros sql que utilizam parâmetros Java Collection no JasperReports. Consultas como a seguinte:

SELECT * FROM bd_banco.contratos WHERE $X{IN, idCampanha, FILTRO_ID} AND $X{IN, idStatus, FILTRO_STATUS}

Desde já, agradeço a atenção.

@Rctnet boa tarde!
Este projeto roda na hospedagem compartilhada do hostgator?
Obrigado!