Crystal Report to Notepad

Abdu Rafeeq

I have a report of crystal report.

Crystal report printing very slow.

So i convert my crystal report to note pad, it converted but converted document not understand, taht document in given below

"{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Arial;}}{\colortbl;\red0\green0\blue0;}{\info{\title }{\author Crystal Reports}{\doccomm Powered By Crystal}{\company Crystal Decisions}}
\paperw12240\paperh16560\margl180\margr228\margt240\margb240\gutter0\windowctrl\ftnbj\viewkind1\viewscale100\sectd\linex0\sbknone
{\pard \pvpg\phpg\posx180\posy500\absw924\absh-260\ql\vertalt\tx360\tx720{\ltrch\f0 \b0\i0\ul0\strike0\fs19 \cf1 16\_Jul\_11}\par }{\pard \pvpg\phpg\posx1740\posy480\absw1035\absh-260\qr\vertalt\tx360\tx720{\ltrch\f0 \b0\i0\ul0\strike0\fs19 \cf1 \~2.00}\par }{\pard \pvpg\phpg\posx3540\posy480\absw1350\absh-260\ql\vertalt\tx360\tx720\tx1080{\ltrch\f0 \b0\i0\ul0\strike0\fs19 \cf1 VAT}\par }{\pard \pvpg\phpg\posx2340\posy760\absw2565\absh-260\ql\vertalt\tx360\tx720\tx1080\tx1440\tx1800\tx2160\tx2520{\ltrch\f0 \b0\i0\ul0\strike0\fs19 \cf1 VAT}\par }{\pard \pvpg\phpg\posx180\posy16320\absw948\absh-260\qr\vertalt\tx360\tx720{\ltrch\f0 \b0\i0\ul0\strike0\fs19 \cf1 1}\par }\sect }

"

I want a good method

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mahesh Chand15y ago
What you need is get data in a DataTable and use that tad data source for your report. Do not go to database for everything. You should also use DataTable to filter the data.
Vilas Gite15y ago
@ Sam sir,
Yes, 'It is more likely the database processing'
which commands provide to database for report is more important....
for example, if, I try to retrieve all records on report by button click it will takes long time (if huge records in that table). But, i try to retrieve particular record on report it shows quickly.
--------------------------------
Sam Hobbs15y ago
It might not be Crystal Report at all. It is more likely the database processing.
Vilas Gite15y ago
Abdu said that "Crystal report printing very slow" and Mahesh sir comments on that "Printing a crystal report is usually not slow". Therefore, i am finding Is really Crystal Report printing slow or why its become slow? I found some strategies why printing goes slow and how to improving speed for report printing.

http://www.tek-tips.com/viewthread.cfm?qid=1276307&page=1
Vulpes15y ago
Not 100% certain but, if you don't have Word, then windows probably will open an .rtf file with WordPad by default.

When I right click on an .rtf file on my Windows 7 machine, WordPad does show up as an option (along with Word) in the 'Open with' menu item.
Sam Hobbs15y ago
I am not sure that Wordpad supports all features of RTF but if it does then I hope it would be associated with the RTF extension if nothing else in the system can show RTF files. I am assuming that the rtf extension is associated with something in the system.
Mahesh Chand15y ago
Printing a crystal report is usually not slow. Wonder if the problem is somewhere else in your code.
Vulpes15y ago
WordPad can also read RTF files.
Sam Hobbs15y ago
Notepad is a program; there is no such thing as a Notepad format. So I don't know what you used to convert the data.

The data that you show is RTF; see the "rtf1" at the beginning? If you rename the file and use ".rtf" for the extension, then if you open the file, it will open using an application that will show the report. You can use Word to open a RTF file.

Poor performance probably cannot be fixed by changing the output format. It is much more likely that your query is not efficient.