Recent content by RobNauticus

Got it. There was a total formula in an above section in the report footer messing things up. I moved those sections below the ones we were working in. Working well now. Thank you for walking me through it LB! YOU ROCK! Rob

When I made the changes and to the total formula it changed all of the test formula results to 0.

LB, I have un-supressed the formulas from the subreports. The data seems to be passing properly as I have added new formulas containing only this: whileprintingrecords; shared numbervar Plywood_Total; Plywood_Total; on my main report next to the total we talked about above. They are all...

The sections in the subreport are supressed, such as the details and the headers, come to think of it, the formula is supressed in the report footer in the subreport. I will make a few changes and let you know, thanks. Rob

Ok I got all the formulas cleaned up as you advised, all of the totals formulas are placed in the subreport footer, the subreports are placed in subsequent report footers above the total formula. I am still not seeing anything add up. I will keep looking for a problem. Thanks and any more...

Hello LB, The problem is that the totals are not being pulled from the subreports. It only takes the value of {@Addon_11}.

Hello good people, Have a small problem with a formula totaling shared numbervars from a subreport. CR10 from Pervasive SQL DB. Here is a formula from one of my subreports whileprintingrecords; if isnull({#RTotal0}) then shared numbervar Glulam_Total := 0 else shared numbervar...

It works! Thanks for the help. Rob

As always, you rock! Give me a few days to try it, I am excited to see it in action. Rob

Hey Lbass, For each line item (which will look identical in the report) I need to have those individual quantities displayed on a single line not summarized but just listed horizontally. Example before Array: item qty 2x4 12" 2x4 12" 2x4 12" 2x4 16" 2x4 16"...

Hello, I have a question about arrays and I am not sure that it has been addressed exactly. My apologies if it has. Using CR 10 and Pervasive SQL Backend I have 2 Groups on the report Category and Item. My goal is to make multiple item's quantities on a single line. I think I need to...

Hello again, CR10 & Access 2003 I want use a conditional group count in my report for several formulas but I am having issues creating the running total field that will count only the instances of a group not the actual records themselves. I want to get a count of the groups (GP3) within...

I will take a look at them this evening. Thanks for the help!

The constant data is easily imported in a separate transaction. I am not concerned with that. The columns marked with a date under sales, cans and traffic are the main ones I am concerned with now. There will be a new column added to each of the three sections each week. It is important that...

Skip, I am pretty competent when it comes to vba, mostly access. I am aware on how to get the data into access just fine but I need the steps in excel to translate the data into a usable format like the screenshots show. Thanks, Rob