Create a column in RecordSet with the Record Count...

Hello

I'm reading a XML file and the next operation need a column with the row count.

I don't want to know how many rows there is in the recordset, but, the row count of each record.

How can I implement this?

tkx in advance
Paulo Aboim Pinto
Odivelas - Portugal

That issue was discussed here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1074253&SiteID=1

CR XI and VB6 prints some blank rows

I've been trying to move some more complex reports from VB DataReports to CR.

I have a CR report that is linked at runtime to a ADO recordset. Although the recordset has some NULL data, entire rows of information will come up blank. If I put in a null substitution in the fields, the substitution shows up. The correct number or rows are printed in the report, just some are blank.

Here some basic facts:
1. If I link to a VB6 DataReport, all data is displayed.
2. I setup a form with a listView to print out the exact recordset that I'm linking and all the data is present.
3. If I just run the query in SQL Enterprise Manager, it returns the correct data.
4. It's not random, it is always the same records (not matter how their selected) that show up blank.

Is there something that would tell CR to ignore a whole line if some or any of the values are null?Sorry...this appears to be a ADO issue...my mistake.

counting/looping through record sets

Hi,

I'm getting out of range errors when i populate an array (vbscript) from a recordset. It's because i don't fully understand the finer details i suppose.

intCount = 0
rs.moveFirst
Do while NOT rs.EOF
response.write rs.EOF
response.write intCount
intCount = intCount + 1
rs.moveNext
Loop

returns this:
False0False1False2False3False45

one too many!

thanks in advance!What is the error message?|||Originally posted by Satya
What is the error message?

There are 5 rows in the record set and it loops through 6 times. So my array has an out of range error.

sorry not to be clear. Der!