Creating dynamic Template

[Former Member]

Hi Experts,

I want to make a dynamic template in web intelligence report.

Suppose i have 2 drop downs:

1)Period From  and 2)Period To

User can select the values and acc to it the report gets displayed.

Ex1: Suppose user select 2010 in period from and 2012 in period To,then report should be displayed as the screenshot given.

Ex2:Suppose user select 2010 in period from and 2011 in period to ,then report should be displayed as the screenshot given.

Please help with the issue.

Thanks,

Neha

[Former Member]

Hi Neha,

Apply query level filter on Year. Select Operator as BETWEEN, so it will give you range.

Find the below screen shot.

Use cross tab to represent data as per your requirement.

Regards,

G Sujitha

[Former Member]

Hello Neha,

Please try to use Input controls and cross tab report..then you can meet your requirement..

Regards,

Naveen D

[sateesh_kumar1]

Hi Neha,

this thread may help :

[kohesco]

Hi Neha,

Please check out this article http://scn.sap.com/docs/DOC-54818

Hopes it helps you.

Grtz

Koen