November 25, 2014 at 3:16 am
In a report I am using a field called fields!strvalue.value
When I put it into my report, the field splits into three data parts:
Column heading is strvalue then the data appears like this:
08:00 - 12:00
1, Smith Street
17, Jones Street
98, The Mews
13:00 - 18:00
142, Smith Avenue
Mrs Smith
Therefore it mixes the time and address values. Name appears at the bottom.
Ideally I would like to sort by time: 08:00 - 12:00 (first column) addresses (second column) name (third column)
I have tried various methods, eg =Left(Fields!strvalue.value,InStr(Fields!strvalue.value & ",",",")-1) in an attempt to isolate the time part. However when I do this, all three parts still appear in the report. I am not sure how to isolate just this one part.
I want to isolate the time part to help sort the report and to also set a parameter that runs off the time part.
Any advice on how to achieve this would be greatly appreciated: thanks. I keep thinking I am close to cracking it, but nothing seems to work - whatever I try, all three data parts keep appearing.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply