[Solved] Carry Prompt Values from one report to another

[thgeorge]

Is there a way to save the prompted values on one report and use them while drilling through from this report to another report.

Thanks in advance

[Darek]

You need to have the prompt values as query items in the query (not necessarily in the face of the report, but in the query).  THe second report (the drill through) has to have prompts set up to accept these.

[thgeorge]

Thanks a million for the reply,
Actually the problem is that i am using a SQL Query as a Tabular SQL and i cannot omit out the start and end dates, as i have some aggregations in the SQL. So isnt there any other way to save the start and end dates picked the first time and use it in the second report that was drill through.

Thanks in Advance

You need to have the prompt values as query items in the query (not necessarily in the face of the report, but in the query).Ã,  THe second report (the drill through) has to have prompts set up to accept these.

[Darek]

You don't have to omit anything. Just add the parameters as Data Items to your query. Than you'll be able to reuse.

[thgeorge]

What i meant was that because its a tabular SQL that i am using, i can add the date, but that will change my windowing logic in the sql, so i am forced not to add the date in the SQL. Hence dosent show up in the DataItems. Moreover reportnet does not allow you to add new dataItems when you use tabular Sql.

[Darek]

Than supersede the Tabular SQL with Tabular Model. Meaning if your query looks like this:

Query 1
   Tabular SQL 1

Make it to look like this

Query 1
   Tabular Model 1
      Tabular SQL 1

Than you'll be able to add those parameters as Data Items without disturbing your SQL.

[Darek]

And I've just tested that you can add new Data Items to a query driven by Tabular SQL. At the query level.

[Darek]

I've forgot to ask: what do you mean when you say "windowing logic in the sql"?

[thgeorge]

Thanks a million it works