Page 1 of 2 12 LastLast
Results 1 to 15 of 28

Thread: Report (2k)

  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report (2k)

    Hi ;
    Can i do a report contain 4 columns . like ( name- seat no - name - seat no )
    Ashraf

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Report (2k)

    Yes you can, in fact what you are describing is 2 columns with 2 fields per column.

    Go into Page Setup uner the file menu, you will find it under the tab called columns.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    I try it but not work . u try with my db
    Ashraf

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report (2k)

    See attached version. To create the report, I did the following:
    1. <LI>Click New in the Reports section of the database window.
      <LI>Select the StudentsInfo table and click the "AutoReport: Tabular" option, then click OK.
      <LI>This creates a report with one column.
      <LI>Select File | Page Setup...
      <LI>Activate the Columns tab.
      <LI>Enter 2 in the "Number of Columns" box.
      <LI>Enter 11.9 cm in the "Width" box.
      <LI>Click OK.
      <LI>You now have a report with two columns, but no header for the second column.
      <LI>Switch to design view.
      <LI>Copy the labels and line in the page header, then paste them and move them to the right. They should start at about 12.7 cm.
      <LI>Switch to print preview to test.
    You can further modify the design to suit your purposes.

  5. #5
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    Thank u hans but i do it work good , and i have another idea in my file
    Ashraf

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    I think this is what you want, see report rptcolumns in the attachment.
    The report is sorted on Sex (descending) and Name.
    After every 50 names, it will go to a new page. I use a pagebreak control that i make visible or not. See code in the on format of the detail section.
    There is a header section for Sex, just to go to a new page when the female begin. If you don't want this, go to the grouping and sorting window and set the group header property for the sex group to No.

    I had to create a new report as the ones you have, with the arabic characters didn't work very well on my european configured pc. I hope you can read my report.
    Francois

  7. #7
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    Thanks Francois , but that not i want . see my report called Rpt1 u will found that contract no 1 contain 2 male (ali- mohamed ) and 2 female ( hesa and sona ) i want them also in the same bus , as i wrote in the word file , i mean ali and mohamed in the seat 1 and 2 of the bus . ok ( hesa and sona ) in the same bus but not beside them in the back of the bus , all the 50 person like that .
    i hope u also understand me
    Ashraf

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    Is these better ?
    I replace the sort on sex by the sort on contractid and suppress the group header.
    I add Contractid to the report to have clear image
    Francois

  9. #9
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    No also ,
    supoose that the bus contain 50 seat , ok
    supoose also that i have 27 man and 23 women , i want the 27 man seat from 1 : 27 then the women from 28 : 50 .
    ok now
    Ashraf

  10. #10
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    Ashraf,
    I couldn't do this in the report only. I have to create a query and use some dirty tricks to get a bus nr for each individual in the query. Then in the report I sort the query data on Bus nr and Sex.
    I hope this time I'm right. If not, let me know.
    Francois

  11. #11
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    yes Francois ,
    That is near what i want i will adjust it to my mdb and tell u about it .
    Thanks
    Ashraf

  12. #12
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    Hello Francois ,
    I check it again it work very good but i see in quer1 u put new tbl1 How i got it . and also can i do index for female only to start from 50 : 23 ( inverse ) insted ofstart from 23 : 50 .
    Ashraf

  13. #13
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    Open the query in design view, go to View / SQL View.
    In the text you see, after FROM tbl1 I add AS NewTbl1.
    For the sorting, I'm still looking for a sollution.
    Francois

  14. #14
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    Thah ok in SQL i see it . also iam still waiting u .
    Thank u deer .
    Ashraf

  15. #15
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2k)

    Iam Still Waiting U .
    Ashraf

Page 1 of 2 12 LastLast

Posting Permissions

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