Amit Raut (10/1/2013)

---

May be number of queries in the report cause OutOfMemory exception. Tyr tuning the queries. You may handle rendering of report by checking record count, but what if...

Koen Verbeeck (9/25/2013)

---

Eliza (9/25/2013)

---

Hi,

The name and subreport are in a tablix deatil row if this is what...

Hi,

The name and subreport are in a tablix deatil row if this is what you mean?

Thanks

Eliza

busraker (9/17/2013)

---

Eliza (9/16/2013)

---

Hi,

All the information for parameters comes from three tables. All joined with inner joins.

At the moment I feel I have functions embedded with functions and its not...

Hi All,

Thanks for the replies.

The issue has now been resolved. We found closing the session and creating a new one and running the SQL made it work

The Line

AND YD.[Level]...

frfernan (10/1/2012)

---

Hello,

you can do it in an iterative way:

Find the first colon, keep the left half into Col1 and move the right half into Col2.

Find the first colon in Col2,...

Hi All,

Thanks for some of the solutions, I've tried a few.

SELECT SUBSTRING(@var,28+CHARINDEX ('CustomerFornm: Changed from ',@var),CHARINDEX('CustomerDOB',@var)- CHARINDEX ('CustomerFornm: Changed from ',@var)-28) AS 'Is this really what you

want?'

Doesn't work as...

Jeff Moden (9/30/2012)

---

Eliza (9/30/2012)

---

Hi Jeff,

Thanks for your reply. I have have played around with the SQL but still struggling. I can get it to pivot from being rows...

Hi Jeff,

Thanks for your reply. I have have played around with the SQL but still struggling. I can get it to pivot from being rows to columns and...

Jeff Moden (9/17/2012)

---

Eliza (9/17/2012)

---

Hi all,

Can I ask please if I have a row and one column has a csv list in it. Is there a way please to split...

This works brilliant,...

The key description are very long and fill the length of the page. I did try placing the key in the header record as a tablix, which had some...