Viewing 15 posts - 5,041 through 5,055 (of 19,564 total)
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...
February 5, 2013 at 11:12 pm
You are welcome.
February 5, 2013 at 4:24 pm
I have not found any good reliable documentation on the RS database.
Much of it comes from discovery and tinkering.
February 5, 2013 at 4:13 pm
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...
February 5, 2013 at 4:09 pm
You are welcome.
February 5, 2013 at 4:03 pm
I have also added a download link on the blog with the properly formatted code.
February 5, 2013 at 3:55 pm
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...
February 5, 2013 at 3:48 pm
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...
February 5, 2013 at 3:26 pm
warner chaves (2/5/2013)
February 5, 2013 at 3:20 pm
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.
February 5, 2013 at 3:19 pm
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.
February 5, 2013 at 3:13 pm
You can look in the datasets for that report. You would typically see those on the left hand sand from within BIDS (Vis. Studio)
February 5, 2013 at 2:05 pm
Stuart Davies (2/5/2013)
Lynn Pettis (2/5/2013)
SQLRNNR (2/5/2013)
Ray K (2/5/2013)
SQLRNNR (2/4/2013)
crookj (2/4/2013)
Daniel Bowlin (2/4/2013)
SQLRNNR (2/4/2013)
bcsims 90437 (2/1/2013)
sing4you (2/1/2013)
ToastMelty Peanut butter....Yum
NUTELLA - nuf said
mmmmmmmm
On Celery.....
On more nutella
On Prancer! On Vixen!
Rudolph
Olive (the other...
February 5, 2013 at 1:54 pm
Ray K (2/5/2013)
SQLRNNR (2/4/2013)
crookj (2/4/2013)
Daniel Bowlin (2/4/2013)
SQLRNNR (2/4/2013)
bcsims 90437 (2/1/2013)
sing4you (2/1/2013)
ToastMelty Peanut butter....Yum
NUTELLA - nuf said
mmmmmmmm
On Celery.....
On more nutella
On Prancer! On Vixen!
Rudolph
February 5, 2013 at 1:30 pm
Viewing 15 posts - 5,041 through 5,055 (of 19,564 total)