outputting one row in the dynamic report

[gdanalakshmi]

I got some code for generating a dynamic crosstab report.
I am able to see only one row in my report.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Dim intX As Integer

If Not mrstReport.EOF Then
If Me.FormatCount = 1 Then
For intX = 1 To mintColumnCount
Me("Col" + Format(intX)) = xtabCnulls(mrstReport(intX - 1))
Next intX

For intX = mintColumnCount + 2 To conTotalColumns
Me("Col" + Format(intX)).Visible = False
Next intX

mrstReport.MoveNext
End If
End If

End Sub

I found the sample code in the book was like the above.

How do I display all the reocrds in the report???

Do i have to write a function to do that???

 

[llkhoutx]

Cursory examination doesn't tell me what your code is doing.

Just use your cross-tab query as the recordsource for your report.
Pad you table with data for all columns before running the cross-tab query, then you always know how many columns you'll have. That's what I do so that all reports always look alike; some just have blank columns.