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

Replication/ syncronisation 2 MSSQL db - 1 linked to as400 - best way?

Hi There,

I would like to have the opinion of you experts!

I have a data on the AS400 which is my actual source.
I have a webpplication that needs this data (read only).

Linking my webapp directly to the AS400 works but is quite slow and the link could drop now and then.
To be sure and to increase response time, I want to have the data from the as400 transfered to a MSSQL db, which I can use for my webapp.

I have setup 2 MSSQL databases. The first one (A) is already linked to the AS400 source, and the second one (B) should be updated by the first one (A).

I would use db B for my webapp.

I need to find out how I can replicate/synchonise the linked database A with database B (in almost real time). Also I don't want to have a risk for when the link to the as400 drops, database B gets empried or upset in one or another way.

Now does my plan makes any sense, are there better or more efficient ways to do this?

And what would be the best way to replicate or synchronise the MSSQL databases?

Thanks,
KJWe do something similar here (production data source is AS/400, web data source is MS SQL). I use DTS to migrate data from production to the SQL Server periodically (as frequently as every 15 minutes). It is far from a perfect solution, but it allows users to bang away merrily on the reports server (MS SQL) with no effect on the production (AS/400). Developing the rules for migrating the data can be complex, however.

Other solutions (linking, direct connect via OLE DB/ODBC) provide more real-time data, but may also negatively impact the performance of the production server.

hmscott|||Did you consider to setup a linked server from MSSQL?
And, do you replace all the data or do you compare first before you migrate and just update the records changed?

I had my webapplication connected directly to the As400 (via Client Access ODBC Driver) which gives indeed real-time data but is already slow. We are now using it with 4 test users only so you can imagine what would happen when we go live with xxx users.

Cheers,
KJ