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...
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')}
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.