Recent content by hlmnsbuggy

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

Crystal 2008 I try to follow 2008 crystal report crosstab sample named comparative Income statement to get percent difference between actuals and budget. I had a problem to show the difference with ‘ %’, if I click percent in the toolbar, all actual, budget numbers and percent difference are...

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