I suggest you ...

Auto Join Tables in Adhoc Reporting

Use defined database relationships/constraints to automatically join tables where appropriate or consider allowing auto joins based on configurable rules (if a table has CourseID and the Courses table is available then join). While something like this may not be simple to implement, any way to avoid users needing to understand database details yet being able to use adhoc reporting is useful. The data views do not work well for this as you cannot have more than one in the report and not all tables can be pre-joined/defined in the data views.

4 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Jerry Latimer shared this idea  ·   ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base