Thanks for the reply Uwe Ricken. You are right, there is no "one size fits all" solution for this. Purpose of my questions is basically to know "what not to...

Hey Tony. Did you find the fix for the problem? I was having the same problem and found this. I haven't tried this yet.

http://social.msdn.microsoft.com/Forums/expression/en-US/39766108-b679-4de1-9874-c08e5207667c/ssrs-document-map-navigates-to-bottom

http://support.microsoft.com/kb/2891088/en-us

Thanks for the quick reply Garadin. I used your code logic in my real query and it worked great. :Wow: I didn't check query performance and all yet but it...

Sometimes I am seeing performance difference while using SPs over Text. (Report takes longer time to execute). So most of the time I try both the approach and use Profiler...

Got the answer from MSDN forum.

Hi Veeren . Thanks for the reply ....

I found the problem I was having. I was so involved in finding solution to fix my BIDS (i thought problem is in...

Thanks for the repoy Veeren,

As you said, I've tried creating new report and adding dataset using the text and stored proc mode. But no success.

One thing to mention is...

Yup, true...time and space were also my concerns after performance and that's why I started this question....

And No, its a data warehouse for reporting purpose, So no insert/update/delete operations...

I think I'll check performance for SELECT queries dropping/adding that identical non clust. index.

for the insert/update/delete i think it won't be a problem because we disable all non clust....

thanks for the reply Gail...

as I said...non-clustered index is of the same structure as clustered...same columns, same order n no included columns.....Only difference I see is in size....n that's obvious...

One reason to do is we have many folders (around 15) so instead of changing TargetReportFolder property everytime I thought deploying everything at one place and moving them will be...

Yes Jack you are right. I figured out that today morning. Reason for null entries is that only.

I generally deploy the report from visual studio to Reporting Server in...

Not exactly...I need the information from rdl file ...execution log gives inforamtion about report executions....thanks for the reply though...:-)

Yes , you are right about catalog table....I can use that for name, description, parameters.....but my requirements for documenting rdl also needs drill thtough links, datasource, dataset fields ......

I have...

Actually reportserver wont give me all the information I need. I want the report description, parameters used in that, drill through links etc....and all of this informations I have to...