SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS problem using Report model as datasource
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

michaeljc70
Starting Member

7 Posts

Posted - 12/21/2012 :  09:57:51  Show Profile  Reply with Quote
I have written many SSRS reports, but am not that familar with deploying them or report models.

Basically, I am maintaining some reports that use report models. The server and database changed. I went into the project with the datasource and model and updated the server/database in the data source and deployed the datasource and the model. The reports still don't work. The error (in Report Manager) is:

"Cannot create a connection to data source 'dataSource1'".
I get the same error when opening the report project and trying to refresh the report.

What confuses me is in the report itself, the datasource has "Report Server Model" selected, but has a long semantic query that doesn't point to the model (that I can tell).

The report has the report model selected in report manager as the data source.


visakh16
Very Important crosS Applying yaK Herder

India
52323 Posts

Posted - 12/21/2012 :  10:02:18  Show Profile  Reply with Quote
can you view code for report (the XML) and see if you can spot any instances of old server and database inside?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

michaeljc70
Starting Member

7 Posts

Posted - 12/21/2012 :  10:09:44  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

can you view code for report (the XML) and see if you can spot any instances of old server and database inside?




Yes, but there isn't any reference other than to the model. The model is in a separate solution.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52323 Posts

Posted - 12/21/2012 :  10:15:59  Show Profile  Reply with Quote
and you've redeployed the model right?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

michaeljc70
Starting Member

7 Posts

Posted - 12/21/2012 :  10:17:36  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

and you've redeployed the model right?





Yes. Twice.

I can see the reference to the model in the code, but where do I see it in the designer? In the connection string is just that semantic query.
Go to Top of Page

michaeljc70
Starting Member

7 Posts

Posted - 12/21/2012 :  10:19:40  Show Profile  Reply with Quote
The DB was also upgraded to 2008 from 2005 if that matters.
Go to Top of Page

navya krishna
Starting Member

India
39 Posts

Posted - 01/20/2013 :  00:14:42  Show Profile  Reply with Quote
Dear all,

i am new for ssrs reports.i need some clarifications on ssrs.

we have one client he want's to display sales report by customer wise using different databases.for example he is maintaining every year databases seperatly in single server.so he need to display in single report.how can i display in single report.could you please any one explain clearly how to do that.

navya krishna katta
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52323 Posts

Posted - 01/20/2013 :  01:29:16  Show Profile  Reply with Quote
are the databases in the server? if yes, you could do like


SELECT * FROM DB1.dbo.table
UNION ALL
SELECT * FROM DB2.dbo.table
...

then use this as query behind for dataset in the report

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

navya krishna
Starting Member

India
39 Posts

Posted - 01/22/2013 :  05:28:56  Show Profile  Reply with Quote
Hi visakh,

if i write that query i am not getting result.

navya krishna katta
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.8 seconds. Powered By: Snitz Forums 2000