Hey ,
I have three different queries on one report .. Every query shows different result set.. Can i use 1 pager for every query? . So the report will show 3 tables each having its own pager.. Is it possible .? Because here is my code and it is showing only one pager for the first query:
DROP PROCEDURE IF EXISTS sp_DBR_prj_consolidated_report
$$
CREATE PROCEDURE sp_DBR_prj_consolidated_report(inLogin varchar(30))
BEGIN
select 'dbr.title','For Engagements';
select 'dbr.pager', 10;
select 'dbr.sum','Duration';
SELECT app_number AS 'Case Number', Engagements as Category, usernames as User, enteredOn as EnteredOn, Project, Product, Activity, Task, StartDate, DurationinMinutes as Duration, Org as Organization, Comments, WorkMode
FROM timesheets.salman
where Engagements='Engagements'
and usernames like CONCAT('%', inLogin, '%');
select 'dbr.title','For Efforts Entered';
select 'dbr.pager', 10;
select 'dbr.sum','Duration';
SELECT app_number AS 'Case Number', Engagements as Category, usernames as User, enteredOn as EnteredOn, Project, Product, Activity, Task, StartDate, DurationinMinutes as Duration, Org as Organization, Comments, WorkMode
FROM timesheets.salman
where Engagements='Efforts Entered'
and usernames like CONCAT('%', inLogin, '%');
select 'dbr.title','For Internal Tracker';
select 'dbr.pager', 10;
select 'dbr.sum','Duration';
SELECT app_number AS 'Case Number', Engagements as Category, usernames as User, enteredOn as EnteredOn, Project, Product, Activity, Task, StartDate, DurationinMinutes as Duration, Org as Organization, Comments, WorkMode
FROM timesheets.salman
where Engagements='Internal Tracker'
and usernames like CONCAT('%', inLogin, '%');
END
$$
Please help.. Thanks
