Complex subreport help

[bsingin64]

Ok, I know that it is "IMPOSSIBLE" to have a subreport nested within another. But let me tell you what I need to do, and maybe you can figure out a way to make it work.

I have a report with its primary record set = a grouped detailed dump of data. In its header I have a subreport that returns a summarized grouping of information (similar data, dissimilar recordset). The subreport right now, just lists a header record (Issue description), and site status (open or closed) for each site under that issue.

I have been tasked with making that subreport look as follows:

repeating
[
Issue: Blah blah blah Blah blah
Site1: open Site9: closed
Site3: open Site7: closed
Site4: open Site2: closed
]

they want all the open sites on the left, and closed ones on the right. they also want the whole OPEN site side of things to be with a red background color and the closed sites side to be a greenish bg color.

I could easily do this with 2 subreports inside the detail section of the "issue" group (one claused with "open" the other "closed), but since this is a subreport itself in the main report, I dont have that capability.

I need some way to format the record set, such that i can display all open's on the left, and closed on the right and color each side accordingly.

 

[Madawc]

Maybe one subreport to get 'issue', and also return something using a shared variable. Then in the next section, two side-by-side subreports.

Also consider whether the data items could be linked in the main report, which is more efficient. If processing time matters, consider using SQL to assemble to desired data.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[bsingin64]

an interesting idea. How would i manage multiple issues however? the main report would then have two seperate detail sections.. it should look like this

issue:a
site site
site site

issue:b
site site
site site
site site

DETAIL
ISSUEtype(HEAVY)
ISSUE:BBBBB
LOTS Of detail

ISSUE:BBBBv
LOTS Of detail

 

[lbass]

I guess I don't see why you can't replace the one subreport in the group header with two, where you set the record selection formula of the first to open records, and for the second, limit records to closed. You can then use the section expert within each subreport to color the data set.

If this doesn't work, please describe your main report structure and your subreport structure, and explain how it is linked to the main report.

-LB

 

[bsingin64]

-I guess I don't see why you can't replace the one subreport in the group header with two

because the report in question is not in a group header, its on the report header....run once based on a passthrough parameter from the main report. the Issues are grouped and the detail records are displayed all in that subreport. I can't break out the detail records into 2 subreports because " it is IMPOSSIBLE to have a subreport nested within another."

I'm researching the idea of Stored Procedures to do the dirty work.

 

[lbass]

You didn't really answer my questions. Are the sites listed under each issue the detail records?

-LB

 

[lbass]

I have a solution that I could give you later today, if you respond in answer to my question.

-LB