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!

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

Recent content by 21128

  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

    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...
  3. 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...
  4. 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...
  5. 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
  6. 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...
  7. 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...
  8. 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.
  9. 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...
  10. 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...
  11. 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
  12. 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?
  13. 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...
  14. 21128

    Query Condition

    Thank You guys Its working fine now i used union

Part and Inventory Search

Back
Top