Search results for query: *

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.

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...

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

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...

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...

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...

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

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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!