Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vnswathi
Starting Member
8 Posts |
 Posted - 2006-05-02 : 10:08:49
|
| 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 the columns -- deptname and amount (depending on the month the amount field is going to sum and display the results into the appropriate date), 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 05Housing 5 5 5Shipping 45 56 85Handling 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. |
|
|
vnswathi
Starting Member
8 Posts |
Posted - 2006-05-03 : 14:05:42
|
Sloved the issue, used matrix to display the fields.Thanks,vnswathi. |
 |
|
|
|
|
|
SQL Server Reporting Services