Combining Missing Data Reports Into One 2

[bmacdo]

Reporting with Crystal v.10, off MS-SQL Server data…

I have been tasked with combining several missing data reports into one. They are grouped by schools and also group rows by formula according to how long ago the client originally was admitted to school, e.g.

Alpha School
Missing Intake Data 90+ Days Overdue
111223333 Smith, John DOB Gender
222112222 Doe, Jane Gender County
444223333 Citizen, Sam DOB County

Missing Intake Data 60+ Days Overdue
123456789 Tiger, Tony County

Bravo School
Missing Intake Data 90+ Days Overdue
999887777 Dorritt, Lil Gender

(+ currently a separate report

Alpha School
Missing Educational Data 90+ Days Overdue
111223333 Smith, John Grade Level GPA School Name
444223333 Citizen, Same GPA School Name

I want to combine these and others so that they will print one school at a time with its various types of missing data and time overdue group w/in the missing data type e.g.

Alpha School
Missing Intake Data 90+ Days Overdue
(detail row)
Missing Intake Data 60+ Days Overdue
(detail row)
Missing Intake Data 30+ Days Overdue
(detail row)
Missing Educational Data 90+ Days Overdue
(detail row)
Missing Educational Data 60+ Days Overdue
(detail row)
Missing Legal Data 90+ Days Overdue
(detail row)

Bravo School
Missing Intake Data 90+ Days Overdue
What I am getting instead w/my attempt is:

Alpha School
Missing Intake Data 90+ Days Overdue
(detail row)
Missing Intake Data 60+ Days Overdue
(detail row)
Missing Intake Data 30+ Days Overdue
Bravo School
Missing Intake Data 90+ Days Overdue
(detail row)
Missing Intake Data 60+ Days Overdue
(detail row)
Missing Intake Data 30+ Days Overdue
Charlie School
Missing Intake Data 90+ Days Overdue

Alpha School
Missing Education Data 90+ Days Overdue
(detail row)
Missing Education Data 60+ Days Overdue
(detail row)
Missing Education Data 30+ Days Overdue
Bravo School
Missing Education Data 90+ Days Overdue

I need for the missing data in different views, e.g. RDV_Client_Intake, RDV_Client_Education, RDV_Client_Legal in individual subreports in a container report. The container report currently has one only group, School, and I’ve put the subreports for the various missing data types in Group Footers 1a, 1b, 1c, etc. w. subreport links to school.

Hope this is sufficient for someone to take a stab at telling me what I am doing wrong. Thanks in advance.

Brad

 

[beltmanjr]

Ok, your subreports (like Missing Intake and Missing Education Data) require a parameter to either (and the first option would be the best) select on a school or suppress all but the school you require to be shown.

I'd go for the records selection parameter where the report only returns the school required. The main report can take a value for this parameter fromt he grouping you created on school and pass it to the subreport. This way you'll only get the school belong to the group in the main report.

You may also with to use a second parameter that is called 'in combined report' (or something like that) to suppress the school group headers in the subreport when it is part of the combined report.


However, by putting these extra parameters in your subreport (this goes for the record selection parameter on school) the users of the reports 'Missing Educational Data' and 'Missing Intake Data' will be asked to make a choice of school when running these reports outside of the combination report. Hence you must give them an option to select ALL schools by either allowing multiple values (when using dynamic cascading prompts) or a single value called 'All schools' when using a static list of schools.

Hope this helps
JR

 

[bmacdo]

I have a school parameter in the container report w/subreport links on school. Sorry I neglected to mention that. I am still getting the running-through of the schools in each missing-data type category (intake, education etc) rather than all the missing data types running through an individual school.

 

[beltmanjr]

So, the container report (is this the main report with the sub reports in it?) has a parameter school? (this isn't required unless the user needs to select one or more school on the main report.

Do the subreports have the school parameter?
If so, is the linking of the parameter between the main report and subreport done correctly?
Can you verify that the school group name of the main report is indeed the one received by the subreport? (place the parameter somewhere in the subreport header where you can see it, make sure that the field is large enough to display all date in case you somehow manage to pass mor than one school) and run the main report).

If it is the correct value, check your record select in the formula workshop. Is the correct parameter used there as in:
{table.schoo} = {?school parameter}

If you run the subreports separately and put in just one school as selection, does that work?

 

[lbass]

You should only have a group on school in the container report, and then place the subreports in the group footer_a, _b, and _c sections, with a link on schools. Within each sub, you would group on the Days Overdue.

-LB

 

[bmacdo]

After looking at the thing backwards and forwards, I scrapped it and redid. And now the subreports to execute in the manner I intended. I am pretty sure it was a linkage problem, as the group dynamic originally was as lbass recommended and I did not change them when I rewrote it. Thank you both for your consideration.

Brad

 

[beltmanjr]

From reading your first post I assumed that you nailed the groups alright indeed.

In the future I'd recommend trying to just display some passed down parameter values in your subreports so you can kind of debug. You'll probably learn to spot errors quicker and be able to correct. You issue indeed sounded like the parameter either not being passed from main to sub or not being in the subreport filter.

Coming to think of it, perhaps you had the parameter on school in your sub already, but didnt link the one from your main report to the existing parameter in the subreport.... so many possible ways of getting it wrong