Search results for query: *

For receipt reports (Epson TM-T88IV printer, for example), to get the printer to cut each page, from Crystal Reports go to FILE PRINT PREFERENCES OPERATION END OF PAGE (or wherever you want it to cut) Check the box that says Feed to cut position before cut and put the slider to partial cut.

My question (thread766-1375984 ) did not get resolved via posting, but I did eventually find the answer. This is the SQL code that casts a BLOB field to printable text: UTL_RAW.CAST_TO_VARCHAR2("MEMOS"."THEMEMO") Thought someone might find this useful.

Paper cutting is totally separate from a new page. Thanks very much for your reply, but I did stumble upon an answer. I was trying to use printer commands for the POS printer via a formula field, but it wasn't necessary. It turns out that Crystal XI has it's own printer preference area that...

I need to print a Crystal Report XI to an Epson POS printer. The report is complete, and it prints well, but I need to be able to force the paper to cut after each record is complete. I have been told that I need to create a formula field and place it in the report footer. I found code...

In a Crystal XI report, I need to use tables from two data sources. When I bring in the second source with an external join, I lose the ability to select distinct records. Is there any way to do this?

Thanks. That was the problem. I meant to check this way back when the subreport was being developed and totally forgot about it. Sometimes you can't see the forest for the trees.

I have this exact problem. I have start and end dates in my main report and start and end dates in my sub report with the user having to enter two sets of dates in the parameters. I've gotten to the change links screen, chosen the start date from my main report, unchecked the "select data...

I appreciate all you time. Thanks so much.

Yes. I cut and pasted the code from PL/SQL to Crystal Add Command.

Thanks for the instructions about Add Command. That will undoubtedly be useful. I don't see any difference in Crystal's SQL. In Add Command, I used SELECT NOTES FROM GSP_BOOKING_LOG Crystal's SQL refers to it as SELECT "GSP_BOOKING_LOG"."NOTES" FROM "GSP_BOOKING_LOG" ... and I couldn't...

I did throw the SQL query from my Crystal Report into PL/SQL Developer and the BLOB field shows up, but it just has <BLOB> for data with a small button on the right that, if pressed, gives you the data. You lost me on the Add Command. Sorry.

I verified that the data was present with PL/SQL tool. I can see it using a simple query. I'm working with a Concept database and they identify the field as a BLOB. Crystal shows it as a Picture type. Connectivity is an Oracle Server.

I am working with an Oracle database that contains a BLOB with text only data. When I insert this field into a Crystal Reports XI report, the data does not show up. I am sure the text is there. Attempts to convert the BLOB to text by creating a formula field (To_Text({GSP_BOOKING.NOTES}) give...

I'm having the same problem in Crystal XI and haven't been able to find a solution. If you figure it out, would you please let me know?