Search results for query: *

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

Thank you Ibass

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

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

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')}

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')}

Product 1

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

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

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

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

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.

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

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

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

I have tried using 5 inches width and .5 gap and it created 2 columns and the images are displaying perfectly side by side but in "Detail a" section I have a field called "comments" which is holding a big paragraph of text and the text is getting truncated. Please suggest how to fix this.

When I am placing the blob field in "Detail b" section, it's not displaying the images side by side(when an employee has more than 1 image) but instead it's displaying one after another. Any help will be greatly appreciated. Thanks

Hi Everyone, I have to design a report to display the employee details in a "detail a" section such as employee id, employee name etc., Also I would like to display the image(which exist in a database table as a blob field) in a "detail b" section. An employee can have 0,1 or 2 images...

Hello Everyone, I have been asked to create report standards for crystal reports XI R2. If anybody can provide me the report standards will be greatly appreciated. Please help. Thank You!

I created a new report anyway thanks for your help.