Jump to report - ERR - One or more data sources is missing credent

I have a chart where I want to jump to a report when the user selects a
certain piece of the pie. In development, this works fine. ALSO from the
report viewer the report being JUMPed TO works fine individual, but when I
try to jump to it from the chart, I get the error, "One or more data sources
is missing credentials".
Anyone have any input on this?Just go to your data sources and go to credentials tab and key in your
passwrod again and save it and try running it. It will work.
Amarnath
"MSSQLServerDeveloper" wrote:
> I have a chart where I want to jump to a report when the user selects a
> certain piece of the pie. In development, this works fine. ALSO from the
> report viewer the report being JUMPed TO works fine individual, but when I
> try to jump to it from the chart, I get the error, "One or more data sources
> is missing credentials".
> Anyone have any input on this?|||'Data Sources' - You mean in the report manager? Will the end user have to
do this? I will try on Monday and let you know. Thanks in advance
"Amarnath" wrote:
> Just go to your data sources and go to credentials tab and key in your
> passwrod again and save it and try running it. It will work.
> Amarnath
>
> "MSSQLServerDeveloper" wrote:
> > I have a chart where I want to jump to a report when the user selects a
> > certain piece of the pie. In development, this works fine. ALSO from the
> > report viewer the report being JUMPed TO works fine individual, but when I
> > try to jump to it from the chart, I get the error, "One or more data sources
> > is missing credentials".
> >
> > Anyone have any input on this?sql

Joining 2 or more data sources.

I know in crystal I can join 2 different data sources with in the report . Is
this possible in RS ?
(note: by different data sources I mean 2 completely different machines) I
have he columns I can join on just cant find a way to join them . One way was
to bring both parts of the data to a consolidated location. But this is not
the case for some reports .
Any help would be great.
ThanksThe only way to do this is to either do this in a stored procedure or to use
subreports. You can not do a local join between two datasets.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"C.M" <CM@.discussions.microsoft.com> wrote in message
news:9797B692-086F-4325-88B6-5AD0ED038627@.microsoft.com...
>I know in crystal I can join 2 different data sources with in the report .
>Is
> this possible in RS ?
>
> (note: by different data sources I mean 2 completely different machines) I
> have he columns I can join on just cant find a way to join them . One way
> was
> to bring both parts of the data to a consolidated location. But this is
> not
> the case for some reports .
> Any help would be great.
> Thanks
>|||Do you know if they are going to allow users to join datasets in RS 2005?
"Bruce L-C [MVP]" wrote:
> The only way to do this is to either do this in a stored procedure or to use
> subreports. You can not do a local join between two datasets.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "C.M" <CM@.discussions.microsoft.com> wrote in message
> news:9797B692-086F-4325-88B6-5AD0ED038627@.microsoft.com...
> >I know in crystal I can join 2 different data sources with in the report .
> >Is
> > this possible in RS ?
> >
> >
> > (note: by different data sources I mean 2 completely different machines) I
> > have he columns I can join on just cant find a way to join them . One way
> > was
> > to bring both parts of the data to a consolidated location. But this is
> > not
> > the case for some reports .
> >
> > Any help would be great.
> >
> > Thanks
> >
>
>|||Not that I have heard.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Clark Kent" <Clark Kent@.discussions.microsoft.com> wrote in message
news:A0BC297B-0DB8-4721-9989-49EF918B7CF5@.microsoft.com...
> Do you know if they are going to allow users to join datasets in RS 2005?
> "Bruce L-C [MVP]" wrote:
>> The only way to do this is to either do this in a stored procedure or to
>> use
>> subreports. You can not do a local join between two datasets.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "C.M" <CM@.discussions.microsoft.com> wrote in message
>> news:9797B692-086F-4325-88B6-5AD0ED038627@.microsoft.com...
>> >I know in crystal I can join 2 different data sources with in the report
>> >.
>> >Is
>> > this possible in RS ?
>> >
>> >
>> > (note: by different data sources I mean 2 completely different
>> > machines) I
>> > have he columns I can join on just cant find a way to join them . One
>> > way
>> > was
>> > to bring both parts of the data to a consolidated location. But this is
>> > not
>> > the case for some reports .
>> >
>> > Any help would be great.
>> >
>> > Thanks
>> >
>>