CR XI - problem subreport display

[campia]

Hi,

In my mainreport I have a few subreports.
For example I have a subreport that shows me the incidents created for a certain apllication "Incidents by Application".
When I only execute the subreport I see the correct number of incidents from de db.
However when I execute the mainreport (that contains the subreport) I have wrong statistics.
execute subreport : 65
execute mainreport: 58

I use two parameters fields to link the mainreport with all the subreports (StartDate and EndDate = to enter a date period), so I have no idea why I have this statistics difference between the reports.
Any idea?

 

[lbass]

Are you saying the subreport returns 58 when the main report is run, but 65 on its own?

In what main report section is the subreport located? Are there any other links besides the date parameters?

-LB

 

[campia]

When I execute my main report (it contains 12 subreports) then I have for this example 58 incidents for application.
But when I execute only this specific subreport I have 65 incidents.
This problem exists in each subreport.
The main report doesn't take the correct values... but when I execute only the subreport I have it.

Main Report is linked to each subreport with a StartDate and an EndDate parameter, that's the only thing.
I put all my subreports in the Report Footer.

andré

 

[lbass]

Please copy the record selection formula from one subreport and the record selection formula from the main report into the thread.

-LB

 

[campia]

Hi,

I use the same formula in the main report and in the subreport:

{Table.Creation_Date} in {?StartDate} to {?EndDate}

 

[lbass]

So your link is between the two parameters, that is, in the subreport linking screen, you have linked {?startdate} to {?startdate} (using the dropdown), and not to {?pm-?startdate}? The same for end date?

Can you clarify the problem? I'm still confused about whether you are saying the subreport is giving two different results when executed on its own or when executed as part of the larger report, or whether you are comparing the subreport results with results from a main report.

Is the creation date a datetime? You might try changing the formula in both subs and main to:

{Table.Creation_Date} >= {?StartDate} and
{Table.Creation_Date} < {?EndDate} + 1

-LB

 

[campia]

Yes i linked {?startdate} to {?startdate} and {?enddate} to {?enddate}.

I use CR with a Service Desk tool. I create my reports, after that I import them to the Tool and execute them.
I created a new incident and executed the report. If I execute only the subreport (example: Incidents by Application) I see the new value. If the total was before 64 after creating a new inciddent I see 65.

BUT when I execute the main report with the subreports I still see 64 even after creating the new incident insteed of 65 !!

In my subreports I created the two parameters fields StartDate and EndDate and put the formula {Table.Creation_Date} in {?StartDate} to {?EndDate}.
In the main report I set the subreports in the Report Footer. There i selected the subreport - Edit subreport - created again the parameter feilds + formula.
After that I linked the main report with the subreport but I have this strange problem...!!!

I have no idea why!

andré

 

[lbass]

I'm not sure what's going on. Are the subreports imported? Do you have "reimport subreport upon opening" checked? If so, you might want to uncheck it. I wonder whether you might be reimporting old subreports that need to be verified (database->verify database). This is just a wild guess. Otherwise, maybe you simply have a corrupt report--it doesn't happen often, but does happen. You might try reconstructing.

-LB