Search results for query: *

Hi, I’m using CR IX and Oracle 9i. I have a subreport that contains notes grouped by note name and the date written on. At the end of the report I have an Index list – it contains note’s category, date written on, and a page where every note's prints out. For my Index list I created output -...

Hi, people. I'm using Crystal XI with Oracle 9 and really appreciate if anybody will help me with this: I have to count the number of records on each page(records are in Details section). The formula has to be placed in Page Footer. For example, I have three payees on the first page -> so the...

Hi, people Unfortunately, I never work with .bmp files(actually with all type of pictures)in Crystal and I would be happy to get any tips how to do my task: I need conditionally show different .bmp objects in the Crystal Report IX (database - Oracle 9). This is how they have to appear - if...

Hi, people. I need to schedule Crystal report 11 based on Oracle 9 procedure quarterly(has to be sent by e-mail from enterprise 1st day of each quarter). In Schedule tab I see On Demand, Once, Daily...but no Quarter. I'll appreciate any answer. Thank you, Lana

Hi, people. I need to schedule Crystal report 11 based on Oracle 9 procedure quarterly(has to be sent by e-mail from enterprise 1st day of each quarter). In Schedule tab I see On Demand, Once, Daily...but no Quarter. I'll appreciate any answer. Thank you, Lana

Hello, people! The data is group by month in my report. I show the data for two years. So the claim count in the report is shown this way:Jan 06 25 Feb 06 45 Mar 06 32 ........... Jan 07 27 Feb 07 41 ........... I have to calculate...

Hi, people. I work with Crystal report 11(sometimes Crystal 9), Oracle 9 db. I'm sure I'm not the first who has problem with minimum/maximum in Crystal. I don't have possibility to get the minimum/maximum records through the view because my reports are based on business view in Crystal 11. I...

Hi,people. I created the view that I have to use in Crystal 9(Oracle 9.2). Here is the example of my view: SELECT claim_prof_entity_fk, MAX(claim_prof_name) AS name, SUM(DECODE(Type_Alert_M1, NULL, 0, 1))AS M1 from claim Here is my question - how it may happen: when I run this view...

Hi,people. I work with Crystal 10 and Oracle 8. I created CheckLine formula in Crystal: "00000000" + Trim({Table.Field1}) ToText({@CheckDate})+ Table.Field2 + Space(30) @CheckDate:date({Table.DocDate}) Table.DocDate type is DataTime that I customise like MMDDYY in Options. I published this...

Hi,people. I use Date function LastFullMonth in Crystal Report 9.2. Does it exist the identical function for Oracle(I work with Oracle 8) or I have to do some calculations. I'll appreciate any answer. Thanks, Lana

Hi,people. I use Date function LastFullMonth in Crystal Report 9.2. Does it exist the identical function for Oracle(I work with Oracle 8) or I have to do some calculations. I'll appreciate any answer. Thanks, Lana

Hi,people. I browse the data in a database field in Crystal and remarked that not all the values are shown in the field. When I select in Oracle I can see all the values. Are there any limitations for database fields volume in Crystal? How can I see all the database values when I'm browsing...

Hi,people. I try to group data for my report but I cannot understand why one of group doesn't work. I have to show in my report the doctors which have more than 2 patients and each patient has to do payment equal or greater than $100.00(in Details I have to show all information for each...

Hi,people. I need make the Date parameter equal to the the last day of the last month but I cannot find the Date functions which can do it. I'll appreciate any suggestions. Thanks, Lana

Hi,people. I have to show the items,items' details, group by department(count(item)has to be >=2). I include count(item)into SelectExpert formula but I don't get any positive results. I'll appreciate any suggestions. Thanks, Lana

Hi,people. I have to show the field in the report that is has to be found by the formula: Sum (distinctcount({Table1.Field1})) but I get the message that "this field cannot be summarized" I'll appreciate if anybody has an idea how can I get this value in Crystal(Oracle db). Thanks, Lana

Hi,people My report has to show only the records where field1(string data type)is '' or null(Oracle 9) I wrote the formula: field1 = '' or isnull(field1)= true But this selection doesn't show up in my where close and I cannot get the records I need I'll appreciate any suggestions Thanks, Lana

Hi,people I have to show in my report(Crystal 9.2)only the records that were created in the last day of the previous month. I'm using for my parameter {?OpenDate}=maximum(LastFullMonth) formula but it doesn't show up in the Database "Show SQL Query" window. I'll appreciate any suggestions...

Hi,people. I have to print my report accoding two special tasks: first - my report sorted by Name.The information for the new name has to be on the new page. second - the information has to be printed on both sides of the list. I'll appreciate any answers. Thanks in advance. Lana

Hi,people. To show last and first name in report(Oracle db) I'm using the formula based on my view fields: UCASE({RPT_CLAIMANT.LAST_NAME})+ IF UCASE({RPT_CLAIMANT.FIRST_NAME})='' Then '' Else ', '+UCASE({RPT_CLAIMANT.FIRST_NAME}) If I don't have firstname nothing shows up in the formula. I...