Tracy Scott
asked on
Creating a chart on a variable from Subreport
Hello,
I have tried to read the threads on here but I just can't figure out how to create my chart. In my main report I have subreport data that is added to my main report data. I am determining how many deals each person has; the main report has full deals and the subreport shows the half deals I am adding them together to give me a variable for Total Deals, which is the value I want to chart on. Of course when I go to chart it, I only get the full deals. I have read where you should put the chart in a subreport because of the way Crystal evalutes. But I don't understand how that works. Subtotals are always calculated last. So how do I ever get the subtotal variable in the chart? Banging my head on the wall.....
I have tried to read the threads on here but I just can't figure out how to create my chart. In my main report I have subreport data that is added to my main report data. I am determining how many deals each person has; the main report has full deals and the subreport shows the half deals I am adding them together to give me a variable for Total Deals, which is the value I want to chart on. Of course when I go to chart it, I only get the full deals. I have read where you should put the chart in a subreport because of the way Crystal evalutes. But I don't understand how that works. Subtotals are always calculated last. So how do I ever get the subtotal variable in the chart? Banging my head on the wall.....
ASKER
I understand the pass methods, I just find it really limiting that you can create robust reports with subreports but you just can't use a chart! I was hoping there was a new feature I didn't now of.
My SQL skills are not that good. Its basically the same table with a salesperson 1 field and salesperson 2 field. The main report counts deals when a person is in the salesperson 1 slot (and determines if it is a split based on there being a salesperson2) and the subreport then flops the salespeople slots and puts sales person 2 in the first position and then counts those deals. I am sure it can be done in SQL but a basic UNION ALL just gave me the records twice, it doesn't swap the names. I know that is hard to visualize what I am saying. I guess I will have to get help with the SQL syntax or create more variables in the report to cycle through the names to count. Just not my strong suit. Like I said, I got the table calculating exactly how I want it, just wanted to graphically display it.
My SQL skills are not that good. Its basically the same table with a salesperson 1 field and salesperson 2 field. The main report counts deals when a person is in the salesperson 1 slot (and determines if it is a split based on there being a salesperson2) and the subreport then flops the salespeople slots and puts sales person 2 in the first position and then counts those deals. I am sure it can be done in SQL but a basic UNION ALL just gave me the records twice, it doesn't swap the names. I know that is hard to visualize what I am saying. I guess I will have to get help with the SQL syntax or create more variables in the report to cycle through the names to count. Just not my strong suit. Like I said, I got the table calculating exactly how I want it, just wanted to graphically display it.
I'll see what I can do. I understand the data.
mlmcc
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Charts are built in a pass before subreports are run therefore the data is not available to the chart.
https://skillforge.com/crystal-reports-milti-pass-processing-engine/
Why do you need a subreport?
Can you combine the data sources?
mlmcc