Skip to Content

Pull Multiple Questions\Answers

capture.jpgI have a report where I am trying to pull the answer to a main question and also pull what I will call the second-answer. So, in the screenshot if the user selects 'Antibiotic stewardship' then they get a second set of questions they are required to answer. I need the 'Antibiotic stewardship' answer and the second answer. It looks to me like the main answer is the same QUESTION ID for all, but the second ones are all different ID's.

Is there a formula I could write for this ? there are 10 main questions and close to 40 second answers.

capture.jpg (41.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 23 at 07:52 AM

    Depends on your database structure. If Secondary answers have a different ID then they could have a separate DB table.

    If so simply join that table into your report linking IDS

    Or if within same table as main question then the secondary question will have a parent ID field.

    In which case add the same table back into report (crystal will complain just ignore) join table from parent to secondary table ID. Crystal will then alias table by adding _1 to table name. You can rename in expert screen by giving a more use friendly extension eg _secondary.

    Ian

    Add comment
    10|10000 characters needed characters exceeded