sub report on the same band as its "master" data

rbuser

Hi,

I am currently using RB 4.23 for Delphi 5.

I am currently creating a report where I have two different dynamic data
I need to display on the same grouping band--Orders table band.
1) Orders.Notes. This I am simply using the TppText component with
stretch set to true. So, no problem there.
2) Orders tables links to another table, UserResponses that links to
UserQuestions table. There can be any number of UserQuestions for an
Order and out of them user can answer to any, none, all, or some of the
questions. I need to get the only ones that have user responses and
need to display that on the Orders band. Also, I need to BOLD face the
font on the UserQuestions.

Currently, I am working my way to use the RTF memo component to do this.
But, this is very cumbersome and not so clean of a code.

So, I am looking to get more of an elegant solution for it.

I wonder if TppSubReport could work on this. But, on this band, I have
all the order level information, such as order Notes I've indicated. I
need Both the Order level information and this User Q/A be on it.

Any suggestions would be great.

TIA,

SeHun

nicocizik

Hi SeHun,

The use of SubReports in your situations could be helpful. You will however
need to create two separate datasets to handle the Orders Notes and User QA
separately (if I'm understanding correctly). You could perhaps create a
master detail relationship between the two so every time the notes of a
certain order are printed, the subreport containing all the User QA will be
printed as well. In this case you will have to be sure you have a common
key field in each query to link the two datasets on.

--

rbuser

Thanks Nico,

I have tried the subreport before reading the post and it just work
perfectly.