I am using Crystal XI and I am am trying to average the array I have built in a main report and is passed to a subreport. I am spliting the data in the subreport to graph employee sick leave. I have tried to average the split data but no luck. I have tried a couple of loop formulas but no luck...
Hi Saran
I haver just had the same thing ensure the graph is numerci axis chart type through chart expert and select one of the date axis charts. Then if you left click on the date in your chart ie 05/17/2009 to select it then right click you will get the a list of options, use the group(X)...
Fantastic Thanks LB this works perfectly for the dates but the percentages are just not pulling out correctly. It is only pulling the one figure which is the last in the array. I will see what I can do to extract the correct values.
1/02/2008 Jan 0.0260
1/03/2008 Jan 0.0260
1/04/2008 Jan...
Hi LB
Thanks for your reply it helped a some but not quite what I am after.
I tried the numeric axis chart option no luck I think it is because I am dragging data from three distinct reports. I ahve one report capturing the available hours by month and passing the value by month to the main...
I have used the datediff function to check the starting date entered by the user and the timesheet date and found out if the difference is 0 or a result then added 1 to the result and used that for my sequence to run the graph out in the subreport. But what I'm trying to do is graph data out of...
I am using CRXI and have developed a sick leave absences report that is grouped by a formula that checks the date differences and produces a number as below.
if datediff("m",{?Pm-@f1_StartDate},{hrpay_lve_union_avw.TIMESHEET_DATEI}) = 0
then...
I have a report that I must graph in crystal the figures I get through the subreport and shared variable seem to be accurate for what I expect. The only issue is that I can not graph the result which is grouped by month. The graphing selection fields excludes this formula and the grouping does...
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.