Hi
I wonder if someone can help me - I have an SSRS report which has lines of data for a portfolio - which has things like security name quantity, FX Rate and Currency etc - what I need to do is loop through these rows so at the bottom I can put a text box which will show the distinct rows of any currencies that are not GBP with the exchange rate e.g the text box needs to show
£1 = $1.250, £1 = EUR1.23, £1 = CAD1.8200 etc
Is there a way to do this in SSRS?
Thank you so much for any help.
Dawnyanne
I wonder if someone can help me - I have an SSRS report which has lines of data for a portfolio - which has things like security name quantity, FX Rate and Currency etc - what I need to do is loop through these rows so at the bottom I can put a text box which will show the distinct rows of any currencies that are not GBP with the exchange rate e.g the text box needs to show
£1 = $1.250, £1 = EUR1.23, £1 = CAD1.8200 etc
Is there a way to do this in SSRS?
Thank you so much for any help.
Dawnyanne