Search results for query: *

I finally got it to work. Thank you for all your comments; they were a big help. 1. The call from the menu is: do form frmrptvur with curdir() + "\Crystal Reports\Gross Profit by Materials Detail ld.rpt" 2. The init event of the form is: LPARAMETERS cReportName, nClientId LOCAL...

The init event of the form does not execute before the init event of the control. I had tried to assign the value to the tag property of the form, but it is too late for the olecontrol to use it. That is the reason that passing the parameters is so difficult.

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

The answer was in the config.fpw. I also have made certain that I have a Clear events command. Thanks for the advice.

Actually what I have is just that DO FORM reportselection.scx Read events

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

We finally discovered that the sales journal included unexpired quotes. We made our record selection filter out records that have JrnlKey_Journal = 12 which is defined as "12 = Quotes Journal." It is found in JRNLHDR.DAT.

We have created a report as suggested by blueboyz. The problem is that the results do not equal the totals as shown on Peachtree's income statement. We seem to have just a couple of hundred dollars' difference. Is this a common problem? Will we be able to reconcile the difference. Our...

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 am using Crystal Reports 9.0 that is packaged with Peachtree.

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 finally got your suggestion about Insert Maximum into the group footer. I guess it took a little while for me to absorb what you were trying to say. Thank you. Carolyn

I still do not get the correct value. When using WhilePrintingRecords, if the last record read does not begin with a P, then the value is released. WhilePrintingRecords; stringVar PO:= If Mid({Command.trans},1,1) = "P" then {Command.trans} What would be the else statement for the next record...

This is the data in a table Acct TransID Amt 5000 PO10041 2500 6000 SO10041 1500 5000 PO10041 3500 6000 SO10041 500 6000 SO10041 1000 It has to look like the display line when I am finished. The problem is that I cannot always get the PO10041 to be captured; sometimes...

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 finally created specialized queries in Access to do the job. Thanks.

If you want to Calculate the Sum, the Option "Show as a percentage of " is disabled.