Search results for query: *

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

John, For some reason when I remove the quotes around the parameter I get a database error. Thanks for the help. Scott

I would like to take a parameter input and use it to select records, but the parameter will reference a data set based on a different criteria. Essentially the user will type in their location and the report will then use this to determine which records to return. I need to build an if/then...

That definitely helps, but how do I use that query with an update statement to acutally create the line#. Currently I only have the ID#. I am going to add the line# column and would like to populate with the serial data. Sorry to be so obtuse. Scott

I would like to be able to insert a series of numbers based on a field. What I essentially have is an ID# that may be repeated in the table. What I would like to do is update a separate column and insert a 1 for the first instance, 2 for the 2nd, etc. The data would look like the following...

I have a fairly simple report that has one group and one details section. I would like for the report to print on the front and back (duplex) when the group is more than one page, and not when the group is only one page. For instance, I go to print 3 records with the first one requireing 2...