Recent content by cfriedberg2

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