Search results for query: *

Hi, My company has recently switched from Crystal Reports to Jasper IReports. I'm findng it hard to find a lot of documentation and training manuals for IReports so far. I'm trying to write an if-then-else statement for a field in Ireport that tests for data type. Here is what I am trying...

Hi, I am trying to group my report on the following SQL Expression named %empl ( select max(B.`ResultText`) from TestMainList A, TestResults B where A.`TestID`= B.`TestID` and A.`Description`= 'Employee' and B.`TestDate` = TestResults.`TestDate` ) However, when I run the report, it gives...

I've been trying to figure out a grouping issue in Crystal reports on and off for months now- what I am trying to do is summarize a point total for an employee entered as a test result. There are a number of tests for an asset in this particular database. All have a score of 0 if they are in...

Hi, I am using Crystal Reports 2008 with an Access database. I am trying to add this command to the report. See below: SELECT T1.resulttext, T2.resulttext FROM testresults T1 INNER JOIN testresults T2 ON T1.testdate = T1.testdate WHERE T1.probetype = "Employee" AND T2.probetype = "Test"...

Hi, Does anyone know if there is an option to place a calender in Crystal 11 or 2008? It seems like this would come with the program but I can't find one- I was trying to have a calender view of tests due (from a database date field). Thanks, Jeff

Hi, I have just installed Crystal Reports 10 on a new Windows 7 laptop and the chart expert seems to work differently then on my old XP pc. I didn't install Crystal on the old pc (it's one I used at work). So I'm not sure how it was installed. The problem is that I have a report when...

Hi, I'm not 100% sure this is the right section for this question, but it is a Crystal question. I recently set up a new pc running Windows 7 and I am trying to connect to MS access databases using ODBC/find file DSN. On my old pc (XP) I just went to Data Sources in the control panel and...

I have a field testresults.resulttext in my report that displays either a name or the word "acceptable". I'm trying to count the number of times a name shows up provided at same time there is an acceptable result with it. Example- this would count as 1 for Smith, R but wouldn't count for...

Hi, I have a report that has 2 headers and 2 footers (a&b) and is a maximum of 2 pages. I have it set up so header a and footer a appear on page 1, and header b and footer b on page 2. I need to limit the number of records on the first page to 4 in the details section, and if there is a 5th...

Hi, I'm using Crystal Reports 10 & I'm trying to have my report select results from the testdate field that were taken in the current quarter. Thanks.

Hi, I'm using Crystal Reports 10 and am trying to have an image show up in crystal (details section) that is taken with a PDA and sent to an image hosting site- and then have it available in the report if certain conditions are met. Is there a way to do this is Crystal 10? Thanks!

Hi, I'm trying to chart a result of a formula containing two summaries. I am able to to chart them, but an unable to divide them by date. The formula @data13 is: ((Maximum ({@Data5}, {AssetList.Barcode}))-NthLargest (2, {@Data5}, {AssetList.Barcode}))/ Maximum ({@Data5}...

Hi, I'm trying to organize sub- reports by each 10 records. I have a total of 30 records sorted by a testid field and I want them divided within 3 subreports. Each 10 records has a the same date- example: 1:59:07 for the first 10, 2:20:15 for the second 10 and 3:54:14 for the 3rd 10. I was...

Hi, I have a report in which I have 4 formulas in the details section, and I am trying to add each row in a fifth formula. The issue is 0 values that I want to exclude from the formula. The formulas are a variation of: if {TestMainList.Description} = "Wt 1" then...

Hi, In the chart expert the field I have in the x axis, which is the area.areaname field in some cases has hundreds of data points. I was wondering if there is a way to chart this information using multiple graphs- it is all in the same group, so there is no way to divide it by group. Is...

Maybe there is an easier way to do this, I have a simple formula: Called TotalC that reads: shared numbervar matha - shared numbervar mathb; Matha and mathb are from subreports. I just want to graph this @totalc field in the main report. Of course, @totalc won't show up in the chart expert-...

I'm trying to comfirm if there is indeed no way to do this or if there is a complicated work-around. I have a report that has 11 sub-reports- I have a graph in one of the sub-reports that is based on a shared variable from one of the other sub-reports. Of course, because it is a print time...

Hi, I'm trying to use the replace function to omit the phrase "barcode not scanned" from the testresults.memo field. I'm sure I'm misunderstanding the replace function, but I am using the formula replace({TestResults.Memo},"barcode not scanned", "") and nothing happens. The field sometimes...

Hi, In a my report, I've been able to suppress the subreport based on a specific formula returning false. I also want the group header in the main report to be suppressed when this is the case- I can't seem to make it work... would this be solved by somer kind of variable?

Hi, I'm trying to organize data in Crystal 10 by month without using a crosstab or sub reports. It would look like this: Jan. Feb. Mar. Apr. May Resulttext 17 22 n/a 28 26 This is just an example, and the data would be for all 12 months but...