468,525 Members | 2,196 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,525 developers. It's quick & easy.

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 2187
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

reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.