Search results for query: *

I have a button which runs a query. It displays properly. I would like to make it so the only thing the user can do is close the query by using "X". As it is now, the query can be placed back into design mode and modified. Any idea how to do this?

I am trying to detremine a formula (VBA function would be acceptable) to calculate the actual pay date given the nominal pay date. As an example: the nominal paydate for the first payroll in January is 1/15/06. I would like the function to return 1/13/06 which is the last working day prior to...

This is actually an XP Home problem but I do not see a forum for that so I have asked the question here since the solution, if available, might be the same. The keyboard I am using has a power key. If this key is pressed while the system is running it very soon won't be. My problem is that...

I want to include an image from a scanned report in another report I am preparing. The scanned image is a TIFF. I inserted the picture and cropped it to size. There is text above and below it. This worked well. I decided it might be nice to have a border around the image to set it off. I...

Is it possible to track the absolute page number while using the page MofN feature ( and resetting the page number based on a certain grouping). We produce a large number of statements with one run of the report program. The report is about 2,000 pages and occasionally we need to reprint a...

I have a report that uses a subreport to summarize data which appears in the report. The data being reported on is account data and the subreport summarizes balances for certain subaccounts within a major account. In the main part of the report, each subaccount appears with its beginning...

Below is an output table. Staff_Status Data 2002 2003 2004 F Sum of Tot_Miles 87,686 113,481 131,360 Sum of Bus_Miles 73,068 92,576 107,969 Sum of Lease_Value $2,442 $2,462 $2,673 Sum of Pers_Value $3,246 $3,612 $3,960 S Sum of Tot_Miles 300,177 290,641 285,710 Sum of Bus_Miles 111,127...

I am using MS Sql Server 7.0 and Crystal Reports 8.5. I put this in the data access area because the problem has its root in data access even though the error message does not necessarily point to a data access problem. I developed a rather complex query which involves the use of temporary...

I have prepared a report which contains project data divided by sub account. Each project has between 3 and 10 subaccounts. The summary would contain the ending balance for each subaccount. The balance is available on each detail record and these are used to print the totals within the...

I have a Basic syntax formula of the form: formula=iif(a<>"G",b,iif(c="I",d,e)) a is a database field which is also a group control it can have two values "G" or "O" (letter) b is a literal of type string (ie in quotes) c is a database field or type string d is a formula which should evaluate...