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

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

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!

Hi Everyone, Please let me know how to uncheck "Format with Multiple columns" under common tab of Details section for an existing crystal reports. This is a mailing label report which was originally designed in older version, I guess ver 10 or 9. I converted this report to XI R2. Any...

Hello Everyone, In my crystal report XI R2, I want as follows: For June 14th thru June 20th (Mon thru Sun) - I would like to display "Release Number 100" in the page header of crystal report For June 21st thru June 27th (Mon thru Sun) - I would like to display "Release Number 101" in the page...

Hello Everyone, I hava crystal report XI with a country field. I would like to group the report based on country field as follows: Group Name ------------------ 1. United States (which should include records from Peurtorico also) 2. Canada 3. Mexico 4. Others(I want to name this group as...

Hello, I am connecting to SQL Server 2008 through ODBC from Crystal Reports 11.5 and I am using the below driver: SQL Server 2000.86.3959.00 But from crystal reports I don't see tables and views. Any suggestion is greatly appreciated. Thank You

Hello, I have the following code in my stored procedure: [CTTitle] =(SELECT TOP 1 TITLE FROM mms.dbo.vwcommitteetermmembers WHERE ID = (SELECT pl.PresID FROM #PresidentList pl WHERE pl.ClubCTID = (SELECT TOP 1 ID FROM mms.dbo.vwcommitteeterms ct WHERE ct.lccompanyid = d.donorcompanyId))...

Hello, I have a report with 3 parameters such as startdate, enddate and country When the user set the startdate and enddate as null and entering only country then I want to display the startdate and enddate as yesterday's date and for this I created a formula as follows and if enddate is null...

Hi Everyone, I have a crystal report gouped on a number field designed in Crystal reports XI R2. I published the report to Infoview (Business Objects Enterprise) and in Infoview I see commas in the grouped field in group tree. And in Crystal Designer I don't see any commas in group tree...

Hello, I want to add a componoy logo in 6 different reports. I want to know how I can add the logo to crystal repository and from repository how I can add to different reports. Also I want to know If after a month company wants to replace the old logo with the new one then I think I...

Hello All, Below is the SQL for getting the President Name when (Rank is 700) But also I want: 1. If there is no President then get the Secretary Name(Rank is 710) 2. If there is no Secretary then get the Treasure Name (Rank is 720) And ctm1.Member is of nvarchar datatype &...