Okay, I'm looking at sl_2.rdl which may be the wrong rdl file. You have in the last textbox:

=Code.CalcSubTotal(ReportItems!txtGLCrDr.value,ReportItems!txtdebit.value,ReportItems!txtcredit.Value,"rs",1,CInt(23))

dim RAcctUnit as string

dim RAccount as integer

dim RSubacct as Short

dim Balance as double

dim...

And one more thought (sorry--too much multitasking) that I may have mentioned earlier. The field that makes the running balance start over at zero, this field has to be in...

More thoughts: whatever field causes the Running Balance to start fresh at zero has to be a field in the report. I usually make it a field in the Detail...

You have a lot less parameters. I'm assuming gldesc is what you need to break on--when the balance needs to start over. Also made the assumption it's a string. If...

RS itself, not SQL Server, writes in VB.Net syntax. If you know that, it makes life easier because you can search for help in Google or books. I use IIF...

If you want to look at my solution, perhaps I could add some detail. I created a table with all the transactions in the general ledger. Each row also has...

We don't really have a fully certified SQL Server DBA. We have someone who takes care of the databases but he's old school and this company is new to Reporting...

I think you can see by the attachment exactly what I put in my Properties.

Yesterday we put the solution on the server thinking maybe it needed to be there to...

I put this in Report Properties for URL:

http://gldev.fcb.main/lawson/portal/reportserver?/Trans_History2_New/Trans_History2_New&rs:Command=Render&rc:parameters=true&rc:toolbar=true

Received error:

A connection could not be made to the report server

/reportserver?/Trans_History2_New/Trans_History2_Newrs:Command=Renderrc:parameters=truerc:toolbar=true

The attempt to connect to the report server failed. Check your...

I forgot to mention (too much multitasking) that I found out this morning that the server we put the solution on, is on 2000, not SQL Server 2005. Could that...

billwarn: Thanks. I think this piece is going to be pivotal.

Jack: I've never deployed a report before (my DBAs did this previously), so we put my project on a server...

I needed a running subtotal to start over again when account, acct_unit or subaccount changes.

I put this in the textbox in Layout:

=Code.CalcSubTotal(ReportItems!txtBegBal.value,ReportItems!txtDebitAmount.value,ReportItems!txtCreditAmount.Value,ReportItems!txtAcctUnitHiddenForCalc.value,ReportItems!txtAcctNoHiddenForCalc.value,CInt(ReportItems!txtSubHiddenForCalc.value))

In Report, Report Properties, Code, I put the...

I got it figured out. It must have been my code because now all the N2 formatting is working fine. Thanks.

No, I'm not doing more math. I tried putting the same Format string around my results in the Code piece and that didn't work either.

Ever since I formatted 3 textboxes...

I edited my reply but you didn't see it. I realized that the @ needed to be removed and then it ran AND grouped correctly.

I'm interpreting what you're saying...