Showing posts with label requirement. Show all posts
Showing posts with label requirement. Show all posts

Thursday, March 22, 2012

Crystal reports and page breaks

I have a requirement from our users that they want to add page breaks into the middle of a text field in our application.

This text is being printed in a Crystal report, so they would have the facility then to split text over 1 or more pages without coding needed to be done.

Is it possible to type in (use of varous keys e.g. Ctrl + Shift + A) a special character in the text field which Crystal Reports will process as a new page?

Any assistance would be gratefully received.you can use chr(13). Create new formula having this code

left({field},100)+chr(13)+mid({field},101,len({Feidl})

and set can grow propery to true

Sunday, March 11, 2012

Crystal report printing to 2 different printers using IP address

Hi ,

I using vb6 and crystal report 5.0 version.
There is a requirement to print reports to two different locations (diff.countries) . If I have the printer machine's IP address instead of Printer name , is it possible to print reports based on the IP address to the resp. printers ? Crystal reports -> printer setup menu will accept only printer name and not printer IP address. Crystal help is not having any clue about this.

It will be of great help if you can throw some light on this.

Thanking you in advance,
Deepa.I use CR Version 8.5.

In my VB code, I loop through the Printers object to get the name of the printer I want and then pass the required info back to Crystal (Printer Name, Port, and DriverName). I don't know if it's possible, but perhaps you can loop through the printer collection and compare it to the IP address to get the right printer?

Dim prt As Printer

For Each prt In Printers

If prt.DeviceName = strPrinterName Then 'You would compare to IP address instead

Set Printer = prt

strDeviceName = prt.DeviceName
strDriverName = prt.DriverName
strPort = prt.Port

Exit For

End If
Next prt

Set prt = Nothing

Report.SelectPrinter strDriverName, strDeviceName, strPort

Report.PrintOut False|||Thank you for your response !!

Tried your code and found that this code piece will work if the specified printer is installed in the local machine.But in my case the application will be provided with a Printer IP address alone.Meaning if we go to Control Panel -> Printers option , there will not be any printer installed.Hence the Problem!

Thanks and Regards,
Deepa.|||I'm sorry I can't be of anymore help, but if you find the solution, will you post it?|||I am trying out some options as of now .Once I get the best way , I will post it here.

Thnaks a lot
Deepa.