What?
We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, ...
... one of my reports uses a row counter to display a "No data found" message when no rows are returned. This does not affect the above problem as the stored procedure simply fails and discontinues processing ...
What?
I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a ...
Why?
I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able ...
... enough and always saying 0 seconds was just confusing the end-user...
Workaround #1
Although I'm convinced of a solution considering the ReportServer database will be able to tell you how many ...
... an overview of some:
Method #1
Create one report with all selectable reports as subreports - toggle visibilty based on parameter.
Method #2
Add a button below "View Report" linked to some ...
Situation
The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just ...
Open a Windows Explorer and make a duplicate of the report that you want to use as a template.
Rename the copy (suffix with template?)
Remove objects unique to the report and leave elements for all ...
Update August 2011
So I don't know how many people were just saying why don't you do the following:
Bring up the "Tablix Properties" of the dataset
Look for the section "No Rows"
Put in a value ...
... Reporting Server URL.
Note:
Change "" to the name of your Reporting Server
Change "%2fMYREPORTS%2fDemos%2fRB+Report+for+Me" to the name and folder of your report.
To hide all except ...
... source name
Enter the login information
Test the connection and click on OK
Create the Report
Still within Business Intelligence Development Studio (BIDS)
Right-click on "Reports" in the ...
... reports though.
The error I'd get was
An error occurred during local report processing.
An error has occurred during report processing.
Cannot read the next data row for the dataset DataSet1. ...
... are reports though that some people set up websites with NO 3rd-party items whatsoever... For those of you with this issue, I'd double-check your website host allows Joomla and if they don't, look for either ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.