Back to basics question.

If you do not have the report data window visible (either as a tab or as a window within bids), then click view and then click report data (at the...

You are welcome.

I have not found any good reliable documentation on the RS database.

Much of it comes from discovery and tinkering.

You can't use CASE in that way. What you want to be using is IF blocks.

IF @GetRowcount=0

Begin

-- insert

END

IF @GetRowcount<>0

BEGIN

-- update

END

But this really looks like a prime...

You are welcome.

I have also added a download link on the blog with the properly formatted code.

I see what happened. The value and text() all got UpperCased. They should be lower case like in the attached script

DECLARE @ReportName VARCHAR(100)

SET @ReportName = NULL;

CREATE TABLE...

This is considered a best practice - to move system databases off of the c drive. I move all of my system databases to a different volume when possible.

Here...

warner chaves (2/5/2013)

---

Hi guys, I just took the remote lab exam about 3 weeks ago, just wondering if anyone knows what the turnaround time for the results is nowadays. I've...

My recommendation to them would be to not change the db name. If it must be changed, hunt down the connection strings and make the appropriate changes.

Sounds like you may have miscopied the script. Paste the exact query you have decided to use. Also make sure you are running this against the ReportServer database.

You can look in the datasets for that report. You would typically see those on the left hand sand from within BIDS (Vis. Studio)

Stuart Davies (2/5/2013)

---

Lynn Pettis (2/5/2013)

---

Olive (the other...

Rudolph