Newbie: Object name 'ProductSubCategory' is not valid.

Hi all,
I have just installed Reporting Services in a W2003 server (without VS.Net).
and SQL Server 2000.
I have run the Report Administrator, and after inserting my the windows
admin user and its password, looks like it works.
Then I load the example file Company Sales.rdl which is in the
Samples\Reports folder. looks like it loads perfectly.
But when I click on it in order to see the file, gives me that error:
Error while processing report(rsProcessingAborted). Query execution error
for Sales dataset (rsErrorExecutingCommand).
The object name 'ProductSubCategory' is not valid.
What am I doing wrong?
Any help/hint or whatever will be wellcome.
Thanks in advance,
Ibai Peña"Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
<cut>
> Then I load the example file Company Sales.rdl which is in the
> Samples\Reports folder. looks like it loads perfectly.
> But when I click on it in order to see the file, gives me that error:
> Error while processing report(rsProcessingAborted). Query execution error
> for Sales dataset (rsErrorExecutingCommand).
> The object name 'ProductSubCategory' is not valid.
>
Have you created the Datasource yet? You need to create a data source for
the sample reports to run. The Books Online explains how to and what
settings to use.
Kaisa|||Thank you for your replay.
I was just to post that I have found that the datasource wasn´t defined.
What leads me to the next question:
Is is possible to set a default datasource for all reports?
Thanks,
Ibai Peña
"Kaisa M. Lindahl" wrote:
> "Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
> news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
> <cut>
> > Then I load the example file Company Sales.rdl which is in the
> > Samples\Reports folder. looks like it loads perfectly.
> >
> > But when I click on it in order to see the file, gives me that error:
> >
> > Error while processing report(rsProcessingAborted). Query execution error
> > for Sales dataset (rsErrorExecutingCommand).
> > The object name 'ProductSubCategory' is not valid.
> >
> Have you created the Datasource yet? You need to create a data source for
> the sample reports to run. The Books Online explains how to and what
> settings to use.
> Kaisa
>
>|||RSConfig.exe file. Sorry, sometimes it is better to spend some time before
asking.
Regards,
Ibai Peña
"Ibai Peña" wrote:
> Thank you for your replay.
> I was just to post that I have found that the datasource wasn´t defined.
> What leads me to the next question:
> Is is possible to set a default datasource for all reports?
> Thanks,
> Ibai Peña
> "Kaisa M. Lindahl" wrote:
> > "Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
> > news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
> > <cut>
> > > Then I load the example file Company Sales.rdl which is in the
> > > Samples\Reports folder. looks like it loads perfectly.
> > >
> > > But when I click on it in order to see the file, gives me that error:
> > >
> > > Error while processing report(rsProcessingAborted). Query execution error
> > > for Sales dataset (rsErrorExecutingCommand).
> > > The object name 'ProductSubCategory' is not valid.
> > >
> >
> > Have you created the Datasource yet? You need to create a data source for
> > the sample reports to run. The Books Online explains how to and what
> > settings to use.
> > Kaisa
> >
> >
> >