Thank you everyone for your responses.

I actually worked it out as follows.

In the report grouping I put in

=Switch(DatePart("ww",LoadDate) = 1,1)

and so forth, up to 52.

I know you're probably laughing,...

Daniel Bowlin (9/22/2010)

---

Try a CTE or temp table to get your DISTINCT then join that back to a SELECT where you query the data and constrain on the MIN or...

Luke L (9/21/2010)

---

tsmith-960032 (9/21/2010)

---

Ok,

ColumnA is a shipping number.

Each...

Ok,

ColumnA is a shipping number.

Each shipping number may...

Luke L (9/21/2010)

---

so the sample data and expected output?

If you're doing everything at rendering just pull everything, then group by columnA, add your calculations on columns b,c or whatnot. ...

Luke L (9/21/2010)

---

Some sample data and required output would be very valuable here. See the first link in my signature for more info.

You need to figure out if you'll...

Scott Douglas (9/14/2010)

---

I built my first Report Builder 3.0 report that has multiple charts on it and a few data tables. It renders nicely locally but when on the...

cliff.cotterill (9/15/2010)

---

How do you set up groups/totals for multiple time periods, such as Year, Quarter, Month to display something like this:

Name_Yr__Qtr_____Mon___________________Amt

Joe _____________Jan_____xxxx_xxxx_xxxxx_$100

Joe _____________Feb_____xxxx_xxxx_xxxxx_$100

Joe _____________Mar_____xxxx_xxxx_xxxxx_$100

Joe ______Q1___________________________$300

Joe _____________Apr_____xxxx_xxxx_xxxxx_$200

Joe _____________May____xxxx_xxxx_xxxxx_$200

Joe _____________Jun_____xxxx_xxxx_xxxxx_$200

Joe ______Q2___________________________$600

Joe...

You can even have 3 visible parameters.

@FromDate

@ToDate

@DaysOut

and allow blank values. Then, in your query, you can check which parameters the user filled in

If Len(Ltrim(RTrim(@ToDate))) = 0

Begin

xxxxxx

End

Else

If... you get the...

chris.king (9/14/2010)

---

Unfortunately, it's not quite that simple.

I also need to be able to show periods of less than 18 weeks so a start and end date are required to allow...

Stuart Davies (9/15/2010)

---

Thanks for the suggestions - lots of food for thought.

The essence of the problem is that I can't see any databases on the server when trying to...

Report parameters are global, and thus can be passed back to any stored procedure, as long as the parameter name(s) match the parameter name that the stored procedure is expecting.

Also,...

You mean running the report off the server???

I am not sure I understand what you are trying to do, but, I hope this will help.

Since you are using an sp, and the parameters are set up, they...

You can select multiple, or single cells to set the format properties as Luke says above.

Examples of what you may put in the format field are :

c2 (currency, 2 decimal...