Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pradeep79

    Suppressing group based on record

    Thanks LB, that did the trick. I wasn't sure of how to use sql expressions and now I understand it.
  2. pradeep79

    Suppressing group based on record

    Complete, pending, failed and no further action
  3. pradeep79

    Suppressing group based on record

    That's correct. Order = 4 can be complete and then we wouldn't want to know about it. A contract may go from stage 1-5 but not in a sequential order. It may start at stage 2 then goto 4 then 5. It may start at 1 and end in 3. All I want to know is the current stage (max order) and whether it is...
  4. pradeep79

    Suppressing group based on record

    I haven't, could you please give me the link to it.
  5. pradeep79

    Suppressing group based on record

    Thanks LB, but the lates stage isn't always 4 as in the above example. It can be anything between 1-5. I want to find the latest stage, then check whether it is pending, withing the group header if possible. If it is pending then print the details if not suppress the details. How can formulas...
  6. pradeep79

    Suppressing group based on record

    I tried using the following formulas: //@pending if {Contract_Stage.Status} = 'Pending' and {Stage_Order.Order} = shared numbervar maxStgOrder then 1; I calculated the maxStgOrder inside a subreport because the following formula won't accept if I use maximum({Stage_Order.Order}...
  7. pradeep79

    Suppressing group based on record

    Id Contract Stage Status Date Order == ======== ===== ====== ===== ====== 1 Test1 Start Complete 21/01/09 1 Bid Complete 21/02/09 3 Neg Pending 21/03/09 4...
  8. pradeep79

    Suppressing group based on record

    Thanks for that. Now I'm stuck with the following format which I think will not work if I move the items to group footer. My report should look like this Id Contract Stage Status Date == ======== ===== ====== ===== 1 Test1 Start Complete...
  9. pradeep79

    Suppressing group based on record

    It will be a seperate one.
  10. pradeep79

    Suppressing group based on record

    Thanks, that's correct I only need the last stage for now. Now I understand it. I will need to also do a report to check any stage pending. Could you please give me an idea.
  11. pradeep79

    Suppressing group based on record

    Thanks, I never thought of putting everything in group footer. Is {Contract_Stage.status} <> "Pending" only enough? Don't I need something like: if {Stage_Order.order} = maximum({Stage_Order.order}, {Contract.Contract_Id}) and {Contract_Stage.status} <> "Pending" then true; to check the status...
  12. pradeep79

    Suppressing group based on record

    I have following 3 tables Contract(Id, Name) Contract_Stage(Id, Contract_Id, stage_name, status, date) Stage_Order(stage_name, order) Each contract can have upto 5 different stages. The Stage_Order table is there to specify the chronological order of stages. Currently I'm grouping by the...

Part and Inventory Search

Back
Top