Joined: 05 Nov 2007
Online Status: Offline
Posts: 1
Topic: viewing 2 records from a recordset. Posted: 05 Nov 2007 at 7:50am
I'm using crystal reports 11 with VBA and sql 2000. I'm sending 2 records or 2 rows of data to a report using a recordset which has formulas and ole images in it and subreports. What I want the report to do is display the data from the first record on the top of the report and the data from the second record underneath so its like 2 reports in 1 but different data. When I try this what happens is the first record is used for both parts of the report so its duplicated only using the first record. I've tried using mailing label wizard since it seemed like you can set the amount of records down but this only shows me the top report and it doesn't show the next record at all even though section expert tells me that its a 1 across pages and 2 down pages. If anyone has a solution it would be greatly appreciated I can provide the reports if my description isn't clear enough. Thanks in advance.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum