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 gurus, My requirement is to download a file to application server in background mode by DYNAMICALLY SELECTING THE DIRECTORIES AVAILABLE in application server. i.e. i must display all the directories available in application server in the selection [More]
I am trying to find the serial number that is required by itunes for troubleshooting. But the trouble is, I don't know what it is. My computer is a HP (not a MAC). I have the itunes serial number. Before loosing my almost 5000 songs I was using an ol [More]
I have the following situation -- 1. I have two WebServices A and B deployed onto OC4J_10.1.3 They both work when I test them using the test service 2. My real need is to call webservice A from B. So I created a proxy for A using JDEV and deployed in [More]
Hi All, 1) I have created a PR with 2 items in the R/3 Backend using the me51n transaction in which for one of the items i have updated the Revision Level field. 2) To transfer the purchase requisitions created in the above step to the SRM system(sou [More]
I had a problem ( from before ) getting a file called --> test_oracle.edi into the system. I am using a set up of EDI X12 over Generic Exchange together with FILE 1.0 protocol. The file has a sender of ACME and a receiver of GLOBALCHIPS, which to be [More]
Hi Experts I am working on a file to File configuration scenario, I wanted to used only one sender and Receiver CC to pick up the files from different folders and drop it in the corresponding folders, Can anyone send the link to the blog or details h [More]
Hi, We configured a sender Split997 adapter communication channel in sap xi. Now we want to test if the communication is working fine in converting the EDIfact message to XML. How can we test this. Thanks in  advance.Wih out the AS2 server access.Is [More]
I have 2 profiles , the one profile i did a search for " fingerprint scanner"  and I tapped the the button that said fingerprint scanner under search. A dos window opened and the a Gui which helped me store my finger print and associate it with [More]
I am wondering if I use ARD would I be able to sit in class (yes class) with my MacBook and edit on Final Cut on my G4 PowerMac? The connection is very strong on my airport connection. MacBook Pro   Mac OS X (10.4.6)  I do this often from G5 to G4. I [More]
Hi, Can a cross tab report be generated with the help of Oracle Application Express? LavinaLavina - you can cheat and create a very simple report like this: Use a PL/SQL dynamic region. Within your PL/SQL, query the database to get the data in rows r [More]