I posted whopping 3 years ago.. Glad it helped you today..:-D

You can do that using C#/Vb.Net and Reporting webservice.. Read the Scott's blog..

http://weblogs.asp.net/srkirkland/archive/2007/10/29/exporting-a-sql-server-reporting-services-2005-report-directly-to-pdf-or-excel.aspx

Hope this helps..

Select max(value) Val, Id from tblname group by Id :hehe:

1.) Would it be easier to convert them to RDLC, then convert the RDLC to RDL(I know how to convert RDLC to RDL)? If so, any suggestions?

[font="Times New Roman"]Ans- Go...

@ Kathleen

You can do like wolfkillj said,

Or try this..

Since the period is starts from October

Write expression like below,

= iif(Parameters!Period.value <= 3, MonthName(Parameters!Period.value + 9) + " " + Parameters!Year.Value-1.ToString,

MonthName(Parameters!Period.value -3)...

@vinayak.v

I was thinking the same when I migrate to SSRS, but there are lot of advantages in SSRS 2008/R2 than Crystal..

Expression is far better than crystal

SSRS report...

Good Article.

Here is an another link with different type of options for row concat.

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

I am in the opinion of Grouping_ID is not a subclause of Group By. It is a function used in Select Statement for aggregation.

I believe the answer is GROUPING...

My Server is Win 2003 & SQL 2005. I got a same error code 126.

Carl Federl's Post helped me for Configuring System DSN for Lotus Notes SQL Driver.

Thanks to Carl.

There is a way to do that.

In Report Parameter properties ,select the Default Values and choose the Option Get Values from Query.

Select the dataset and value field. Remember to check...

Thanks Sun.

I created a Calculated field in dataset and calling a function in Code behind. This function returns the Type of Incident.

Let me try with SQL Query it self.(using CASE......

I did like below...

if (S_PID = 1005) or (S_PID = 1458) or (S_PID = 1031) or (S_PID = 1038) or (S_PID = 1045) or (S_PID =...

I am sorry, I have no Idea of linking SQL Table to DBF file.

Dhans:unsure:

Hi

Sum function can compute only Numeric values.

So Try this

= Sum(iif(Ltrim(Rtrim(Fields!Exp1.Value)) = "",0.00,Fields!Exp1.Value))

Dhans

Instead of using Import/Export wizard, You can import DBF files using SSIS Packages.

Steps:

1. Create an SSIS Package using BIDS.

2. In the Connection Managers

Right Click --> Create OLE DB Connection-->New--> In...