how to use Foodmart sample reports?

i'm new to reporting service and would appreciate some helps with the
problem i ran into.
background: sql2k on w2k3 with sp3a. sql analysis service, vs .net
2003. and reporting service.
I set up the distributed installation, sql server, reporting server,
analysis service on the same box, but the report designer and vs .net
2003 are on developer's machine.
After installation and upload of the sample database (AdventureWorks),
all the reports worked except Foodmart Sales report. see error msg:
============== An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'FoodMart 2000'.
(rsErrorOpeningConnection) Get Online Help
Unspecified error
===============
how to make this report works? i've installed the analysis services on
the server, but i didn't see a database for foodmart on the sql server
(i saw AdventureWorks, ReportServer, ReportServerTempDb)
Thank you!Foodmart is the sample database that ships with SQL Server 2000. You should
be able to find the foodmart cube with your original SQL distribution.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"lins" <steve.lin@.powells.com> wrote in message
news:1106169708.806166.137040@.c13g2000cwb.googlegroups.com...
> i'm new to reporting service and would appreciate some helps with the
> problem i ran into.
> background: sql2k on w2k3 with sp3a. sql analysis service, vs .net
> 2003. and reporting service.
> I set up the distributed installation, sql server, reporting server,
> analysis service on the same box, but the report designer and vs .net
> 2003 are on developer's machine.
> After installation and upload of the sample database (AdventureWorks),
> all the reports worked except Foodmart Sales report. see error msg:
> ==============> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'FoodMart 2000'.
> (rsErrorOpeningConnection) Get Online Help
> Unspecified error
> ===============> how to make this report works? i've installed the analysis services on
> the server, but i didn't see a database for foodmart on the sql server
> (i saw AdventureWorks, ReportServer, ReportServerTempDb)
> Thank you!
>|||i saw the foodmart cube in analysis service, but not as a database in
sql server. am i missing something here? can someone give me some step
by step check list to make that reprot works? i searched online help
and microsoft site and found no info how reporting services work with
analysis servcies.
thank you.|||Yes, foodmart is a cube. here's the description of the sample report:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_samplereports_v1_0jlf.asp
here's a description of how to install AS and the foodmart sample database:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/aginstalling_5trn.asp
Once this is done, you'll need to configure the report's datasource to
access the foodmart database (cube). You can do this on the
properties->data sources tab for the report.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"lins" <steve.lin@.powells.com> wrote in message
news:1106248441.279279.304390@.c13g2000cwb.googlegroups.com...
>i saw the foodmart cube in analysis service, but not as a database in
> sql server. am i missing something here? can someone give me some step
> by step check list to make that reprot works? i searched online help
> and microsoft site and found no info how reporting services work with
> analysis servcies.
> thank you.
>|||thank you for the reply. as i said earlier, i'm new to reporting
service. i wonder if someone has worked with the foodmart sample
report before can provide me a sample data soruce connection string.
the current one on my reporting server for the foodmart looks like this
Connection Type: OLE DB
Connection String: Provider=MSOLAP.2;Client Cache Size=25;Data
Source=localhost;Initial Catalog=FoodMart 2000;Auto Synch Period=10000
(but this connection string is not working for me. )
and i'm using Windows NT Integrated Security.
thank you.|||Do you have Analysis Services deployed on your machine?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"lins" <steve.lin@.powells.com> wrote in message
news:1106259008.263757.204280@.z14g2000cwz.googlegroups.com...
> thank you for the reply. as i said earlier, i'm new to reporting
> service. i wonder if someone has worked with the foodmart sample
> report before can provide me a sample data soruce connection string.
> the current one on my reporting server for the foodmart looks like this
> Connection Type: OLE DB
> Connection String: Provider=MSOLAP.2;Client Cache Size=25;Data
> Source=localhost;Initial Catalog=FoodMart 2000;Auto Synch Period=10000
> (but this connection string is not working for me. )
> and i'm using Windows NT Integrated Security.
> thank you.
>