Search results for query: *

I have placed an olecontrol on a form in VFP 6.0. The name of the control is CRViewer9.CRViewer.9.2. It will display a Crystal Report very nicely. That information can be found in thread faq184-3039. I want to call the form with the viewer with the following command from a menu. do form...

I have a VFP 6.0 project that has only one form. When I work in development, the form shows up just fine from a prg named main using the following command: DO FORM reportselection.scx When I compile the code into an executable, there is no form. What is necessary to show the form so the user...

We have created a sales listing report by state using JrnlHdr, JrnlRow, Customer, and Chart. When running the report we had only one transaction that was duplicated. We added all the obscure fields from JrnlHdr and JrnlRow to determine the cause. And none of the ones we added showed up with...

I am creating a report that displays data for a certain period of time. In order to get the YTD values, I want to summarize in one line the YTD data as a subreport. In order to link the reports I want to take the data from January 1 of the year in question to the last date in the primary...

I have the tables JrnlHdr and JrnlRow joined as suggested in my last post. I have also used Customer and Chart. Now, I want to find out the values for specific Account ID's such as 401000 as Sales and 501000 for COGS as found in Chart. Amount in JrnlRow does not seem to return the correct...

I have created a Crystal Report using CR Developer 9 on an offsite computer. I am trying to move it to another computer that uses CR Standard 9. The underlying data are Visual FoxPro 6.0 free tables. The connectivity is through an ODBC driver that we just downloaded and installed from...

I want to create a report using the ddf files that contain the following fields: Customer ID, Customer Name, Sales on just specific account(not total billings), and date of sale. I am having difficulty determining just which tables contain the information needed. How would the tables be joined?

I have a report that has records with POXXXX and SOXXXX for which I want to accumulate totals. I am doing this by suppressing the details and displaying only the Group Footer. XXXX in both of these fields determines the group. There may be several detail records that are summarized. I can...

I am displaying only the group footers which have summarized sales data. There is a percentage of sales that is to be calculated. I have been asked to sort that data descending by the values in the group footer. Is it possible?

I have a report that has lots of detail sales data. I am displaying only the group footer and a summary of sales data and the percentage of the groupings based on the grand total. That is working fine. However, I want to show the percentage (100%) in the report footer. When using the...

I am creating a crosstab report that contains Sales and Cost of Sales. I want to summarize the data by state. Then force a pagebreak after each state. I do not see anything that allows me to force a page break on various groupings.

I am creating a crosstab report that contains Sales and Cost of Sales. By letting the COS field display as a negative, the Total is correct. I have been asked to not show the COS as a negative. How do I do that and still have the columns operate correctly?

Dim cat As New ADOX.Catalog When I use this code, I get the error message "Compile error: User-defined type not defined." What do I do to correct this?

Field1 NewDate Company Rep: #Error #Error Rosauers #Error 38864 5/27/2006 38857 5/20/2006 38850 5/13/2006 38843 5/6/2006 38808 4/1/2006 38777 3/1/2006 #Error I have a sample query containing the following data. It is data from an...

I have created a combo box on a form. When the user selects his choice, I want the record pointer to be at that record for all the other information on the form. How do I do it? I used a recordset.FindNext, etc. but that presented some unexpected problems.

I am using CRXI Professional against an Oracle database. I am using cascading parameters. The first list is up to 100 items (currently there are 77 items), the second can be that long as well. My difficulties are with displaying all 100 items. It seem as though, only about 1/2 of the items...

Is there a way to freeze the reports headings so that they will display no matter how far down one has scrolled? I am referring to freeze panes such as can be done in Excel.

I am having extreme difficulty with some of the features of Crystal XI not woking correctly. Uninstalling and reinstalling have not corrected the situation. I have been leary of deleting anything from the Windows Registry, although I made sure that all of the pertenint files had been deleted...