By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 2,004 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

Ms Access Report for printing

P: 1
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
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
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.