Chart Question...

Hi,
I'm trying to create a line graph/chart in reporting services. I have 2
stored procedures that outputs the count of 2 tables that created 2
datasets.
Both these procedures use a field called acctdates. I'm trying to use
the acctdates as the catagory field and the 2 counts in the data field. But
I keep receiving an error saying I can't use a field from another dataset
for the current dataset. Is there a way around this problem? or is there a
different way I should approach it?
Please help....
Thank you,
RickyYou may want to consider joining the two datasets inside a stored procedure.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ricky" <kmeas1@.gmail.com> wrote in message
news:Ow0xdjVNFHA.2372@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm trying to create a line graph/chart in reporting services. I have
> 2 stored procedures that outputs the count of 2 tables that created 2
> datasets.
> Both these procedures use a field called acctdates. I'm trying to
> use the acctdates as the catagory field and the 2 counts in the data
> field. But I keep receiving an error saying I can't use a field from
> another dataset for the current dataset. Is there a way around this
> problem? or is there a different way I should approach it?
> Please help....
>
> Thank you,
> Ricky
>