Recent content by MaumeeScott

I need to add a sequence number to an existing table. The primary key is alpha-numberic which is causing me problems when I attempt to select a certain number of records. What I am trying to do is to select the first 50K records or records 50K through 100K etc. I thought about taking an...

I have a couple of data parameters that are displayed in the page header using the following computed field: "Beginning Date " &StartingDate & " Ending Date " &EndingDate This works great as long as the report finds records in the date range. If there are no recrods in the date range then the...

Is there a way to use a variable in the expression builder. Specifically I am attempting to use the variable in the if section of a conditional section. I would like to use something like the following as a condition. <variable> = 2 In this case if the variable = 2 then the report would...

I now see the method, but can't seem to get the syntax correct. Would is make more sense to use a conditional section instead? Can I use a variable in the ifExp in the Conditional section? Thanks again for all your input. It has been extremely helpful. Scott

John, I am struggling a bit on the syntax. I also don't see the BuildFromRow method on the Content Frame, do I need to add it? Thanks again, Scott

I am attempting to only show data in my content section based on a formula. I need to pull all of the data into the report for other formulas, but as far as displaying the records in the content section go, only some will be displayed. If I override the Methods on Text Controls I end up with...

Thanks again John! You have been a tremendous help and I can't thank you enough. Scott

I am attempting to Return the Maximum Value of a Computed field in the content frame. The follwing is the Override Method on the content frame which essentially counts the number of null fields in a record. Sub OnRow( row As AcDataRow ) Super::OnRow( row ) Dim NullCount As Integer...

John, That worked great! Thanks! Would the same process be used to find the Maximum value of that same variable? Thanks again! Scott

The error when trying to use the Group Selection formula was that formula needed to be evaluated later. When attempting to conditionally surpress the group footer I got unexpected results in that it didn't surpress the group footer. Based on some research I have since changed the way the...

I am attempting to create a report a parameter is used to show records based on a value that is calculated in a group. I have two conditional running totals in my report that are multiplied together to give result x. The user will input a value y and will only want to see records where x is...

I have the following method on an integer control in the content section of a report. This essentially calculates how many of these fields are null and returns the number. This works fine. What I now need to do is to Average this in the report after section and I can't seem to get it to work...

Thanks John. Very helpful. Scott

What would be the best way to count and display the number of null fields on a record? Thanks!

That did the trick! Thanks a million! Scott