No announcements
Found 869645 threads
-
0 VotesUsing Stored Procedure in Reporting
Prodesh, if you getting error when u try to execute the Stored Procedure in DATA tab in Report but no error when u execute in Oracle DB then you ...Answered | 1 Replies | 4669 Views | Created by prodesh - Wednesday, May 5, 2010 5:29 PM | Last reply by Anilchow202 - Wednesday, May 5, 2010 7:14 PM
-
2 Votes
creating a report from a stored procedure
I am trying to create a new report using a stored procedure. when i click on add new report it is taking me to a window where i need to write the query.Answered | 4 Replies | 2411 Views | Created by Honeycrust - Monday, February 13, 2012 2:32 PM | Last reply by Honeycrust - Monday, February 13, 2012 3:53 PM -
0 Votes
Stored Procedures in Report
Well, I would use RSScripter to dump the catalog to a Visual Studio BIDS project and do a text search of the RDL to see which procedures are called.Answered | 3 Replies | 3318 Views | Created by Shailesh Thapliyal - Thursday, July 7, 2011 4:34 PM | Last reply by Shailesh Thapliyal - Thursday, July 7, 2011 7:50 PM -
2 Votes
Using stored procedure with Report Wizard?
Hi, Try these steps Open Reports Solution In Solution Explorer Right Click on Reports Click on Add New ...Answered | 2 Replies | 14292 Views | Created by Martin_70 - Monday, February 15, 2010 12:50 PM | Last reply by VS Patel - Monday, February 15, 2010 1:17 PM -
0 Votes
report designer not seeing stored procedure
I can do this using the Microsoft AdventureWorks databases and creating stored procedure and then create report based on the sp.Answered | 4 Replies | 6404 Views | Created by ghw123 - Monday, September 26, 2011 10:55 PM | Last reply by ghw123 - Thursday, September 29, 2011 8:42 PM -
0 Votes
Creating a stored procedure for a subscribed report
You can not mix procedural logic this way.Answered | 1 Replies | 586 Views | Created by Machzy - Thursday, February 25, 2016 6:26 PM | Last reply by Naomi N - Thursday, February 25, 2016 6:41 PM -
1 Votes
Stored procedure error display on report
Hi Linda, I suggest you try to select the error string as a row data in your stored procedure when there is no row returned, please ...Answered | 3 Replies | 6003 Views | Created by Linda Cornerstone - Wednesday, May 4, 2011 2:04 PM | Last reply by Eileen Zhao - Monday, May 9, 2011 6:02 AM -
0 Votes
Different results in Stored Procedure and in the report
Hi DReddyC, According to your description, the stored procedure contains a parameter, when you run the procedure in dataset, it can return corresponding ...Answered | 2 Replies | 697 Views | Created by DReddyC - Wednesday, October 21, 2015 6:39 PM | Last reply by Qiuyun Yu - Thursday, October 22, 2015 6:36 AM -
1 Votes
SSRS Report using stored procedure
I can create a dataset using stored procedure, but can not link to the report using VS 2012 Express.Answered | 3 Replies | 5013 Views | Created by sourises - Monday, November 12, 2012 3:06 PM | Last reply by sourises - Monday, November 12, 2012 10:16 PM -
0 Votes
Basing a crystal report on a stored procedure...
You will have to connect to the crystal report programmatically.Answered | 1 Replies | 2893 Views | Created by Brad Pears - Thursday, June 30, 2011 9:08 PM | Last reply by Dig-Boy - Friday, July 1, 2011 1:28 AM -
0 Votes
Stored Procedure not recognizable in Report Builder
Check if you have specified credentials have permissions to the database and also you can select storedprocedure in your radiobutton and will give you the list of stored ...Answered | 3 Replies | 5821 Views | Created by abhishekgandhi - Friday, May 4, 2012 12:27 PM | Last reply by Syed Qazafi Anjum - Saturday, May 5, 2012 11:05 AM -
0 Votes
Stored Procedure
Even if you want your logic in a stored procedure, you can get the results returned directly from the stored procedure.Answered | 8 Replies | 3950 Views | Created by Binggoy - Monday, October 3, 2011 5:08 AM | Last reply by Steen Schlüter Persson - DK - Monday, October 3, 2011 8:39 AM -
0 Votes
Using stored Procedures in SSRS Reports - Access question
You would store the database access credentials securely in your datasource, and save them so that each report using this datasource uses that user to access the database.Answered | 2 Replies | 954 Views | Created by Greeneyed_lady - Wednesday, July 30, 2014 9:16 PM | Last reply by ReportCreator - Wednesday, July 30, 2014 10:37 PM -
2 Votes
call a srrs report from within a stored procedure
Or execute the report in the Report Manager if the report was deployed to Report Server.Answered | 3 Replies | 1291 Views | Created by Maneet10 - Tuesday, March 19, 2013 2:19 PM | Last reply by Charlie Liao - Wednesday, March 20, 2013 5:34 AM -
0 Votes
Link 2 store procedures in 1 crystal report
I have not worked with crystal reports but in such cases like in SSRS - you can define to two different datasets( one for each stored procedure) and in the report ...Answered | 4 Replies | 962 Views | Created by Durgavalli26 - Wednesday, May 20, 2015 1:46 AM | Last reply by Lydia Zhang - Thursday, May 21, 2015 6:39 AM -
0 Votes
Calling a Stored Procedure from SSRS Report
First I assume the below is wrapped in a stored procedure.Answered | 2 Replies | 18137 Views | Created by reporting_beginner - Thursday, June 11, 2009 6:47 PM | Last reply by Jinchun Chen - Friday, June 19, 2009 10:05 AM -
0 Votes
Advantage in using stored procedure for SSRS reports
If you design your reports with text query you need to make changes to the dataset which consumes more time than modifying your SP.Answered | 4 Replies | 6035 Views | Created by karthik_karthik - Thursday, August 11, 2011 2:39 PM | Last reply by vvsut - Thursday, August 11, 2011 3:49 PM -
0 Votes
Calling a Stored Procedure (with parameters) to open up a report
Hi Gary, As far as I know, Visual Studio Crystal report wizard support Stored procedure as CR's data source directly, and there is a sample ...Answered | 1 Replies | 5985 Views | Created by Gary Cowan - MCITP - Thursday, September 25, 2008 3:14 PM | Last reply by jack 321 - Monday, September 29, 2008 6:32 AM -
0 Votes
Trouble binding report to a stored procedure with parameters
Generally, we are using SSDT for VS 2015 to design Reporting Service 2016 reports.Answered | 1 Replies | 1586 Views | Created by DarrellDoesData - Friday, September 23, 2016 12:39 AM | Last reply by Xi Jin - Friday, September 23, 2016 7:54 AM -
0 Votes
Help in Reporting , SSRS , Stored Procedure
I am getting data from a table and i am writing off to the report.Answered | 2 Replies | 701 Views | Created by sqlPreacher - Tuesday, September 9, 2014 1:19 AM | Last reply by Visakh16 - Tuesday, September 9, 2014 3:11 AM - Items 1 to 20 of 869645 Next ›
No announcements
