Crystal Reports :: Pass TextBox Value To Formula Field?
Feb 26, 2014
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.
(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?
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.
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 have one asp.net application in which i have crystal report binded in aspx page when it load it shows perfect.. i have lot of filed in crystal report in which i have one filed1 i need to show that value in out side of the asp.net textbox ..
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
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?
I am developing we application using Csharp on Visual studio 2008.How can I pass values from Page or GridView to a Crystal Report? For example I want some details on a Default.aspx want to appear on the Crystal report when I click on it. How do I pass theses values from Page to crystal report at Runtime?
I create an ASP.NET Crystal Report Web application using VS.NET 2010. In ASP.NET page, I stored two values in Session state and need to pass them as input parameters to Oracle stored procedure. In Crystal reports 2010 once you connect to a stored-procedure as data source, it automatically creates the parameter fields with Crytal Report Viewer. how I pass values to store procedure at runtime automatically.
2. I like to pass above values to the store procedure with IN parameters named P_CourseNo and P_StudentNo to print out the Crytal Report with Store Procedure as data source.
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 am using the following code to pass parameter from VB to crystal report but getting the error messgae "Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))" while it trying to add the first parameter. This chunk of coding works in another VB perfectly. The only diffferent is the working one takes the parameter to stored procedure where the failed one I added parameter during crystal report design time.
I got the overlap text when display data in Crystal Report columns. How do I set how many character to display to prevent the over lap the character to other column in Crystal Report.
I created a CR which data source is a store procedure. Within the store procedure there is one parameter. How to pass a value to the parameter and display CR on the screen?