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!

  • Congratulations strongm 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. Charliy

    Suppress subreport based on a number not being in a range parameter

    Okay, a little more tricky but still the same principal: You can apply that same suppression to all of the fields in that band. That way it will still take up the space, but will not print for the ones you don't want.
  2. Charliy

    Printing Multiple Labels for a Single Record

    Why are you using subreports? I've done a similar report to print a sheet of labels for s single patient. I just created what one label would look like, then copied and pasted it several times.
  3. Charliy

    Suppress subreport based on a number not being in a range parameter

    Just do it by row. You can have parameters for ?StartRow and ?StopRow then just put a suppression formula in each Detail band.
  4. Charliy

    Report grouping / sorting help needed!

    You can create a formula like {table.accountname} & {table.accountnumber} and group on the formula.
  5. Charliy

    Prompt Question

    You probably want to filter on the dates and the times separately. Let's say you selected Day Shift for March 1 thru March 4 Your records would include all day for March 2 and 3, not just Day shift. to display your formulas you just need to make your variables shared, and create additional...
  6. Charliy

    Prompt Question

    Your problem is the AND stringvar Starttime := ""; stringvar Endtime := ""; if {?Days/Nights} = "Day shift" then (starttime := "06:00:00" ; endtime := "17:59:59" ) else (starttime := "18:00:00" ; endtime := "05:59:59" )
  7. Charliy

    Conditional Feld Size & Total Page Count

    What determines the size of your group footer? Is it a string field with "can grow" checked?
  8. Charliy

    Cascading Prompt?

    You don't need to use cascading for that. (isnull({?NamePrompt}) or {table.name} = {?NamePrompt}) you could also use ({?NamePrompt = "ALL" OR {table.name} = {?NamePrompt})
  9. Charliy

    Windows7: Version: CRXI / Experienc

    Having done similar projects, I suggest you also scan for "alternate" spellings of "Weapon
  10. Charliy

    calculating dates when suppressing records

    The CRRed would be applied based on the results on the formula that LInda provided.
  11. Charliy

    Shared Number Variable ARRAY

    I would create s delimited string, something like 23/14/17/32 Pass that to the subreport, then use SPLIT to treat it as an array.
  12. Charliy

    Formula to remove bracketed text

    This may not be elegant but it works. Replace the first line with local stringvar RAW := {table.yourfield} It will not handle double close brackets well. local stringvar RAW := "ABC[DEF]GHI[HIDE ME]JKL"; local numbervar I :=1; LOCAL NUMBERVAR GOSTOP := 0 ; local stringvar cooked := ""; while...
  13. Charliy

    If-Then Statement Help

    You may need to change the order of your ifs. Right now if the type is Stock or In Kind, then you would get that sentence, even if the person is a Member.
  14. Charliy

    Move Field(s) into Column(s)

    One way to do this is with Shared variables. First Group on your Member, then split the group footer in two. Suppress the group header, detail, and the second group footer. Create a formula like this: //init shared stringvar memb1 := ' '; shared stringvar memb2 := ' '; shared stringvar memb2...
  15. Charliy

    Calculate date difference for dates on 2 different lines of detail

    You can use either NEXT or PREVIOUS depending on which line you need the result on. NEXT({table.admission_date}) - {table.dismissal_date} or {table.admission_date}) - PREVIOUS({table.dismissal_date}) with either one be sure you're testing to see that you're still on the same patient.
  16. Charliy

    pull all rows from two tables with the same field names Crystal 2013

    Another approach is to apply names to the fields in the SQLL Command, so that would look something like: SELECT table1.keyfield ,table1.address as home_address ,table2.address as work_address from table1 join table2 on table1.keyfield = table2.keyfield
  17. Charliy

    Crystal grouping and while printing records

    Not exactly clear on what you're trying to get to. Do you want totals by month including each of the last three months, or do you want the last three months rolled up while you do totals for other months individually? If you want to do something like this: Customer ! month 1 10 month 2 15...
  18. Charliy

    Using a Shared Date Variable from a Sub Report in a Running Totals Field Evaluate Formula

    You can have a formula that contains the value, then just use that formula in the eval: //@subresult shared numbervar totval Then in your evaluate formula you can use {@subresult}
  19. Charliy

    Using if then else & instr in Crystal Reports

    Are you trying to do something like this: IF {table_date.balance_accrual} > 0 then "Accrual Loans" else "Other

Part and Inventory Search

Back
Top