Report in general

[Space Cowboy]

Good Morning Good People
Can the report facility be made interactive so that its possible to scroll through the table by client or part number etc or is it to produce something that can be printed off?

 

[Gasman]

The latter.

 

[theDBguy]

Both

 

[The_Doc_Man]

You can preview a report before printing it, but be aware that "interactive" has a VERY limited meaning in this context. You can scroll through the report but don't expect to be able to do anything with it OTHER than look at it.

 

[jdraw]

I'm not sure if your question is academic or if you're approaching tentatively asking how to search and show few records at a time.
An option, pending clarification, could be a form with search field and max number of records to show...???
Reports are for print typically.

 

[Space Cowboy]

Thank you all,
I suspected that report may be print only.
I also thought the "form" was for inputting data to the DB.
I want to look at an analysis by each sales rep, then the next rep etc
Without going through a new query everytime.

 

[Gasman]

So you create a query for a report that groups by sales rep.
Then a form to select a range of reps or all of them.

NB: You have to sort and group WITHIN the report. It takes NO NOTICE of any source sort or grouping, other than to accept the source one record at a time.

 

[theDBguy]

Thank you all,
I suspected that report may be print only.
I also thought the "form" was for inputting data to the DB.
I want to look at an analysis by each sales rep, then the next rep etc
Without going through a new query everytime.

Reports can be used liked forms (almost, up to a point), but it's definitely better to use forms as forms and leave reports for hard copy printouts. Good luck!

 

[Space Cowboy]

thank you guys,

Form it is!