Search results for query: *

PLEASE PLEASE PLEAES HELP FOR THOSE WHO KNOW.. PLEASE.. this is quit IMPORTANT for me.. thakn u thank u thank u

sorry that i didn't make this clarify. what if i only want to show the page header? i don't want to show all headers, but i only want to show the page header. thank you for your help. It will be great if you have any ideas i can show page header on every drill down. thank you m

HI, Question how to enforce column headers whenever click to see the details level? software CR 8.5 database: oracle 8 problem i hide the details section on my report. the users will double click on the line, then it will get the specific lines that he/she wants to see. therefore, he/she...

am i goning to add a section below group header section for order_no for the {@accum}? i tried it, but it doesn't work. it seems like it is pulling out {cur_wip} and accumulated it, but it didn't take the sum of received_val + sum({cur_wip},{ord_no}). do you have any idea as to why this...

did you check the "break by page"? selection when you rt. click on the section which you put your stated?

but i have 2 questions: 1. why do you use whileprintingrecords? 2. how can i do grand total for a formular? i created the formular as {@total_cost}, which i try to do sum({@total_cost}) for the grand total, but it doesn't allow me to. it pops up warning sign that said, "summary/running...

hi lbass and synapsevampire, the formular that i used is very simple, which i have wrote it earlier: for {@total_cost} shared numbervar received_val; received_val + {cur_wip} i placed the formular under subreport, Group Footer 1B, which i placed my subreport in the grp section: Group Footer...

thanks synapsevampire , i hope this will understand better.. i have a main report and a subreport. for the subreport, i want to get {received_val}. in the main report, i have a valuable called, {cur_wip}. i need to calculate total_cost by adding those 2 together {received_val}+{cur_wip}...

Hi, i have trouble doing calculation when parameter passed from subreport to main report. version: crystal 8.5 database: oracle 8.0 main grp footer OrderNo_1a: cur_wip received_val_subreport grp footer OrderNo_1b: total_cost subreport grp footer OrderNo_1a...

hi lbass, thanks for all ur reply and help. i figure the table out as the steps you show me was right, but i mess up the set up of the tables. I should have customer part driven sales part, thus, i can get all the variable in customer parts. sorry for all the mess and confusion i've made...

when i convert to date, i use to_char({tablename},'YYYYMMDD') i hope this help... m

hi lbass, i have question about linkage problem. if i linked main_partno to sub_partno, isn' it true that will create 1-1 issue?? my question is i want to list *ALL* the parts in customer_order(sub).. let say: main partNO: 1,2,3,4,5 sub partNO: 1,2,3,4,5,6,7,8,9 if i linked by their...

quick question. isn't it true left join mean the (+) should place on the left?

hi lbass, thanks for your reply.. i have a question (actually it happens couple times when i do report). I do the LEFT JOIN as you have suggested, which my sql look like this: from PART_COSTpcbh, SALES_PART sp, shop_ord so, customer_order coj where sp.PART_NO = pcbh.PART_NO and sp.PART_NO =...

i'm not sure about break on that nadeau26 suggested, but i used decode for repeated value. sometimes it's useful *IF* not many fields is selected or don't have much decode. Otherwise, the sql statement will run slow. select a_addID, cc_custCode, decode(col1,1,c_custID,'') custID from( select...

hi lbass, i'm sorry to get you all confused as you are trying to help me. -------------------------------------- sql: shop order select sp.partno, sp.std, so.closed_date from shop_order so, sales_part sp, part_cost pc where sp.partno(+) = pcbh.partnoand pcbh.partno= so.partno customer...

hi lbass, i think i know the problems. i shouldn't have {sub_sp_partno} = {main_sp_partno}, because i already have sp_partno = so_partno and sp_partno = co_partno. i'm sooo stupid after all these mess i've created, but your reply give me the clue of what i've done wrong. however, my...

oh mine.. u r the greatest of alllllllllllllllllllllllllllll.. i've been trying to figure this out for 4 days 'coz i was working for an sql for it.. thank u thank u... u r my saver.. thank u

hi lbass, thanks for your response, you help me to think through something that i haven't really thought of and i hope you can help me as well. i was looking through my report and code closely, which i find something that i hope it makes sense; i believe this is the cause of my report. i list...

what do u mean by create unique index? what if you have a group of 4 got repeated itself for twice, how can you created a unique index? if so, will this index affected the original table in the database? m