Viewing 15 posts - 8,281 through 8,295 (of 18,926 total)
Hi there,
Are you using a matrix?
Yes
Are the columns in the table only fields from the query with groupings.
There are 2 calculatd fields once in ssrs year(date) and month(date).
In the dataset...
November 4, 2009 at 12:28 pm
Ok Thanks, I was hoping to get something more usefull, but apparently not.
I just did this test. I updated the sp to return the top 1% of the data....
November 2, 2009 at 11:52 am
29 ms, seconds, minutes?
November 2, 2009 at 11:31 am
Can you guys run this query on your SSRS database engine. I need to know if you get the same data as I do. I always get TimeDataRetrieval...
November 2, 2009 at 11:01 am
... and the timeout is at 30 MINUTES. It's already way too long so I can't see how increasing it would really help.
November 2, 2009 at 10:25 am
Luke L (11/2/2009)
Here's the MS reasoning why you might be seeing the timeouts...
http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
Basically, the session...
November 2, 2009 at 10:23 am
That's also what stumps me. When I run other reports with as much or even more data (we're talking about less than 500 KB of data here). They...
November 2, 2009 at 10:20 am
I'll add my vote to the "show more of the message" group in the results. Also it would be nice to have options to show 100 or more results...
November 2, 2009 at 10:02 am
This one's got me stumped... any one can tell me why 1 report fails and everything else around it works (same servers, client, permission, dataload...)
http://www.sqlservercentral.com/Forums/Topic812455-162-1.aspx
November 2, 2009 at 9:58 am
oh ya, and I added 5 GB of space to rstemdb "just in case"... even if the current size was only 350 mb with 200 mb free space.
I'm out of...
November 2, 2009 at 9:48 am
I know Al.... VENDOR APP is the keyword in my question :w00t:.
Anyhow if you're going to waste time documenting every report in our compagny and customize the OCR for them,...
October 22, 2009 at 7:46 am
The app is custom tailored for our needs. It's an ocr that scans a pile of 100s of pages. It detects what the page is and then...
October 22, 2009 at 7:11 am
About 4 GB of RAM on the server, sql server express is maxied out at 1 GB. Last time I checked, there was still 1.5 GB of ram available.
October 21, 2009 at 11:37 am
Actually I love to grow the dbs while in maintenance mode and give it 3 to 12 months space. Since we're ordering a new server, I'll ask for plenty...
October 20, 2009 at 12:11 pm
You got most of them....
The ones I particulaly like is the mixed use of left and right joins (not a bug by any means, but just odd).
Group bys without aggregates...
October 17, 2009 at 3:19 am
Viewing 15 posts - 8,281 through 8,295 (of 18,926 total)