ActiveReport SZ/STOCK-XYZ output format

[uncle_dolan]

Hi Everyone,

 

Been modifying datafields in my active reports to output numbers to 2 decimal places only. I would like to do this for stck sizes as well. I am currently using the SZ/STOCK-XYZ data field to grab my X,Y and Z dimensions for stock as set in mastercam. I would like each of these values to be limited to 2 decimal places but cannot work out how to manipulate the default formatting. Any help would be greatly appreciated!

 

Brendan

[headhunter]

Click on "output format" under "appearance" on the right hand side of your screen when you open Active Reports Designer. Click the box, click on "number" and you should see a field for number of decimal places.

 

Edit to add: make sure you click on the "SZ/STOCK-XYZ " entry first to make sure you are changing the correct field.

[uncle_dolan]

Click on "output format" under "appearance" on the right hand side of your screen when you open Active Reports Designer. Click the box, click on "number" and you should see a field for number of decimal places.

 

Edit to add: make sure you click on the "SZ/STOCK-XYZ " entry first to make sure you are changing the correct field.

 

Tried that one already...since it is not a number field as such, this does not work. the output of the "SZ/STOCK-XYZ" is XXX.XXX,YYY.YYY,ZZZ.ZZZ, with the number of trailing numbers dependant on the specificity of the stock def in mastercam. I have tried a few combimations of formatting changes using the output format section but to no avail. Is there any way that you can set this in the controlling XML Document? Any other ideas?

[uncle_dolan]

bump

[ThRaSH]

It's possible to format the stock size with C# code. As you already found out you can't format "SZ/STOCK-XYZ" as a number, because it's actually a "string" of numbers. So you would need to convert that string into numbers, then format the numbers for 2 place decimal, and then convert again back into a string to display in your report. If you want I could work out some code for you.

[uncle_dolan]

It's possible to format the stock size with C# code. As you already found out you can't format "SZ/STOCK-XYZ" as a number, because it's actually a "string" of numbers. So you would need to convert that string into numbers, then format the numbers for 2 place decimal, and then convert again back into a string to display in your report. If you want I could work out some code for you.

 

Hi Thrash,

 

A sample piece of code would be great only if it doesn't take you long to whip up. I'm familiar with a couple of other scripting languages but havent got to C# yet. If you could get me a short piece of code that could work I'm sure I'd be able to tweak it to my purposes! TIA Brendan

[ThRaSH]

Here you go. You just need to change the code so it points to the Name of your TextBox. I used a TextBox named txtStockSize in example below. If you have any problems\questions, let me know.

 

using System;
using System.Windows.Forms;

public void Detail_Format()
{
// Load s_stocksize variable with the TextBox.Text from your SZ/STOCK-XYZ datafield.
// This example uses a TextBox that has the Name txtStockSize
string s_stocksize = ((TextBox) rpt.Sections["Detail"].Controls["txtStockSize"]).Text;

// If Then to check that the SZ/STOCK-XYZ datafield is not empty
if (!String.IsNullOrEmpty(s_stocksize))
{
	string[] szArray = s_stocksize.Split(',');
	string s_NewString = System.String.Empty;		
	double[] dNumArray = new double[szArray.Length];

	for(int i = 0; i < szArray.Length; i++)
	{
		dNumArray[i] = double.Parse(szArray[i]);
		szArray[i] = String.Format("{0:0.00}", dNumArray[i]);
		//MessageBox.Show(szArray[i]);
	}
	s_NewString = String.Join(", ",szArray);
	((TextBox) rpt.Sections["Detail"].Controls["txtStockSize"]).Text = s_NewString;
}
}