sql server reporting services: how to use Foodmart sample reports? -- sql server reporting services

You're in the

sql server reporting services

group:

how to use Foodmart sample reports?

how to use Foodmart sample reports?

lins
1/19/2005 1:21:48 PM

sql server reporting services:
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!

Re: how to use Foodmart sample reports?

Lukasz Pawlowski [MSFT]
1/19/2005 2:51:43 PM

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.

[quoted text, click to view]

Re: how to use Foodmart sample reports?

lins
1/20/2005 11:14:01 AM

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.

Re: how to use Foodmart sample reports?

Lukasz Pawlowski [MSFT]
1/20/2005 12:38:03 PM

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.

[quoted text, click to view]

Re: how to use Foodmart sample reports?

lins
1/20/2005 2:10:08 PM

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.

Re: how to use Foodmart sample reports?

Lukasz Pawlowski [MSFT]
1/24/2005 4:14:30 PM

Do you have Analysis Services deployed on your machine?

-Lukasz

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn