SubReport not working.....

[matthew.friendars.usda.go]

Hi Folks:

I've done several generic reports in the past, but have never used a SubReport before now.  I've tried to watch a few videos and also read through several articles here/elsewhere, but I'm missing something.

I created a very short video to show what I have done and what the issue is:

If any one can help me I would appreciate it  very, very much.

I also have some screen pics below....

The Main Oracle Report is based off of a view which is working fine:

http://cwebpro.com/SQL/SQL_MAIN_REPORT.PNG

The SubReport is based off of a different view:

http://cwebpro.com/SQL/SQL_FOR_SUBREPORT.PNG

The two reports are linked through: ANIMAL,EXAM_DATE,DIAGNOSTICIAN, and DIAGNOSIS (If this were a table, that would be the compound PK).

The ERROR:   When I run the report (click on Preview in studio) it tries to give me like 60000 pages (should be about 50).

Below are some screen pics of some settings that can give you more information:

Subreport Query with Parameters

http://cwebpro.com/SQL/SQL_AND_PARAMETERS_FOR_SUBREPORT.PNG

Location SubReport:
http://cwebpro.com/SQL/SUBREPORT_IN_MAIN_REPORT.PNG

SubReport Parameters:

http://cwebpro.com/SQL/SUBREPORT_PARAMETERS.PNG

Parameters in Outline View:

http://cwebpro.com/SQL/SUBREPORT_PARAMETERS_InOutline.PNG

Thank you for your help Folks!

Matthew

[narcism]

What does your subreport look like?

[matthew.friendars.usda.go]

Hi Narcism:

Here is a pic of the subreport when run by itself  (after enter manually the parameter) I get the following:

 

http://cwebpro.com/SQL/subreport_ran.PNG

[matthew.friendars.usda.go]

I also edited the original post and added a very short video to show the problem better:

[narcism]

A couple of things to check, each at a time:

1. Make sure you recompile your subreport every time you modify it. You may have an old *.jasper file for it and that one gets picked up by your mainReport.

2. Place some limits on the mainReport's query and check the data from the subreport. You could even place some textfields with your parameters at the top of the subreport, in a title band for instance, to see if they get passed correctly.

3. Perform some record counting to understand how big the resultsets are, especially for the subReport's query.

[matthew.friendars.usda.go]

Thank you for your help Nacism....  it's working now!

Have a nice day  :)