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

Its Crystal Reports XI R2

Yes i am talking about the SQL Query Command line. I first created the parameter in command prompt itself and later edited it to allow multiple values box as well. With that if i select a single account it works fine but if i select multiple account then it gives an error saying failed to...

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

Sorry i have the following code: if {sl_companies.company_id} in [1, 2, 3] then "A" ELSE IF NOT({sl_companies.company_id} in [1, 2, 3]) THEN "B" ELSE "C

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

Yes, the report works fine in Crystal reports but when i pass parameters via XML, it accepts the parameters but end up with that error.

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

hi LB Thank you for your response. It works perfect. What if i have a parameter {?StartDate} and i want it to set it as default i.e {?EndDate}-1 or a day before CurrentDate? How the Selection Formula looks like? Thankx

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

Thank You guys Its working fine now i used union

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?

what i am trying to do is, i need the last value entered on selected date. what i did was check for 1 day before and if there is value entered it gives me the rd value of last shift_no. There is a case where there might not be any rd value for 1 day before the selected date, meaning that no data...

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