Newbie: Object name 'ProductSubCategory' is not valid.

[Ibai Peña]

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

[Kaisa M. Lindahl]

"Ibai Peña" <Iba...@discussions.microsoft.com> wrote in message
news:5AB26ADF-387C-4588...@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

[Ibai Peña]

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

[Ibai Peña]

RSConfig.exe file. Sorry, sometimes it is better to spend some time before
asking.

Regards,
Ibai Peña