Home Forums Reporting Services Reporting Services Report to pull UserID field and Date field from 5 tables and display a List? RE: Report to pull UserID field and Date field from 5 tables and display a List?

  • Hi Drew,

    Thanks for the alternative approach, you guys are great.

    On the question of multiple entries of the same UserID in single tables, well I thought long and hard about how to avoid this and here's what I did....

    Luckily, I created the front-end forms which capture the data for these tables.

    At the moment the tables and the forms are in development, but I wanted to ask about the reporting side of things in parallel with developing the forms (and might I say you guys have helped big time with that)

    So what i'm in the process of doing is adding some validation rules to each form which will check to see if the corresponding table already contains the UserID, if it does, the user will get a "lovely & pleasant - your names already down, you're not coming in" message... So that should take care of any duplicates.

    Thanks again, learnt so much from this thread alone today!