473,325 Members | 2,870 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Separate a single report into multiple reports

5
I have over 150 customers, of which maybe a couple dozen or so have active information at any time. I have a single "Customer Report" which is formatted and set to page break for each new customer via 'force new page'.

Information for customers are updated throughout the morning, some of which are prompt and can be sent, others which may not be updated til later in the day. I had 2 ideas in mind

1. Can I make some kind of form or something that would populate itself with the active reports listed out. Where as the user can see all active reports and single out ones to view, print, or send as needed.

i.e.
-Customer Report Form-
  • Customer 1's Report [Preview] [Print] [email]
  • Customer 2's Report [Preview] [Print] [email]
etc...

2. Was to just wait til ALL info is updated and send out all at once, I've searched the internet and came up with this... http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm
I am not having luck implementing this, I am not certain where to put the code or what needs to be edited to make it work for my database. It points to several items so where do i start, make a new form for report management only?

There has got to be a solution other than creating a separate report for every customer, as this was my first idea.

Any help, ideas, suggestions would be appreciated.
Jul 12 '12 #1

✓ answered by zmbd

It sounds like you should be able to define a parameter query that feeds a report. Then you could pull report by customer.

See if this puts you on the right track.
http://office.microsoft.com/en-us/ac...001117077.aspx

-z

5 5764
zmbd
5,501 Expert Mod 4TB
It sounds like you should be able to define a parameter query that feeds a report. Then you could pull report by customer.

See if this puts you on the right track.
http://office.microsoft.com/en-us/ac...001117077.aspx

-z
Jul 12 '12 #2
LarryM
5
That is definitely a start... but not giving me results i need, i got the dialog box to display - but when i select a item and click ok, i still receive the full report. I think this would be a great solution.

I have a query which collects data I wish to share with my customer(s), it is not limited to 1 record per customer. so what i need it to do is, display in the combo box customers displayed in that query (only once, so if customer A has 4 records, I wouldn't want "customer A" to appear 4 times on the combo box. One step further if I could have the customer appear in the combo box with its count of records (i.e. "Customer A (4)") that would be great too.
Jul 13 '12 #3
zmbd
5,501 Expert Mod 4TB
Your report needs to use the query as the record source.

Are you able to create a simple select query that returns just the desired records for a single customer? Nothing fancy here, no popup questions, no forms, etc... just a simple one such as:

Expand|Select|Wrap|Line Numbers
  1. SELECT [Field1],
  2.        [Field2],
  3.        [Field3]
  4. FROM   tbl_one
  5. WHERE ([Field1]=1);
Jul 13 '12 #4
NeoPa
32,556 Expert Mod 16PB
Larry, if you have something that needs to be included in the question, then please include it. I (read any of the experts) don't want to go off somewhere to study a separate page just to get the info on your question I will need in order to help you. You (read any member posting questions) have the responsibility to include all information that is relevant to the question. I think if you consider this for just a fraction of a second you'll see it makes sense.

As it happens, the page wasn't even available when I looked, so I'm flying somewhat blind anyway, but it seems to me the question breaks down into two separate items :
  1. How do I identify the required records?
  2. How do I get just those records to print?
  1. The simplest approach is to have a boolean field in the table which is reflected on the form as a CheckBox.
    Otherwise, add some interface to your form whereby you note the ID of every record that you select by double-clicking or some similar method.
  2. For the former approach simply design the report to select only those records with the boolean flag set.
    For the latter you should formulate a list of the IDs in a string, with each item separated by a comma (,) then formulate this into a filter string. EG. Assuming an ID field called [ID] and ID values of 1, 3 & 5, you would want the following string :
    Expand|Select|Wrap|Line Numbers
    1. ([ID] In(1,3,5))
    When the filter string is ready pass it to the DoCmd.OpenReport() call using the WhereCondition parameter.
Jul 14 '12 #5
LarryM
5
I have it working great, the user selects the report and a popup allows them to select a customer, and the report displays perfectly. I was even able to have the report name itself via on load and me.caption (this is all new to me so I was excited to get it working)

I am now playing around with the new "Navigation Form" feature, where the the user can click the nav tab (which is always displayed) on top to recall the report and select new criteria which displays in the frame below.

This brings me to one more inquiry, <SNIP>
Jul 16 '12 #6

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

Similar topics

2
by: Sigurd Bruteig | last post by:
Hi all! I have a problem printing multiple reports. The code i use is: Dim stDocName As String stDocName = "rptInvoice" DoCmd.OpenReport stDocName, acNormal, , " = date()" The problem is that...
3
by: MHenry | last post by:
Hi, I have 30 separate Access reports to print to pdf files. Presently, I print these reports to Acrobat pdf files one report at a time. I am looking for some help, or a program or add-in...
3
by: nhienvo | last post by:
I have table of customer information. For each record in the table, I'd like to output it to Snapshot passing in a report as the type. I'd like to use the same report for every customer. The...
2
by: Eych | last post by:
(ASP.NET with Crystal.NET) I can create a pdf or rtf file with my report for one record. However, I would like to loop my table and create one big report which would be a concatenation of 10...
2
by: B Garner | last post by:
Hi all Help please. I would like to automate the printing of a report. The report actually is a single page and prints a label. I would like to be able to print the report multiple times...
0
by: mr_doles | last post by:
I have finally got the hang of this ReportViewer control. The one question that I have is dealing with multiple reports. If I have, lets say, 10 rdlc reports should I have 10 WinForms to put them...
2
by: Thall | last post by:
Hey Gurus - I've seen a few solutions to this problem, but none of which I can do without a little help. Here's the situation The following code loops thru a sales report, using the sales rep ID...
3
by: joelpollock | last post by:
I'm having trouble continuously page numbering a large report in MS Access. The report is made up of three separate Access reports which I join together at the end. In the past I have opened the...
0
by: mgarg005SSRS | last post by:
My requirement is to create multiple reports (.rdlc) and show them using single report viewer control. A: User selects a report from drop down list. B: Depending on report name a report has to be...
5
by: MyWaterloo | last post by:
I am currently using... DoCmd.SendObject acReport, BactPDF, acFormatPDF, Me.Text199, , , "BacT Results " & Me.Report_Heading ...to email my report. I have now come up against a need to send...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.