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

    Force a specific record?

    I'm using a formula so search a database for all "Inpatient Fees" for a hospital. Within these fees is one lone field called "Budget Only" that MUST be shown as well. Is there ANYWAY AT ALL to not let the details finish until that record is shown?
  2. Frostburn

    How do I sum a formula that is not in the details line?

    How can I sum a formula that is NOT in the details line, but in a group footer instead? I would like to sum the formula that is in group footer 3 in group footer 2. Thanks in advance, TJ
  3. Frostburn

    For the love of God, does anyone know how to declare variables?

    Please, if you know how to declare variables, and use them in a formula, please tell me.
  4. Frostburn

    How do I declare a variable in Crystal?

    This formula keeps causing Crystal Reports to crash: if Sum ({@YearlyBudget}, {tblSubSection.SSName}) > 0 then Sum ({@AvailableBudget}, {tblSubSection.SSName}) / Sum ({@YearlyBudget}, {tblSubSection.SSName}) * 100 --How do I declare variables to work with so the formula can deal with those...
  5. Frostburn

    Is it possible to send an entire SQL statement to Crystal Reports?

    Is it possible to send an entire SQL statement to Crystal Reports? I've created a great SQL statement that shows up the correct records--so I recreate it to my best ability in Crystal, and get the worst gibberish I've ever seen. Here's my statement: SELECT DISTINCT...
  6. Frostburn

    Adding subreport values with report values?

    Within the SAME report, I have both details areas (main report,) with subreport areas as well. I must add a value within the subreport with a similiar value outside of the subreport. How is this possible? What is the syntax for the formula field? Thanks
  7. Frostburn

    Compacting Text Files

    You could save it as a .txt file, which will be smaller than a .doc file, or something like that. You might be able to create a kind of 'zip' for it. -- Good luck.
  8. Frostburn

    How do you add subreport values with values not in the subreport?

    How do you add values in the subreport with values outside of the subreport? Thanks in advance

Part and Inventory Search

Back
Top