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: *

  • Users: gal
  • Order by date
  1. gal

    Running Total Summary - Display Zeroes for NULL value?

    Thank you for your quick response, synapsevampire. I actually had created a few formulas like that, but having as many fields and group footings, I thought there might be a quicker way of doing it. Your help is much appreciated.
  2. gal

    Running Total Summary - Display Zeroes for NULL value?

    C.R.8.5 - How can I default a Running Total Summary field to display a Zero when it has a NULL value? I have several Running Total fields that display as a Blank in the group footer if the summary value is not 1 or greater. The Running Total field uses the Evaluate, Use of Formula option...
  3. gal

    Running Total--Formula Code to evaluate only the LAST Detail record?

    Thank you so very much, LBass. It's just what was needed. Have a great evening!
  4. gal

    Running Total--Formula Code to evaluate only the LAST Detail record?

    Thank you, LBass. One typical formula counts PATIENTS who are admitted with an SA diagnosis and subsequently lose it: Running Total Name: RT1_SA _Removed: Field to summarize: @PatientID Type of summary: distinct count Evaluate Use a formula: {@DX_SA_ Removed} >= 1 Reset on change...
  5. gal

    Running Total--Formula Code to evaluate only the LAST Detail record?

    C.R. 8.5: Background: The Diagnosis History table contains three record types reflecting data at the time of Admission, Update, or Discharge. A patient may be admitted with a substance abuse (SA) diagnosis that may remain or be lost upon Update or Discharge. Or he may acquire an SA diagnosis...
  6. gal

    CR 8.5 How to convert AM/PM time to Military Time?

    This formula works. Thanks for all your efforts. if Left (totext({history.time}), 2) ="12" and Right (totext({history.time}), 2) ="AM" then "00" + ":" + Mid(totext{history.time}),4,2) else if Right (totext({history.time}), 2) ="PM" then ToText (CDbl...
  7. gal

    CR 8.5 How to convert AM/PM time to Military Time?

    Thank you for your response. The Sort is Ascending. I need to convert the time to Military format.
  8. gal

    CR 8.5 How to convert AM/PM time to Military Time?

    Crystal Reports 8.5: Please provide a formula that converts a Time field containing AM/PM format to Military Time. When I compare two time fields directly, they sort as though they were strings. But, "12:01 AM" should not sort higher than "10:00 PM". Thank you.
  9. gal

    CR 8.5 pass data back from Subreport for calculation in Main report

    Thank you for your explanation. Is it possible to use "if statements" within the formulas in the subreport? Will it work if you say something like, shared Numbervar x; if A = B then x:=sum({Table.Myfield},{Table.FieldGroupedOn}); x <====is this part of the required code or does it indicate a...
  10. gal

    Pass Totals from Sub report to Main report for computing in Main

    Thank you, synapsevampire, for your very helpful explanation. I will move the Sub report to the heading because I don't see a way around needing a Sub report. I will also follow your additional suggestions. Two more questions, please: Is SomeTotal the Shared variable name in your example--so...
  11. gal

    Pass Totals from Sub report to Main report for computing in Main

    Using CR 8.5 the objective is basically to pass the Final Total # Beds in each hospital (e.g., Hospital A and Hospital B) from the Sub report to the Main report. The Final Total # Beds for each hospital is used as a coefficient in calculations at multiple Group levels in the Main report...
  12. gal

    CR 8.5 pass data back from Subreport for calculation in Main report

    Thank you. I didn't know they existed. Help says, "Shared variables (Crystal syntax) Shared variables use the same memory block to store the value of a variable throughout the main report and all of its subreports. Thus shared variables are even more general than global variables. To use a...
  13. gal

    CR 8.5 pass data back from Subreport for calculation in Main report

    In a CR 8.5 Subreport I need to subtotal table data into 12 formula fields and pass the summarized data back to the Main report to to be used in calculations. The reason: The data cannot be summarized as required at the group levels because the 12 fields are independent of the groupings. The...
  14. gal

    Median in &quot;Cross-tabulation&quot; style 8.5 Crystal Report

    This CR lists Median Number of DAYS used by a given geographic Region, by Hospital. Hospitals are placed horizontally across the page creating a "Cross-tabulation" effect. Region levels occur at Group Footings GF2-GF4. At each GF, I Inserted a Summary-Median of DAYS for each Hospital. The...
  15. gal

    FIXED LENGTH fields, fixed length TEXT FILE output--in Crystal 8.5?

    How does one export Crystal Reports 8.5 output to a text file with all FIXED-LENGTH fields? How would you PAD BLANKS TO THE RIGHT for a text field (e.g., zip code for 9 places)? How would you PAD ZEROES TO THE LEFT for a "numeric" field? (All fields are concatenated into one to avoid making a...
  16. gal

    CR Subtotalling AT A GROUP--apart from Sum of Detail records?

    Hi, lbass and other stars! Is there a way of "Subtotalling At A GROUP level" for # Beds available, while subtotalling for # Patients detail records at the same group level? I have to calculate subtotals at 4 group levels. At each group level I will report Bed Capacity, Number of Patients, and...
  17. gal

    CSS: Hyperlinks without underlines: Syntax of text decoration=none?)

    I need to make Hyperlinks without underlines. Would like to use a stylesheet rather than put the style tag on each page. 1) Can I include the Syntax of anchor text decoration=none in a style sheet? 2) Can you use more than one stylesheet on a site? 3) Can you use and Include File with a...
  18. gal

    Can Javascript and VBscript be used in the same asp program?

    I think I can use the response.write technique to make the back button! I'm confused about how you would designate client-side VBscript as opposed to the (default?) server-side VBscript, and what types of procedures would be client-side. Are updating and displaying of database records...
  19. gal

    Can Javascript and VBscript be used in the same asp program?

    Thank you, onpnt, for your thorough reply. So, the only script that needs to be started and stopped is the Javascript? I'm looking to go to a previous page, but do not know the original path. I intend to use this code, but have not tried it yet, as a more experienced person at work said she...
  20. gal

    Can Javascript and VBscript be used in the same asp program?

    Each time you put a Javascript end tag, would you then need to put a VBscript begin tag in order to use VBscript as well? Or, does it default to script=&quot;VBscript&quot; if you assign it up front? Thank you!

Part and Inventory Search

Back
Top