mw112009 (8/10/2011)

---

I guess I didn't explain this correctly.

The new text field sits in the main report. There is also a sub report.

The plan is to get a value from the...

mw112009 (8/10/2011)

---

Well, here is a first step.

I created a text field ( later we can hide this ) in the main report.

My question is how can I pull a...

You should be fine :-P.

For the next time around, you can use this tool, it generates the insert statement for the sample data. Takes only 2-3 secs per table...

http://www.ssmstoolspack.com/

LEFT JOIN ... ON tbl_Codes.option_ID=tbl_codes_select.option_ID AND tbl_Codes_Select.User_ID = 1

If you put that in the where clause you'll then have a hidden inner join ( 1 != null )

neocoolio (8/10/2011)

---

Hi masters!!!

Finally I found an answer.

I've just changed the (linkedserver properties) @srvproduct that was ODBC, to ORACLE and now it works fine.

Thank you so very much. I hope someone...

:hehe::w00t::-D

No idea beside the "show data" menu. But I'm sure you've already explored all those at this point.

David Jackson (8/10/2011)

---

I've resolved this. I turned OFF Keep together on one page if possible in the properties of the Tablix where the data sits. Why this caused...

I'd seriously...

Good, I was thinking I was getting senile! 😀

I hope you like spam. If...

Marios Philippopoulos (8/10/2011)

---

dheeraj gupta (8/10/2011)

---

Hi,

The things you mentioned looks good. Does it mean that Update Stats with Full Scan is not needed for the Indexes that were rebuilt?

Can you pl...

dheeraj gupta (8/10/2011)

---

Hi,

The things you mentioned looks good. Does it mean that Update Stats with Full Scan is not needed for the Indexes that were rebuilt?

Can you pl provide the...

Grant Fritchey (8/10/2011)

---

I agree. The DTA is a very dangerous tool and it's suggestions can be problematic, in the extreme. After reading Gail's articles, get a copy of my book....