Hi. I am making a crystal report wherein what I need to do is to show the 'ActualUsage' of the office supply items during a specified quarter of the year based on input from the user.
If the user selects 1st Quarter, then it would be months, Oct - Dec.
The crystal report should look like this:
Actual Usage
Item Name Oct | Nov | Dec Total Usage per Quarter Estimated Increase in Usage
Pencil 5 12 3 20 2
Does anybody have an idea how to do this?
I am doing this with MS Sql Server stored procedures with asp.net and c#. Please help. :)
Member
14 Points
27 Posts
Dynamic Crystal Report based on parameters passed
Aug 12, 2012 08:03 AM|karenbalmaceda|LINK
Hi. I am making a crystal report wherein what I need to do is to show the 'ActualUsage' of the office supply items during a specified quarter of the year based on input from the user.
If the user selects 1st Quarter, then it would be months, Oct - Dec.
The crystal report should look like this:
Actual Usage
Item Name Oct | Nov | Dec Total Usage per Quarter Estimated Increase in Usage
Pencil 5 12 3 20 2
Does anybody have an idea how to do this?
I am doing this with MS Sql Server stored procedures with asp.net and c#. Please help. :)
Contributor
6622 Points
1743 Posts
Re: Dynamic Crystal Report based on parameters passed
Aug 14, 2012 06:08 AM|Ajay2707|LINK
Hi , This will achieve by Cross tab feature in crystal report.
check this all.