Viewing 15 posts - 856 through 870 (of 2,278 total)
I would try a couple of different options.
First, you could add a Row_Number() to the query and look for the last or max value of that column.
Or, put...
October 11, 2011 at 8:30 am
After coming up with the wrong answer....I wondered if there was some kind of precedence with Union, Except, and Intersect. It seems there is, and knowing would have made...
October 11, 2011 at 8:23 am
When in preview mode, immediately above the report preview but below any input parameters is a row of icons. You should see a refresh icon between the stop and...
October 7, 2011 at 8:23 am
I have to wonder what having so many indexes would to to insert and update performance
October 6, 2011 at 12:23 pm
Try running your query in SSMS with EXECUTE AS the user instance that is failing. That might give you a better error message.
October 5, 2011 at 11:50 am
Usually this means I have to go back to the dataset and do my calculation there and just put the field on the report.
October 5, 2011 at 11:46 am
In a situation like this I find looking through the RS Trace files to be helpful. Trace files are basically log files the the Report Manager creates. You...
October 3, 2011 at 7:50 am
If you have the enterprise version you should be able to do a data driven subscription.
October 3, 2011 at 7:46 am
Viewing 15 posts - 856 through 870 (of 2,278 total)