Recent content by YA

Hello, I am working on a report that displays a list of classes by location using Crystal Report 9. In the GH#1 (class location), I would like to put a piece of code to dynamically generate destination anchors like: '<a name = "' + {table.loc_name} + '"></a>' For example: <a name = "CA"></a>...

Hi LB! Thanks for your help. It worked great! YA

Hello I am developing a report in CR8.5 to show all orders created for companies by region. I created a paramter field called &quot;Region&quot; and created 4 default values.(All, North America, EMEA, and Japan) The tricky part is the &quot;Region&quot;. I have to use {COMPANY.BILLING_COUNTRY}...

Its not a major issue but can anyone help me on this?

Hi Synapse Thanks for your response! I am trying to modify the sql in the subreport. The record selection formula looks like this: {EMPLOYEES.ID} = {?Pm-EMPLOYEES.ID}and {CLASSES.ID} = {?Pm-CLASSES.ID} The sql looks like this under &quot;Show SQL Query&quot; SELECT...

Hello I am using CR8.5 and trying to modify a sql query directly in the Show SQL Query window. I changed WHERE part of the query but the change did not get reflected when running the report again..Do I have to do something else? Thanks for your help in advance..

Thanks Jim and Marina for the information. I havent had a chance to fully test my report with your information yet..but I will let you know the result when I test it out.. Thanks very much!!

Hi Jim I modified the selection formulas exactly what you mentioned as follows: (IsNull({TPV_PUB_LOCATIONS.STATE}) or not isnull({TPV_PUB_LOCATIONS.STATE})) and (IsNull({TPV_PUB_BASE_CLASSES.ID}) or left({TPV_PUB_BASE_CLASSES.ID},5) = &quot;class&quot;) and...

Also the record selection formula in the subreport: (IsNull({TPV_PUB_LOCATIONS.STATE}) or not isnull({TPV_PUB_LOCATIONS.STATE})) and (IsNull({TPV_PUB_BASE_CLASSES.ID}) or left({TPV_PUB_BASE_CLASSES.ID},5) = &quot;class&quot;) and (IsNull({TPV_PUB_PERSON.CURRENCY_ID}) or...

Okay, I will post the formulas from the report. //@Initialize (placed in report header) whileprintingrecords; shared currencyvar sharedILTCancel := 0; //@Evaluate (placed in detail section, and summing records) whileprintingrecords; shared currencyvar sharedILTCancel; If not...

Hi Ngolem. I changed the all record selection formulas in the subreport to: (IsNull({table.field1}) or {table.field1} = <something>)and But the result is still the same. The shared variable from the subreport doesnt return any value because of no records matched. I modified @evaluate in the...

Thanks for your reply Ngolem. I composed my formulas in the subreport the way you suggested. Then I am not sure what I should do with the part of your suggestion. I need help on this part. >you must test for null on any fields that are used in the selection criteria....like this...

Thanks very much for the responses!!!!!! Sorry that it wasnt clear enough. Let me add some more notes here. Both subreports are passing shared variables to the main report. I have fomulas to initilize the shared variables to zero in the main report in the GH#1a Location Name. I think the...

I am creating a report that shows Credit Card revenue by state. I have 2 subreports on the mail report. One of them shows all confirmed credit card transactions and the other one shows all refund(cancelled) transactions during the data range. The problem I have is like this: CA and MA have...

Has anyone ever tried to use the Avery Tent cards #5305? The size of the cards is 2 1/2&quot; * 8 1/2&quot; and 2 card/sheet. Since Avery #5305 is not available in CR8, I am trying to figure out the &quot;user-defined label&quot; by changing sizes, gaps, and margins but I cant seem to get it...