Crystal Reports :: Record Selection Formula Editor Error?
May 24, 2010
I'm trying to generate crystal report based on the two dates selected by the user ... the selection formula editor gives me
the error "a string is required" when I want to save and close my formula , can any1 help me whts wrong with my formula shown below ,
{records.entrance_date} >= {?entrance_date} and {records.entrance_date} <= {?entrance_date2}
both ?entrance_date and ?entrance_date2 are of date data type
am using crystal reports and directly exporting it to pdf. I want to filter records based on record selection formula but below mentioned code is not filtering data for particular employee. All records are coming to pdf. I want only selected records based on selection formula.
ReportDocument report = new ReportDocument(); string ReportPath = Server.MapPath("Reports/PayRollReport.rpt").ToString(); report.Load(ReportPath);
in my project iam providing users to send sms acrooss india..in admin panel the admin have a feature to check the usersent sms details on the basis of userid.. when admin selects the userid then corresponding send sms details are details are displaying.. my requirement is generating the crystal report for that table..the users are displaying from one table and sent sms details are displaying detaials from another table.. how to generatye crystal report for that..and how to give formula fields in crystal reports
I'm doing a report that includes blocks of text. The block of text that is inserted into the report is determined using a formula.
I want to indent the first line (similar to writing a letter) of the text. Can anyone let me know how to program this into the formula. I'm looking for something similar to the Bold (<b>), underline (<u>), or hard return (<BR>) codes that are used with HTML format.
(the user selects the sort field from the Dropdown list ddlSort and the sort direction from the Radiobutton list rbSort).
This works fine, the only problem is that this doesn't work for the formula fields, because they are not part of the database. However, since it is possible to set the sort order by the formula field in design time, it should be possible to do this programmatically.
I need to concatenate address string. Is it better to concatenate using the formula field or concatenate in the Sql query itself? which one would be faster?
how can i get and set crystal report formula fields from c# code behind, i use this code, double sum=reportdocument.datadefinision.formulafields[1].text but it get formula text not value
I need to pass some data from text box ( ie dump from textbox ) to crystal report how can ido it using formula field in c# i have textbox1.text="INDIA" how do i display the value from textbox in crystal rpeort using formula field.
I have a typed dataset that is displaying an image using an iBlobFieldObject on a report. I need to use a crystal report formula field to hide the image when the value is null, does anyone know how to do this?
Reports Error when publishing a Website on to the Web Server---- The type initializer for 'CrystalDecisions.Shared.CrystalReportClientScriptManager' threw an exception
I have a web application designed using VS2008 & Crystal Reports for VS2008 (Ver. 10.5.3700). I'm using Framework 2.0 for deployment.
My development system is WinXp and my deployment system is Win2003 Server.
Here is what i have done -
1) Added a Crystal Report to my project "rptReport.rpt"
2) Added a Crystal Report Source (crSource) to my .aspx page.
3) Added Crystal Report Viewer to my page, with crSource as its Report Source.
This works fine when i run it on my development machine. But Gives a "Load Report Failed" error on my deployment machine. This is what i have already tried doing on deployment server:
1) Giving IIS_WPG full control to temp folder.
2) Publishing with "Allow this precompiled site to be updatable." checked/unchecked.
I just have top Balance amout in DB which is 3605241. now I have to display the updated balance After debit or credit. I want to get the Previous Balance amount for addition/subtraction.How can I do it using Formula field?
How to print the particular record to the crystal report. I have a gridview control in webform1, in that gridview I have a link button like salary check, the link button passes the particular empid to the next form and display all the records in the webform2, in the webform2 I am having print button, if I click the print button,all the fields in the webform2 wants to print in the crystal report...
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
I have 2 parameters 1. InvoiceNum: this is array of InvoiceNumbers and 2. CompanyNickName. A single string value Now when I am passing these parameters to report only 1st record is getting displayed and not others. Ideally no. of records should be equal to no. of InvoiceNums e.g. if there are 3 invoice no. it shoudl display all 3 invoices. here is relevant code
private void SetCurrentValuesforParameterField( ArrayList InvoiceNumList) ParameterFields param = new ParameterFields(); ParameterValues vals = new ParameterValues(); ParameterField parameterfield = new ParameterField(); foreach (object submittedValue in InvoiceNumList) ParameterDiscreteValue InvoiceDiscreteVal = new ParameterDiscreteValue(); ParameterValueKind.StringParameter; //ParameterField parameterfield1 = param[1]; parameterfield =new ParameterField(); ParameterValueKind.StringParameter; ParameterDiscreteValue InvoiceDiscreteVal1 = new ParameterDiscreteValue(); new ParameterValues(); // CrystalReportViewer1.ParameterFieldInfo = param; } vals.Add(InvoiceDiscreteVal1); parameterfield.CurrentValues = vals; param.Add(parameterfield); InvoiceDiscreteVal1.Value = CompanyNickName; vals = parameterfield.Name = Parameter_Field_Name1;// 2nd Parameter CompanyNickName parameterfield.ParameterValueType = parameterfield.CurrentValues = vals; param.Add(parameterfield); }// End of Loop InvoiceDiscreteVal.Value = submittedValue.ToString(); vals.Add(InvoiceDiscreteVal); parameterfield.Name = Parameter_Field_Name; //1st Paramt name InvoiceNum parameterfield.ParameterValueType = ParameterDiscreteValue InvoiceDiscreteVal1 new ParameterDiscreteValue(); new ParameterValues(); // CrystalReportViewer1.ParameterFieldInfo = param; } vals.Add(InvoiceDiscreteVal1); parameterfield.CurrentValues = vals; param.Add(parameterfield); InvoiceDiscreteVal1.Value = CompanyNickName; vals = new ParameterValues(); // CrystalReportViewer1.ParameterFieldInfo = param; } vals.Add(InvoiceDiscreteVal1); parameterfield.CurrentValues = vals; param.Add(parameterfield);
I have create crystal report with select * from table name command and designd it but when it is shoiwing i want to show as filterd record that i am using follwing code
OleDbConnection gn = new OleDbConnection(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString.ToString()); protected void Page_Load(object sender, EventArgs e) { PrintReport(); } private void PrintReport()
I have data in 2 rows with 1 booking no each rows have different data. But when trying to view crystal reports shows only top row data.. i want 1st row data should come on 1st page and second row data on 2nd page.
Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off". Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL. ----------------------------------- This error will be display when I am try to show the Crystal Report. Can anybody tell me what Property I have to ser in Windows Server 2008 R2 or in IIS7???
i upload my site on server but there is error in crystal report web.comfig there is error as belowParser Error Message:Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.