nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Print multiple reports, chosen by multiple parameters

ag1234567890

Hello,
 
I've created a report, the first one we are going to use with our Magento extension so we are not yet into Birt Reports and its functions.
I googled during the last days but I did not find a good solution that works.
 
My specific report is an invoice and the report is being selected by our Magento extension. We enter a parameter on start which selects the stuff for our report.
The report works without a problem.
But now my customers asked for a way to batch print reports, which means they want to start the report, enter multiple parameters (seperated by ","), and multiple birt reports should be shown. A page for each.
 
I hope you understand it. I found the request a bit weird, but understandable if you want to quickly print many invoices of course.
 
I've already tried some stuff, such as setting my parameter as dynamic list box to select more than one but as a newb to it, I cant find a solution.
Anyone got an idea or an example report?
 
Thanks
 
ps: my birt version is up2date

Find more posts tagged with

Comments

Clement Wong

Welcome to the BIRT community. With BIRT, there's always more than one way to do things.
 
I'm not familiar with your Magento extension, but from what I understand from the requirements, there should just be a few simple modifications to your report design, depending on your design/data source.
 
The "before" attached example is the included SalesInvoice example included in the OS BIRT Designer (Window > Show View > Other... > Report and Chart Design > Report Examples > Solution Reports > Business Forms).
 
The "after" attached example illustrates one option so that multiple order numbers as a comma separated list generates each invoice on a separate page.
 
Modifications made:
1. Changed the report parameter type (was a Decimal) to String.
 
2. Changed the Data Set SQL query clause from:
<pre class="_prettyXprint">
AND CLASSICMODELS.ORDERS.ORDERNUMBER = ?</pre>
To:
<pre class="_prettyXprint">
AND CLASSICMODELS.ORDERS.ORDERNUMBER = 10100</pre>
as a place holder. You'll change the beforeOpen event later to make it dynamic in Step 4.
 
3. Deleted the Parameter "OrderNumber" from the Data Set.
 
4. Select the Data Set's Script. Add the following in the beforeOpen event:
<pre class="_prettyXprint">
inClause = "CLASSICMODELS.ORDERS.ORDERNUMBER IN ( " + params["OrderNumber"].value + ") ";
this.queryText = this.queryText.replace("CLASSICMODELS.ORDERS.ORDERNUMBER = 10100", inClause);</pre>
5. Drag the Data Set (Invoice Data in my example) out
 
6. Select ORDERNUMBER as the column to display/bind
 
7. Create a new Group in the table. Group on "ORDERNUMBER". Change the Page break > After: from Auto to Always Excluding last.
 
8. Delete any child report items that Step 5 may have created in the table such as the ORDERNUMBER label and Data Item.
 
9. Drag the contents of the existing report into the Group header.
 
10. Select on the Table and add a new Filter
<pre class="_prettyXprint">
row["ORDERNUMBER"] Equal To row._outer["ORDERNUMBER"]</pre>
If you run the report, you'll see two pages (with the default parameter), one for each order number.

ag1234567890

Hey,
 
thanks for that quick answer and in such a detail! Helps a lot. I'm still trying to figure out how to properly work with Birt Report. It's quite a nice tool with many possiblities.
 
Thank you!

ag1234567890

Okay,
 
I've followed your steps and created a new report by that, I've done every step and checked with the other report you've uploaded.
Now the report works, I can start it after I uploaded it to Magento. I added a ceckfield for the report ID on the report and once it runs it shows the correct ID.
A second page with the second report works as well, it just always shows both invoice items on both pages and it only shows values of the first invoice.
 
The table for invoice items and invoice values is at the Detail row and in the Group Footer Row in the inner table. The address at top that works correctly in both first and second report is in the header group row of the inner table. If I was putting stuff in the top, it always works so I guess my inner table is still not working correctly.
 
I've uploaded my rptdesign. Without database stuff (SQL still there of course!) as you cant address it from outside of our LAN anyway. I'm not sure if it helps you??
 
I highly appreciate any answer!
 
Wish you a nice weekend.

Clement Wong

Since I am not able to run your report from my end, I changed the Data Source to the Classic Models sample database and made aliases for the column names you have in your database. There were just a "few" to aliases to add.
 
After I ran the report, and it shows up as expected. Two pages, each order on its own page.
 
I did not make any structural changes to the report. Only three changes were made: The Data Source (switched to Classic Models db) and Data Set (changed SQL and commented beforeOpen code).
 
I ran this on a few versions of OS BIRT (4.4.2 for example) and commercial BIRT (iHub 3.1) and same expected result. What version are you using?
 
The data returned by your SQL statement should not make a difference because the outer table is filtering out each order.
 
If you can replicate the behavior you are seeing with Classic Models and let me know what type (OS or Commercial) and version of BIRT you are running, I can take a look further next week.

ag1234567890

I really have to thank you. I've just tried what you described and it worked perfectly fine with that replacement. That obviously means the mistakes is on my side, and it is indeed. It is quite weird, but I'm really happy it was my mistake.
First my SQL Query was wrong, it gave me both order items for one invoice order... and later I've also noticed I used the wrong entity_id in my SQL as well.
 
Then after trying for some hours, my report was broken as well, didnt create any ResultSet but that wasnt the point tho.
 
Thanks a lot...

Clement Wong

Good to hear that it is now working!