Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: subhankar pandey
  Where is subhankar pandey?
 Kolkata/Delhi
 India
 subhankar pandey
 Tags
Subject: RE: Same Record is displaying
Thread ID: 154517 Message ID: 154529 # Views: 1 # Ratings: 1
Version: Visual FoxPro 8 Category: Reports and Printers
Date: Monday, December 17, 2007 2:49:56 PM         
   


> Dear Experts
> Althought it is very confusing my report is not act as per my menthod, wud appreciate if anyone found the error !
>
> Tables hv two records but while in print preview mode only first record is displaying except INR figure fields, attached the report+table for more details.
>
> Pls help.
>
> regards
> Subhankar
> https://www.foxite.com/uploads/991e8160-8587-463d-9f8f-b5c3e76b265b.zip


Subhankar,

Why not use a report cursor? You use a SELECT statment to create the report cursor, leave the report's datasession as "default" and then just before you call the report,

SELECT MyTable1.Field1, MyTable1.Field2, ...,  MyTable2.Field1, MyTable2.Field2, ... ;
   FROM MyTable1 ;
   INNER JOIN MyTable2 ON MyTable1.FKField = MyTable2.PKField ;
   WHERE llSomeConditions ;
   ORDER BY SomeFields ;
   INTO CURSOR MyReportCursor
REPORT FORM MyReport TO PRINTER PROMPT PREVIEW
USE IN SELECT([MyReportCursor])  && don't need this anymore so get rid of it


This gives you a simple flat file, non-normalized cursor that contains all of the fields you need, it is filtered to contain only the records you need and is sorted in the order that you need for that report. You create your report off of your report cursor and it works a charm for you. It is often far easier to develop a report off of a single flat file cursor than it would be to set up the relations and filters. Also, because this is working off of it's own cursor, the report will not move the record pointers for your tables.

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

Same Record is displaying Posted by subhankar pandey @ 12/17/2007 1:17:41 PM
RE: Same Record is displaying Posted by Jojo Sabino @ 12/17/2007 2:07:02 PM
RE: Same Record is displaying Posted by Vladimir Zhuravlev @ 12/17/2007 2:11:18 PM
RE: Same Record is displaying Posted by Ken Murphy @ 12/17/2007 2:49:56 PM
RE: Same Record is displaying Posted by subhankar pandey @ 12/19/2007 5:48:06 AM
RE: Same Record is displaying Posted by subhankar pandey @ 12/19/2007 8:00:42 AM
RE: Same Record is displaying Posted by Ken Murphy @ 12/19/2007 2:16:35 PM
RE: Same Record is displaying Posted by subhankar pandey @ 12/20/2007 7:35:01 AM
RE: Same Record is displaying Posted by Ken Murphy @ 12/20/2007 1:40:12 PM