i am making this inventory program where the user can query the database...for example he can find out what items are used for this particular project for a given date span or who used those items..etc..he can even make his own sql...
but on the datareports and crystal reports i think you have to like make a template first of the report...that you have to specify the fields to be shown...but the user is given the flexibility on his queries so the fields may vary for each query...how do i make a report for that?
don't know if it makes sense but i want to have a sort of a dynamic report..where fields on the report would depend on the query of the user..
thanks