Search results for query: *

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

Hi! I am using PHP4.2.0 and having problems with track_vars INI directive. When I pass a variable($sender_email) to another page(.php) with POST method, I get this error: Undefined variable: sender_email I know that <?php_track_vars?> is no longer supported and I dont need to do anything...

Hi MarcLara . Thanks for your information. Thats what I 've heard about Couchman's book. Still lots of people are recommending the book tho. Recently. I 've ordered Sybex kit and exam crams on amazon.com. I will give it a try with these books and see how it goes. I will follow you and take...

Hi wushutwist. Thanks for responding to me. You are right..I would use the STS tests if I feel not confident enough after reading and studying some books. Could you please tell me which book(s) you used for the exams? Thanks!

Thanks for the response, Duo. I am looking at STS website.. A couple of questions.. 1)Would you think its possible to pass all exams without it? 2)Which delivery type did you use..(Download/CD, Online30daysAccess, Online90daysAccess) Thanks!

Hi I am going to buy some books to study for OCP DBA and researching which books are best..It seems like it really depends on the person, but what would you think which book would be the best?? The books I am interested in buying are: Oracle Press - Couchman 8i Exam Guide Sybex DBA study kit...