Badge with tickets on separate pages

[Francine]

I need to print badges on the first page and the following pages should be the applicable tickets for that badge.
The page size needs to be 4"x4".
I am using 2 tables: one for the registrants info and one for the applicable tickets for each registrant. I have added a relation between those 2 tables.

Then I tried to use a sub report and put the property of the databand in subreport for new page before to true and set skip first to false. But when I set the skip first to true there is no page for the sessions data even though the registrant has at least 1 session.

I have tried also to use 2 pages and set the collate to 2 but the page 2 is not linked properly to the data from page 1.
I have tried many combination with many option but cannot get it to work.
I am used to use Crystal report with sub report without any problems but cannot get it to work with Stimulsoft for PHP.

What is the solution for this situation?

[HighAley]

Hello.

You can put several Data Bands on one page.
Usually, it's possible to create reports without sub-report.
We don't see the schema of your data but it seems that you should create master-detail report.

Thank you.

[Francine]

I was able to figure out the necessary properties to use sub reports. If the first record has data for the subreport 1 and/or subreport2, the subreport1 and subreport2 are not displaying the data. If I had a record prior to that same record, the subreport1 and/or subreport2 display the data properly. I have tried many combination of different properties but could not make it work properly all the way.
I have attached a zip file with the report and the sql tables data that I am using. In the BadgeRegistrants table you will find that there are 2 different type of data for the sessionid field. So if you run the report to query the record for the first sessionID you will see that the dance tickets are not appearing. IF you try then with the second sessionID which as a record prior to the record from the previous sessionID, you will see that the 2 dance tickets appear.

[HighAley]

Hello.

It's possible to use several Data Bands on one page of the report template. So try to avoid using sub-reports.
Also read the The main differences of reporting features between Crystal Reports and Stimulsoft Reports article from our blog.
If you still need our help, please, send us additional samples of rendered reports with description what is wrong.

Thank you.

[Francine]

I was finally able to make it work with Data Bands. Thank you for your help.

[Andrew]

Hello,

Thank you for letting us know about this.

Have a nice weekend!