Multiple Datasets

I have two datasets.
I have a list with multiple tables in it to break out information.
There are two tables that I need to populate. They are using dataset 2.
THe rest of the tables are using dataset1.
How do I link the data that is pulled in dataset 1, to dataset 2?
Both datasets have the account number field in it. And when the primary
table 1 pulls the account number, I want dataset 2 to display the references
for the account number that is displayed in dataset 1?
ThankOn Jun 4, 3:36 pm, Susan R <Sus...@.discussions.microsoft.com> wrote:
> I have two datasets.
> I have a list with multiple tables in it to break out information.
> There are two tables that I need to populate. They are using dataset 2.
> THe rest of the tables are using dataset1.
> How do I link the data that is pulled in dataset 1, to dataset 2?
> Both datasets have the account number field in it. And when the primary
> table 1 pulls the account number, I want dataset 2 to display the references
> for the account number that is displayed in dataset 1?
> Thank
You should be able to achieve this via drill-through, where you pass
the account number from the main report to the drilled-through one.
Another way of accomplishing this is to use the dataset that includes
the account number as a report parameter and then reference the
parameter selected via the query/stored procedure that sources the
other table control. Assuming that the report parameter is called
AccountNum (that is linked to one dataset), you could use something
like this:
select ... from References where AccountNumber = Parameters!
AccountNum.Value
Also, you could try using Jump to URL/Report (as part of the
Navigation property of a table control, etc).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Multiple Coumn Report goes to column 2 on group page break

I have a multiple Column report with a group that I have specified "page
break at end". The problem I am having is: if it just so happens to be
printing in column 1, the next group starts printing in column 2 instead of
on a new page.
Any ideas?Hi Ron,
> I have a multiple Column report with a group that I have specified "page
> break at end". The problem I am having is: if it just so happens to be
> printing in column 1, the next group starts printing in column 2 instead of
> on a new page.
I'm having the same problem here...
Regards,
Jens|||Just so you know, I did go through the time consuming process of creating a
Microsoft ticket to confirm my suspicion this is a bug. They had no help for
a work around. If you come up with some sort of clugy solution or whatever
to work around this let me know. I will do the same if I come up with
something.
"Jens Weiermann" wrote:
> Hi Ron,
> > I have a multiple Column report with a group that I have specified "page
> > break at end". The problem I am having is: if it just so happens to be
> > printing in column 1, the next group starts printing in column 2 instead of
> > on a new page.
> I'm having the same problem here...
> Regards,
> Jens
>|||Hi Ron,
> Just so you know, I did go through the time consuming process of creating
> a Microsoft ticket to confirm my suspicion this is a bug. They had no
> help for a work around.
thanks for the info.
> If you come up with some sort of clugy solution or whatever to work
> around this let me know. I will do the same if I come up with
> something.
I tried re-arranging my report so that I was able to put the multi-column
part into a sub-report and handle the page breaks outside of that, but just
to find out that multi-column sub-reports are also NOT working.
I guess you can imagine how much this actually s*cks. Especially for me who
was the "Let's save some $$$ - we don't need CrystalReports!" guy in our
company - and now am having a BIG problem.
Sigh...
Jens