Thank you for the suggestions.
I found very stupid solution is that I had to make main report copy and bring that same report as a sub report in to the main report Group Header (Location_id).
I was doing this just to play around with another formula and found that this solution.
So weird...
I forgot to tell u one more thing is that in the main report i have created a dummy formula to call the sub report shared variable. and then created another local formula to call the dummy formula. now chart expert shows the formula. this is work around to see the formula in the chart.
Help me...
If I do that I will get print time value error message on chart.
but what I did was to make it work in sub report, declared my shared variable like below
whileprintingrecords;
shared numbervar s_mtd;
global numbervar MTD sub:=
sum({daily_summary_fact.actual_revenue},daily_summary_fact.location_id
on change of field : Types (M,Q,Y - these are values in the Types feild)
Summary field is: MTD main -(sum({daily_summary_fact.actual_revenue},daily_summary_fact.location_id})
Don't summarize checked in.
Yes I did link on both fields.
I am using Crystal Report 2008 version.
I have following calc in sub report:
MTD sub:
shared numbervar Y;
Y:= sum({daily_summary_fact.actual_revenue},{daily_summary_fact.location_id});
MTD main:
Main report formula:
shared numbervar Y;
I'm trying to place the MTD...
thread149-1589108
I have shared variable in sub report and called that in to main report.
main report has two groups, 1) clinic_id and 2) location_id.
sub report also has same thing.
I have my sub report in location_id group footer A and shared variable in location_id group footer B.
Chart is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.