Search results for query: *

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

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

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

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

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.

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

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

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

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

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

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

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

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.

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?

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