Author Topic: Subquery In Report Studio  (Read 2357 times)

Offline ghostraider

  • Senior Member
  • ****
  • Join Date: Mar 2008
  • Posts: 70
  • Forum Citizenship: +1/-0
Subquery In Report Studio
« on: 29 Jul 2008 02:53:01 pm »
Hi All,

In Impromptu we could use sub queries, for example a report within a report. I have a table which has only one column (names of people) and it has 10 rows of data. I have several reports where i filter data using 3 people from the column and i use the same 3 people's names to filter out data in many reports. How can i just have these 3 names pre-selected in a report and use it in all the others instead of creating a prompt each time or entering the values in the filter. Please let me know.


Offline rockytopmark

  • Statesman
  • ******
  • Join Date: Jul 2006
  • Posts: 522
  • Forum Citizenship: +46/-0
Re: Subquery In Report Studio
« Reply #1 on: 30 Jul 2008 04:22:15 pm »
Master/Detail Relationship