Check out the attached report file. You'll need to change the Data Source "DS_Database" to point to a real server for the report to run.

This has an example of how...

That's embarrassing; I did a CTRL+F search for "Backup" without checking the forum title. Thanks for the information.

On the "Chart Data" context menu that appears when you select on the chart, right-click the value under "Category Groups" (by default "= (Details)"),

Select "Category Group Properties"

Switch to the...

Sure - it extracts the binary report data (the actual report) from the ReportServer database, converts it to XML and extracts the relevant fields for Query Text and Query Type...

I'm not sure of a standard method - searching the solution in BIDS doesn't identify matches within queries.

There are two methods:

1. Download an application that can search file contents,...

Here is how I would solve this problem, however there may be an easier solution:

CREATE FUNCTION [dbo].[SplitByXChars]

(

@string nvarchar(max),

@segmentLength int

) RETURNS @t TABLE

(

val nvarchar(max)

)

AS

BEGIN

...

Consider the below - this is my preferred way of solving this type of issue. (Redundant brackets around the outside because I would then likely add another unrelated condition that...

In my office I've written an AJAX webpage that updates every 60 seconds, and checks the ReportServer database tabless of our report servers for report executions (automated report subscriptions and...

What are you using to show your status matrix? Are you successfully retrieving tasks (the objects you are setting the status for) from an SQL query? Have you written an...

Hi thammunhui, could you please upload some screenshots to give us a better understanding of this issue?

Andrew

I suggest passing the parameter to SQL and letting SQL handle filters in its WHERE clause (if you can modify the query/stored procedure). I believe using a dataset query will...

This issue has come up quite a few times at my work.

This is caused by Internet Explorer 11 identifying as Mozilla/Webkit and SSRS identifying it as a non-IE browser and...

You may want to upload your image to an image sharing website - your attachments aren't opening.

To chain report parameters, in your second parameter's query's WHERE clause, refer to @<first...

If I understand correctly, you're asking how can you stop BIDS from automatically generating the report when you open the "Preview" tab. I haven't been able to do this myself...

Your expression is correct. Are you able to paste the SELECT statement and the query results when ran in SSMS?