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

  1. slicknick515

    Shared Array Variables

    I want to be able to pass values from the details section of a subreport to my main report. I have the subreport in Group Header 2. The field from the subreport is call DispenseDose. For example, I have Product ID as a Group in my main report and subreport and i need to pass all of the values...
  2. slicknick515

    Summing shared Variables

    Thanks IanWaterman and others for the help. The last suggestion worked great!
  3. slicknick515

    Summing shared Variables

    Sorry, I may not be understanding where to put everything you posted above. Where would i place the first formula that contains the shared variables. Maybe it will be easier if i lay it out for you... Group Header 1-> Clinic Group Header 2-> Product Details-> Contains both subreports referenced...
  4. slicknick515

    Summing shared Variables

    Also, I tried Summing the variables separately and then multiplying by the cost.
  5. slicknick515

    Summing shared Variables

    Just to add, I tried to Insert a summary of {@Cost} but this formula isn't available to Sum. I also tried to do the Sum formula but that field can't be summarized.
  6. slicknick515

    Summing shared Variables

    I have two subreports within the Details A section of main report. Subreport 1 has a shared variable named MyTotal Subreport 2 has two shared variables named MyTotal2 and MyTotal2a On the main report, I have the formulas below-> @MainFormula Whileprintingrecords; Shared NumberVar myTotal...
  7. slicknick515

    Shared Variables Issue

    Hi, I am trying to pass values from a subreport to the main report. Main report shows current Quantitiy on Hand of a particular product. Subreport shows Quantity on Hand on a particular date selected. I want to show the Historical Qunatity from the subreport next to the current Quantity on the...
  8. slicknick515

    Help with Formula

    Hi everyone: Here is the data example-> Transactions Table Gender PatientID TxID M 1 655 M 2 159 M 11 712 F 14 888 F 22 098 M 34...
  9. slicknick515

    BO Rights

    An associate is having an issue with the sections expert. When he righ-clicks on the left inside of a group header and clicks, section expert or suppress section, etc., it does not do anything. When he right-clciks within the group in the report and clicks section expert, it allows him to check...
  10. slicknick515

    Suppress Leading Zeros of a Summary

    Sorry, I did mean trailing zeros. Taking the "while reading records" resolved this issue. Thanks so much!
  11. slicknick515

    Suppress Leading Zeros of a Summary

    Baically, i am using this formula to show the patient's dose. If the dose is not a whole number, it shows that number up to four decimal points. If it is a whole number, it clips the zeros. In my group footer, i have a summary of the dose and i want to treat it the same way with the leading...
  12. slicknick515

    Suppress Leading Zeros of a Summary

    I use the formula below to suppress leading zeros of a number but i want to replace the {FIELD1} with the (Sum of {FIELD1}) Is this possible? WhileReadingRecords ; StringVar text := Totext ( {FIELD1} , 4 , "" ) ; NumberVar end := length ( text ) ; NumberVar clip := (if Val (...
  13. slicknick515

    Maximum of a Summary

    Well, the report is written and I have to show all the products usage but I wanted to put a little "fun fact" in the group header that shows the most used product and how much was used of that product.
  14. slicknick515

    Running total final result displayed in page header

    Have you tried creating a summary that shows a sum of calls and put it in the grand total section, then move that summary object from the grand total section to the page header section? Or is it a deeper issue?
  15. slicknick515

    Maximum of a Summary

    I wrote a utilization report. It is the total amount of a product used in a given time period. I want to show which product was used the most. To get the total used, I simply did a summary that is the sum of @totalused. I can't figure out how to make it look at total used and bring back the...

Part and Inventory Search

Back
Top