Solved Reports

[Teri Bridges]

Guys, when I nest my three sub reports in to the main report, I cannot scroll past the first record. It keeps bouncing back to the first record. Any help please.

 

[Gasman]

Would need to upload the db I would have thought?
You have given nothing to work on.

 

[Teri Bridges]

Would need to upload the db I would have thought?
You have given nothing to work on.

Sorry, It was a general question. I did not know if there was a known bug. I am still working on the issue. I started over building the reports. If I have the same issue I will post more. Thanks.

 

[theDBguy]

Reports are usually created for printing, so scrolling doesn't come into play. Otherwise, you would normally use a form for displaying and viewing the data.

 

[Teri Bridges]

Reports are usually created for printing, so scrolling doesn't come into play. Otherwise, you would normally use a form for displaying and viewing the data.

Yes, I was trying to validate my report totals and am not able to stay scrolled to the bottom of the page. It bounces back to the first record

 

[theDBguy]

Yes, I was trying to validate my report totals and am not able to stay scrolled to the bottom of the page. It bounces back to the first record

Is the total correct if you print it?

 

[Teri Bridges]

Is the total correct if you print it?

No I scrapped the reports and tried to adjust my tables and include the Course ID in every table so I could put it in a report by course ID. But that did not work. I think I am making more of a mess than I am solving my problems.

So not I think I need to remove the Course ID from each table.

What I want my end result to be is the user has one main form they start on. They enter the initial course details, they then click lessons and enter the lesson, they then click on topics and enter topics, then click on Events and enter the events.

I took advice from this group and nested my forms all that seemed to be working, with one exception. The Course ID and lesson ID are not populating in the events table. They are in the topics table. But I am not sure I even need these fields in the table. Ugh.

Taking the same approach with the report I created a course report, Lesson report, Topic report, and event report. I nested the event report in the topic report, I nested the topic report in the lesson report and then I nested the lesson report in the course report. This is where the scrolling issue came up. and the lesson durations did not come out right because if I had three exercises or topics in the same lesson it counted the duration 3 times.

I am not sure I am making my situation clear, but I drive on.

This version I am working with now has the report that is not totaling correctly and has lost capturing the Course and lesson ID in the events table.

I don't know if anyone can help, I may have to start all over. or just give up! Ugh.