check that the ASPNET user has read, execute,list permissions on the folder [C:\Program Files\Microsoft SQL Server\...\Reporting Services] and its child folders.

dates are always ticky, watch out for them especially when using different formats for the front end and the backend.

so what exactly do you want help on? the query or the form.

you don't necessarily need a separate sub form you can just show the related colours/shades in a data...

Ruaan,

If you go to the RS configuration manager are you able to connect to your RS server?

what is your primary key?and what is the order of priority on the CustGrpCode when dropping one of the duplicated rows.

can u post your tables ddl?

unless if its a typo you did not alias your sub query and you do not need to include the columns to be agregated in the group by, you just...

we will need more info on your db, and if possible post the ddl

is your web server up and running

you can use a sub query and then group on it

select a.item1,sum('abc'),sum('def')

from

(

select a.item1, 

      case

when a.item1 in ('value1', 'value2', 'value3')

      then 1

      else 0

            end as 'abc',

      case

when a.item1...

i would be tempted to do this in the frontend app.

John,

my thought as well.why should a developer not want to do it. i thot that was part of the job spec.

what is the format of the zip code?

i think its crazy design, before making any changes make sure you do an impact assessment. otherwise if it ain't broke don't fix it

mind me asking why you would need to pass an expression to a stored proc?

the link is going nowhere

http://www.sqlservercentral.com/testcenter/Using%20the%20SQL%20Server%20Service%20Startup%20Options