Dyanamic Parameters
Hi All,
I am stuck with a report, could you please help.
I have a dynamic stored procedure, which depending on Begindate and Enddate displays columns deptname and amount (depending on the month the amount field is going to sum and display the results in the appropriate date columns), that is sum(amount) in Jan05,Feb05,Mar05........depending on the Begindate and Enddate, it's displays the values.
EX:-
Deptname Jan 05 Feb 05 Mar 05
Housing 5 5 5
Shipping 45 56 85
Handling 10 14 18
How do i incorporate this into the Report designer, because when i use this Stored procedure and create a report, i can see the values coming in the Dataset, but i don't see the Amount values coming into the Preview Page.I only see deptname coming into the Preview page.
I am building a string in the Stored procedure.(Just Letting you know)
what can i do to make the amount values be displayed under appropriate month.
Thanks,
vnswathi.
