1. 

   JMitchell, Member

   I am trying to write a popup parameter query but it wont save past a certain letter count... how can work around this?

   here's what i want my query to be:

   select 'thismonth', 'This Month'
   union
   select 'lastmonth', 'Last Month'
   union
   select 'custom', 'Custom - Enter start and end dates'
   union
   select 'thisyear', 'This Year'
   union
   select 'quarter1', 'First Quarter'
   union
   select 'quarter2', 'Second Quarter'
   union
   select 'quarter3', 'Third Quarter'
   union
   select 'quarter4', 'Fourth Quarter'

   when i save the query this is what saves:

   select 'thismonth', 'This Month'
   union
   select 'lastmonth', 'Last Month'
   union
   select 'custom', 'Custom - Enter start and end dates'
   union
   select 'thisyear', 'This Year'
   union
   select 'quarter1', 'First Quarter'
   union
   select 'quarter2', 'Sec
2. 

   myDBR Team, Key Master

   You can also use procedures in parameter queries.

   --
   myDBR Team
3. 

   JMitchell, Member

   ok ill try it out and let you know it goes :)
4. 

   JMitchell, Member

   How can i pass the parameters here is my sp:

   DROP PROCEDURE IF EXISTS sp_DBR_timeframedr
   $$
   CREATE PROCEDURE sp_DBR_timeframedr()
   BEGIN

   select 'thismonth', 'This Month'
   union
   select 'lastmonth', 'Last Month'
   union
   select 'custom', 'Custom - Enter start and end dates'
   union
   select 'thisyear', 'This Year'
   union
   select 'quarter1', 'First Quarter'
   union
   select 'quarter2', 'Second Quarter'
   union
   select 'quarter3', 'Third Quarter'
   union
   select 'quarter4', 'Fourth Quarter';

   END
   $$

   here is the parameter query:

   call database.sp_DBR_timeframedr()
5. 

   myDBR Team, Key Master

   When you use a procedure in parameter queries, simply specify the procedure name in parameter queriers. Also, you might want to avoid the 'sp_DBR' prefix as it is the default for reports itself. Just use something else (sp_par_XXX).

   The parameters you can pass to parameter query itself are the inLogin (for recognizing the user) and mydbr_paramX (for linked parameters).

   --
   myDBR Team

Reply

You must log in to post.