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)
 Can I run a report (SSRS) from a Stored Procedure?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rafael.soteldo
Starting Member

36 Posts

Posted - 10/12/2012 :  17:19:40  Show Profile  Reply with Quote
Suppose I create a report (made with SSRS), can I install it in a SQL Express 2008 DataBase and execute it via Stored Procedures?

Thanks in advance for your time

-------
Rafael Soteldo

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 10/12/2012 :  18:53:28  Show Profile  Reply with Quote
That seems like a very unusual workflow. Usually it flows the other way around - you have the report definition on a reporting site, and it uses a stored procedure (or a query) to connect to a database to generate the report.

Can you describe in more detail what your goal is?
Go to Top of Page

rafael.soteldo
Starting Member

36 Posts

Posted - 10/13/2012 :  19:15:02  Show Profile  Reply with Quote
I don't have the problem actually, but I'm in charge of making the investigation.

We are developing an LOB app using Silverlight (.NET), Silverlight doesn't have a native way of making data-centric reports and listings, so, I wonder if we can make reports in SQL Server, and then, execute those reports from the application as stored procedures.

Thanks in advance for your time

-------
Rafael Soteldo

Edited by - rafael.soteldo on 10/13/2012 19:16:22
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 10/14/2012 :  10:37:31  Show Profile  Reply with Quote
I don't know of a way to do what you are describing. The SSRS report definition is stored in .RDL files. Reporting services uses the RDL file together with the queries/stored procedures from the database to render the reports. Given that pattern, I don't see how you can call a stored procedure to accomplish the same thing.

I understand that Silverlight does not have a native way of rendering SSRS reports, but it may be possible to host SSRS reports in Silverlight. I am familiar with Silverlight only in passing, so I may be wrong - but google for it - for example this: http://sushantp.wordpress.com/2009/11/25/silverlight-reporting-support-for-ssrs-reports-problem-and-possible-solutions/
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
769 Posts

Posted - 10/14/2012 :  10:57:06  Show Profile  Reply with Quote
There is another option for running SSRS reports. You can use a local version (.rdlc) - where you have the .rdlc files and 'put' it together with the stored procedure. You would then use the SSRS report viewer control to display the report.
Go to Top of Page

rafael.soteldo
Starting Member

36 Posts

Posted - 10/15/2012 :  15:03:56  Show Profile  Reply with Quote
Thank you all!

Thanks in advance for your time

-------
Rafael Soteldo
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 10/18/2012 :  09:18:58  Show Profile  Reply with Quote

I couldn't imagine doing it another way. Get your query into a stored procedure. Give it parameters. Rely on a view or two. Test it. Once you have the results you want, use SSRS to present the results appealingly. Any changes or improvements later should be done in the SP or views.. tables.
Go to Top of Page

navya krishna
Starting Member

India
39 Posts

Posted - 01/23/2013 :  01:49:36  Show Profile  Reply with Quote
Dear all,

i have one problem in ssrs.i need to display sales report customer wise [sales and budget and variance and variance percentage] from different databases but in single server.it will be there detailes in multiple databases.i need to display detailes in single report.could you please anyone help me.for example we are maintaining 2010,2011 databases so i need to display customer no,sales,budget,variance,variance percentage in single report ...

year from 2012 year to 2013 date filter 01-01-12..31-12-13

Customer No. Sales -2012 Budget-2012 Variance-2012 Variance %-2012 Sales -2013 Budget-2013 Variance-2013 Variance %-2013

i need details like this in one report using multiple databases.please anyone help me.


navya krishna katta
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 01/23/2013 :  02:09:36  Show Profile  Reply with Quote
quote:
Originally posted by navya krishna

Dear all,

i have one problem in ssrs.i need to display sales report customer wise [sales and budget and variance and variance percentage] from different databases but in single server.it will be there detailes in multiple databases.i need to display detailes in single report.could you please anyone help me.for example we are maintaining 2010,2011 databases so i need to display customer no,sales,budget,variance,variance percentage in single report ...

year from 2012 year to 2013 date filter 01-01-12..31-12-13

Customer No. Sales -2012 Budget-2012 Variance-2012 Variance %-2012 Sales -2013 Budget-2013 Variance-2013 Variance %-2013

i need details like this in one report using multiple databases.please anyone help me.


navya krishna katta


please dont hijack threads to post your question
Start a new thread for your question as it will improve readability

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

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.08 seconds. Powered By: Snitz Forums 2000