Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: 21128
  • Order by date
  1. 21128

    Crystal Reports File Path

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

    Parameter with multiple values in command line

    Its Crystal Reports XI R2
  3. 21128

    Parameter with multiple values in command line

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

    Parameter with multiple values in command line

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

    Find common rows

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

    Crystal Reports Grouping Problem

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

    Crystal Reports Grouping Problem

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

    Server Error

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

    Server Error

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

    Server 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...
    • 21128
    • Thread
    • Replies: 3
    • Forum: XML
  11. 21128

    condition in xml schema

    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...
    • 21128
    • Thread
    • Replies: 0
    • Forum: XML
  12. 21128

    currentdate as default parameter

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

    currentdate as default parameter

    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?
  14. 21128

    Default Value for Parameter Field

    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...
    • 21128
    • Thread
    • Replies: 1
    • Forum: XML
  15. 21128

    Query Condition

    Thank You guys Its working fine now i used union
  16. 21128

    Query Condition

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

    parameter

    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?
  18. 21128

    parameters

    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?
  19. 21128

    query help!!!

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

    query help.........

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

Part and Inventory Search

Back
Top