Search results for query: *

Find the solution by using add command using the following sql select last_day (add_months(trunc(sysdate,'mm'),level-12)) as E63_BOOK_DATE from dual connect by level <= 25

ODBC oracle, crystal report 2011 I have 2 crosstabs with monthly premium and premium earned info. I need the output to be fixed and therefore all information needs to be in the same exact position each month. In the report, I show only month end date, and premium amounts, I need show all of...

CR 2011, oracle if I have policy premium, policy effective dates and expired dates, I need to report mtd earned premium by every month end. how can I do that? data: pol effectivedate expireddate premium pol3 1/15/2013 1/15/2014 3600 report to show: Beginning date month end month premium...

I found LB's advice from thread149-1529329 about how to flatten table. It worked perfectly. Thanks LB Ann

Crystal 2008, odbc I have a claim table with layout as this Claim # Enter date NOTE TITLE XX19000008 01/08/2010 ACORD1 XX19000008 01/31/2010 ALAE Expense XX19000008 02/09/2010 Reserve Change ZZ24000164 12/07/2009 CLAIM ZZ24000164 12/22/2009 Replacement ZZ24000164 12/22/2009...

Crystal report 2008, oracle I have a report grouped by claim number then by transaction dates. I need to reset to 0 at the different claim number. I placed formula 1 at the group 1 header- claim number numbervar cnt := 0; cnt I placed another formula at group header 2 - transaction...

...date(tonumber(right({?Column2 - mm/yyyy},4)), tonumber(left({?Column2 - mm/yyyy},2)), 01), {?Column2 - type}), CurrentSummaryIndex); if M = 0 then 0 else ((M-N)/M)*100 Please help, your advice will be greatly appreciated Ann

crystal 11 and 2008. odbc I have a policy table data layout as following policy premium coverage pol1 300 dwelling pol1 100 content pol1 100 liability What sql I can use in addcommand to inverse the data from vertical to horizontal policy dwelling content liability pol1 300 100...

should be balnk in record selection since this is my first step to do in crystal, instead of using tables, I use add command so it will create a customized table. My problem is that someone wrote the query in oracle program, I need edit the query into sql to run in crystal - add demand, but I...

cr 11, oracle I would like to use the following oracle query to add demand to reports in crystal. There are some errors, Since I don't have have much SQL knowledge, I hope your expert can help me. Please let me know how to correct the query so I can run the sql in the crystal- add demand...

Thanks for your help!!! Your guys are great! Ann

CR11, oracle I have a field shown as below Annual Premium = $1,093.00<BR>(Quote Number: QUHO328025)<BR>(Company: ABC company) How can I split this field into just QUHO328022 only Thanks ANN

Thanks LB for your advice, This works perfect!!!

Thank lbass and dgillz for your replies. I have two groups in the report. If I place group number in group one, that is where I need it, it shows off orders as 1, 5 , 6 instead of 1 , 2, 3 , I guess that is due to group two in the report. How shall I do? Thanks again!!

CR 11, oracle, I have a report was grouped by agent and sorted by Top N production for the group. How can I show rankings (N) in the report, (fist place, 2nd place..)? Thank you for your help Ann

Thank you fsreport for your reply, The address type : string 255 currently address 101 maple street, #211 is in one filed. I need seperate it into 3 fields into street number street name appartment number How can I do that? Thankss

CR11, Oracle I have to split address fields such as 101 maple street #211 or 202 wall ave. Apt 209...into street number, street name and apt number separately, How can I do that? thank you for your help!! Ann

go to section expert, select group header, check new page after

CR11, oracle I have agency activity report that I display agency in group header. Now I need to show all agent numbers under each agency horizontally under agency group header. after that I have agency activity summary. How can I show all agent numbers under agency groupheader horizontally...

CR 11, oracle I have a agency production reports that cover over 3000 agency activity that month. Does crystal report have that option so I can transforn the report into pdf's by agency number then loaded into each agency's inbox Any advice is welcome Ann