Search results for query: *

Morning; I have a bunch of old routines developed in 2.6 (in a 16 bit environment) that became quite unstable under Vista and Windows 7 (and even on select boxes under XP). So I upgraded to VFP 9. The transition went quite well except that in some programs (PRG routines, not compiled) I get a...

Hello; A coworker has been trying to run an old application and gets an error message: "A temporary file needed for initializaion could not be created or could not be written to. Make sure the ... path exists and space is available. Choose close to terminate" It is running on a relatively...

Hello; We have several old applications developed and compiled under FP 2.6. They have remained stable despite their age until recently. A coworker has the primary applications installed on a relatively new machine running XP SP 3. When executed there is a brief "splash", and then we're back...

Afternoon; Assume a table that has a left most field indicating a client identifier, as well as a product identifier, and a number sold field. (A record might indicate that client John bought 3 widgets.) In a given month John might have bought 6 different profucts. All those details...

Good morning; I need to generate a report that simply cannot be displayed on a single page, even in landscape mode on legal paper. I assume there is a process one can follow to create a two page report. (That is, if there are fifty lines to be displayed the output will be 100 lines.) Can...

Morning; I want to highlight every second line in a report. I thought I had it when I conditionally formatted based on record number, but that isn't working when the LINE in the report represents data from multiple records. (That is, several records are summarized to a single line in the...

Good afternoon; Assume we have three distinct records from a single individual - each record indicates a numeric estimate for a specific datum. My report has a column for each of those three pieces of info. So I have the client identifier, followed by the three estimates, using a formula to...

Morning; I'm working in a database with which I am unfamiliar, and that is undocumented. CR is my sole access to the data. What I need is a printout of the field structure. It appears this functionality is not immediately available, but I'm hoping there's some sort of obscure function one...

Morning all. In getting up to speed on CR I have two drill down reports that are both working, but seemingly in different fashions. I'm missing something. In report "D" I display client records (there's only one from each client) - at DDGL (DrillDownGroupLevel)=0. It then groups on county...

I have a report that is working quite well - it involves drilling down (from the county level) into the details of the data. On inspection, though, I want the drilled down level to reflect a group, essentially. (That is, when I drill down I want the report to indicate the summation of multiple...

I must say you all are a helpful lot, and I do appreciate the assistance as I get up to speed with CR. I would like to have my report header repeat when I drill down into the report. I could set up a header "B" and suppress based on DrillDownGroupLevel, but I have to think there's an easier...

This hould be relatively easy, but I'm new to CR and this one is frustrating me. Assume we want to display a sum in a column, and that the rows are county indicators. I filter the sum column so it indicates the value for men only. I want another column to indicate the same sum, only for...

Hello all; I am trying to develop a cross tab report. It will be grouped by county. No problem to there. I would like to be able to drill down into the county details. Do I have to use a sub report to accomplish this? Thanks in advance. D

Morning; I'm unable to link two tables, because the primary key in one is numeric, and string in the other. I'm using a command instead of setting the relation, but am getting a failure as the "ToNumber" function is not (I am presuming) a recognized function at the server level. My command...

Good morning; Ultimately I want to add four parameters to a report I am preparing, but for now I'm dealing with just two. I started with {?YearParameter}, a dynamic parameter that repopulates when data is entered for a new year. The filter is simple, simply looking for records where the...

Morning; A couple days ago I posed a question pertaining to conditionally suppressing sections. Wanzek pointed me at the DrillDownGroupLevel function, which helped immensely. This is a follow up question, although I feel I should note that I am a CR newbie, and that I should apologize if...

I've got a report which indicates county names and the number of records that were recorded in each county. I want to be able to drill down into that data, and have that data displayed with a totally different detail line and headers. I split the details section in two, and put the drill down...

Hello all; I'm new to CR, and am working with data that has been accumulated by a non programmer. I need to link our dynamic data to our "tombstone data" (address, phone, etc), but the primary key in the former is a 9 digit numeric (integer). In the tombstone data it is a 9 character text...