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...

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....

29 ms, seconds, minutes?

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...

... and the timeout is at 30 MINUTES. It's already way too long so I can't see how increasing it would really help.

Luke L (11/2/2009)

---

Did a bit more googling than I had when this originally came up in my office...

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...

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...

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...

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

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...

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,...

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...

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.

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...

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...