Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Cascading sub/linked reports? Post Reply Post New Topic
Author Message
Chrispy1
Newbie
Newbie
Avatar

Joined: 29 Nov 2006
Location: Canada
Online Status: Offline
Posts: 8
Quote Chrispy1 Replybullet Topic: Cascading sub/linked reports?
    Posted: 04 Mar 2007 at 1:11pm
Not that I've spent the better portion of my weekend trying to figure this out......Censored
 
What I'm trying to do is have a high level report (Area Code, District and Region) with counts based on various columns.  The user will then be able to click on one of the districts (for example, on 416 East) -> this click will take them to a brand new report that will show them the information within this district, broken out by Manager (same columns on this report).  Clicking one of the names of the Managers will lead to another report, this one showing each of the employees under that manager (again, same column headers).  Finally, clicking on one of the employee's names will take the user to a report showing the data that went into each of the counts (so each of the column headers above will be a new section for this specific report).
 
Now, if that's not complicated enough, I need to have the user being able to click on one specific data point (416 East | Outstanding Orders, for example) and be taken directly to a report that will show them the data contained in this count.  Is this even possible, or have I been wasting my weekend trying to figure this out?  Everything I found in the User Guide and on line ended up having Crystal Reports asking me for my parameters everytime I tried to open a subreport - this can't happen - I want to be able to open the main report, which has no parameters (as it's Provincial) and then have the clicking on the data point be the parameter selection.
 
(Also, if there's a way to have a hyperlink or something back to the main report, that'd be really nice to.....)
 
OK, now that I've asked for the world, I'm going back to work...Thanks in advance to any and all who reply...
Chris
There are 10 type of people in the world - Those that understand binary and those that don't.
IP IP Logged
EscApe
Newbie
Newbie


Joined: 13 Nov 2006
Location: Finland
Online Status: Offline
Posts: 37
Quote EscApe Replybullet Posted: 07 May 2007 at 3:58am
First: a subreport can't include another subreport.

I think that the first part of your report could be created with grouping with drill down functionality.

Another part (416 East | Outstanding Orders) would be best to create as a subreport.

When you add a subreport, you can link it with main report. That is the main report will automatically send a parameter to your subreport and data displayed can be selected with this parameter.
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.015 seconds.