Hi,

Did u check the performance of your query how much time its taking?

And My suggestion is use report parameters and remove sql parameters(Except mandatory parameters)

Thanks,

Veeren.

Hi

Use join in the report expressions.If u want to do in report side

Thanks,

Veeren.

hi,

just for a try use expression as in your report or Query which will be easiy to u,somethin like it will take 8000 positions ("Left(Feildvalue,8000)" if it works...

hi,

As per me By using the Golbal page numbers we cant achive this SSRS 2008 or u need to go for the custom code or assemblys not sure this will...

Hi,

Make it simple your query like below logic

If (parameter=ALL)

{

Select * from table}

else

{

select * from table where =@param

}

Thanks,

Veeren

Hi ,

If you can able to achive this thats well and good man:)

thanks,

Veeren

Hi,

Add a new dataset which have the employeeid to the report and use that data set to show parameter which have multiple values by changing the properties in the parameter.

And...

some random thoughts use date diff.

oh...i belive that the subcription has issues with the report parameter if you are able to get the o/p with out any parameter!

No idea in 2000.we can go for linked...

hi,

try below one

http://forums.devarticles.com/microsoft-sql-server-5/sql-reporting-services-parameters-90768.html

You can create parameters of your reports in SSRS whose data sources are datasets created in the data tab of the report.

In this dataset, by...

did the same parameter giving result in the manual report execution?

Thanks,

Veeren.

Hi,

Which Version on Reporting Services you want to know?

SSRS 2005 or 2008 or 2008 R2?

Thanks,

Veeren.

Hi,

My advice is do this like in the query level like as you need in the report for time saving.And use the feild in the SSRS Matrix column group and...

Hi,

My advice is if your using the 2008 then use the group variables.

Thanks,

Veeren.

chk the below blog on regarding report variables and group variables in SSRS 2008.

http://blogs.msdn.com/b/sqlrsteamblog/archive/2008/07/21/group-variables-in-reporting-services-2008.aspx

Hi ,

Try the below one.

=IIF(Cint(Fields!Product.Value) = 10, nothing , Fields!Product.Value)

Thanks,

Veeren.