Method:Classic General Q&A

Re: Report Designer - calculated fields

Method_Inderdeep — Wed, 10 Oct 2018 20:03:07 GMT

Hi StuartKatz,

Do you mind letting me know the end result that you are trying to achieve and what are the fields you are working with and on which report? It will help us in narrowing the issue.

-Inder

Re: Report Designer - calculated fields

Method_Inderdeep — Wed, 10 Oct 2018 20:03:04 GMT

Hi StuartKatz,

Do you mind letting me know the end result that you are trying to achieve and what are the fields you are working with and on which report? It will help us in narrowing the issue.

-Inder

Re: Report Designer - calculated fields

StuartKatz — Wed, 10 Oct 2018 17:51:31 GMT

I have been trying to get scripts to work in the report designer and I keep getting weird results.

I followed your example above and created the following script where label28 is a new label I added to the group footer 2 and label33 is a label that is a summary in group footer 2 and is bound to InvQty in the table I am using for this report.

Private Sub OnBeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs)

ctype(sender,xrLabel).Text = Microsoft.VisualBasic.Format(label33.Text,"##0.00")

End Sub

What shows up on the report is ##0.00

Any idea waht I am doing wrong?

Re: Report Designer - calculated fields

s.nissel — Wed, 29 Feb 2012 01:43:45 GMT

I need to calculate to labels together to give me a total in a new label. I followed the above coding and it took one label and divided by the 2nd label. I need it to add them together. What coding would I use for that. I assume i need to subsitute the / with a + but when I did that it just showed me $#,##0.00###".

Re: Report Designer - calculated fields

Method_Michael — Thu, 22 Sep 2011 19:14:05 GMT

JKM@SA,

The line of code I gave you has to be all on the same line and not on 2 seperate lines. If you are still having issues, I would suggest looking at some of the field on the Estimate templates(They have a simlair setup) or booking some consulting time.

-Michael

Re: Report Designer - calculated fields

JKM@SA — Thu, 22 Sep 2011 17:50:20 GMT

I am getting an error message. Here is what I entered:

Private Sub OnBeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs)

ctype(sender,xrLabel).Text=Microsoft.VisualBasic.Format

(xrLabel13.Text/label2.Text,"$#,##0.00###")

End Sub

I am getting the following error message:

There are the following errors in script(s):

label3.OnBeforePrint,line 2: error BC30455: Argument not specified for parameter 'Expression' of Public Function Format(Expression As Object,[Style As String = "]) As String'.

label3.OnBeforePrint, line 3: error BC30035: Syntax error.

Re: Report Designer - calculated fields

Method_Michael — Thu, 22 Sep 2011 16:51:01 GMT

JKM@SA,

Take note of the actual names of the labels you are using to display the fields you want to use in your calculation. (Click on the labels and in the property grid look for (name).)

Create a new label and in the property grid go to Scripts > Before Print and click ... , this will being up a windows where you can enter a script

Enter the following between the 2 lines of existing code:

ctype(sender,xrLabel).Text = Microsoft.VisualBasic.Format(label5.Text / label6.Text,"$#,##0.00###")

You will need to replace label5 and label6 with the names of the labels for the fields you are using.

For those you want to know what the script is doing:

ctype(sender,xrLabel): Refers to the label calling the script

Microsoft.VisualBasic.Format(value,"$#,##0.00###"): Applies a currency format to value.

-Michael

Re: Report Designer - calculated fields

JKM@SA — Thu, 22 Sep 2011 16:19:08 GMT

Total Profit is in the table in a calculated format. Total Actual Man Hours is just a sum on the report.

Re: Report Designer - calculated fields

Method_Michael — Thu, 22 Sep 2011 16:07:14 GMT

JKM@SA,

Where is Total Profit and Total Actual Man Hours calculated? Are they stored in the table in the calculated format?

-Michael

Report Designer - calculated fields

JKM@SA — Thu, 22 Sep 2011 15:39:19 GMT

I have a report with Total Profit (calculated) and Total Actual Man Hours (calculated). How to I set up a calculation for:

Total Profit/Total Actual Man Hours