Thanks Sean for that.

Infact I wanted unique counts of the document types, so I took the distinct data into a temp table and then using your SQL queried from...

Great relief then. Thanks. Will try and post back.

The table is so simple. It's just got a date column and a regID column (integer). The rest of the columns not applicable for this query.

I can see how...

Thank you Eugene.

Both my SQL and yours (very interesting SQL), gives the same result.

Day RegTotal

116

4121

532

636

737

836

933

1046

1145

I thought of a calendar table but then...

Host entry as in \etc\hosts? I tried that as well, with localhost mapped to <servername>

Also in IIS added both localhost and servername to the Default Website.

Recycled the Application Pool...

Thanks Anthony.

I re-ran the Config Manager and upto the point of Initialisation everything is fine. The tick is there on Initialisation. Reports themselves do work on localhost/reportserver, but it's the...

Thanks for the Reply.

I checked everything again. Both the databases are there. I could manage to deploy a report as well from localhost/reportserver.

But localhost/reports still won't work.

From rsreportserver.config...