Results 1 to 8 of 8

Thread: indenting of numbering data

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2013
    Posts
    87

    indenting of numbering data

    hai all..

    i designed my data report and it shows similar like this
    Code:
    1. vbforums is good to solve 
    your problem
    what should i do to change the hanging text format like:
    Code:
    1. vbfourms is good to solve
        your problem
    Last edited by si_the_geek; Jan 22nd, 2013 at 04:08 PM. Reason: added Code tags to show indent

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: indenting of numbering data

    Welcome to VBForums

    Thread moved from the 'VB6 and Earlier' forum to the 'Reporting' forum

  3. #3
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,195

    Re: indenting of numbering data

    Make the number and the text two different controls.

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Jan 2013
    Posts
    87

    Re: indenting of numbering data

    ok i can make it two controls but it will give me numbering problem..how can i generate the numbers if they are seperated?

  5. #5
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,195

    Re: indenting of numbering data

    What is the datasource for this report? If it's a database table then you could add the number as a field in that table. You need to explain more about how you generate this report.

  6. #6

    Thread Starter
    Lively Member
    Join Date
    Jan 2013
    Posts
    87

    Re: indenting of numbering data

    I'm using ms access with vb6 and ADO. User will select the data randomly by using checkboxes. If I add a field for numbers, it won't produce the numbers in sequence. How can I generate the numbers automatically sequence.

  7. #7
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,195

    Re: indenting of numbering data

    As far as I know there is no way to auto increment a report object using the DataReport, haven't used it though for a long time. But, you can control the number field by code when you add records to the database. When you retrieve records from the database you would use "Order By" in the SQL statement. Are you using an ADO Recordset or dataEnvironment for the reports datasource. It would be helpful if you posted the code you using for generating the data for the report.

  8. #8

    Thread Starter
    Lively Member
    Join Date
    Jan 2013
    Posts
    87

    Re: indenting of numbering data

    Well I'm using DE as my report's data source. Here's my SQL code in DE :

    SELECT * FROM table1 WHERE Classroom like 'C%' ORDER BY NAME
    I can add numbers and order them. It's good if i want to show all of them but got problem if I just want to retrieve only several records. I want the numbers look like 1,2,3,4... till the end even I selected randomly records.

Posting Permissions

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



Click Here to Expand Forum to Full Width