rqR'us

You could create a new parameter (@month) in your report defined as integer.

Then you select the "Non-Queried" option and in the Label/Value...

Hi,

What we ended up doing is using something like this in each of our label iif( Parameters!ReportLang.Value =1,"Heure Début:","Start Time:") inside of our label...

You could also use the global variable user!language to...

Hi,

I will try to be as clear as possible, excuse my english

What you will need to do is for the SP's that are used to generate the...

Hi sara,

I just try to stay away from dynamic SQL

Eric

Hi,

What I usually do is create a user defined function that will convert my comma separated list into a table and then join on this table in my SQL statement.

Like...

Hi,

Have you installed RS SP1?

Might be it.

Eric

Sorry,

I gave it a try and it doesn't work the way a tought it would.

I was able to modify the decimal and grouping symbol by specifying a different language in...

Hi,

In the textbox property. you could use custom formatting string like this ###.###,##

HTH,

Eric

I'm happy to see that I'm not the only one using GOTO for error handling . I think it makes sense when your...

Hi,

We use this kind of functionality a lot. This should get you started:

1- Edit your Group

2 - In the Group On option you should have something like this:

=iif( Parameters!ReportGrouping.Value =...

Hi,

I usually try to stay away of GOTO statement but i have to admit that i've used it a few time in the past for error handling...

Sorry about that,

Just add the group by statment in the join like so:

SELECT

 h.client,

 count(*)  as Count_Total_Slots,

b.EmptySlot

FROM database1.dbo.Hardware H

JOIN (SELECT COUNT(*) AS EmptySlot,client FROM database1.dbo.Hardware WHERE Removed...

Hi,

Maybe something like this would do the trick:

SELECT

 h.client,

 count(*)  as Count_Total_Slots,

b.EmptySlot

FROM database1.dbo.Hardware H

JOIN (SELECT COUNT(*) AS EmptySlot,client FROM database1.dbo.Hardware WHERE Removed IS NULL and  (substring(model, 1,...

3. Can I include other reports in a report?

This can be achieve using sub-reports.

What about using a global temporary table ...