Search results for query: *

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

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, crystal 8.5 thanks in advance for those who help and reply. -------------------------- i have a question regarding about subreport. from subreport, i shared a value called asp which i need to pass it onto main to calculated a asp_gm value. however, no calculation will be done if i...

hi, crystal 8.5 main report date data type: Date subreport date datat type: DateTime i'm having a great trouble in passing date parameters from subreport to main. i have 2 sets of date range parameter created: 1 in main and 1 in subreport. i have both of these reports Parameter Value Type as...

hi, this is similiar on what i've asked before, but this time, it is a set that cause the problems. I need to have this sql as clean as possible in order import to crystal. i cannot do suppress if duplicates function in crystal, because there are many orders and each order has the same set of...

Hi, This is a strange question that i cannot figure out why. I have an if statement where i want to pull all the "NEGATIVE" values to this column, but it doesn't work which i don't know what have i done wrong. I hope all the experts here can help me. CR 8.5 Oracle 8.0 database: ID...

crystal: 8.5 database: oracle 8.0 hi everyone, i'm doing a monthly trend report, but i cannot the date range to work. the problem i'm having is that the data won't show once i have the date range if statement insides a formular. formula: if (cstr({DATE_APPLIED}) >= '1/1/2004' and...

Hi, is it possible for crystal to do pivoting? I want to create a report that will rememeber the data from previous month (this is a monthly trend report). crystal 8.5 month 1/04 2/04 3/04 sum_cost sum_cost sum_cost 3000 40000 50000 3300...

Hi everyone, I hope all of the experts here can help me to resolve this problem. this is somewhat complicated (at least to me), so that's why i'm asking for help and i really hope any of you can help. this is quit urgent too... problems: oracle 8 i have 2 tables that i want to join...

Hi, please HELP!!!!!!!!!! does any of you know how i can add 0 into a Blank field? thank u

Hi to all experts, I have a question regarding about subreport. this is my first time to use subreport Crystal 8.5 Oracle Database Problems: I have created a subreport, however, a strange thing is i go to Edit/Subreport Link. i choose table1(main report) link it to table2 (subreport). The...

hi, i have the same problems again for duplication. is there any way i can resolve it besides outer join? i have 2 tables, but the data got repeated when i put it together and there is only 1 field from both table that has similarity. i'm using oracle 8 as database table 1: cust pn...

Hi, I am having trouble with dymanic values in parameter for Crystal report 8.5. problem: i want to have 3 selections criteria. 1. date 2. region 3. customer the biggest challenging and problem here is region and customer. for example: i have 3 regions: europe, asia, america if the...

hi, this is a little complicated and i will try my best to explain it. i have 6 tables in my sql statement, in which i'm having difficulty to retreive some data from database. database: oracle 8i here are the 6 tables: 1. SO_OP soo 2. SO so 3. Shop_Mat_rev smrs 4. MS ms 5. Pur_req pr 6...

Hi, I always have problems with duplicated/repeated lines. for my sql, i have to join 6 tables to retrieve data. 1st table: so_operation wc ord# parpart# qty fj 10023 ws20004 0 fj 10023 ws20004 0 2nd table: so ord# parpart# qty 10023 ws20004 0 3rd table...

To all experts, hi, i try to use UNION and i can't get the function right. i really really hope i can get help from any of the experts here, please help.. from the sql statement select coj.ord#, coj.part#, coij.coi_part#, coj.line#, coij.coi_line#, coj.redqty, coij.coi_invq from co_join...

Hi, Here is the data: Cust# Invoice# BookQ InvoiceQ 1234 10099 9000 3000 1234 10100 9000 2000 1234 10101 9000 0 from the above data, BookQ repeated 2 times. From my report, I will have to pull out all the invoice # and InvoiceQ, however, there...

hi, this is extremely urgent. in Crystal report, i had a formula where i want to retrieve all the date where count_date field is empty. below is the code i wrote, if {?count_date} = "" then {?count_date} however, it keeps highlight ("") and asking me about date for...

Hi, i really hope i can get help from all of the experts here.. i've looking into this , but doesn't seems to have any luck.. i donno if it is syntax problem.. many many many thanks.. i use Oracle 8.0, debug in TOAD here is my select statement: select ip.LOCATION_NO location_no...

Hi, this is very quick and reallyr eally need help.. i use Multiple Value for Parameter Values, however, it doesn't work till i create an array. Parameter field: House, select "Allow Mulitple Values: discrete values" also, i need to show everything that is not equal to 0 so my...