Category: Crystal reports

Preventing growing fields from overwriting data lower on the report

Problem : On a crystal reports report, you have a field that can gow quite large, and has ‘can grow’ selected. Hower, when growing it overwrites data lower on the report in the section Solution: Crystal reports fields grow without regard to what’s below it in the same section, you need to create a seperate […]

Getting a named day-of-week from a date field

To get a named “day of the week” in your crystal report, do the following: – Create a new formula field, using the editor – Paste the formula below in, replacing with the name of your report field containing the date [“Sunday”, “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, “Saterday”, “Sunday”] [DayOfWeek({<datefield>})]

Creating a PDF from a crystal report at runtime

The code sample below shows how to create a pdf during runtime from any crystal report. This code assumes you already have a valid report ‘myreport’, if you want an example of how to create a report item from code check ‘ — export report to pdf ‘Imports CrystalDecisions.CrystalReports.Engine ‘Imports CrystalDecisions.Shared Dim s_filename As String […]

Binding a string to a textfield on a report at runtime

This sample demonstrates how to display a string in an unbound field on a crystal report. This can be used to display messages which are diffrent depending on runtime parameters during report generation. Private Sub DisplayReport() Dim myreport As ReportDocument Dim freestring As CrystalDecisions.CrystalReports.Engine.TextObject myreport = New ReportDocument myreport.Load() freestring = myreport.ReportDefinition.ReportObjects(“Text1”) freestring.Text = “Your […]