Post reply

Newby question

  • August 4, 2017 at 2:25 am

    #324832

    Hi

    I am looking for some advise. We have taken on a new finance system at my firm and the report builder is SSRS 2014 which I have never used before. As  I am compentant in Excel my firm assume that I will be able to build reports without training, yes a mistake but nothing I can do about it without paying for my own training.  Anyway I have built a number of reports now which work (thank god) but I am struggling to format a column as per the hard coded reports. In the hard coded reports our  file numbers show as

    XXX000-0001
    But on my reports this is showing as xxx0000001. I have tried formatting the text to add a dash but this doesn't work. I assume it must be achievable as the hard coded reports use the same report builder, can somebody point me in the right direction please so I can make our reports look right

    Thanks
    Chris

  • August 4, 2017 at 2:47 am

    #1954105

    Where is the value of your file number coming from? Does the source it's coming from contain "xxx0000001" as well?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • August 4, 2017 at 2:56 am

    #1954106

    It comes from a field called matter number. I assume the source contains "xxx0000001" obviously a sample as all the matter numbers are unique as I say the system reports that are hard coded shows this as client no "xxx000" and matter no "0001" as per my example above with the dash between the 2 numbers

  • August 4, 2017 at 3:06 am

    #1954107

    Personally, I would use an expression to add the hyphen in then. Assuming your field name is of (n)varchar type, and is always 10 characters in it's original form:
    =LEFT(Fields!Matter_Number.Value, 6) & "-" & RIGHT(Fields!Matter_Number.Value,4)

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • August 4, 2017 at 3:10 am

    #1954108

    Your assumption is correct. Just one last question. Where do I add that expression 🙂

    Thanks for your help

  • August 4, 2017 at 3:18 am

    #1954109

    cmw 66135 - Friday, August 4, 2017 3:10 AM

    Your assumption is correct. Just one last question. Where do I add that expression 🙂

    Thanks for your help

    You use the expression as your field/textbox value. Your field, in the preview pane, probably contains "[Matter_Number]" right now. If you right click the field, an option menu will appear; oOne of those options if fx Expression. That'll open a dialogue window to input your expression.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • August 4, 2017 at 3:31 am

    #1954112

    Was just going to type the reply that I worked out where to put this and then your reply popped up on my email

    Thanks for your help

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply