Search results for query: *

its working. THANK YOU.

hello all, I am using crystalreports version9.2,oracle 10g. I have to rank the top 10 schools on the total amt they recieved. I have groupname field like school_id,and database field tot_amt. Here, i was put running total on tot_amt on each record reset every group. I need to do ranking on...

i am using oracle 10g. totalsales is the database field.There i was put running total on that field.

hello, I am working on crystalreports 9. i need top 10 countries that had top sales. But groupsort expert option is disabled to use top N .Any otherway.. THANK YOU.

if {?start-date}=date(1900,01,01) then (if month(currentdate)<>1 then {LOAN.GUARANTEE_DATE} >= minimum(yeartodate) and {LOAN.GUARANTEE_DATE} <= maximum(lastfullmonth) else {LOAN.GUARANTEE_DATE} in dateserial(year(currentdate)-1,1,1) to...

hello all, I am using crystalreports9 and oracle 10g. I am little confused with ytd/latyearytd. Below iam giveing all the details,please look on that report run for monthly. parameters: start date, end date groupby: doe_id sortby: tot_amt_ytd database field is: di_amt. reportcolumns...

thanks. but its giving records up to last year march 31 2005, i need up to dec 31 2005.

hello all, I am using crystalreports9 and oracle 10g. I am little confused with ytd/latyearytd. Below iam giveing all the details,please look on that report run for monthly. parameters: start date, end date groupby: doe_id sortby: tot_amt_ytd database field is: di_amt. reportcolumns...

thanks its working .

if put above formula in pageheader suppression, iam not getting pageheader in any page.

hello all, iam using crystal9,oracle 10g. i have a problem with pagebreak. i have textbox in groupfooter2b, there i need a pagebreak. i have choosen newpageafter in section expert at groupfooter2b, iam getting pagebreak but problem is that in next page iamgetting pageheader also. i have to...

thank you..

hello all, how to suppress a duplicate rows in a report.

GroupName ({@student name}) = previous(GroupName ({@student name})) i was placed this in pageheader suppression its giveing error like, this field as no previous or next value.

group2 field is formula field. its giveing error like, this field as no previous or next value.

hello all, iam using crystalreports 9,oracle 10g. i have my report as following, report header pageheader groupheader1 groupheader2 details group footer1 group footer2a group frooter2b report footer pagefooter i have a textobject in groupfooter2b there i need a page break to display...

user wants to select data from parameters. so these are must.

but i need lastyear records also.

but, when i use this formula in selection formula its giveing below sql querry. SELECT "LOAN"."LOAN_TYPE_CODE", "DISBURSEMENTS"."DISB_AMOUNT", "DOE_INSTITUTION_1"."INSTITUTION_ID", "DOE_INSTITUTION_1"."NAME", "LOAN"."GUARANTEE_DATE" FROM "EPIC_USER"."LOAN" "LOAN"...

above formula giveing error message , when i was put running total "the remaing text does not appear to be a part of formula