Sitemap

Amicuk Programming Answers

How to change crystal report data field at runtime ?

2015-10-11   Views:8

Advertisement

Hello everyone, I have a Crystal Report file ,which i am using to generate report for my windows form project . In that report i have a filed called as Quantity which data type is set as decimal, the requirement is like that the number of value those

Hello everyone,
I have a Crystal Report file ,which i am using to generate report for my windows form project .
In that report i have a filed called as Quantity which data type is set as decimal, the requirement is like that the number of value those comes after decimal point that should be set according to the value which is given by the user at the run time .
For eg: If user gives 1 at the run time then the report Qty field value set one value after decimal point. Like 12.1
if user gives 2 then Qty field the value is 12.22 like tat  but user can give from zero to any number.. and if it is zero it should not show decimal
Note: The main idea hear is how to change the filed in Crystal Report decimal point value by using code(or we say writing code we need to set manually as user input it will change)
Can any body help me how to solve this issue .
S.K Nayak

The replay answer
Advertisement
I think you could probably make the field you see a formula field and take a parameter as the number of decimal places.
totext converts a number to a string.
totext({decimalField}, 2)
That's 2 decimal places.
You could probably substitute a {parameter} for that 2.
If not then you could substitute an entire formula.
To explore formulas:
foreach (FormulaFieldDefinition f in rpt.DataDefinition.FormulaFields)
MessageBox.Show(f.Name);
// f.Text = your new formula
Where rpt is an instantiated report.
Or add another string field which you display in the column and do the calculation with the original decimal.
Hope that helps.
Recent Technet articles:
Property List Editing;  
Dynamic XAML

Go to See the other 6 answers

How to change crystal report data field at runtime ?

Category:DefaultRelease time:2015-10-11Views:130

Hello everyone, I have a Crystal Report file ,which i am using to generate report for my windows form project . In that report i have a filed called as Quantity which data type is set as decimal, the requirement is like that the number of value those[More]

Setting Crystal Report data source at runtime

Category:DefaultRelease time:-0001-11-30Views:130

In advance, I've read all of the posts on here about dynamically changing the data source for your report at runtime and none of it seems to work. I developed a report against my development database using an MySQL ODBC connection. At runtime I want[More]

Using Crystal Report Data Connection in Xcelcius 2008

Category:DefaultRelease time:2015-10-11Views:130

The documentation does not explain how data to populate row, column and details is passed to SWF. Can some-one please point how CR Data Connection when created in Xcelcius 2008 is used in Crystal Report Design time ? Is it through Flash variables? Ba[More]

Load linkage error - "com/crystaldecisions/sdk/occa/report/data/Fields"

Category:DefaultRelease time:-0001-11-30Views:130

We had installed and were using Crystal Reports for Eclpse with JBoss 4.2.  We recently upgraded to JBoss 5.1  Our crystal reports do not work from the web interface anymore.  The error we get is: Caused by: java.lang.LinkageError: loader constraint[More]

Xcelsius - Crystal Report Data Consumer connection Issues

Category:DefaultRelease time:2015-10-11Views:130

Sorry for the long post but i hope with the full explaination, i can get a quick answer & solution. Using Crystal Reports 2008 and Xcelsius 2008 Engage, SQL 2008 stored procedure. I have tested the Crystal Reports Data Consumer connection within the[More]

SAP Crystal Reports data source connection problem using sap business one

Category:DefaultRelease time:2015-10-11Views:130

Hi, I m facing a problem regarding: SAP Crystal Reports data source connection problem using sap business one I am trying to create a Crystal report but when I try to configure a new connection it does not work. I select Sap Business One data source[More]

Defining multiple Crystal Report Data Consumer connections?

Category:DefaultRelease time:-0001-11-30Views:130

I am creating a Xcelsius object that uses data from Crystal Reports. To do that, I define Crystal Report Data Consumer connection. With this I can use Crystal to connect to the data source, create table of data (crosstab) and pass it to the flash obj[More]

Schedule CR by crystal report data consumer

Category:DefaultRelease time:-0001-11-30Views:130

Hello expert,         I want to embed a xcelsius dashboard into crystal report by crystal report data consumer, but I don't know if I can schedule this mixed crystal report in infoview and send it out by email periodically? because I 've heard there[More]

Crystal Report Formula field function  on OLAP SAP BI/BW Cube

Category:DefaultRelease time:-0001-11-30Views:130

Dear All We create OLAP Cube Report in  Crystal Report 2008 (BO)  base  SAP ( DB2)  BI/BW  Cube, Grid report coming correctly.  Crystal Report Formula Field  functionalities are not avilabel or suporting.  If any one explain or some kind of documenta[More]

Regarding Crystal Reports 2013 SP1/SP3 runtime distribution clafrifications

Category:DefaultRelease time:2015-10-11Views:130

Hi, We are in process of migrating exsisting Crystal Reports from CR 2008 SP4 to CR 2013 SP1/SP3. Iam unable to find the corresponding msms for the same for runtime distribution (to install on end user Boxs). Can see latest as v.13.0.13.1597 (_http:/[More]

Crystal Report Date Prompt  Query from SAP BW

Category:DefaultRelease time:2015-10-11Views:130

Dear Support, Using Crystal Report 2008 and Query is design In SAP BW Date Prompt is made mandatory in Query at Query Designer. Problem:  Requirent is that Date promt shoud take value currentdate-1 when report is excuted first date prompt will show i[More]

Hot
Hi Guru's, We have a problem with end users that have the Bex add-in loaded in Excel 2007 when they are using a different 3rd party add-in.  The problem is when they close Excel, they get password prompted for a password protected VB project in the w [More]
there show up about itunes. it said you cannot authorize more than 5 computers. well i only have 2 computers had broke. so, i bought new imac yestersday. so there said, i am not able to authorize more than 5 computers. so how, i do?Youneed to de-auth [More]
I am using JTable to display a series of simple text strings. Every cell contains the same kind of data; it isn't querying a database or anything like that. The user must be able to delete these cells quickly, so the design of the application is such [More]
I want to Pass Paramaters to an external application when launced from Web dynpro ABAP . I have successfully launched an .exe file ( Notepad / eViewHSEditor ) from Web dynpro using the logic from Standard WD_TEST_APPL_ACFEXECUTE component  But I am u [More]
Hi, I created a inter company drop ship (third party) SO and kept the delivering plant from other company code Now when the goods are delivered to customer and billing is done How to clear the MIRO invoice between two plants of separate company codes [More]
Hello, since bandwidth profiler is no longer available in Flash CC (???) I've read in the help that I should use Adobe Scout for that but I can't find explanations of how am I to do it. I want to limit the download speed and thest how the .swf behave [More]
We are migrating from SAP BusinessObjects Enterprise XI to SAP BusinessObjects BI Platform 4.1 Support Pack 2 Patch 1. Our Crystal reports were in version 2008. We are having issues with text formating in our PDF documents. For example: lines will ei [More]
Dear all, I've found this macro of Paul Edstein: http://tinyurl.com/onypmay The macro works fine in Word for Windows, but in Word:mac I get an error for this line: .Text = "\<[!\>\<]{1,}\>" Why would that be? BTW: What exactly is Pau [More]
Hi Friends, I want to create a report in spreadsheet format and can also be uploaded to excel file. The length of width is 200 chars. Is it possible to do it on Oracle Reports? Thanks a lotHi, when calling the report you can set the parameter desform [More]
Hi Im wondering if it is possible to do this in FRStudio. I have 2 grids in one report. Both grids come from a different datasource ie:2 different cubes. I want to use the same prompt selection (use the same data) for both grids but without having 2 [More]