You can use DATEPART function (eg: DATEPART(ww, time_uploaded)).

Thanks Tommy Bollhofer,

From the link you provided, i've understand that we can not create Hierarchy directly from different dimensions which linked via a Fact table.

But if we could create a...

Thanks a lot Jack Corbett and Grant Fritchey for your quick response...:)

I know even if there is way, it might be expensive interms of performance or additional load load on...

Can any one please help me...

when i execute the following query,

BEGIN TRANSACTION T1

INSERT INTO table_1 VALUES ('ABA','xxx',130)

COMMIT TRANSACTION T1

BEGIN TRANSACTION T2

INSERT INTO table_1 VALUES...

Thanks for ur suggestion Simon,

I tried both formats jpeg and gif, still have the same problem.

When i export it to PDF or image images are exporting. The problem is only...

use subscriptions.

Its just the table having rows.

Returned rows are 4 or 5 aggregated rows based on certain conditions.

But i'm running only reportserver, no other applications are running on server.

As of now...

I've checked the Execution log, there most of the time it is taking for data retrieval only.

Report is fast in BIDS and its very slow in reportserver.

I'm checking in both...

Thanks a lot for the immediate response.

Here are the Details of my SQLServer,

Edition Enterprise Edition

ProductLevel...

Yes, exactly.

When i do any changes for report manager, its reflecting immediatly.

But its not for reportserver.

I'm using SQL 2005, SP3. Do i've to restart my machine?

That is the only...

It was working for tabs, buttons in report manager...but when i change this for report server its not working(i refreshed so many times as you suggested).

please help me on this,...

Its working, Thanks a lot..!

There is small correction in the path...(C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\Styles)

Do i need to restart my machine or only SQL server services?

Thanks a lot for your immediate reply...!

regards,

Ramu

Can you pls tell me how to change the color of the parameter area?

i'm new to this, pls tell me where to find the Style sheet of RS manager?

Regards,

Ramu

How to set default sorting order as DESC when i use interactive sorting?

Regards,

Ramu