Report Designer data Tables

I have a set of data tables with their own datasets from different database
tables. They go across the report page and all need to be linked together
via an ID number. How can this be achieved or is there a better way of doing
it other than in report tables?
The data tables across the report page are:
Details, Actuals and Budgets ie., ID number in Details need to be linked to
the same ID in Actuals and Budgets so that it appears as a single line of
continuous information across the page.
Thanks
IanStep 1. Create one report for each of the Details, Actuals, Budget data.
Give each report an ID parameter.
Step 2. Create a main report and add a list data region. Make the dataset of
the list be based on a query that returns unique id values. Inside the list
data region add subreport controls and map them each to the reports you
created at Step 1. You will need to map the subreport parameters to the ID
field in the main report.
Done.
HTH
Charles Kangai, MCT, MCDBA
"IanP" wrote:
> I have a set of data tables with their own datasets from different database
> tables. They go across the report page and all need to be linked together
> via an ID number. How can this be achieved or is there a better way of doing
> it other than in report tables?
>
> The data tables across the report page are:
>
> Details, Actuals and Budgets ie., ID number in Details need to be linked to
> the same ID in Actuals and Budgets so that it appears as a single line of
> continuous information across the page.
>
> Thanks
> Ian
>|||This sounds more like a query problem than a report problem. Is there a
reason that you are not joining the tables in the source query? Then each
record returned will contain all your information -- details, actuals, and
budgets. When you say single line of data, I presume that there is only one
row of data for each ID. Is that not the case?
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"IanP" <IanP@.discussions.microsoft.com> wrote in message
news:9F30A2FE-A28F-45E6-989C-913EB78FD61A@.microsoft.com...
>I have a set of data tables with their own datasets from different database
> tables. They go across the report page and all need to be linked together
> via an ID number. How can this be achieved or is there a better way of
> doing
> it other than in report tables?
>
> The data tables across the report page are:
>
> Details, Actuals and Budgets ie., ID number in Details need to be linked
> to
> the same ID in Actuals and Budgets so that it appears as a single line of
> continuous information across the page.
>
> Thanks
> Ian
>|||Thank you Charles and Jeff
Yes jeff it is a db design problem, I was not involved in its design, and
now it is being revisited and Jeff, your note sounds promising so I will go
back and revisit what I was experimenting with
Ian
"Jeff A. Stucker" wrote:
> This sounds more like a query problem than a report problem. Is there a
> reason that you are not joining the tables in the source query? Then each
> record returned will contain all your information -- details, actuals, and
> budgets. When you say single line of data, I presume that there is only one
> row of data for each ID. Is that not the case?
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "IanP" <IanP@.discussions.microsoft.com> wrote in message
> news:9F30A2FE-A28F-45E6-989C-913EB78FD61A@.microsoft.com...
> >I have a set of data tables with their own datasets from different database
> > tables. They go across the report page and all need to be linked together
> > via an ID number. How can this be achieved or is there a better way of
> > doing
> > it other than in report tables?
> >
> >
> > The data tables across the report page are:
> >
> >
> > Details, Actuals and Budgets ie., ID number in Details need to be linked
> > to
> > the same ID in Actuals and Budgets so that it appears as a single line of
> > continuous information across the page.
> >
> >
> > Thanks
> >
> > Ian
> >
>
>