Search results for query: *

I have created a formula called @TemplateFileName with the following codes ------------------------------------------------------ WhileReadingRecords dim pos as number dim pos2 as number pos = InStrRev(Filename,"\") if (pos = -1)then pos2 = -1 elseif (pos > 0) then pos2 =...

I have created a static parameter called {?Account}in command line. In query i have a condition where it checks users.account_number = {?Account} In this case while i run the report, for example if i enter the parameter value to be 1000 it gives me the correct data. It works fine for one value...

Joining 3 different tables i have the following result in CR Name ID Status s_date e_date branch bill pay Dell 1 Pending 12/19/2011 12/31/2011 2 62 40 Dell 2 Search 12/19/2011 12/31/2011 2 46 30 Dell 3 Search...

I want to group the report based on company_id. If company_id equals to 1 or 2 or 3 then the group will be called A If company_id is not equal to 1 or 2 or 3 then the group will be called B How do i create a third one which includes entire company_id which might be called C My code is if...

I get an error message below when i try to run the report. Can anyone please guide me how do i fix it? thanks. Server Error in '/eSOMS Reports' Application. ------------------------------------------------------------ Missing prompting unit. Description: An unhandled exception occurred...

I get an error message below when i try to run the report. How do i fix it? thanks. Server Error in '/eSOMS Reports' Application. ------------------------------------------------------------ Missing prompting unit. Description: An unhandled exception occurred during the execution of the...

Below is my XML Schema to pass parameter for Crystal Report. I am wondering if i could give a condition to change Texts inside the <Prompt> </Prompt>. In my case if {?Log_ID}=33 then <Prompt>Include Unit 1 [ Default : Yes ]</Prompt> but if {?Log_ID}=41then <Prompt>Unit Not in this...

I have a parameter named {?EndDate} when i run the report i want it to set it the current date as its default value, so that the value of {?EndDate} will be the day that report is run. Is it possible?

I am using Crystal Reports XI, Oracle 10g and Esoms as the application to view Crystal Reports. I used the below xml file to pass parameter fields. It works perfect but when the parameter box pops up to select date, it is blank. I can click Ok to proceed without the data entered and it gets the...

I have a condition in my query Select ......... from log_entries where UPPER( '{?IncludeStatus}') = UPPER('Yes') and log_id = CASE {?Log_ID} WHEN 6 THEN 25 WHEN 31 THEN 33 WHEN 27 THEN 29 WHEN 39 THEN 41 WHEN 35 THEN 37 ELSE -1 END If the user selects {?IncludeStatus}=Yes and enters...

the date parameter i had created for the crystal report is static. Does Business Object Infoview accept static parameter? If no then how to change the static to dynamic?

the date parameter i had created for the crystal report is static. Does Business Object Infoview accept static parameter? If no then how to change the static to dynamic?

I created this query to get the entry of previous days, last time they entered. i dont know why but it gives me blank. can anyone please help? select max(decode(sta,2,rd,null)) "MW_Previous", max(decode(sta,5,rd,null)) "MV_Previous", max(decode(sta,8,rd,null)) "P2300-3 Previous"...

the query looks like this select max(DECODE(STA,2,RD,NULL)) "MW_Previous", max(DECODE(STA,5,RD,NULL)) "MV_Previous", max(DECODE(STA,8,RD,NULL)) "P2300-3 Previous", max(DECODE(STA,11,RD,NULL)) "P2300-4 Previous" from history where tour=18 and dt={?SelectDate}-1 and shift_no=(select max(shift_no)...

THIS IS MY QUERY SELECT max(rev_no), max(tour), max(DT), max(SHIFT_NO), max(DECODE(STA,1,RD,NULL)) "MW PR", max(DECODE(STA,2,RD,NULL)) "MW", max(DECODE(STA,3,RD,NULL)) "MW D", max(DECODE(STA,4,RD,NULL)) "MV PR", max(DECODE(STA,5,RD,NULL)) "MV", max(DECODE(STA,6,RD,NULL)) "MV D"...

My query looks like this (SELECT max(rev_no), max(tour), max(DT), max(SHIFT_NO), max(DECODE(STA,1,RD,NULL)) "MW PR", max(DECODE(STA,2,RD,NULL)) "MW", max(DECODE(STA,3,RD,NULL)) "MW D", max(DECODE(STA,4,RD,NULL)) "MV PR", max(DECODE(STA,5,RD,NULL)) "MV", max(DECODE(STA,6,RD,NULL)) "MV D"...

I have a output like this Selected Date 8/20/2009 shift MW MWD MV MVD 11 769 390 12 780 11 385 5 13 785 5 395 10 ----------------------------------- 16 15 how can i create a formula so that for next...

this is my query SELECT max(rev_no), max(tour), max(DT), max(SHIFT_NO), max(DECODE(STA,1,RD,NULL)) "MW PR", max(DECODE(STA,2,RD,NULL)) "MW", max(DECODE(STA,3,RD,NULL)) "MW D", max(DECODE(STA,10,RD,NULL)) "P2300-4 PR", max(DECODE(STA,11,RD,NULL)) "P2300-4", max(DECODE(STA,12,RD,NULL)) "P2300-4...

this is my query SELECT max(rev_no), max(tour), max(DT), max(SHIFT_NO), max(DECODE(STA,1,RD,NULL)) "MW PR", max(DECODE(STA,2,RD,NULL)) "MW", max(DECODE(STA,3,RD,NULL)) "MW D", max(DECODE(STA,10,RD,NULL)) "P2300-4 PR", max(DECODE(STA,11,RD,NULL)) "P2300-4", max(DECODE(STA,12,RD,NULL)) "P2300-4...

hi guys, I am new in crystal report developer. I am using crystal report xi and oracle 10g. The query i have created gives an error Error starting at line 1 in command: Select h.tour, h.rev_no, h.sta, h.shift_no, h.user_ID, h.rd, h.notes, (select h2.rd from history h2 where h2.sta = 1 and...