471,084 Members | 823 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

Ms Access Report for printing

I have SQL Server Database and MS Access 2003 is connected with ODBC. I have very large amount of records in various tables. The database is very dynamic as it changes every minute. I知 trying to have a live MS Access report which would pull data from SQL Server. I値l try to explain how I知 trying do this:

The Access report should have two parts:
1. Title page report, just like table of contents. It should be listing a particular field of a view table and also should be filterable so that the title list would list only necessary report list.
Example:
[i]1. household information package<click to view or print>
2. small business information package<click to view or print>

3. medium business information package<click to view or print>
4. monthly seminar package<click to view or print>



2. Detail report: The detail report is for viewing the detail report or printing purpose which would be generated once we click on the report title hyperlink.
Example:
Title: 1. Household information package report
i. Kitchen
Description: bla bla bla bla
NameOfItem Cost Condition


ii. Living Room
Description: bla bla bla bla
NameOfItem Cost Condition
iii. Bed room
NameOfItem Cost Condition

My question is, How can I build the title page report with hyperlink or button next it. And, detail report which is launched/ printer when we click the link/button?
I知 sure I値l have more question but this is my first mountain to cross.

Thanks in advance for you help
Sonik
Jul 25 '07 #1
1 2314
JConsulting
603 Expert 512MB
I have SQL Server Database and MS Access 2003 is connected with ODBC. I have very large amount of records in various tables. The database is very dynamic as it changes every minute. I知 trying to have a live MS Access report which would pull data from SQL Server. I値l try to explain how I知 trying do this:

The Access report should have two parts:
1. Title page report, just like table of contents. It should be listing a particular field of a view table and also should be filterable so that the title list would list only necessary report list.
Example:
[i]1. household information package<click to view or print>
2. small business information package<click to view or print>

3. medium business information package<click to view or print>
4. monthly seminar package<click to view or print>



2. Detail report: The detail report is for viewing the detail report or printing purpose which would be generated once we click on the report title hyperlink.
Example:
Title: 1. Household information package report
i. Kitchen
Description: bla bla bla bla
NameOfItem Cost Condition


ii. Living Room
Description: bla bla bla bla
NameOfItem Cost Condition
iii. Bed room
NameOfItem Cost Condition

My question is, How can I build the title page report with hyperlink or button next it. And, detail report which is launched/ printer when we click the link/button?
I知 sure I値l have more question but this is my first mountain to cross.

Thanks in advance for you help
Sonik

For starters, you won't be able to create a clickable item on a report. A report is a static "view" or snapshot of data, and the only controls available after the creation of the report are menu items or right click menu items.

You're going to have to rethink your report idea and maybe create a form that does some of the work prior to printing or previewing.
J
Jul 31 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.