code error

Asked by taylor on 3/10/2010 11:41:14 AM

Im new to crystal reports and Im getting an error this field name is unknown... how do I fix this im really lost right now or can you at least point me to some sort of tutorial on crystal reports so i can at least fix this issue and save my job help any one out there


Comment (1)

How can I hide the white spaces when suppressing columns?

Asked by Lara on 3/26/2009 5:17:04 AM

I want to conditionally display columns by adding a formula to suppress when a condition is met. This works fine, except now there are big white spaces between the columns. How can I get rid of those? I’ve tried adding a stylesheet, when the condition is met, set the width to 0px, but that doesn’t work either. Please help??? Thanx in advance:)


Comment (0)

cannot open sqlserver

Asked by murali on 1/29/2009 12:09:16 AM

With form_Adequacy.Report
.WindowState = crptMaximized
.WindowBorderStyle = crptFixedSingle
.WindowTitle = "CRC Monitoring Report"
.DataFiles(0) = App.Path & "Database.mdb"
.ReportFileName = App.Path & "ReportsREPORT2.rpt"
.SelectionFormula = cond
.Action = 1
.PageZoom (100)
End With

**** after passing the parameters, in line .action=1 the error is Cannot Open SQL Server, and it says that [property is write-only]


Comment (0)

How to compare and equate date field in crystal reports

Asked by Rinku on 10/25/2008 12:51:18 AM

I am trying to write a formula in crystal reports where i need to compare a date parameter with a date but keep geting an error message that reads - " A Date is Expected here ". I am stuck and cant get around the problem. Can anyone suggest how to compare two date values or a Date parameter to a date value in crystal report Formula editor.


Comment (0)

what is the role of simplify page header during cystal report export to Microsoft Excel

Asked by Rinku on 10/17/2008 7:42:10 PM

I am trying to export my crystal report file to Microsoft excel format with data only option.

There is a checkbox saying " Simplify Page Headers " which is selected by default. If i dont uncheck the option my excel output appears distorted. sometimes some headers are missing and sometimes some row data is missing. I dont understand why this is happening. Can anybody explain this.


Comment (0)

How can i use 'Can Grow' option with a number frield in crystal report

Asked by Rinku on 10/17/2008 7:35:17 PM

I am designing a report which has many fields to be displayed. Due to this my fields are overlapping if presented on a single line. I used the " Can Grow " option in the format options and was able to grow the text boxes to multiple lines. However some reference numbers that i use on the report are too long and i want them to be displayed on multiole lines so that i can arrange all the fields in one line. Crystal reports is not showing me " Can grow " option when i right click on number field. Does anyone know how to get around this problem.


Comment (1)

How to create dynamic columns in crystal reports

Asked by Rinku on 9/21/2008 11:30:48 AM

I am having a requirement where i do not know in advance how many columns will appear on my report. I want to create dynamic columns which will appear on the report depending on conditions at run time. Can someone tell me how to design reports where the number of columns are not fixed and i can increase the number of colums printed on report depending on user data at run time.


Comment (1)

Which is better or faster for crystal report performance - SQL commands or stored procedures ?

Asked by Rinku on 9/21/2008 11:17:53 AM

I am a new crystal report developer. While developing reports sometimes i create stored procedures and build reports on it and sometimes i write SQL commands. However i am not sure which one of them gives better performance or faster performance for the reports.


Comment (0)

Where to use hide and supress in crystal reports

Asked by Rinku on 9/21/2008 11:12:28 AM

I am confused between the hide and supress options. As i do not need drilldown often which is the only difference i know between the hide and supress options in crystal reports.

Can someone tell me what are the differences between the hide and supress options in crystal reports and advise on where to use hide and where to use supress.


Comment (0)

How to Interpret or understand report performance information in crystal reports

Asked by Rinku on 9/21/2008 11:01:02 AM

Crystal reports provides facility for viewing report performance. I am not able to interpret the meaning of the performance indicators which i need to improve the performance of some of the reports that i created. what are the most important indicators of performance for crystal reports.


Comment (0)