Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Subreporting Post Reply Post New Topic
Author Message
schizm
Newbie
Newbie


Joined: 14 Jun 2012
Online Status: Offline
Posts: 5
Quote schizm Replybullet Topic: Subreporting
    Posted: 14 Jun 2012 at 6:12pm
Hi. The company i am working for is a franchise and they would like a report that will compare the results of the individual stores performance, and how it fairs to the national average.

I have created a subreport with this information in, and i have created a parameter {database.storeid} = {?Pm-?StoreID??01} ..
When the report compiles, the user is prompted to enter in a storeID and the report for this individual store loads. When i take away the function and parameter, it gives me the average of the nation (which is what i want)

However, it won't let me have both and i have virtually tried everything. Any help would be greatly appreciated
IP IP Logged
rkrowland
Senior Member
Senior Member
Avatar

Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Quote rkrowland Replybullet Posted: 14 Jun 2012 at 11:52pm
Rather than conditionally selecting records based on the store ID, I'd use that parameter to surpess stores which don't equal that store ID.
 
IE You need all stores to be in your data to analyzze them for the national average.
 
Create a group on StoreID, format this group how you'd like your individual store to be displayed. Now conditionally surpress the group on
database.storeid <> {?storeid}
Now in your report footer you can create national averages as all the data for other stores is still in the report.
 
Regards,
Ryan.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.