It isn't working with Reporting Services 2008.

No failures, but the Tooltip duration keeps the same.

If anybody has a clue or if they can get it to work, I'm interested.

Regards, Harm....

Veeren,

This is EXACTLY what I'm looking for.

I've implemented it, now I'm testing for results.

Thnx!

Chris,

Thanks for all your replies!

I'm reading the articles you've pointed out to me, very educational.

Regards, Harm....

What do you mean?

I just expand [1], [2] until [31] (for days of month)???

Because this was how we started, but I liked the [1] till [31] to be dynamic.

Or do...

Like the results from the first answer.

Application123456.......31 MaxUsage

Office2003433000....... x 4

Telebanking232000....... x 3

Yes, it is.

My original output (from the first answer of Chris) was:

With the dynamic pivot it is:

ApplicationOffice2003Telebanking

Office20033 NULL

TelebankingNULL...

I'm trying to understand (still beginner sql), but still getting strange results:

EXEC dynamic_pivot

'SELECT i.Application, i.daynr

FROM ict_apps i',

'application',

'max(daynr)'

Horizontal I've the application (OK), but vertical I like the days with a final...

I've tried to work out the "Fetch" command. See my result, but I got an error

Msg 102, Level 15, State 1, Line 44

Incorrect syntax near '@Dagen'.

Msg 102, Level 15, State...

Chris,

I used the query (2nd) with succes. GREAT RESULTS!

Last question:

I'm trying to get the columns Appliction, Daynr, MaxUsage but I'm stuck.

I'm only getting Application and MaxUsage like in your example.

I...

First of all thanx for the reply!

Will this also work when the table "ICT_Apps" is automaticly filled each day and the results should be

like "where monthnr=month(getdate())", because in this example...

Ok....

I've solved the problem on a different way.

Now I use the next code:

If @P_Type = 'Totaal' Goto Totaal

If @P_Type = 'Geregistreerd' ...

Hi, thx for the reply.

This query has to function in a dataset from a subreport in Reporting Services.

By passing different parameter values I would like to use 1 report with...

Tenga,

Maybe there is a better way, but what I would do is the next:

* Create parameter P_Startdate for Startdate

* Create parameter P_Enddate for Enddate

In the dataset you use to get...

(Luke, it seems that you where right afterall......)

Still looking and triggered why I couldn't get User!UserID to work for me, I searched and tryed on.

I've found the solution for my...

Thanks for the reply, but as you could read in my first sentence is that not the solution.

Looking further for a solution, any help is welcome.....