1. 

   bushraj, Member

   Hey,

   I have created the connected paramter report. The first parameter Team is dependent on second parameter User..

   First SP is

   'DROP PROCEDURE IF EXISTS sp_DBR_UserWise_Support
   $$
   CREATE PROCEDURE sp_DBR_UserWise_Support(Severity varchar(50),Team varchar(50),User varchar(50))

   begin

   SELECT u.Usr_username as Users ,c.con_value as Tasks

   FROM wf_frmwrk.tps_team_sla1 s,wf_workflow.users u,wf_workflow.content c
   where Team ='Professional Support'
   and s.User=u.Usr_uid
   and( s.SeverityLevel = Severity or Severity='All')
   ;
   end
   $$'

   And for second parameter i have created the sql parameter

   select 'All'
   union
   SELECT usr_username FROM wf_workflow.users where usr_status ='Active' ;

   SELECT distinct(u.usr_username) as username FROM wf_frmwrk.tps_tbl_userwise_master m ,wf_workflow.users u
   where m.usr_uid=u.usr_uid
   and m.Team = mydbr_param2

   Now it is changing the users but only showing blank checkboxes without the user name .

   What I m doing wrong here.. do help please

   Regards,
   Bushra
2. 

   myDBR Team, Key Master

   Try to use format:

   select ID, Visible_value
   from myparam

   in the parameter queries when you use connected parameters.

   --
   myDBR Team
3. 

   bushraj, Member

   Hey ..

   The connected parameters are showing in radio button form .. I want in popup or combo box. In parameters i have already choosen popup but it is still showing in radio button . Why is that?

   Awaiting for your reply
4. 

   myDBR Team, Key Master

   Please check the parameter type from the Parameter queries.

   --
   myDBR Team
5. 

   bushraj, Member

   Parameter type is Popup but still showing radio buttons.
6. 

   myDBR Team, Key Master

   That should not be the case, so you might want to recheck the parameter definition. If you continue to have a problem, please send screenshots of your report and parameter definitions to support.

   --
   myDBR Team
7. 

   bushraj, Member

   How we can use All option in connected parameters like selecting 'All' from one parameters and then the other dependent parameters changes to 'All'. Over here by All i mean select all records ..

   Regards,
   Bushra
8. 

   myDBR Team, Key Master

   If you plan to put All selection into a connected parameter, it probably would be easier just to return one 'All' record from the connected parameter. This way you could handle even the situation where there is more than one level in connected parameter.

   --
   myDBR Team
9. 

   bushraj, Member

   How can i do that using parameter queries? Any example..?
10. 

    myDBR Team, Key Master

    If user selects 'All' selection from first popup, return 'All' to next popups and handle the ID for 'All' inside the report.

    --
    myDBR Team
11. 

    bushraj, Member

    For first pop i have created this parameter

    Select 'All', 'All'

    union

    SELECT org_id,Organization FROM wf_workflow.tps_lut_organizations where IsActive='1' order by 1

    For second pop up i have created this proc..

    DROP PROCEDURE IF EXISTS sp_DBR_sup_proj
    $$
    CREATE PROCEDURE sp_DBR_sup_proj(mydbr_param1 varchar(35))
    begin

    if (mydbr_param1='All') then

    Select 'All','All';
    else

    SELECT distinct t.Prj_ID,p.Project_Call_ID FROM timesheets.tps_trans_effort_timeline t ,timesheets. tps_lut_projects p
    where t.prj_ID=p.prj_ID
    and p.org_id=mydbr_param1;

    END IF;
    end
    $$

    Now whats wrong how can i call this procedure for second popup?
12. 

    myDBR Team, Key Master

    Looks ok to us.

    --
    myDBR Team
13. 

    radhey_krish, Member

    Hello myDBR team,

    How can I make multiple select items in a single popop?
14. 

    radhey_krish, Member

    I am still waiting for your response of previous queries.
15. 

    myDBR Team, Key Master

    Popups are for selecting single elements. Use checkboxes for selecting multiple entries.

    --
    myDBR Team
16. 

    radhey_krish, Member

    Thanks for letting me know

Reply

You must log in to post.