Search results for query: *

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

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

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

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

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

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

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

CR 11 I have to type the following formula in display string WhilePrintingRecords; global numbervar a; a:=CurrentFieldValue; totext(a) Now it reurens number with decimals. How can I return numbers without decimals? Thanks for your help in advance! Ann

CR 11 oracle I have static parameter to allow users to pick from a list. My problem is that I only get part of listed data. eg 100 of 300. Does anybody know how to fix the problem. Thanks!! Ann

CR11, oracle I have main report spread over 3000 pages by agent numbers. I added two subreports over agent number group header. the report start accessing database, reading subreport records every time I click next page. Is this normal due to subreport? is subreport only useful for a few...

CR 11, Oracle data I found an excellent sample for showing quarterly growth in cross tab. I ran into probelems to modify this code to make yearly? I got error message 'subscript must be between 1 and size of array.' Where can I find to fix that. please be detailed since I am a begineer at this...

CR11 Does crystal report have option to set report for read only so others can't change the report? Please advice Thanks!

CR11, oracle I have a simple report that contains a formula field but I can't insert summary to report footer. The detail in the report is as following, pol# ,effective date,expired date, earned fee I had added two formula field to evaluate fee earned in detail @term is {expired...

CR 11, oracle database I have been searching for solution for yearly percentage change for a crosstab report. I have to come for your expert's help since I am a beginer for this I have a financial crosstab report layout like this Columns: Accounting periods Rows: Summarized...

CR11, Oracle database I have crosstab has been design as following On column field, I put group by periods, on summarized field, I sum amount 2005 2006 Revenue$ revenue$ Expense $ expense$ Now I need to add column to show year growth in this crosstab. By reading previous posts, I need to...