Dynamic 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 fields), 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.

What is the output of stored procedure? It should return date, category,
Quantitiy/Number (appears in dataset)

If you return those three values from stored procedure then you can use Table
grouping feature in the Report desinger to build the report.

Thanks
Murthy

I am getting values from the Stored procedure and also able to see the results
in the Dataset on the report designer DATA page, but when it comes to laying out
the Report on the report designer LAYOUT page and see the PREVIEW, that is where
my problem comes.

I am able to display the Department name column but not the Amount column which
i have grouped by Year and month.

Any help is appreciated.

Thanks,

vnswathi.

If you get into Dataset then you will surely have those values in Layout/Preview
pages too.

Can you verify textbox properties in the layout screen and see are you able to
get dataset values there or not? Also check visibility attribute of those text
fileds too?

As a simple test, you can verify this by placing a textbox and set those dataset
values and see the preview.

Thanks
Murthy

I have a other feeling that you may doing something wrong in the Grouping
section. Are you building drill-down report? If yes you have to check toggle
items?