Search results for query: *

Crystal 10 on Oracle The date field I am trying to work with is represented as a number in the database. I am using this formula to convert the number to a date: (DateSerial ((int({F0006.MCD4J}/1000)+1900),1,{F0006.MCD4J} mod 1000)) If the field in the database is 0.00 then the formula...

Crystal 10 on Oracle I am working on a report that uses a separate field for each month (1 - 12). If todays date is in one of the month buckets, I need to grab the value in that bucket and use it in a "quarter" formula. The value in that bucket is the percent complete on a construction job. For...

Crystal 10 Oracle I would like to get my subreport placed so that it is horizontal (across, not down) to my main report data. I have tried just about every combination of subreport placement, insertion of additional sections and the underlay option. Both the main report and subreport are simple...

Crystal 9 ODBC My problem is twofold: First, I am trying to count heads of household that are handicapped/disabled and heads of household that are not handicapped/disabled. "Y" represents handicapped/disabled and "H" represents head of household. My running counts evaluate the first statement...

Using Crystal 10 & SQL database: This should be simple. My first group is on employee name. My second group is on transaction date (with the by month option). I have a summary count of the date details (how many transactions) but I also need to count the number of distinct months/year for each...

CR Version 11 When using Not OnFirstRecord with New Page Before and Not OnLastRecord with New Page After in the Section Expert, how do these two funcions actually get rid of blank pages? What are the conditions the functions are testing? I'm trying to understand the logic behind what I am...

Version 11 When using Not OnFirstRecord with New Page Before and Not OnLastRecord with New Page After in the Section Expert, how do these two funcions actually get rid of blank pages? What are the conditions the functions are testing? I'm trying to understand the logic behind what I am using...

I am using version 9 attaching to Oracle through a command object. I am trying to sort the report by Next Date, Zip Code or Employee Name based on the following formula: if (UpperCase({?SortType}) = 'NEXT DATE') then ToText({Command.NEXTDATE}, 'yyyyMMdd' )else if (UpperCase({?SortType}) = 'ZIP...

I have been periodically checking this forum for an update from Annette Harper on whether or not she has heard from her publisher regarding updating the CRCP Exam Guide for XI. I received my CRCP for version 10 back in June and now need to certify for XI. Much of the current cert material was...

I am using version 9 and I am trying to base a formula on the first two digits in a 12 digit string. I know I would use the LEFT function but I am unsure of the syntax. It would be something like, if the first two digits are 03 or if the first two digits are 77 then "myfieldname" else...

I am using Crystal version 9. I have an employee field that uses 4 codes - 1,2,3,4. I would like to able to group on code 1 only if the employee field = 1 and not group when the field contains 2,3,4. I thought of grouping in specified order but have not tried it because I don't want codes 2,3,4...

I've been studying the material for several weeks and I just took the Master Exam quiz from Annette Harper's book (my actual exam is on Monday). I'm kind of freaked out because by the looks of the quiz, the exam itself is going to be different than the other two. Based on comments in this forum...

I am trying to set up accounts receivable aging parameters. Initially, I was using one field to calcultate the aging (racct.lastpaydate) however, if there has been no payment, this date is null. So, if this field is null, I have to look at the invoice created date and age off of that. I have...

I've read over this several times but something in the material just now jumped out at me. In the section that talks about the Report Processing Model, I am looking at what happens during pass 1. Under the paragraph, Evaluation of Recurring Formulas it says, "Formulas that contain references to...

I have the following "Aging" formula: if CurrentDate - {RACCT.LASTPAYDATE} in [30 to 60 ] then "30 to 60" else if CurrentDate - {RACCT.LASTPAYDATE} in [61 to 90] then "61 to 90" else if CurrentDate - {RACCT.LASTPAYDATE} in [91 to 120] then "91 to 120" else if CurrentDate - {RACCT.LASTPAYDATE}...

I am preparing for the Level 2 CRCP exam and I'm looking for clarification on a couple of points. In the section about Setting Up and Configuring Data Sources, the material says that Oracle, SQL Server and Microsoft Access are native connections. But then the example given for setting up an...

I have worked with Access for a few years but am no expert so this one should be a cinch for someone who is. I have two tables. I am comparing records in table A to records in table B. If a record XX in table B indicates activity for record XX in table A, I just need to update a field in table A...

I’m working with a main report and a subreport. The main report is grouped by client account number, then Invoice Month. The details section of the main report contain the invoice details. The subreport contains all of the Credit (payments) detail. There is already a shared variable that keeps...

I'm working with a table that stores several client types. I only want these client types to show up in a paramter list and I would like the user to be able to choose one client (of Client category 1) or all category 1 clients. However, what I see in my "pick list" are all client types. Plus, I...

I have a main report that totals invoice amounts by account number. My subreport totals payments/credits with no grouping (no, the file structure does not allow me to link these two tables in the same report). I want a grand total of all payments/credits from the subreport to display in the...