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!

Recent content by Garyjr123

  1. Garyjr123

    Sorting on Dynamic Groups and Running Totals for Groups

    I have a report that has it's grouping linked to a dynamic grouping filter which I want to do a custom sort on. Basically, the table and field are a Shift Type Name that sorts in alphabetical order. What sort formula should I use? OR_LOC_SHIFT_TIMES.SHIFT_NAME that is linked to another table...
  2. Garyjr123

    Dynamic Parameter Problem (Adding a Command)

    LB, To be continued tomorrow... I think I need to start from scratch with this report. Gary
  3. Garyjr123

    Dynamic Parameter Problem (Adding a Command)

    Now... I changed the Selection Expert: {appt.start_datetime} in {?StartDate} to {?StopDate} and {res2.resunit_id} = {?ResUnitID} and {res2.restype_id} = 2 and {resindstaffinfo.last_name} + ", " + {resindstaffinfo.first_name} = {?Practitioner} and I tried {appt.start_datetime} in...
  4. Garyjr123

    Dynamic Parameter Problem (Adding a Command)

    Ok, since I concatenated two (last_name & first_name)fields within the table resindstaffinfo which table.field should I be referencing?
  5. Garyjr123

    Dynamic Parameter Problem (Adding a Command)

    Hey LB! Yes, the data populated perfectly (or near as I can tell when I right click on the field and browse the data). In the Select Expert (last line): {appt.start_datetime} in {?StartDate} to {?StopDate} and {res2.resunit_id} = {?ResUnitID} and {res2.restype_id} = 2 and...
  6. Garyjr123

    Dynamic Parameter Problem (Adding a Command)

    I created a command for my report: select resindstaffinfo.last_name + ', ' + resindstaffinfo.first_name from phsprod.dbo.resindstaffinfo where resindstaffinfo.is_pract=1 I did not link this command in the Database expert and I am not referencing it in my main report but when I try to run a...
  7. Garyjr123

    Suppress 2nd Subreport is no data returned in 1st

    LB, I added two test variables to GH1c to see what the new sub1a and sub2a in GH1b were passing to GH1c. I find that even though there is no data for one or the other sub or I suppress blank data, supress the supbreport etc. that in GH1b there is a value still showing up which in turn has my...
  8. Garyjr123

    Suppress 2nd Subreport is no data returned in 1st

    That is correct, either one of the subs can be populated and the other blank. If I add them twice what would the formulas be or how would I go about doing this? It seems to me that I would run into the same problem with the second set of subs. Would I just be adding another GH below GH1b (the...
  9. Garyjr123

    Suppress 2nd Subreport is no data returned in 1st

    LB, I have done what you asked and the only problem I have is if there is data in one of the subreports that subreport shows in GH1b so that that GH doesn't suppress completely. How do I suppress the subreports if the other is not showing so that the whole of GH1b is suppressed? Gary
  10. Garyjr123

    Printing Issue: Report Cutting off from Left Margin

    For some reason I have a report that has information cutting off from the left and will not print the whole report (in landscape) accordingly. I do not have this problem with other reports but this one. I've looked at the printer setup, page setup, report options and options but can't figure out...
  11. Garyjr123

    Suppress 2nd Subreport is no data returned in 1st

    Nope, I used the formula you gave me and implemented it in GH1c which worked fine. It suppressed the main report data when the variable returned "" but when I added the same formula to the x+2 in any other GH (i.e. a or b) the report just comes back blank. So, this doesn't make any sense to me...
  12. Garyjr123

    Suppress 2nd Subreport is no data returned in 1st

    LB, When I add the shared stringvar to any other section in the suppression x+2 of the select expert no data is returned for the entire report. (the following formula in GH1, GH1a or b whileprintingrecords; shared stringvar code; shared stringvar code2; code = "" OR code2 = "" Gary
  13. Garyjr123

    Suppress 2nd Subreport is no data returned in 1st

    LB, Sorry to have mislead you but I wnat to suppress GH1c (actually all the data) if either of the subreports do not show data so the "OR" does work for me. Ultimately, is there anything we need to do differently to suppress the patients returned data (GH1a, b, c) if there is one subreport...
  14. Garyjr123

    Suppress 2nd Subreport is no data returned in 1st

    Ok, I changed this: GH1c Main report fields Selection Expert > Suppress > x+2 whileprintingrecords; shared stringvar code; shared stringvar code2; code = "" AND code2 = "" to whileprintingrecords; shared stringvar code; shared stringvar code2; code = "" OR code2 = "" Changing the AND to...
  15. Garyjr123

    Suppress 2nd Subreport is no data returned in 1st

    LB, The subreports are filtered by {test.testcode} Subreport 1 Select Expert > Test.Testcode > is one of FSGLU, IS6P, ISCR, ISCTPANEL, ISORCG8P, ISTROP Subreport 2 Select Expert > Test.Testcode > is one of BMP, CMP, CREAT, GLU, TROP Does this make a difference? Basically, it is passing the...
See more

Part and Inventory Search

Back
Top