Problem with FR 3.19
Hi, NEED HELP!
i have many stupid problems with FR 3.19x. I would like to create a complex
report with big page header that contains tow sub-reports which should be
print data from diffrent tables. A header band (horizontal) that contains two
vertical(cross data) bands that print heading from driffrent db tables.
Last but not least the master data band (horizontal) that contains the same two vertical (cross data) bands to print the data from the other tables. The data
comes from TFRXADO components (built in data connections) to MS SQL Server.
for example
->->->- Cross Band ->-> -> Cross Band ->
Hhead1 Hhead2 | Vhead1 Vhead2 Vhead3 | Hhead3 | Vhead4 Vhead5 | Hhead5
Hdata1 Hdata2 | Vdata1 Vdata2 Vdata1 | Hdata3 | Vdata4 Vdata5 | Hdata5
...
-- Footer .....
Free-Report support only one vertical cross band - ok that has been worked
with the one - BUT FR 3.19 tells me three times 'Incorrect band position: xxx'
The band that reported is:
1.) detail data band from subreport 1
2.) detail data band from subreport 2
3.) master data band from main report (that's with the two vertical cross bands)
What's wrong ? I need a solution in a short time.
The other Problem:
- Tha master / detail tables won't be completly opened by detail -> master resolving on load time.
- The property 'IndexFields' of a detail table are incorrectly
set by designer. I've fixed the bug - where can i post the fix ? :-)
unit frxDBSet;
procedure TfrxDBDataset.Open;
procedure openMasterAndDetailDS(ds: TDataSet);
begin
if ds.DataSource <> nil then
if ds.DataSource.DataSet <> nil then
openMasterAndDetailDS(ds.DataSource.DataSet);
if not ds.Active and OpenDataSource then
ds.Open;
FInitialized := True;
end;
begin
....
if FInitialized then
Exit;
openMasterAndDetailDS(FDS);
...
end;
i have many stupid problems with FR 3.19x. I would like to create a complex
report with big page header that contains tow sub-reports which should be
print data from diffrent tables. A header band (horizontal) that contains two
vertical(cross data) bands that print heading from driffrent db tables.
Last but not least the master data band (horizontal) that contains the same two vertical (cross data) bands to print the data from the other tables. The data
comes from TFRXADO components (built in data connections) to MS SQL Server.
for example
->->->- Cross Band ->-> -> Cross Band ->
Hhead1 Hhead2 | Vhead1 Vhead2 Vhead3 | Hhead3 | Vhead4 Vhead5 | Hhead5
Hdata1 Hdata2 | Vdata1 Vdata2 Vdata1 | Hdata3 | Vdata4 Vdata5 | Hdata5
...
-- Footer .....
Free-Report support only one vertical cross band - ok that has been worked
with the one - BUT FR 3.19 tells me three times 'Incorrect band position: xxx'
The band that reported is:
1.) detail data band from subreport 1
2.) detail data band from subreport 2
3.) master data band from main report (that's with the two vertical cross bands)
What's wrong ? I need a solution in a short time.
The other Problem:
- Tha master / detail tables won't be completly opened by detail -> master resolving on load time.
- The property 'IndexFields' of a detail table are incorrectly
set by designer. I've fixed the bug - where can i post the fix ? :-)
unit frxDBSet;
procedure TfrxDBDataset.Open;
procedure openMasterAndDetailDS(ds: TDataSet);
begin
if ds.DataSource <> nil then
if ds.DataSource.DataSet <> nil then
openMasterAndDetailDS(ds.DataSource.DataSet);
if not ds.Active and OpenDataSource then
ds.Open;
FInitialized := True;
end;
begin
....
if FInitialized then
Exit;
openMasterAndDetailDS(FDS);
...
end;