Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    559

    Unanswered: Report with same fields, different data?

    I'm not really good with reports. But I have a form where it lists reminders (things that are over 7 days old) within the database. This query is done after the user logs into the db. When the 'Reminder Form', frmReminders, is displayed, it has basic information (Task_ID, Task_Description, Status, Date_Originated, Days_Old) and lists multiple tasks there that fit the criteria.

    What I'm trying to do is have two command buttons.
    1. User can print a report with all the information above (a summary) of ALL the overdue tasks.
    2. User can use the 'ctrl' plus mouse click to highlight multiple individual records and then print them out with ALL the details of each record using another command button on a report that I've already created.

    ***MY QUESTION***

    How can I make the report (summary report), display the same field, multiple times while it fulfills the selection of selecting ALL of the tasks displayed in the listbox on the form, frmReminders?

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    either the question is too simple or the problem is too complex!

    you have total control over reports (BTW one of big-A's really good features) - you probably have to develop the question a touch to get a meaningful reply.

    with no more info than your post (given i don't use the report wizbangs), i can only suggest a peek at properties/hideduplicates

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •