IF OBJECT_ID('tempdb..#test', 'U') IS NOT NULL

DROP TABLE #test;

CREATE TABLE #test

(

requestid INT,

eventdate DATETIME,

...

Hi Phil,

Thank you for your answer. This query is for a log application.

I have focused on 1 request ( requestid). But it is possible they are several requestid

This is...

No answer ??

I really need your help.

All suggestions are appreciated !!!

Thank U.

That works well

OK. But I have not possibilities to have the SSAS solution.

But I can't do it in my report ?

It's only for a report !!!!!!!!!

Thank you Sir.

I tried this and that's work well.

But I dont't know why my [ALL MEMBER] is null.

Do you know I can rename it like ' All Clients' ...

Re All,

I tried this

SELECT NON EMPTY {[Measures].[MyMeasure]} ON COLUMNS,

NON EMPTY {

Hierarchize (

Generate (

...

Any idea !!! Please !!!!

OK.

I want to design an SSRS report based on a ssas multidimensionnal cube.

This report display the top 10 sales for the company.

I want that user can dynamically display ( top...

Please help !!!!!!!!!!!!!

Thank U Martin.

Thats works good !!!

Thank You MicVog,

I will try the third solution and I will let you know.

Thank U

Hi Jack,

Thank U for your answer.

So, do U know how can I do it within the report server?

I hearded that it's possible with C# script: http://stackoverflow.com/questions/15831328/ssrs-disabling-export-options-eg-pdf-for-individual-reports

Hi,

I have the problem.

Did U find solution for it ?

Lidou

Thanks !!! 🙂