pjrpjr7 (1/28/2013)

---

I have a report developed in ssrs 2005 and it runs on 2008 report server. It has 5 parameters (out of which 2 are date parameters and the other...

Hi Maneesh,

I'm not sure I understand what you mean exactly can you explain further? 😎

Regards

ld

There is a memory limit on Pivot tables though i'm sure it's higher than 1000 rows but I supose that depends on your system and what you are trying to...

Thanks for the responses.

There are no filters on, i'm just pulling the measure into the browers and the total doesn't match the table.

I have re-processed the cube and it still...

Hi,

Thanks for the reply, i'm on 2008 sp3

I have tried the connection through excel and it still shows the same amount of records as in the browser which is wierd.

I...

FYI. Doesn't work on SQL 2005

Error showing on line "Insert Into #t1(col) Values (1),(1);"

Msg 102, Level 15, State 1, Line 5

Incorrect syntax near ','.

I believe this function is not available...

Thank you 🙂

Perfect!

I had the same issue, good response 🙂

Answering the question from face value, I was going to choose 0,1 as the answer however, checking my logic in SQL 2005 & 2008 and both returned 1,1 as the...