gsc_dba (7/2/2010)

---

You will need to create a custom set and then rank that set.

http://msdn.microsoft.com/en-us/library/ms144726.aspx

Sample:

WITH

SET MySet AS

Extract

(

...

You will need to create a custom set and then rank that set.

http://msdn.microsoft.com/en-us/library/ms144726.aspx

Sample:

WITH

SET MySet AS

Extract

(

...

Have you tried this in your SSRS parameter:

="[Country].[Country].&[Australia]"

Is it not as simple as...

Right Click on Tablix Properties -> Filters -> Add...?

I want to display only the lines that have values in any of the actual budget or...

Can you please provide the stored procedure?

Try (tried?) this link:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/032ace55-f514-4aae-bc61-306783bec3c9

I have seen this before and turned out to be permissions/group policy for my scenario...:hehe:

This link should provide you with the examples you are after:

http://msdn.microsoft.com/en-us/library/ex0ss12c%28VS.80%29.aspx

For Windows Server 2008 (x64) you have to run the VS command prompt as administrator (regardless of your own permissions)...

Hi Andrew,

I googled around: http://searchsqlserver.techtarget.com/tip/Decrypt-encrypted-stored-procedures

As a fellow DBA I would consider using some form of source control for your SQL code.

RedGate http://www.red-gate.com/products/SQL_Source_Control/index.htm have a beta version which I find very...

Hi,

From my experience of custom components - you will need to register the .dll into the GAC (Global Assembly Cache).

This can be achieved by using GACUtil or Visual Studio command...

Sample to get you started:

Private bOddRow As Boolean

'*************************************************************************

' -- Display green-bar type color banding in detail rows

' -- Call from BackGroundColor property of all detail row textboxes

' -- Set Toggle...

I think you need to have a reports solution in VS2005.

Once you have this, add the Data Sources and then to add the reports:

Right click reports...Add...Existing Item -> point to...

The only way I can perceive this working is to create a custom macro in Excel to effectively "move" sheet2 to sheet1.

The macro would need to sit outside of the...

I am intrigued...

These tools I find really useful:

http://bidshelper.codeplex.com/

http://www.mosha.com/msolap/mdxstudio.htm">

http://bidshelper.codeplex.com/

http://www.mosha.com/msolap/mdxstudio.htm

As for schedule, I setup the ETL process to "run every hour" with a check (check_sum) to determine if there is...

If you are using parameters you can utilise a range of dates:

StrToMember(@ProgramStartDate) : StrToMember(@ProgramEndDate)

If not you can use the same syntax:

[Time].[FINANCIAL].[Date].&[2010-05-01 00:00:00] : [Time].[FINANCIAL].[Date].&[2010-05-07 00:00:00]

In your Date Hierarchy, is there...