http://stackoverflow.com/questions/259390/how-do-i-best-display-checkboxes-in-sql-server-reporting-services

Have you tried creating a parameter which takes in A,B,C as value and another parameter which depends on the first dataset for operations to perform .

Read cascading parameter :-...

Pros :- Automated process don't have to bother about scheduling report every now and then. Data driven subscription allows you to pass multiple parameters without bothering about reports. Reports generated...

Very good initiative.

http://www.sqlservercentral.com/articles/SQLServerCentral/105392/

-- Delete Duplicate Data

; WITH CTE AS (

Select A,B, RowNum = Row_Number() OVER (ORDER BY A)

From t_TAble1

)

DELETE FROM CTE

WHERE RowNum > 1

Thanks,

Ankit

Either use RenderFormat = ExcelOpenXML

or Excel in ReportServices.config file add Visible = "false"

Thanks K,

I hope the solution is :-

Use the Excel renderer (xls) by changing the value of Visible to true, in the following line in the RSReportServer.config file.

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="true"/>

No I guess

Excel

Again the ReportURL can change. Need the report server name or machine name

not report name but server name

Unfortunately, it has become a show stopper for me as the query fetches some ad-hoc report and the same is failing.

Can you let me know why exactly it hapenes...

If you are importing using DTS/Import Export wizard. you might want to Edit the data type and length of the source. Cause thats what might be causing the truncate.

Hi,

You can switch partitions if your idea allows this or TRANSFER the partition to other. PLease follow the following url for more details.

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

http://msdn.microsoft.com/en-us/library/ms191160(v=sql.105).aspx

Money can take upto 5 decimal. Whereas, if you need > 5 decimal places for a value go for decimal(n,m)

Even excel wont allow that many columns .. are you sure you are talking abt coln and not rows ?