hai all..
i designed my data report and it shows similar like this
what should i do to change the hanging text format like:Code:1. vbforums is good to solve
your problem
Code:1. vbfourms is good to solve
your problem
Printable View
hai all..
i designed my data report and it shows similar like this
what should i do to change the hanging text format like:Code:1. vbforums is good to solve
your problem
Code:1. vbfourms is good to solve
your problem
Welcome to VBForums :wave:
Thread moved from the 'VB6 and Earlier' forum to the 'Reporting' forum
Make the number and the text two different controls.
ok i can make it two controls but it will give me numbering problem..how can i generate the numbers if they are seperated?:confused:
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.
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.
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.
Well I'm using DE as my report's data source. Here's my SQL code in DE :
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.Quote:
SELECT * FROM table1 WHERE Classroom like 'C%' ORDER BY NAME