Search results for query: *

Hi,lbass and thank you very much for the answer. You and hilfy send me very interesting solution but unfortunately - it's not really matching to the problem I have... 1.I don't need to count the lines in the main report(plus it represents main data report and 6 subreports.The report with what I...

Hi,hillfy Thank you very much for the respond - I tried several times with the different variations your solutions but unfortunately it doesn't work. I would like to specify some things with you: 1.{@SetPageStart} Shared BooleanVar nextPage = false; {@SetPageStart} Shared BooleanVar nextPage...

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

Thanks a lot! It works!!!

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

CoSpringsGuy, Thank you very much for the answer - but the main problem is not how how to swich/suppress the pictures connecting to the different Field values(I understand this) - I don't know how to show these pictures into the formula(and to what object I can attach this formula - because OLE...

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

Thank you very much. Lana

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

THANK YOU VERY MUCH! I CHANGED CONNECTIVITY AND IT'S WORKING NOW!

I open Database Expert -> Create New Connection ->Oracle Server -> I feel out Service,User ID,Password boxes(the same that I used in Toad to connect to database) and I choose the view that I created. Lana

I'm sorry... I just realize that I sent wrong mail - I mean - view -the regular view that I created using Toad and inserted using Database Expert Lana

I insert my business view through Database Expert choosing it from the list Lana

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

Yours query works well. But - yes -to have "in_prev_month" function would be great! With a lot of thanks Lana

Thank you for help. I'll work with it right now. Lana