Thank you for the reply, But its not working

I created a calculated field as Year and assigned FY_1 value field which is coming years from dataset

Some how not working showing...

Its still not working;But I changed the stored procedure as like below

I don't understand why I am getting error at first select statement like "error converting datatype varchar to numeric"...

select...

Thank you for the reply tried your sql code the problem is that the amounts are varying in free column and dollars column?

Before that in free column for particular system...

yeah,thank you.it got worked.

Hi,

Is there any way to sum two textboxes amount into one.

I am using two different tables with same dataset.I need total amounts which I am...

No, I am not using those fields in my sp,if I use those its very easy to drag me in SSRS report but he problem is I am selecting only...

Thank You so much...

Please find the attachment for the database records, and below is the select statement

SELECT

G.FiscalYear,G.SystemID, I.SchoolID,SUM(I.AMOUNT) as 'invoiceamt1',

CAST (SUM(ISNULL(I.AMOUNT,0) - ISNULL(I.OtherAmount,0)) AS NUMERIC(18,2)) AS 'invoiceamt',

datename(month,dateadd(month,MONTH(R.FundMonth),0)-1) as 'FundMonthName',

G.SystemID+'-'+VS.SystemName as 'SystemName',I.SchoolId+'-'+VS.SchoolName as...

Thank you for the reply.

I have a quick question in SSRS report, I am trying to use format percent in the expression for tablix

how can I write an expression...

Thank you..

Hello I am creating an SSRS report where in the header I am trying to insert a text box with expression;in that expression the date should be july 1,2013 -...

Thank you so much,it worked..

No,we don't have calendar table?

Any help regarding the expression?

Need help please!!

No,we don't need to insert new rows into 2014 year.I had written sp please correct me

-->first we get systemcertificationid from 2013 year using all the conditions I got 126 records...