Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TA77
  • Order by date
  1. TA77

    bcaslow, Am getting no outer report data in my subreport

    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...
  2. TA77

    Bcaslow, can I use a subreport to funnel two seperate datasources

    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...
  3. TA77

    Bcaslow, can I use a subreport to funnel two seperate datasources

    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...
  4. TA77

    Need to combine data from two different sources on a single report

    Bcaslow, Can i use a Subreport to create a single report that pulls data from 2 differnt databases that reside on seperate servers? If so, how?
  5. TA77

    Need to combine data from two different sources on a single report

    The databases reside on two different servers. But they are both UDB databases.. How do I create a link between the two DBs??
  6. TA77

    Need to combine data from two different sources on a single report

    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...
  7. TA77

    Need to combine 2 data sources on a report

    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...
  8. TA77

    Need to combine data from two different sources on a single report

    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...
  9. TA77

    Need to combine data from two different sources on a single report

    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...

Part and Inventory Search

Back
Top