Hi all
I am working on Crystal reports 8.5
In one report we need to display weekdays and weekends in every month for the given date range
I mean
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Days of Service
Weekdays Number of weekdays in the month
Weekends Number of weekends in the month
And I need to calculate total of some items from Friday after 3 pm
2) In another report I am using stored procedure to get fields
As per my knowledge we cannot use other than one stored procedure in crystal reports 8.5
So I am using sub report to get some more fields other than stored procedure fields
But in main report I need to get sub- total of fields in sub report.
Could any one please help me out?You would use the Crystal Reports (http://www.saveonsupport.com) shared variable functionality. In your subreport you would have a formula field something like this:
WhilePrintingRecords;
Shared numbervar myTotal;
myTotal := myTotal + {field name}
Add this field to the subreport and suppress it.
Then in the main report you need another formula something like this:
WhilePrintingRecords;
Shared numbervar myTotal;
myTotal
The subreport keeps adjusting the total while printing records and the main report simply displays this value.
Hop this helps!|||Thanks for your reply
it works for me
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment