why not use a temp table with an index instead of using a subquery

I found out the problem .. !!!!!!

The startup parameters were not set for the SQl2008 instance. So i copied the the same from the other instance running and pasted for...

Hi,

Yes the server has microsoft Forefront Client Security Antivirus installed. Could that be an issue??

Thanks

isnt this enough?

DECLARE @AA AS varchar(10)

SET @AA = convert(varchar(10), 33/37.0)

select @AA

as both numbers are integers the output also would be integer. so either one number can be converted to decimal...

just another method..

select sum(Total),case when RowNum<4 then Category else 'Others' end from (

Select count(1) as Total,row_number() over (order by count(1) desc) as RowNum,

Category from manager group...

try this

http://tek-tips.com/viewthread.cfm?qid=932379

One more solution in Single query.

Select * from table_1 where [Class] in

(case when @type='Auto' then 'MD' else 'ID' end,

case when @type='Auto' then 'RD' else 'IW' end,

case when...

isnt it " Where valuedate '20070731' and Valudate '20070724' ?

or i didnt get the question correct

The deployed reports can either be given subscription or it can be embedded in your website page for viewing.

Subscription is done from the reports server UI where in report properties...

seems the datatset name also was by default set as "Test" when it was created and the "Test"dataset name is hardcoded in some expression as the scope parameter or something?

Create datasets for each parameter values with each dataset query is filtered with the value from the other parameter value except country.

for eg

create sate dataset with query like

select...

can you tell the error ?..

The reason could be many like

the paramaeter datatypes in the sub report and the value being passed are not same types

Check if...

for statewise color

Opne table row Properties-- BackGround color --Expression -- =iif(state="CA" ,"red" ,iif(state="NY" ,"blue" ,"green"))

for alternate row color

Opne table row Properties-- BackGround color --Expression -- =iif(iif(RowNumber("[dataset]") mod 2...

Please correct if i am wrong. both select statements returns same number of fields and the names of the fields are also the same but the no of records would...

Try this

In Visual Studio – in an aspx page – Add a Microsoft Reportviewer control from the tools menu-Reporting tab.

Then add this code on any button click in the...