I was able to get the Multiple Input filter to work..Thanks for all your help!
I am having problems creating a subreport. When i created the subreport, i'm not getting any errors but my outer report is not displaying in the report view. In order words, I see my nested report data but not the...
The problem with union filter is that the data rows are not appended side by side. In other words I want to be able ton view the ID pulled from the 2nd query right next to the ID pulled from the 1st query.
Right now, my union report has the 1st query and then the 2nd query is appended at the...
Hi,
I want to create a subreport which pulls data from two seperate databases on a single report. i.e the Outer report will be from a differnt datamart. the ID pulled from the 1st datamart will be used to run the nested query/report which pulls from a seperate database (therefore the subreport...
Yes, I need the results from query 1 in order to run query 2. Query 2 will be pulling values based on the IDs retrivived in query 1.
Unfortunately, I can't do a union on the database side.
I would need a lot of help on how to make the two queries to match and then use MIF..
When i built the...
What am trying to do is this... I want to create a report that pulls data from 2 different data marts. keep in mind, the data marts reside in different databases, therefore 2 different connections.
The reports would have a total of 7 columns, six of the columns come from the same datamart. One...
The number of records could run into thousands..
Essentially, what am trying to do is this --
The report has majority of the information coming a table that resides in a different database. The information needed on the last column (Z) is located on a seperate database.
One of the records...
The report has a total of 7 columns, 6 of the colums are pulling from the same data source . The last column will need to use the ID (primary key) pulled from the 1st query to against a different data mart (data source) to pull another piece of information. (therefore a different database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.