Hi,

Below is the sample DDL and attached is the rdl. When Order1 is the Order Number then Legend and Map1 should be displayed and table7 space should not be...

Any help will be greatly appreciated .

Thanks. Worked great performance wise.

Any feedback ?

Thanks .

Thanks work perfectly .

For the interval between 8-8:30 , it's showing multiple rows

2015-04-08 08:00:00.000300

2015-04-08 08:00:00.00000

2015-04-08 08:00:00.00000

2015-04-08 08:00:00.00000

2015-04-08 08:00:00.00000

2015-04-08 08:00:00.00000

2015-04-08 08:00:00.00000

2015-04-08 08:00:00.00000

2015-04-08 08:00:00.0001150

2015-04-08 08:00:00.00000

2015-04-08 08:00:00.00000

2015-04-08 08:00:00.00000

2015-04-08 08:00:00.00000

should be

2015-04-08 08:00:00.000,145 ,0

Thanks . Both solution works perfectly .

Also it will be helpful if you can provide me with an Update to #orders table instead of Select .

It works for others except ProjectID 2989 and ProductId 652 . When OrderID,ProjectID,ProductId and ProjectAmt are same then it should keep the amount in one of the rows and make...

Please help .

I added that as well but then the report doesn't display any of the images. The images are a part of the rdl and not from the database.

I need this urgently . If anyone could help me out that would be great .

Thanks,

PSB

Any feedback will be appreciated .

Thanks,

PSB

Thank you ! Works perfectly .