Hi,

I am working with SSRS 2008.

InitialTogleState is Boolean. How can I set to Collapse?

Thanks,

Peter.

Thank you for suggestion!

Could you specify exactly what control/property to look at? I can't find expand/collapse property...

Thanks,

Peter.

In case anyone interested here is the solution:

http://www.mssqltips.com/tip.asp?tip=1283

basically I needed to use a javascript function:

void(window.open('your url'))

and define it in my Experssion for Go to URL Action.

Peter.

Yes, my paramters were created by a RS Query Designer. Here is the entire query generated by the tool

//********************

SELECT NON EMPTY { [Measures].[Remote Hrs], [Measures].[PTO Hrs], [Measures].[Total Charged Hours],...

How can I use the above hierarchy to define default values for report parameters in my report? It is a Reporting Services report is sitting on the top of Analysis...

Thanks a lot, Steve! It worked out great!

Peter.

I understand that it will give me the measure (in your example Order Line) for the current day. Correct?

I need a total measure aggregated for the entire time period, like...

Do you have any examples by chance. I am not a .net developer but can pick up logic if I have code sample.

Thanks.

I am not sure I understood your question. If you still have it, please re-state it.

Peter.

Looks like I need more help.

My MDX query now works, but I am struggling with creating this new calculated measure based on query logic in my cube. Basically I want...

Thanks a lot, Steve.

I missed hierarchy creation portion. Thanks for highlighting it and detailed explanations. It works perfect now.

Just curious - is there a way to build current date without...

Thanks for the reply. Well I knew that. It is not enough for my purposes. I need better control.

Steve,

The requirement is to show every employee whether they worked or not on any project (whether they filed a timecard or not). My fact table contains only event of filing...

And what if I need to move the cube across two different servers?

Thanks,

Peter

I changed the grain of my fact table - it is at day level now. I bit closer to what I need. I am trying to figure out how to...