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

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

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

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

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

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

Is it possible to create an ODBC connection to a SQL Server database running on a Novell server? Don't know much about this so I thought I would ask. Thanks.

I need to pull data from the current quarter and the previous quarter based on the Current Date. If the current date were in February I would want the 1st quarter of the current year and the 4th quarter of the previous year. Thanks!

I need to do a distinct count on a formula using the distinct count summary function. The problem is that there are potential nulls in this formula so that my distinct count is off by 1 where there are nulls. (formula looks like this: if field x = Y then field z) I can't use a conditional...

I have date parameters (?StartDate and ?EndDate) and they are being run against a date/time field. The selection criteria looks like: Date({date/time field}) in ?StartDate and ?EndDate This works fine except that it takes forever to run and no matter what date range in insert the report looks...

I would like the report to pull all records when the parameter is not filled in. Essentially the user should be able to enter a parameter value and get the results desired or ignore the parameter and get all data. I need this to work on multiple parameters, be able to be passed to a...