Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Passing data to subreport to be graphed Post Reply Post New Topic
Author Message
sbodell
Newbie
Newbie


Joined: 13 Jul 2009
Online Status: Offline
Posts: 9
Quote sbodell Replybullet Topic: Passing data to subreport to be graphed
    Posted: 22 Apr 2014 at 7:30am
I have a report that aggregates (using Groups and Running Total Fields) data. I have customer name (only of a certain type) and a value for each fiscal year (grouped by Customer). As the fiscal year values are percentages, they are Formula Fields calculated using the Running Total Fields. I don't need/want any other data in the report other than these values which I want to chart. I have a sample that builds variables by concatenating them together and then passing them to the subreport. The variables get passed ok, and I think I have them parsed ok, but when I attempt to run the report, its about 3,000 pages long - one line for every record in the source view (from an Oracle database).

So, how do I get the report to ONLY show data from the shared fields that were passed into the subreport and parsed?

How do I create a chart for each customer with the 4 fiscal year values in them?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 23 Apr 2014 at 5:05am
I haven't done much charting, but I think that it drives off the data itself, not print time variables like formulas and running totals.

Probably your best bet would be to create a stored procedure that returns just the values that you want to chart...though again, I don't have much experience with charting.
IP IP Logged
sbodell
Newbie
Newbie


Joined: 13 Jul 2009
Online Status: Offline
Posts: 9
Quote sbodell Replybullet Posted: 23 Apr 2014 at 12:46pm
I believe you're correct in saying the charting is driven off the data. I have an example that passes "merged" data in a shared variable to a subreport, parses it back using the split(varName, sepChar)[recornumber+1]. While I have some idea what its doing, not enough to figure out if it actually works (though it does in the sample with a much simpler data set).
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.016 seconds.