Hello
I am trying to create report using Active Link table.I am using MS SQL Server Database.According to the help I have the following the code in Activate Event of Dialog component:
reports = <<%text%
ShoppingCart|Rpt_ShoppingCart@[PathAlias.ADB_Path]\Rpt_ShopCartDetails.DDD
%text%
In After Validate Event :
contacts = alltrim(CurrentForm.Controls.ContactList)
report = alltrim(CurrentForm.Controls.ReportList)
dim filter as c
dim order as c
Filter = ".T."
Order = "Item_id"
Dim filename as c
filename = session.session_folder + "tempreport.pdf"
filename = report.saveas(report,"pdf",filter,order,filename,.f.)
if file.exists(filename)
currentform.RedirectTarget = session.session_url + "tempreport.pdf?" + time("hms3")
end if
But when i run it i get the following error:
Errors in: event.AfterValidate code:
Amyuni Low Level Print:
Layout name: Rpt_ShoppingCart@[PathAlias.ADB_Path...artDetails.DDD
Layout type: report
Report not found: 'Rpt_ShoppingCart@[PathAlias.ADB_Path]\Rpt_ShopCartDetails.DDD'.
Here Rpt_ShopCartDetails.DDD is the Active link table and Rpt_ShoppingCart is the Report Name.
And Rpt_ShopCartDetails.DDD file exists in the Application[PathAlias.ADB_Path] folder.
Please anyone help me to solve this problem...
Thnx in Advance...
I am trying to create report using Active Link table.I am using MS SQL Server Database.According to the help I have the following the code in Activate Event of Dialog component:
reports = <<%text%
ShoppingCart|Rpt_ShoppingCart@[PathAlias.ADB_Path]\Rpt_ShopCartDetails.DDD
%text%
In After Validate Event :
contacts = alltrim(CurrentForm.Controls.ContactList)
report = alltrim(CurrentForm.Controls.ReportList)
dim filter as c
dim order as c
Filter = ".T."
Order = "Item_id"
Dim filename as c
filename = session.session_folder + "tempreport.pdf"
filename = report.saveas(report,"pdf",filter,order,filename,.f.)
if file.exists(filename)
currentform.RedirectTarget = session.session_url + "tempreport.pdf?" + time("hms3")
end if
But when i run it i get the following error:
Errors in: event.AfterValidate code:
Amyuni Low Level Print:
Layout name: Rpt_ShoppingCart@[PathAlias.ADB_Path...artDetails.DDD
Layout type: report
Report not found: 'Rpt_ShoppingCart@[PathAlias.ADB_Path]\Rpt_ShopCartDetails.DDD'.
Here Rpt_ShopCartDetails.DDD is the Active link table and Rpt_ShoppingCart is the Report Name.
And Rpt_ShopCartDetails.DDD file exists in the Application[PathAlias.ADB_Path] folder.
Please anyone help me to solve this problem...
Thnx in Advance...
Comment