TppReportExplorer and TppDesinger save as problem
Hi, I has a doubt.
1. I open a report using BtnDesignClick method which is "Stock Info". and
than I save it as "Stock Info 2". After Than I press btnLaunchClick. But
the exproler did not display "Stock Info 2".
2. So I decide open "Stock Info" on Explorer and save it as "Stock Info 3".
The report can preview fine. However If I open it using BtnDesignClick
with the report as "Stock Info 3".It show a error "cannot generate report.
cound not open dataset : xxxxx"
What should I do?
ps : I using SDAC 2.45.2.28 with MSDE 2000 ,Report Builder Pro 7.03 and
Delphi 7 Ent 4.453
procedure TmyEndUserSolution.BtnDesignClick(Sender: TObject);
begin
RptRunTime.Template.DatabaseSettings.Name:='Stock Info';
RptRunTime.Template.LoadFromDatabase;
RptRunTime.Template.SaveTo:=stDatabase; //Save To Database
DesignerRunTime.DataSettings.AllowEditSQL:=True;//allow change DATA
Source SQL
DesignerRunTime.ShowModal;
end;
procedure TmyEndUserSolution.btnLaunchClick(Sender: TObject);
begin
If Not(ppReportExplorer.Execute) Then
Begin
pnlStatusBar.Caption := 'Error: ' +
ppReportExplorer.ErrorMessage;
MessageBeep(0);
End
Else
pnlStatusBar.Caption := 'Explorer Launch Successful.'
end;
1. I open a report using BtnDesignClick method which is "Stock Info". and
than I save it as "Stock Info 2". After Than I press btnLaunchClick. But
the exproler did not display "Stock Info 2".
2. So I decide open "Stock Info" on Explorer and save it as "Stock Info 3".
The report can preview fine. However If I open it using BtnDesignClick
with the report as "Stock Info 3".It show a error "cannot generate report.
cound not open dataset : xxxxx"
What should I do?
ps : I using SDAC 2.45.2.28 with MSDE 2000 ,Report Builder Pro 7.03 and
Delphi 7 Ent 4.453
procedure TmyEndUserSolution.BtnDesignClick(Sender: TObject);
begin
RptRunTime.Template.DatabaseSettings.Name:='Stock Info';
RptRunTime.Template.LoadFromDatabase;
RptRunTime.Template.SaveTo:=stDatabase; //Save To Database
DesignerRunTime.DataSettings.AllowEditSQL:=True;//allow change DATA
Source SQL
DesignerRunTime.ShowModal;
end;
procedure TmyEndUserSolution.btnLaunchClick(Sender: TObject);
begin
If Not(ppReportExplorer.Execute) Then
Begin
pnlStatusBar.Caption := 'Error: ' +
ppReportExplorer.ErrorMessage;
MessageBeep(0);
End
Else
pnlStatusBar.Caption := 'Explorer Launch Successful.'
end;
This discussion has been closed.
Comments
The report explorer displays the folders and items stored in the rbFolders
and rbItems tables. The rbItem table has a structure of Item_ID, Folder_ID,
Item_Name, Item_Type plus some additional fields. These are populated and
managed by the report explorer.
To programmatically stored and load reports to the rbItems table, see the
Templates thread of the Tech Tips newsgroup for an article titled Load
Reports Stored by the Report Explorer.
--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com