Search results for query: *

A little background first: I worked for an Healthcare organization that uses a large off the shelf Practice Managment (Scheduling, Patient Registration, Billing) and Electronic Medical Records applications through an Application Service Provider. As part of the product suite, we have a local...

Because the amount of rows per ROW_ID will be unpredicatable (including the maximum number of rows), I was hoping to find a solution that would loop through all of the rows for a given ROW_ID and then concatenate the DX_ID values together. B

Here is the current layout of the table I'm working with: Row_ID Line DX_ID 123 1 a 123 2 b 123 3 c 534 1 a 534 2 b 945 1 a 945 2 b 945 3 c 945 4 d...

Thanks Dave! I also do try to avoid using objects from different databases in the same report as I've seen other problems crop up as a result, but this issue was something that I hadn't seen before. I'm also not finding any documentation from Business Objects outling some of the issues that are...

Greetings: I'm noticing when using two tables in a report, from two different databases on the same SQL Server, that after executing the report and showing the SQL Query, that there is no referrence to the second table even thought there are columns from the seccond table being displayed on the...

Thanks all! After reviewing the SQL Query I found that there wasn't any reference to tableB or the Inner Join that existed between tableA and tableB. When looking at the tables and links within the Database Expert I could see these however. On further review, I noticed where no fields from...

Turkbear, Thanks for the reply. I just modified the report, and removed those additional tables that were LEFT OUTER JOINED to Table A. This report now only includes Table A and Table B which are Inner Joined on the same column as mentioned previously. I'm still getting records from Table A...

smeyer56, After reading your post its still a little unclear to me what your trying to do. It almost sounds like you want a printout of what the report looks like in Design view from within Crystal Reports? You could somewhat accomplish this by taking a print screen of the Report in CR when it...

lbass, Thanks for the reply. I did confirm that matched records from tables A and B are being include in the resultset (along with those records that do not match). I'm not aware of any changes in 9.2 that would cause this. Any other thoughts? Thanks, Brent

Greetings: I have a CR 9.2 that is returning unexpected results. Table A and B are Inner Joined on a common column called CSN. However, when the report executes, it returns records from table A even though there is not a matching record in table B. The report also utilizes several other...

Johnsf: I've seen different behavior between Crystal Reports (CR) and Crystal Enterprise (CE) when Grouping within a report is not able to be pushed down to the server. In my case it was because two different databases were being used in the report, and the report was using a formula as a...

I have a report (CR 9.2) that uses a table that has a DateTime column. My problem is that CR shows (looking at the Type in the Field Explorer) the column as a Date column. If I create a new report using the same table and column is shows it correctly as a DateTime field. I have review the...

Thanks for the suggestions synapsevampire. On further investigation, it appears that the report is having trouble in Crystal Enterprise because it is unable to use Server Side grouping. The report is unable to use Server Side grouping in this case because it's using several different objects...

synapsevampire: Thanks for the reply. I have tried playing around with the different Report Option settings, but still no luck. I have also created several other reports (using different tables) that use the same formula as described above, but in these cases the way CR and CE outputs groups...

Greetings: I having issues with Null Groups showing up when a report is ran within CR(9.2), but not when the report is run in CE(10). The following formula is for a group within the report: if isnull({CLARITY_EPM.PAYOR_NAME}) then "SELF PAY" else {CLARITY_EPM.PAYOR_NAME} When the report is...

I had a similar issue, and what was suggested in a post I found was the following: For the fields that overlap, change the 'Can Grow' property to 'Yes'(in this case confirm that it is checked), and set the 'Maximum Number of lines' value equal to 1. These can both be found on the Common tab of...

Let’s try focusing on your issues one at a time. For the users that are unable to print, can you tell us which print control (ActiveX or Acrobat) they are using when they attempt to print a report?

I'm noticing when exporting reports to PDF from CE10(or Crystal Reports for that matter)that in some cases the formatting of the report gets altered undesirably. For example: 1. Graphics looked distorted 2. Text objects in Group Header sections are formatted correctly in some groups but not in...

EO: With a user that is unable to print: Have them confirm which Print Control is being used for printing. Have the user go to the preferrences page and then click on the Crystal Report Preferrences link. There is a section called "DHTML viewer printing uses the ...". If the option "ActiveX...

EO Are the users using the ActiveX Print Control when they attempt to print the report? From the sounds of it, it might be that they do not have the necessary permissions on their PC to install the Control so they can print the report. I beleive they would need to have atleast Power User...