Yes, I basically would like to just read those NEW records that have recently been inserted into the "staging" database from all different sources. From there I will have...

I don't think this is doable in real time. We are currently utilizing SSIS packages to extract the data into SQL once a day and running the reports from...

Can you give some more details as to how is getting cut off? Maybe even post a screenshot of the excel sheet to get a better idea of the...

Found this solution on this site which i applied and worked like a charm! Thanks so much for ALL your help!

LINK TO SOLUTION : http://www.sqlservercentral.com/Forums/Topic1025852-150-2.aspx

Thanks again!

Renatto.

Also, as mentioned before, this only occurs when using the designer preview or any other browser through the report manager in ssrs after deployment. When i physically run the...

I actually dont have any defaults for the 4 parameters I have, however each parameter is dependent from the one prior, meaning that I load the second parameter based on...

Just to add to the post above, these are some of the scenarios i will be facing :

Example access control for SSRS report scenarios:

Scenario 1: User can only access to...

I agree! That is the only solution I can think of and what I am trying to implement right now. I wonder if SSRS 2008 has the ability...

Yes, I definitely would like to do the filtering in SSRS as the same procedure is being utilized alot in the same report set and don't want to filter within...

Thanks for the reply and sorry for the ignorance on this, but how do you tell SSRS to only display records 1 to 20? I am sure the Visibility...

Thanks all for your suggestions. After getting access to the documentation and the actual server i found out that it is definitely a hardware issue. Its a 2003...

I am trying to do some more research as of what happened to this server. Apparently reporting was ran off of this before and everything was ok at the...

Thats what I thought ... made sense to me to just read straight from the table rather than hit the view which would generate hundreds of columns when i only...

I dont see them because when i load the file on word i can see that there is only one carriage return and no line feeds per record.

There are only 6 columns that I care about on each record, and every record has it regardless of the size, however at the end of each record if the...