Report Writer, which function to convert amount to string ?

In the Report Writer, i need to convert the amount or total amount
field content and convert its format and store into the calculated
field which is in string format.
Please advise me which function I can use to convert it to string and
this will then combine/join with other calculated fields (string
format).
Many Thanks in advance.
0
WKZ0
1/26/2010 9:32:59 AM
greatplains 29623 articles. 6 followers. Follow

2 Replies
3169 Views

Similar Articles

[PageSpeed] 50

Hi,

in GP Report Writer, you can use the System-Defined Function CUR_STR().  
Just pass the any currency field to the function on any calculated field of 
type string.  You can then use concatenate operator to combine this new field 
with any string fields.

Hope this helps!

Cheers,

Dennis Araullo, MACS
Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certified Enterprise Administrator


"WKZ0" wrote:

> In the Report Writer, i need to convert the amount or total amount
> field content and convert its format and store into the calculated
> field which is in string format.
> Please advise me which function I can use to convert it to string and
> this will then combine/join with other calculated fields (string
> format).
> Many Thanks in advance.
> .
> 
0
Utf
1/26/2010 10:46:03 AM
Many thanks to Dencio.
0
WKZ0
1/26/2010 2:15:18 PM
Reply:

Similar Artilces:

Advanced Financial Reports--Correct Type & Source
My Advanced Financial Reports have been modified and are incorrect. My Balance Sheet doesn't balance. It is subtracting Net Profit instead of adding it. Could someone please look at their Advanced Financial Report Definition Screen and tell me what the Type and Net Income/Loss Source is to be for Balance Sheet and Income Statement? I greatly appreciate the help. For my Balance Sheet, the Type is "Balance Sheet" and the Net Income/Loss Source is "P&L 2005", which is the name of my primary income statement. For my Income Statement, which is "P&...

what is the function and name is of the symbol in each table cell.
Under Paragraph I clicked the Show/Hide Symbol icon so I can now see a symbol at the end of each text within a table cell. I wondered what that is so I tried to use Help to find out. I did find help that mapped a word (like paragraph) into a symbol. But I can't find anywhere where if I know the symbol it will tell me the meaning. Can you tell me how to find such info? Or maybe you can tell me what the function and name is of the symbol in each table cell. Thanks I'm sorry, I meant to sent this to the Word group. Of course, I wouldn't mind getting the info...

Safe Pay Check Amount Problem
I am trying to setup Safe Pay. Everything seems to be working fine except for one annoying quirk. Our bank's Positive Pay data format gives us 12 characters for check amounts ($$$$$$$$$$¢¢). The file that Safe Pay generates is working perfectly except for those checks that are greater than $9,999,999.99 (9 characters). If the check amount is greater than that (say $10,000,000.00), the value that the Safe Pay file shows for that check is 002147483647. And, even if none of the individual checks exceed $9,999,999.99, if the total of the checks in the batch exceeds that a...

Report Format
Env: CRM 3, VS 2003, remote connect to CRM server. I've created a QUOTE in VS2003 and when viewed using PREVIEW from within the VS environment it produces a beautiful QUOTE (at least in my opinion). When printed, again from the VS environment, it is perfect. When I upload the RDL file to the CRM server, create an new REPORT using this RDL then produce a REPORT, the formatting is all over the place. When I inspect the source (in VS) there are no fields that extend past the defined size. It appers that the CRM report engine randomly adds CRLFs all thru the report ... ??? ...

need custom cut and paste functions
Hello, I once wrote here about a problem I had cutting and pasting where columns would turn to "REF!" after a cut and paste. I would work around it by copying, pasting and then manually deleting instead. I thought turning everything in the sheet to absolute references would solve the problem but it didn't so now I am thinking of a different solution. Could someone tell me what I need to do to write my own cut and paste functions which would basically copy the selection and then on a paste it would paste and then delete the original selection from where it was copied from...

Cannot delete report
Hi All, I have install the report manager sometime ago, it is working fine. Until recently we found that when i click the action menu, nothing is come out. I can't delete or rename the report. But I can add new report. Do anyone encouter this before? Thanks. -- Regards, Venedict ...

Function doesn't run
In my spreadsheet, I have the following function =VLookup(K16, zips, 2) However, instead of returning a result, the function remains in the cell. How do I fix this problem? Format the cell as General and re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "Justin" <jmeyer@incrementaladvantage.com> wrote in message news:1165596899.059148.31580@80g2000cwy.googlegroups.com... | In my spreadsheet, I have the following function | =VLookup(K16, zips, 2) | However, instead of returning a result, the function remains in the | cell. How do I fix th...

Log ON Report Manager
Install Report Manger in the Server CRM Satisfactorily, but I have problems when I do log on to Crystal APS, I am using an account of domain administrator and it does not allow me to accesar to the APS. APS User Name: CCSGR3000\crmadmin APS password: ********* APS Server:servcrm I need Help, Thanks. The problem is with the login. Use the following: APS User Name: administrator Password: (should be blank) APS server: localhost (if it's local) I did run into a problem that Report Manager couldn't be accessed from anywhere on the network. It was an IIS configuration problem. &q...

Categories deleted converting from Quicken
Hi folks, I just converted from Q2003 Premier to the Money 2005 Trial 2 days ago. I noticed today that a number of categories have been removed from the transactions in my checking account and credit card accounts. What I've noticed so far: 1. All sub-accounts for Utilities were gone. This wasn't too bad because I could use find replace since the payee name has been the same on these for all years I have in Quicken/Money. 2. All sub-accounts under Insurance were gone. 3. The category Groceries came over, but there were no transactions in it. Quicken had several hundred...

Convert Double Space To Single Space
How do you convert double spaced text to single spaced? I don't see an option for this in Outlook. I can paste into Notepad, copy and then paste into Outlook, but I would prefer a way to do it within Outlook. ...

Converting Money 2000 Canadian to Money 2006 Canadian
Hi, Can anyone confirm that such a conversion is possible? I was hoping to convert to Money 2007 but was unsuccessful. I'll live with Money 2006 Canadian but I want to ensure the conversion is possible first. I don't want to drop the money on it to find out it doesn't work. Thanks in advance, In microsoft.public.money, smurfgun wrote: > >Can anyone confirm that such a conversion is possible? I was hoping to >convert to Money 2007 but was unsuccessful. I'll live with Money 2006 >Canadian but I want to ensure the conversion is possible first. I don'...

Inserting Excel into Access Reports
Office XP Have a great Access application that produces a nice template (headers & footers) report into which I'd like a spreadsheet inserted before going to the printer. In the past, I'd just print the Access reports, then reload them into the inkjet printer and run the Excel spreadsheets as needed. The heat of the new color laserjet turns the paper grey if it runs through too often, so it's time to get the reports printing on one pass. Any suggestions would be welcome. I've of course also got Word XP, MS Publisher XP, as well as Adobe Acrobat, if anyone thinks it m...

Display Report Header/Footer
Can somebody please give me the telephone number of the smartass MS VP who came up with the bright idea for the Ribbon so that I can call her and have her tell me how to display the Report Header & Footer in a report? Obviously, I must be an idiot because I can't figure out how to do it with this simplied, intuitive, help-ya out m***** fu***** ribbon. Oh stupid me, its under 'ARRANGE'. How idiotic of me to think that it'd under 'DESIGN' since I'm 'designing' a report as opposed to 'arrangeing' a report. "microsoft"...

Windows Update Office 2007 Converter confusion
On my desktop I have Office 2003 (laptop has Office 2007). I recently received an attachment in .docx format (2007). I downloaded the converter to my desktop and opened the document. Now on my desktop (which has Office 2003) I receive update notices for Office 2007. Should I ignore these? Hide them? Install them? Will I still be notified re updates needed for Office 2003? Thank you for whatever insight you can provide. If you can give me some of the background explanation as to why this is happening (I presume related to the 2007 converter viewer install), I can understand bett...

eXtender and Crystal Reports
I've created a Crystal Report to print eOne solutions eXtender fields. They store inaformation in 4 different tables: EXT00101 (String), EXT00102(Numbers), EXT00103(Date),EXT00104(Time).. I have created a View that unions all these tables - and convert them into a Varchar.. Once that is done, I've created a function called GetExtFieldValue where i pass the extender window id and field number and it returns the value for that string. This report was working fine and all of a sudden it became so slow that now it takes 7 minutes to get one record. If I delete all the data from EXT...

Payables Trial Balance Report with Options
I am trying to run an A/P Trial Balance Report today that will give me the A/P balance at January 31, 2007. I keep getting the balance as as February 28, 2007. I've run the same report for A/R and am able to get the balance as at January 31, 2007. Currently using GP 9.0. With my previous employer who was also using GP 9.0, I sure that we were able to run an A/P Trial Balance report for a previous period. Does anyone have any suggestions as to what I my be missing or what may be set up incorrectly? -- JR JR, The only date that you can spcify on the Aged Trial Balance With Options, ...

Adding a button with a function on protected sheets.
How do i add a button to 'reset/clear' the data on a worksheet that is protected and uses VLookup data (from another worksheet). Everyday this table will have data chosen from combo boxes or manually entered in allowable editable fields and at the end of the day after the files is saved, I need to clear that data for use on the next day. How is this Reset button applied with allowable edit ranges, VLookup data and a protected worksheet? Thanks There's several ways to do this. 1. Instead of straight vlookups, use =IF(ISBLANK(VLOOKUP(....)),"",VLOOKUP(....)) wher...

Today Function
how is this function called in the code? I want to use in in an update query that is coded to a button. thanks Hey Dave, I hope I'm understanding what your asking for but I think this is what you are looking for: Today() HTH, Shane Dave wrote: >how is this function called in the code? >I want to use in in an update query that is coded to a button. > >thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200706/1 Well I think it is either Today() or Date() not sure which and not sure how to use it in the code. I ...

Crystal Report not found on File Repository Server
I recently upgraded our MSCRM server to a new server. We don't typically use the internal CRM reports, we have some custom ones created with PowerTrack that we primarily use. The CEO tried today though to open one of the canned MSCRM reports and got this error message. I tried the others and I get it on all of them. CrystalReportViewer File frs://Input/a_063/021/000/5439/6ac34043c58b1112.rpt not found on File Repository Server. I checked the input folder in c:\program files\crystal ent 9\filestore\input and it is empty. I would have copied them from the old server, but it is ...

Converting number to text
Is it possible to convert, say 1234 to one thousand two hundred and thirty four Thanks There is no direct functions to convert this. For a VBA solution check out the below links http://www.ozgrid.com/VBA/ValueToWords.htm http://support.microsoft.com/kb/213360 http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Jacob (MVP - Excel) "booshi" wrote: > Is it possible to convert, say 1234 to one thousand two hundred and thirty > four > > > Thanks > > > . > ...

Converting a MFC DLL to a regular DLL
Hi, I have an MFC DLL which i have now removed the single MFC window that popped up error messages. I want to now convert it to a regular DLL. What parts of the code to i need to remove / modify? And what compiler settings need changing? On Aug 4, 6:05=A0am, hamishd <Hamish.D...@gmail.com> wrote: > Hi, I have an MFC DLL which i have now removed the single MFC window > that popped up error messages. > > I want to now convert it to a regular DLL. What parts of the code to i > need to remove / modify? And what compiler settings need changing? I would create a dummy MFC reg...

how can I asign printscreen to a function key or key combination?
My key board has no printscreen key. What can I do? That seems unlikely, but it is hardly a Word issue. The PrtScn button is usually a dual function button somewhere on the top row of your keyboard. If it is not then you need to ask the keyboard manufacturer. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< ...

grayscale autoshape changes to color when converting to PDF
When converting from Microsoft Publisher 2007 to Adobe Acrobat 8.0 PDF, the autoshape picture that we changed to grayscale changes back to color when reviewing the created PDF. Are you setting Acrobat to print in black and white? Select the PDF printer, properties, paper/quality tab. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "CDJ" <CDJ@discussions.microsoft.com> wrote in message news:6BE9EE01-97DB-4AB6-BD9C-25E27E0BB68D@microsoft.com... > When converting from Microsoft Publisher 2007 to Adobe Acrobat 8.0 P...

EDC Reports
Is there a way to gain access to the EDC report(s) in SO Manager without having to configure it for EDC? I need the accounting department and back office mangers to be able to look at and print these reports without them actually having to or needing to do any EDC processing. You could use the Tender Summary report (Reports | Misc | Tender Summary) to get credit card totals by type & register. Marc "Alex" <Alex@no.com> wrote in message news:edLaU8DUHHA.2212@TK2MSFTNGP02.phx.gbl... > Is there a way to gain access to the EDC report(s) in SO Manager without >...

Calculate Subreport totals in a main report Group footer
Hi all Apologies if this has been answered before but I can’t find it. I have a main Report with a Group called “Product_Category” which lists a number of “Products” in the Detail I have a Subreport named “product_costs” which has a record for each date and Text Boxes named “materials” and “fuel” (there are more but I’ll keep it simple). The Subreport sums all costs and has Text Boxes named “summaterials” and “sumfuel” in the footer (all with a height of 0.1cm) The Subreport is embedded in the Detail of the Categories and linked by Product_id In the Detail of the Main Rep...