MysteryJimbo (2/22/2012)

---

I dont mean to be pedantic but for accuracy I'd want to see this query as a between and in a stored procedure with default values so it can...

Thank you all for the explanations. Makes perfect sense now. 🙂

Hakuna Matata (2/22/2012)

---

Try this :

WHERE CONVERT(DATE,FM.Openeddate)=CONVERT(DATE,GETDATE())

Jeremy... (2/22/2012)

---

I am trying to write a query that pulls our new orders for the current day.

Where FM.Openeddate = getdate()

did...

Lynn Pettis (2/22/2012)

---

Jeremy... (2/22/2012)

---

I am trying to write a query that pulls our new orders for the current day.

Where FM.Openeddate = getdate()

did not work. It...

I figured it out. I had to select the group in question, go to properties, set hidden to false and toggle item to none. now the drilldown is gone.

ColdCoffee (2/17/2012)

---

This?

CASE WHEN (

SELECT MIN(dbo.GetLocalDateTimeFunc(FA2.ReceivedDate))

FROM FileActions FA2

WHERE...

Thank you! That appears to have worked. However, now the dates in that column are in a different format:

"2012-01-01 10:12:03.090" vs "Jan 13 2012 2:20AM"....

SQLKnowItAll (1/18/2012)

---

Jeremy... (1/18/2012)

---

Is this in the BI studio? I'm not seeing "report" in the properties...

Is this in the BI studio? I'm not seeing "report" in the properties box. thanks.

Geoff A (1/18/2012)

---

you can't. by default the page size is 8.5 x 11 and the report will fit onto that (or many pages) if needed.

you can of course, change the...

Are you referring to maybe when the report has been exported to excel or PDF?

I've seen it done in the past where when viewing the report in Internet...

Thanks for the help. I'm actually using the BI Studio to create reports. Also, the size of the report constantly changes so the height of the report would...