| Author |
Message |
pto160
Newbie
Joined: 13 May 2009
Location: United States
Online Status: Offline
Posts: 16
|
   Posted: 15 May 2009 at 5:51pm |
|
I followed your advice and added the values from the shared variable to the main report and it is displaying correctly. I added a section below the subreport. How do I add the shared variable in the main report as a parameter? Do parameters only work with fields in the database? If I can get this, this will save tonnes of paper.
|
 IP Logged |
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
Posted: 18 May 2009 at 6:43am |
I'm not sure, as I no longer use the parameters in the reports, I just pass the desired dataset to the report to display.
You should be able to set the shared variable to a parameter. I would try a formula that assigned the parameter to the shared variable and place this new formula in the report header. something like:
shared numbervar whatIwant := @parameter;
"" //to hide the assignment value
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 20 May 2009 at 6:08pm |
Debmac posted this nice link for another question that should resolve your issue on using one parameter in the main report for all of your sub reports...
http://www.tek-tips.com/faqs.cfm?fid=1329
|
|
IP Logged |
|
pto160
Newbie
Joined: 13 May 2009
Location: United States
Online Status: Offline
Posts: 16
|
Posted: 21 May 2009 at 7:13am |
|
Thanks. The shared date variable is in the subreport (Called shipped qty) because it is pulling most of the information from other formulas in the subreport that use the Sales table. It is pulling the net stock from the main report. It is not a table date field in the database.
Is there a way to pass the shared date variable as a record selection based on a parameter even though it is not a field in the database?
I have been told that I may need to use conditional suppressing to make this work.
I can use rapidshare.com to send the file if need be.
|
|
IP Logged |
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
Posted: 21 May 2009 at 7:32am |
I'm sure what you mean by passing a shared date variable as a record selection.
shared is shared, it has access to all parts of the report. if you want to use it to select records for a stored proc or subreport, then I would create a formula that just 'displays' the shared variable and then use it in the linking of the subreport to the parameter that needs it.
I don't know if this work, but it is what I would try first...this is setting the parameter of the subreport to the value that you want. I can't see why this wouldn't work, but Crystal has quirks, and I just might not have come across this one, yet.
|
|
IP Logged |
|
pto160
Newbie
Joined: 13 May 2009
Location: United States
Online Status: Offline
Posts: 16
|
Posted: 21 May 2009 at 12:57pm |
|
Thanks. Would I create the formula that just 'displays' the shared variable in the subreport or the main report?
|
|
IP Logged |
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
Posted: 21 May 2009 at 1:13pm |
|
in the main report so that you can use it to link to the parameter in the subreport.
|
|
IP Logged |
|
pto160
Newbie
Joined: 13 May 2009
Location: United States
Online Status: Offline
Posts: 16
|
Posted: 21 May 2009 at 3:56pm |
And in the subreport I would put shared numbervar whatIwant := @parameter;
"" //to hide the assignment value.
and then use subreport links to link the main report and the subreport?
|
|
IP Logged |
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
Posted: 22 May 2009 at 6:24am |
I don't think so. the subreport is gathering some data from the database. It is usually gathering this information based on some criteria. I thought that a part of the criteria was the value in the shared variable. Either way, the subreport is 'Linked' to the main report via the parameters. Right click on the subreport from the main report and choose 'Change Links' or something like that. I would attempt to link the formula in the main report to the appropriate parameter in the subreport.
Does this make sense?
|
|
IP Logged |
|
pto160
Newbie
Joined: 13 May 2009
Location: United States
Online Status: Offline
Posts: 16
|
Posted: 22 May 2009 at 8:08am |
|
Thanks. Yes, I am basing it on a shared variable in the subreport.
Okay to summarize. I displayed the shared variable in the main report using a shared variable called Return Date (Out of stock date), which is displaying the correct date. I created a parameter in the subreport called Out_Of_Stock_Date and linked it to the Return Date formula in the main report using change subreport links.
So, how would I create the parameter so the user puts in the Out of Stock Date? I take it I need to create a parameter called Out_of_Stock_Date in the main report?
|
|
IP Logged |
|
|
|
