error with multi-nested groups

[brianj774]

Hi,

I have a report with multiple groups, one nested in the other, which is behaving badly. I expect I've just set it up incorrectly, but I don't see anything that would suggest what I'm missing.

http://dl.dropbox.com/u/495070/shared/s ... Report.csv
http://dl.dropbox.com/u/495070/shared/s ... Report.mrt
http://dl.dropbox.com/u/495070/shared/s ... Report.pdf

Can you point me in the right direction?

What I'm trying to do, is create a number of receipt documents. The outermost group collects distinct orders, and the innermost group deals with specific items on the order. The main problems (there are others, admittedly) that I am stuck on are that some of the datarows for the 'orders' group are being placed after ALL the receipts...

Thanks

[HighAley]

Hello.

We couldn't clearly understand what are you trying to get.
Please, describe the report you are making.

Thank you.

[brianj774]

Hello,

I'll try to describe it differently.

The report is a 'range of receipts'. It gets its data from a stored procedure that takes a single order ID, and 2 dates to make a range. Here is the output of the stored procedure for one set of inputs. As you can see in the csv file, there are many orders. Some orders have many items. Some items have modifiers. Some orders have multiple receipt comments. Some data is identical for all rows (like the company address)

From that data, I'm trying to build a report that generates, from that dataset, a single receipt per OrderID, with all the appropriate item details, comments, total summary, etc.

What I've tried, as you can see in the mrt file, is a group on Order ID, and another on OrderItemID. I have various bits of detail at the appropriate places. I think if you look at the mrt, you'll understand what I was trying to do.

Finally, if you look at the output pdf file, and just quickly scan through it, you'll see in a hurry whats actually happening (the headers of both groups, and detail of the inner group are being generated sequentially, but the detail of the outer group which comes AFTER the inner group is getting rendered after all the headers).

I'm sure whatever it is will be pretty simple to resolve. I don't expect this is a very complicated construct.

Thanks,

Brian

[HighAley]

Hello, Brian.

I'll try to describe it differently.

The report is a 'range of receipts'. It gets its data from a stored procedure that takes a single order ID, and 2 dates to make a range. Here is the output of the stored procedure for one set of inputs. As you can see in the csv file, there are many orders. Some orders have many items. Some items have modifiers. Some orders have multiple receipt comments. Some data is identical for all rows (like the company address)

From that data, I'm trying to build a report that generates, from that dataset, a single receipt per OrderID, with all the appropriate item details, comments, total summary, etc.

What I've tried, as you can see in the mrt file, is a group on Order ID, and another on OrderItemID. I have various bits of detail at the appropriate places. I think if you look at the mrt, you'll understand what I was trying to do.

Finally, if you look at the output pdf file, and just quickly scan through it, you'll see in a hurry whats actually happening (the headers of both groups, and detail of the inner group are being generated sequentially, but the detail of the outer group which comes AFTER the inner group is getting rendered after all the headers).

I'm sure whatever it is will be pretty simple to resolve. I don't expect this is a very complicated construct.

There are several problems in your report.
1. The Group Header could be used with one Data Band only. The next Data Band will be rendered after all groups of the first Data Band. See the attached Report1 file.
2. The Group Footer doesn't help in this case.
3. The Child Band could help you. See the attached Report2 file.
4. Also you could place text boxes on the one Band instead of two. See the attached Report3 file.

You should rebuild your report using our advices.
Also look at the master-detailed reports in our Demo. It could be useful for you.

Let us know if you need any additional help.

Thank you.

[brianj774]

Thanks,

Using a combination of your suggestions, and a few of my own, I've completed this report. Thanks again for the assistance.

[Andrew]

Hello,

Great!
Let us know if you have additional questions.

Thank you.