Field Selection

I'm pretty new to Crystal and I'm stumped at the following issue:

I need to select a sub-set of a dataset. In this case I need to select fields with a status of "Requested", from a list of fields that include "Accepted", "Requested", "Declined". This part is easy, but it gets complicated (for me):

Then I have to use those fields filtered by "Requested" to find, within the last 180 days, if any clients have "Accepted" and/or "Requested" and/or "Declined" (i.e. status = any).

This is a two staged selection process, and I'm fine with the code for the 180 days selection. It almost seems to be a contradiction in that I need to filter by "Requested" in the first intance, and in the second I need to then show returns (for all Status types), but the initial filter means I can not do this.

Another way of looking at it is:

1. I want to select X1 from X(1,2,3,4,5), then
2. I want to use X1 to determine if there have been cases of X(1,2,3,4,5) in the last 6 months.

Any help is muchly appreciated.

Cheers.

Mat.any ideas? I'm desperate.

field missing in Crystal Enterprise

I've got a report that runs from Crystal 10 just fine and the field shows up, but the field is missing when the report is run from Crystal Enterprise. All other fields show up just fine.

Information that may be important or not: I'm retrieving data from a SQL Server 2000 database Previously, I was getting a "failed to create rowset" error and the report wouldn't run at all. I narrowed the problem to the "Solution" field. Once I changed the driver* in the database connection, the report ran but the Solution field didn't show up. It's the longest field in the report and the only field in the report over 255 characters, if that means anything.

*I think I changed it from OLE DB to ODBC, but it could have been the other way around or totally different. Someone who's been here more than 3 weeks talked me through it.

Edit: I've tried Cstr({Solution}) and even Left(Cstr({Solution}), 20)Strangely, removing the Select Distinct Records option fixed it. To solve the resulting duplicate records problem, suppressed every result where the "ticket number" equaled the previous number. I think the report takes longer to run now.

Field accumulation

Hello,

I am building a crystal report for a timeclock program.

Currently I have the report displaying all employee punches and accumlating each punch at the end of the row as follows:

Time In Time Out Status Total
9/15/05 8:00 am 9/15/05 12:00 pm Working 4.00
9/15/05 12:00 am 9/15/05 1:00 pm Lunch 1.00
9/15/05 1:00 am 9/15/05 5:00 pm Working 4.00

At the bottom of the report I want to display the total hours for each status type for the pay period.

Lunch Total Break Total Reg Hours ect...

How can I accumlate the total for these fields? Sorry if this is an amature question, been racking my brain and searching diligently without any useful results.

Any help is greatly appreciated

Thanks,

LarryDo you want to show the total of times?

Faster Printouts In Dotmatrix

Is it possible to format the crystal reports to take faster printouts in dotmatrix, if yes then how?
Thanks
krishnanblrYes, you can get speed of Dos mode printing.

Install a Dot matrix printer driver (Eg.Epson-Ex-1000)
In the report, set font of ALL columns to Roman 12/10 cpi or Sanserif 12/10 cpi or Draft 10 cpi or Draft 12 cpi.

In the printer setup dialog, don't forget to select
Device Options - Print Quality - Draft.
-Madhu :wave:|||Thanks for the reply, i will try and get back on this. thanks again :)

Fast Printing from Crystal report 9.0

Hi,
We have created an application in VB 6, MS ACCESS 2000 and all the reports we created in CRYSTAL REPORT 9.0. Now our customer is complaining that printing speed is very slow. IS there any way to fasten the printing speed of Crystal report ?Instal Generic Printer and adjust the report accordingly. in this case you will not able to print graphics line etc. but printing is very very fast. The printer driver exists in windows. i have also applied this thing in my projects (with crystal 8.0).|||Originally posted by jimman
Hi,
We have created an application in VB 6, MS ACCESS 2000 and all the reports we created in CRYSTAL REPORT 9.0. Now our customer is complaining that printing speed is very slow. IS there any way to fasten the printing speed of Crystal report ?

Hi,

Use Printer support fonts, you can find out the printer icon contains in the front of the font name.|||HI,

I think the best way to achieve fast printing is to print in DOS format; for this u will have to export the report into text file and using Bat file print this report..

try and see..

swapnil