John@OnyxTheaters

I'm trying to customize our pick lists to show our cost, price, where to buy the product, and quantity of each product. I've adjusted the "Datafield" accordingly for cost and price (i.e. Datafield = dtr:Cost). Problem is the quantity and cost/quantity and price aren't accumulating. For example, on the first product in the attachment I've got an Apple Airport Express where price is $99 each and there are three. I need the price to say $297 ($99 x 3). Any suggestions on how to go about doing this? Also, is there a list of datafield names anywhere so that I can see what to name certain datafields?

bala

John -

The problem is accumulating the price values. To resolve this you have to do some changes in both Designer and Script side.

Steps to follow to make this to work:

Designer Side changes:
1) Drag one textbox as named TotalPrice and set Summary group to “GroupHeader1”
2) Go to the properties of txtPrice and make the visible value to False

Script Side Changes:
Write this code:

Sub GroupHeader1_BeforePrint
Dim strTotPrice As String = ReportUtilities.ReturnTextBoxValue(rpt,"GroupHeade r1","txtPrice")
Dim strQty As String = ReportUtilities.ReturnTextBoxValue(rpt,"GroupHeade r1","txtQuantity")
Dim strPrice As String=strQty*strTotPrice
ReportUtilities.SetTextBoxValue(rpt, "GroupHeader1","TotalPrice",strPrice)
End Sub

Publish and Run. Hope this will help.

- Bala

bala

Hi -

We have the easiest way to make this. You have to set the summary type information for the Price text box as follows:

a) SummaryFun = sum
b) SummaryGroup = Corresponding Group Header
c) SummaryType = SubTotal

Save and Run the report.

Hope this will help you.

Thanks,

- Bala

John@OnyxTheaters

Awesome, thank you!

John@OnyxTheaters

Worked perfectly, thanks again bala!