| Author |
Topic |
|
rafael.soteldo
Starting Member
36 Posts |
 Posted - 2012-10-12 : 17:19:40
|
| 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
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-12 : 18:53:28
|
| 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? |
 |
|
|
rafael.soteldo
Starting Member
36 Posts |
Posted - 2012-10-13 : 19:15:02
|
| 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 |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-14 : 10:37:31
|
| 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/ |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-10-14 : 10:57:06
|
| 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. |
|
|
|
rafael.soteldo
Starting Member
36 Posts |
Posted - 2012-10-15 : 15:03:56
|
| Thank you all!Thanks in advance for your time-------Rafael Soteldo |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2012-10-18 : 09:18:58
|
| 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. |
|
|
|
navya krishna
Starting Member
39 Posts |
Posted - 2013-01-23 : 01:49:36
|
| 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-13Customer 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 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-23 : 02:09:36
|
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-13Customer 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 questionStart a new thread for your question as it will improve readability------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Can I run a report (SSRS) from a Stored Procedure?