If you had ever the fun to deal with the advanced quantum mechanics of oracle licensing you're really happy with the 'all inclusive' approach of sql server.

Hi,

if you can change the query of your report and the table it queries isn't to big, you can try to hide the easily guessed value for your parameter in...

Hi,

have you tried adding a row group to your tablix?

Lars

What kind of authentification do you use for your database? You should execute ist locally on the server where your SSRS is installed to get a better error message, but...

When you populate your available values with a dataset, you can use two different columns as the label and the value. So you can select the label or the value...

Hi

did you try the builtin SSRS GUI under http://yourservername/reports? You can easily manage your reports there, organize them in folders and set permissions to view items on folders...

Hi,

have a look at your string, between seconds and milliseconds should be a "." not a ":"

Lars

Hi Randy,

you should have a look at the PIVOT function, in BOL it's documented somewhere under the FROM... clause.

Lars

Hi,

does this work for you?

DECLARE @fromdate DATETIME = '2011-01-20';

DECLARE @todate DATETIME = '2011-02-10';

DECLARE @productid INT =1;

WITH DateRange AS

(SELECT @fromdate AS [date]

UNION ALL

SELECT DATEADD(DAY,1,[date]) AS [date] FROM DateRange WHERE [date] <...

Hi,

this will get you all the dates from previous december:

BETWEEN DATEADD(MONTH,-1,DATEADD(YEAR,DATEDIFF(YEAR,0,@MyToMonth),0)) AND DATEADD(DAY,-1,DATEADD(YEAR,DATEDIFF(YEAR,0,@MyToMonth),0))

Lars

OK, sorry, just realized that this is the subforum for 2000, so the query above wouldn't work, cte is a feature of 2005 and above...

🙁

I'm just starting to find my...

Hello Oliver,

we used the possibility to generate reports via URL from many different applications written in java, powerbuilder , c++ and other languages. SSRS is a great way to manage...

Hello Rolf,

maybe this way:

DECLARE @startdate DATE;

DECLARE @daytofind INT;

SET @startdate = '2011-11-29';

SET @daytofind = 2;

WITH myWeek AS

(SELECT @startdate AS myDay, DATEPART(WEEKDAY, @startdate) as MyDayofWeek

UNION ALL

SELECT DATEADD(dd,1,myDay) AS myDay, DATEPART(WEEKDAY, DATEADD(dd,1,myDay))...

Maybe this project can help you:

http://sqlmetadata.codeplex.com/

it's still in development for 2008, but there is also a version for 2005