Create a dataset to pull values from the cube with the query below.

select <parameter3 value that goes into the the dropdown> from cube where <parameter3> <param 2 like = begins...

=CountDistinct(Fields!SubgroupCode.Value,"GroupCodeName")

In the footer row of 'GroupCode' place the above expression.

"GroupCodeName" is the Name of GroupCode group

It should work.

Born, Coimbatore (Manchester of South India)

Earned my stripes working in Bombay

Then Fort Smith, Arkansas

Then Dallas, Texas

Then Saginaw, Michigan

Then Winston Salem, North Carolina

Now Charlotte, North Carolina

If it is 2008, in Column Groups, right click the Group properties of the YYYY/MM column and under Sorting, choose that column and set the Order appropriately.

This should work.

Siva.

select a, b,c from xx where (@id is null or id =@id ) will solve your purpose.

Siva.

No best practices. It is all from mistakes that I learnt(continously learning) from.

As you rightly pointed out, DB size does not matter, but if you find time to exlpore data...

Geez! you have answered yes to most of the questions......

See, if , for a matrix cell against a row/col group, the query does not return a value, then SSRS...

[Not a fix/soln, just to investigate further]

Hi there,

Are you using a matrix?

Are the columns in the table only fields from the query with groupings.

In the dataset properties tab, are all...

Connect to each of the ReportServer DBs and run the query.

Or talk to your sys admin to script this.

selectc.Name,

s.StartDate,

s.NextRunTime,

s.LastRunTime,

s.EndDate,

s.RecurrenceType,

s.LastRunStatus,

s.MinutesInterval,

s.DaysInterval,

s.WeeksInterval,

s.DaysOfWeek,

s.DaysOfMonth,

s.[Month],

s.MonthlyWeek

fromdbo.catalog c with (nolock)

inner joindbo.ReportSchedule rs

onrs.ReportID = c.ItemID

...

OK.

what is your current state.

Could you try http://localhost/reportserver and http://localhost/reports

and reply with what you see.

It is not custom code I am referring to, Ben. Just right click the report(rdl) in the solution explorer and select View Code. The report's xml code will open in...

Glad you found a workaround.

Out of sheer interest, you can right click on the report and View Code and look for the old SP name and see where it still...

On the matrix cell, where you have state, for the background property use the Select expression

IIF is only for either or choices. when you have more than 2, then, Switch...

after you rename the SP and refresh the datset, did you rebind the refreshed dataset with the table control on the report.

Go to the table properties and choose the current...