472,981 Members | 1,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,981 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 2427
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

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

Similar topics

2
by: Matt Sogla | last post by:
I was wondering if it is possible to take a canned report ( on an Access database (Access XP version), and then be able to write a C# application that will make a call to the canned report in...
15
by: Mark C | last post by:
All, I have exhaustingly been looking through the newsgroups in search of a way to systemically output an Access 97 report to a pdf file using the full version of Adobe Acrobat. I want the user...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
16
by: cyranoVR | last post by:
This is the approach I used to automate printing of Microsoft Access reports to PDF format i.e. unattended and without annoying "Save As..." dialogs, and - more importantly - without having to use...
13
by: salad | last post by:
Hi Guys: I was stuck. I needed to send a report to a file. My beautiful report(s) in Access were going to require loss of formatting with RTFs, a PITA in WordMailMerge, sending it as a text...
6
by: Ron | last post by:
Hi, I know Access allows for easy construction of a report setup to print labels from a table/query, etc. I've done that one. It works pretty well for what I need. However, is there an...
0
by: imranabdulaziz | last post by:
Dear All, I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2005 as a back End I generated local mode report but as there was no printing option available . I assign...
10
by: Snoopy33 | last post by:
I have a DB that I developed on access XP (2002) and deployed over a year ago. No one has had problems printing any of the reports within the DB until we started loading 2007 on new computers. ...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.