[Progresso] Modifying progresso 'Model' reports

[Ditto]

With a distinct lack of support training and documentation, I'm struggling with what seems a really simple change. I've taken a copy of "AL_tmp_Learner_SEN_and_FSM" under Reports -> System to modify. I simply want to add Surname and Forename to the report. I can see this in the Datasets. So far, this has baffled me but I'm sure it will be solved by one of those simple little nuggets of info that successful SSRS development requires!

 

Edited September 10, 2017 by Ditto

[coconurtaler]

Just wondering if you sorted this in the end?

[Ditto]

With a bit if help from Progresso support yes. Basically you need to put a lookup in as follows: =Lookup(Fields!LearnerID.Value,Fields!LearnerID.Value,Fields!Surname.Value, "DS_Learners") and similar for forename. It was necessary to add the shared dataset Learners (as DS_Learner_Details) first. Having a look at the original report (AL_tmp_Learner_SEN_and_FSM" under Reports) now, the dataset, surname and forename have sensibly been added. If you want to see the report before it was changed, have a look at your sandbox environment.