Thanks for the reply.

I used the below case statement in my Select statement to get the starting day as Monday:

(CASE WHEN datename(dw,date) <> 'Sunday' THEN CONVERT(varchar(10), DATEADD(WK, DATEDIFF(WK, 0,...

Thanks WIll take a look at it:)

Thanks for your reply..

I tired using all the datetime expressions related to date with the below exprseeion in dervived column

DATEADD("WK",DATEDIFF("WK",0,date),0)- but the same query gives correct answers in sql ,...

Thanks 4ur reply!

The below expression works fine

=Sum(IIF(Fields!Cityname.Value = "CityA", Fields!empname.Value, 'Noname'))

the above code works.

Similarly I have another feild AvgRate

city emp avgrate

CityA Emp1 7.5

CityB Emp2 3.3

but the...

I was thinking the same...whether to combine data from various web services into SP and handle the error if the system is down...Im nt sure if this can happen...should give...

Thanks for ur inputs.... I would look in to it..

And similarly I use a web service as a data source connection in another req.... I have webservices which would fetch...

Thanks 4 ur reply!

No I have not used stored procudure...U mean to say one single stored procedure to combine all data from 3 databases ???COuld you please explain me little...

Thanks mate for your help!

Thanks...

I wanted the Case 1 of yours...

Default Paramater of date to be set to -2 if today is Monday(so that saturday data is displayed) and -1 if other weekdays...

I had...

Thanks....I am using the lookup transformation only...n again I don have to worry about updated records... It is just only the new records...

Thanks:)

Thanks for your reply..

I had some mistakes with the hyper link which I had used... After corrrecting it, things look fine..

Thanks all for your help!

I suppose date/time data type is not creating any problem...If I use date/time data type and select allow multiple values, the date paramater is being passed ...

But only if I...

Thank u both!!

I am able to pass the date paramater if the data type of the date parameter is set to Text.

But my start and end date paramaters are Calendar...

Hi,

I have changed the URL and it works fine now but there is another problem that exists.

Below is the link I used in JUMP URL Option

="http://servername/ReportServer/Pages/ReportViewer.aspx?/test/test/Report2&rs:Command=Render&ReportParameter1=" & code.urlencode(JOIN(Parameters!ReportParameter1.value, "&ReportParameter1="))

The above...

IF I try embedding the URL encode function with the jump to URL link,I am not able to jump to url...i.e it throws error internet cannot display the web page...

looks...