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
I have did a lot of movement of equipment and computers and moving my Time Capsule.  Trying to set all the equipment back up, I have run into a problem of not being able to access my files on my Time Capsule.  It is an older Time Capsule (1TB, 2008/2 [More]
When I power on my MacBook Pro all of my programs open, ie photoshop, word, excel, email, calendar etc. somewhere I have selected some setting but can't find where.Remove the check in the box "Reopen windows when logging back in":Read other 7 an [More]
Hi , I am using FCC.communication channel is running fine. But , content is missing in payload. Even i cant see fiield tags in MONI. What could have been the probelm. Regards --PradeepHi, My FCC parameters are, Emp_header.fieldSeparator     ' ' Emp_h [More]
All, We are seeing errors when creating a new external resource for an SQL (Oracle) database in Process Admin. We are using the latest and greatest version of Enterprise for WLS. Resource definitions are disappearing after creation in some cases. Som [More]
If I use an inline subquery within the SELECT of a data model query, the symbol data link appears in the query_name of the data model. This causes the data link between two queries not to be used even if there is an existing link between the two. The [More]
Hello everyone, I have the next scenario requirement: Informix -> XI -> R/3 but the answer from the R/3 BAPI has to be evaluated to send an email in case of error and to update some rows in Informix database, the query in the sender jdbc is a JOIN f [More]
OK stuipid question but where can I find the wallpapers that came with my 3g.. When I updates my girlfriend phone to new iOs I switched wallpaper and it is no longer an option. It was a pic that came with the phone. Help anyone?Restoring your iPhone [More]
We have developed a process to clean-up our org structure of people who have left the company.   In testing, we found that the standard deletion process does not allow for deletion of users who are tied to a shopping cart.    Our business requirement [More]
I generated an html signature using TB. İmages and writing are all fine, however, there appears an anchor sign/image in front of the signature, which can not be deleted or selected at all. The anchor doesn't disappear once the email is sent. It could [More]
This program is great to animate with, but EXTREMELY FREAKIN' FRUSTRATING to implement. A lot of this could be alleviated if the "publish" options let me specify an URL at the host level (or better yet an FTP protocol that I could upload my work [More]