You could add a field to your dataset either in your report or before it comes to the report & make it a varchar made up of your value +...

Just to check I'm on your page here..

Do you mean: you have a graph with data labels and you want the data labels to show [value]:1 ?

Have you tried this...

Hmm.

Ok So we have it like this...

@Param1 - multiple values

@Param2 - multiple values

@Param3 - multiple values

@Param4 - multiple values

Do they all feed into a single dataset or is it 4...

I think i'm catching on now.

So that SQL is the dataset used for your parameter?

Ok, so what does the query that uses the parameter look like?

it should be something like...

Use an iif statement in the textbox's visibility expression.

something along the lines of

isHidden

=iif(@hideParam = 1, True,False)

make sense?

Its fairly easy in SSRS 2008 R2.

You can set the X axis as a date range and get it to display all dates regardless of any data.

BUT...in SSRS 2008 its...

Hey,

I'm not sure I follow here - are the text parts in your SELECT's meant to be the parameters?

Because the SQL you posted will just output the below with no...

if your shared datasource is set to "windows security" you shouldnt get the prompt. I take it this isnt an option though? I assume your datasource should use the credentials...

Hey,

Not sure I follow you 100% so I'll suggest something but feel free to provide more info or correct me.

Ok, so I'd suggest you use your existing AD Group (COMP\reportwriters)....

Hey,

Not sure this will be much help to you..but..

There's no way to do this out the box I'm afraid. Assuming I have your intentions right, here is how I'd do...

Hi,

Thanks for the reply. I'll check out the scripts as I was also worried about the single file issue here.

Some of the grooming jobs do change the recovery model which...