benlatham (8/19/2008)

---

You could do it by adding a report parameter (e.g. ShowAll) and having the initial visibility of the rows to be based on the parameter value. Of course...

I am sure you are right Susan but I can't help to think that there must be another way to do this.......

Ok I will need further help here. I already have the detail row's Visibility.Hidden = True, Visibility.ToggleItem = ticket_nbr. Ticket_nbr is a textbox in a Group Header. ...

Thanks Susan!

Great idea! Does...

Wow old hand, i would have never thought of that. Then again i am still a newbie. Thanks i will try it.

btw, the date fields are in Unix...

Jack Corbett (7/30/2008)

---

Just based on the number of correlated subqueries in your code I would say yes there is a better and faster way. Probably the best way for...

Jack Corbett (7/23/2008)

---

You could put a textbox on the report and set the visibility (Hidden Property) by checking the value of the parameter like this =IIF(Parameters!test.Value = "x", False, True)...

tried that and the output is worst hehe. any other ideas?

Yes, this is the same report Nigel was helping me. As a matter of fact, I took his script, reworked it to join to the parent dataset so I...

Both subreports get parameters from the parent report. The 2nd sub receives 4 parameters and yes, when i run it independently, i am passing the exact values from the...

Thanks Nigel! I will try this.

Can anyone help? I still cant figure this out and need to deploy to production asap.

declare @pay_begin_dt datetime, @pay_end_dt datetime,@empid char(7),@piecework_pay decimal(8,2),@base_wage decimal(4,2),@hours_worked decimal(8,2),@hours_ot_worked decimal(8,2)

,@hours_dbl_worked decimal(8,2),@reg_hourly_rt decimal(8,2),@ot_prem_rt decimal(8,2),@ot_pay decimal(8,2),@dbl_time_pay decimal(8,2),@gross_pay decimal(8,2),@ot_prem_rt_calc decimal(8,2)

,@ot_prem_rt_calc_label char(30),@dbl_time_hrly_rt decimal(8,2)

set @empid ='3021184'

set @base_wage = 8

set @pay_end_dt = '7/4/08'

set @pay_begin_dt = '6/28/08'

set...

No cursor.

No calcs in WHERE clause.

My calcs are all done in a subreport. The main report uses a LIST and passes employee id among other parameters to the subreport....