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 eastwestk

  1. eastwestk

    Crystal Reports 2011 is not displaying all images stored in BLOB field

    Hello All, I have images (jpg, gif) stored in a sql server 2014 database in a database field of datatype Image. And I am using this field (BLOB field) in my crystal report 2011 detail section inorder to display images. The problem with my crystal report is, it's displaying some gif images...
  2. eastwestk

    Split String Help

    Thank you Ibass
  3. eastwestk

    Split String Help

    {CALL "xyz"."dbo"."storedprocedurename";1('Product 1,Product 2')}
  4. eastwestk

    Split String Help

    join({?testparam - Productname},"','")
  5. eastwestk

    Split String Help

    I just tried, it worked if I select single value but did not worked with multiple values selection. when I say show sql query for subreport I see the following: {CALL "xyz"."dbo"."storedprocedurename";1('Product 1 '',''Product 2')}
  6. eastwestk

    Split String Help

    In crystal reports XI R2 go to Database menu and click Show SQL Query, you will see the following statement. {CALL "xyz"."dbo"."storedprocedurename";1('Product 1')}
  7. eastwestk

    Passing single/multiple values to stored proc parameter from crystal

    I tried below solution posted on sap forum to pass either a single value or multi-value to a sql server stored procedure parameter (varchar datatype) from crystal report XI R2. In my crystal report , I am displaying all the available parameter values to the user and the user will select...
  8. eastwestk

    Split String Help

    I am displaying all the available parameter values to the user in the crystal report and the user will select either a single value or multi value as below. Single Value Product 1 Multiple Value Product 1 Product 2
  9. eastwestk

    Split String Help

    I just tried & it didn't work, when I say show sql query in subreport I see the following: For multiple values: {CALL "xyz"."dbo"."storedprocedurename";1('(''Product 1 '',''Product 2'')')} For single value: {CALL "xyz"."dbo"."storedprocedurename";1('(''Product 1 '')')} where as it should be...
  10. eastwestk

    Split String Help

    I forgot to mention that I have a subreport. I linked the below Join formula in the main report to the stored procedure parameter in the subreport, inorder to pass a multi-value parameter to the stored procedure. //Formula: @JoinFormula Join({?testparam - Productname},",") Will your suggestion...
  11. eastwestk

    Split String Help

    I have a join formula as below in my crystal report ( the parameter is multi-value parameter). Join({?testparam - Productname},",") which will return the result as follows 'Product 1,Product 2,Product 3' But I want the result as follows 'Product 1','Product 2','Product 3' Please advise.
  12. eastwestk

    Help with Dynamic & Cascading prompts

    Hello Everyone, I have a crystal report which is using the sql server stored procedure as a datasource. In the stored procedure I have 3 parameters,One of the parameter is called @Country. When I try to make this @Country parameter dynamic I am getting the error as Fail to get values...
  13. eastwestk

    Help with Images

    Hello Everyone, I have a report in which I am displaying images side by side (formatted with multiple columns) in the detail section. Is it possible to preserve the correct height/width ratio of the images? They appear to be stretched to fit a specific size. Is it possible without the...
  14. eastwestk

    Help with Column holding text in a diff. language

    Hi Everyone, I have a column called "Title" which holds the translation of title in different languages. When I am placing this column in the "Group Header" section I see only little empty square boxes, I don't see the translated title. I am using Crystal Reports XI R2. Any suggestion how to...

Part and Inventory Search

Back
Top