Detail Segment iN Report show only one record

[tommy99]

Hello,

I have a simple report design with the fields taken from 2 different (free) tables. The first table (A) contains only one record and the values of this record is used to print the headings in the Page Header.

The second table (B) contains many records and the fields are placed in the detail segment of the Report design. When the report is previewed or viewed, it shows the fields in the header segment correctly, but it displays only the first record in the Detail segment from Table (B). It does not show the other records in the Table(B). What could be the reason. Any help will be appreciated.

 

[craigsboyd]

Make sure that table(b) is selected just before you run the report...

SELECT TableB
Report Form...blah blah blah

_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[tommy99]

I did write SELECT TABLE B but the same problem still appears.

The code is like this.

DEFINE WINDOW _REPDENODET FROM 2,8 TO 55,113 TITLE 'Report Preview' CLOSE FLOAT GROW ZOOM
ACTIVATE WINDOW _REPDENODET
SELECT _DENOFACTOR

REPORT FORM DENOMINATION_DETAIL PREVIEW IN WINDOW _REPDENODET
RELEASE WINDOW _REPDENODET

Should I send the Report design file ? As the Fields in the Page Header is shown using the single Record from TABLE A and the Fields in the Detail segment is shown using records from TABLE B (_DENOFACTOR)

I checked from Data Session Window and I could see all the records in the TABLE B.

 

[craigsboyd]

does your report have a dataenvironment? If it does make sure that the _denofactor is set as intially selected. Or, is there any functions called inside the report that could switch the selected data source. Also, which record is the one printed fron _denofactor? Is it the last record? Have you tried going to top of that data source? Grasping at straws, but it sounds like there is a different alias being selected somehow before or as the report runs. Otherwise _denofactor would be iterated in the detail section.

_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[tommy99]

Thanks. The problem is solved. The DataEnvironment had both the tables and I removed the first one (Table A) from it. Then it worked fine. Since the TABLE A is used only in Page Header and has only one record, it was not giving any problem as it is not part of the Data Environment.

Thanks again.