Thank you Jeff & Jeffrey for your helpful replies. I have sorted it now

Sadly my skills to SQL are not great so I find it easier to do...

Thank you Jeff & Jeffrey for your helpful replies. I have sorted it now

Sadly my skills to SQL are not great so I find it easier to do these queries...

Tried again and still didn't work.

Think I will abandon this for today and possibly take a different approach.

Thank you for all your help with this

That gave me the following error. The other grand totals seem to work out ok which is why I assumed it would just be this part of the query I...

I'm guessing on each change in value on Earners.feeBudFee or for each Earners.feeRef possibly?

At the moment the above code is pulling back multiple values which I have filtered to only...

David you are an absolute legend. That worked perfectly

Thank you

PostingDetailsDate returns a date and time, not sure if thats the issue. Not even sure how to use the CDbl expression

Thank you again David. Textbox is now showing #Error

Thanks David I got the following error

The Value expression for the textrun ‘SplitBillsMasterSplitAmount.Paragraphs[0].TextRuns[0]’ contains an error: [BC30451] Name 'PostingDetailsDate' is not declared.

Hi David,

Sorry I didnt explain it very well. My background is more excel than sql

I have a field that is called PostingDetailsDate I know the following would give me the...

YTLP gets it total from =code.SumLookup(LookupSet(Fields!Fee_Ref.Value,Fields!Fee_Ref.Value,Fields!Split_Amount.Value, "Billing"))

TSA =Sum(Fields!Total_Split_Amount.Value)

YT  =Fields!Current_Annual_Budget___Billed_Time.Value

I did try and put this in a calculated field which was my first option but I kept getting errors, which I...

Hi Andrey

I get the following error when I try that

A sort expression for text box ‘Textbox26’ refers to a report item. Report items cannot be used in sort expressions.

Hi Thom

Sorry I didnt make sense. What I was trying to say is that I am trying to write an uncashed cheque report and for some reason the...

Sean

Thank you for your reply. Sorry my question wasn't complete I was typing while trying to work out the problem, as I have said before I am very...

Hi Luis

Yes I am connecting to a SQL database. The report is built using the report builder connected to our finance program (SSRS 2014) but I assume the...