how to run a report in different report type like list crosstab etc

[ravimahazan84]

Hi,

Is it possible to run a report by prompt selection in different report type like
List
Crosstab
i mean to user would be able to select in which report type he wants to see a same report.

Thanks
Ravi

[andy_mason_84]

Hi,

You could create a new page for each type of report (List Page, Crosstab Page, Chart Page) and then put a render variable on each page where the parameter is passed by a prompt on the prompt page?

So the user selects List on the prompt page and then it only displays the List Page.

[ravimahazan84]

Hi Andy,

Could you please revert me in more detail as i am not able to locate it ,thanks.

Ravi 

[andy_mason_84]

Create a Report in Report Studio that has 3 pages in it.  Each page will be a different type of report.
Page 1 = List Report
Page 2 = Cross Tab

On your prompt page create a Value Prompt and enter the static choices List Report  / Cross Tab Report, call the prompt 'Report_Type'

Then on Page 1 create a Render Variable (Boolean) that says ParamValue('Report_Type') = 'List Report'
Then on Page 2 create a Render Variable (Boolean) that says ParamValue('Report_Type') = 'Cross Tab Report'

Then when you make the choice on the prompt page it will only show the page that the prompt variable relates too.

[ambuj2k50]

1.This can be achieved by creating the report with 3 different data containers and hiding them by using a render varible.
The render variable will use the parameter value given by the user to select the container.

But when the amount of data is huge and the data container selection is frequently altered the server hit increases.

2. Please check the attached report XML for a alternate way to achieve this by using javascript which will give better performance with less server hit.

[ravimahazan84]

hi Ambuj,
Many thanks for your solution which you provided
can u please send me the sample xml to acheive this in report studio without java script ,thanks

Ravi

[MFGF]

hi Ambuj,
Many thanks for your solution which you provided
can u please send me the sample xml to acheive this in report studio without java script ,thanks

Ravi

It's attached in the post immediately above yours...

MF.

[ravimahazan84]

Hi MFGF,

Attached XML is using Java script i am looking XML with out using java script which uses render variable and all.

Thanks
RAVI