-
Jan 21st, 2013, 07:26 AM
#1
Thread Starter
Lively Member
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
-
Jan 22nd, 2013, 04:09 PM
#2
Re: indenting of numbering data
Welcome to VBForums
Thread moved from the 'VB6 and Earlier' forum to the 'Reporting' forum
-
Jan 22nd, 2013, 05:05 PM
#3
Re: indenting of numbering data
Make the number and the text two different controls.
-
Jan 23rd, 2013, 09:51 PM
#4
Thread Starter
Lively Member
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?
-
Jan 24th, 2013, 01:29 PM
#5
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.
-
Jan 25th, 2013, 12:14 PM
#6
Thread Starter
Lively Member
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.
-
Jan 25th, 2013, 04:39 PM
#7
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.
-
Jan 25th, 2013, 09:15 PM
#8
Thread Starter
Lively Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|