1. 

   ajdjackson, Member

   Hi

   I've created a report with several tabs which the user can create an order (like selecting options for a car).

   I would like the last tab to be a summary of the their selections.

   I have defined that tab as : select 'dbr.tab', 'Summary','report.php?r=291&m=7&h=49641140304b8b7cf7fb05bc8c9479fdf85af87a&embedi=1';

   The report that this is calling is:

   CREATE PROCEDURE `sp_DBR_SS_Summary`(inPlotID varchar(25)) BEGIN

   select * from hilmark.tblss_orders where tblss_orders_PlotID = inPlotID;

   I am stuck as how I pass the inPlotID parameter in the url.

   The inPlotID parameter is the first parameter in the main tabbed report.

   Thanks again for your help.

   Jake
2. 

   myDBR Team, Key Master

   Jake,
   you can use format:

   select 'dbr.tab', 'Summary','sp_DBR_SS_Summary', inPlotID;

   --
   myDBR Team

Reply

You must log in to post.