Thanks for the help.

The link is having the formula that i want, but i'm getting same error while calculating percentage.

I'm using this formula:

=iif(inscope("matrix1_FiscalYear") and inscope("matrix1_Expense_Income"),formatpercent(fields!data.Value/Sum(iif(inscope("matrix1_Expense_Income"),Fields!Data.Value,nothing)),2),"")

Please correct me if I'm wrong.

Thanks...

Hi Jeff,

I have visited the link. I've to look in to detail for your solution. I'll try and let you know.

Thanks for your help.

Regards,

Puja Shah

Hi,

Can you please explain me what shall I pass in RBalChanger parameter?

I don't have such field.

Hi,

I'm getting this warning when I run the report:

"Warning1[rsRuntimeErrorInExpression] The Value expression for the textbox ‘Running_Balance’ contains an error: Input string was not in a correct format.e:\ad-hoc report generation\reporting services...

I checked in backend, its working properly.

The main problem is I'm not able to calculate & display running balance.

Any suggestions will be great help to me.

Puja Shah

Hi,

I tried to get running balance as you have mentioned in the VB code, but I don't have unit value, account value & sub_acct values so I passed " "...

Hi,

I tried as per your VR code. I don't have last three parameters(AcctUnit as string,Account as integer, Sub_Acct as Integer) in function.

So I passed " " in AcctUnit, 0 in...

Hi

Thanks for the help. I'll try the solution and let you know whether it works or not.

Regards,

Puja Shah

Hello Ravi,

Please check the attachement & let me know what am I doing wrong?

Puja Shah

Hi Ravi,

The condition is to get opening balance for selected general ledgers. So that I've to keep in the query. If I don't keep that condition, then it gives me...

Hi Ravi,

I'm getting very arbitrary values. I did exactly same as you have instructed.

Here is the query that i'm using:

SELECT dbv.transid,dbv.branchid,dbv.glid,

transdate,

dbv.scrollno,

dbv.voucherno,VoucherDate,dbv.gldesc,

dbv.transdetid,dbv.instrno,InstrDate,

dbv.debit,dbv.credit,dbv.narration,opbal.GLCrDr,

(select sum(isnull(GetOpeningBalance.GLCrDr,0)+isnull(credit,0)-isnull(debit,0)) from DayBookVw,GetOpeningBalance(@ason) where transid<=dbv.transid

and GetOpeningBalance.glid=daybookvw.glid) as RunBal

...

Hi,

Thanks for the reply. I'll try and tell whether it works or not.

Puja Shah

Hi,

Ok I'll reply if I get the answer.

Thanks for sharing.

Puja Shah

Hi Ravi,

I've same problem. I'm getting correct value for first general ledger, but for other I'm getting only second value correct which should be first value.

If you get the answer...

Hi Ravi,

You are right, IsNothing() returns a Boolean value.

=IIF(ISNothing(Previous(Fields!GLCrDr.Value+Fields!credit.Value-Fields!debit.Value)),Format(Fields!GLCrDr.Value+Fields!credit.Value-Fields!debit.Value,"N"),Format(Previous(Fields!GLCrDr.Value+Fields!credit.Value-Fields!debit.Value)+Fields!credit.Value-Fields!debit.Value,"N"))

I this case, when you are using PREVIOUS() function directly, you will not get the correct result. The reason is, for...