473,568 Members | 2,935 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to change the format of text in a report?

33 New Member
So i have a report that will be seen by several customer around the world. I have done some research on ways to change some of the financial figures to show the correct currency. There are two fields on the report that I would like the correct currency symbol to be displayed. So fore example when creating the report for my Japanease customers i will be using Yen. So i opened up the report in design view and went to the properties box for the 2 desired fields. In the format box i typed ¥#,### so the format will show up as Yen.

So here is the weird part. One of the fields, we will call it field A the Correcy format is applied. However, the second field (field B) it still shows up using a USD ($) currency format. I am wondering why this would happen and how do i fix this?

Let me give one more piece of information about field B. The report is being generated from a query and in that query the field B is an expression. The expression is
IIf([Credit]<[Total Std Cost],[Total Std Cost],[Credit])

It basically is taking the lowest of the two values in the previous query. Now i have checked the formats for all of these fields and they all read as the correct currency format (¥#,###). However it just seems like once this IIf statement is ran, it changes the currency to USD ($) format. Is there an easy fix for this?
Sep 24 '10 #1
2 1885
slenish
283 Contributor
Kent,

What you have to look at first is what is Credit and Total Std Cost displaying? If they are currency in USD that is why you are getting a USD result. You need to either change those fields to give the currency you are looking for or you might want to look at creating another query that pulls some of the information from this original one minus this field B and create a new field to calculate the currency difference.

Slenish
Sep 25 '10 #2
kent christensen
33 New Member
got it! Thanks!
Sep 27 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2745
by: Newgene | last post by:
Hi, group, I have python2.3 installed on win2k. I noticed that when I open a dos format text file (eol is '\r\n'), readline() always returns a line ending with '\n' only, not '\r\n'. While I read the same file on unix, it returns a line ending with '\r\n' correctly. This makes me difficult to determine the format of a text file, dos or unix....
2
5641
by: ezelasky | last post by:
We are using the bcp utility (via APIs) to export data from a SQL table in a fixed format text file. BCP is inserting spaces for a field if the field contains a NULL. This is fine with us except at the end of the line, there are no spaces for that field just the end-of-row terminator prematurely, so it looks like that field is not present...
3
1673
by: dennist685 | last post by:
Format text as a heading I'm progressing through a walkthrough on DetailsView control Early on it says Type Edit Employees, select the text, and then format the text as a heading. I clicked format, then styles, but nowhere found how to make selected text a heading.
0
1043
by: mannaikarthik | last post by:
Hi, Currently I am designing some reports in ASP.NET using SQL Server reporting services-2000 I want to format a report item (a column in the report) like the following. Just consider a report item called Annual Target (AT), it's a calculated field based on some database fields If the value of AT is whole number (e.g.: 0, 1, 45,...
2
2782
by: devathi | last post by:
I have to display 16 columns in A4 size paper, am able to display arnd 4 columns in one paper. Suggest java program for generating A4 format excel report in which i can display any number of columns.
13
3227
by: Neil Cerutti | last post by:
Many of the file formats I have to work with are so-called fixed-format records, where every line in the file is a record, and every field in a record takes up a specific amount of space. For example, one of my older Python programs contains the following to create a fixed-format text record for a batch of new students: new =...
2
1360
by: David | last post by:
I have VB6 app that generates a report using the Printer object. It basically was an old text report that i generated using Print# statements. I am wondering if the Printer object has changed significantly in vb.net and whether to consider using some other tool. The report grabs data from a database but I do a lot of processing of the...
2
1434
by: mahesh123 | last post by:
Hi Folks, I am generating the text reports from the visual basic 6.0. while printing the text report the Char(12) ie page break character is not recognising. Is there any alternate Solution for recognise the page breaker while printing the text reports. Help me immediately. Thanks ---------- Mahesh
3
5615
by: Phil Stanton | last post by:
Correct me if I'm wrong, but is it impossible to change the font in a report field when in print preview (MDE database) or can it only be done in design view in the MDB database. Part of my database is used to print name tags for functions, and it would be nice for the operator to have a choice of different fonts, colours and backgrounds. I...
6
6408
by: K Viltersten | last post by:
I have the following button: <asp:LinkButton id="Btn" runat="server" text="Click"> </asp:LinkButton> I have added an action listener in the javascript where I change the text on it: this.dom.textContent = "Clicked"; The change is effective but after the site has reloaded the text is back to "Click".
0
7693
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7917
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7962
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6277
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5501
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5217
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
2105
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1207
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
933
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.