Custom Reports Form

[agehoops]

Pretty sure this is possible just don't know how and wasn't sure whether to put this in forms or reports but thought forms was more logical.

What I'm basically looking to do, is have one form which is full of tick boxes which represent different fields of data from the various tables. For every box that is ticked, I want that data to be shown on a report. So basically it has to generate a custom made report depending on the options selected on that form?

Hope that makes sense

Thanks for the help in advanced

 

[stopher]

It's probably worth searching the forums and google. Here's one link that might help

Chris

 

[agehoops]

Brilliant. Thanks for the response i'm sure i'll be able to figure out something from the link. Appreciate it

 

[agehoops]

Ok I had a look at that link but it's only really for a flat file. How would I adapt it for a relational database? Couldn't really find anything on google for it

 

[stopher]

Not sure I understand what you are asking for. From my brief look at the link, it is creating a report from a table (although it can just as easily be a query with fields from multiple tables and therefore relational). You choose the fields you want to see and the report displays them.

If you are looking for something that allows users to create reports from any fields in any tables (as opposed to the ones you've provided for in your query) then I would say:
- Access reports are intended to be static reports
- In theory I think this could be done but would take a lot of code
- Probably better to investigate a third party (I've heard people mention Crystal reports)
- Allowing users to generate their own reports with a completely open view of tables and fields runs the risk of users generating information that doesn't necessarily say what they think it does.
- if you are reporting data e.g. sales info, then consider a third party tool or Pivot tables.

On the subject of pivot tables, I have all our sales data pushed into an Access based data warehouse. We then point Excel Pivot tables to the data warehouse. This gives us an extremely powerful and dynamic reporting/analysis tool. The data warehouse is designed so that it only has the fields and data that makes sense. The users can pretty much shape and filter their data however they like with whatever fields they choose (prviding they are in the data warehouse.

hth
Stopher

 

[agehoops]

Alright then, i'll take another look and see what I can do, cheers