1. 

   stefx, Member

   Hi to all, why don't appear the incon with a link to a detailed report?
   Thanks a lot
   Stefano

   DROP PROCEDURE IF EXISTS sp_DBR_AL_SCUOLA
   $$
   CREATE PROCEDURE


   _

   ( anno2 int, istituzioni int)
   BEGIN

   select 'dbr.report','sp_DBR_AL_SCUOLA_DETT','anno_sel=2002','id_ist=1';
   select 'dbr.count', 2;

   select
   i.ISTITUZIONE_DESCRIZIONE as 'Istituzione',
   count(*) as 'Totale alunni'
   from osp.indicatori_completo i
   where anno = anno2 and (i.ISTITUZIONE_ID = istituzioni or istituzioni = 0)
   group by i.ANNO, i.ISTITUZIONE_DESCRIZIONE
   order by ISTITUZIONE_DESCRIZIONE;

   END
   $$
2. 

   stefx, Member

   I've edit the SP, but this is what an user see: http://www.ddmo.it/link-report.jpg
   Hte first column should be hidden and don't appear the report link icon.

   DROP PROCEDURE IF EXISTS sp_DBR_AL_SCUOLA
   $$
   CREATE PROCEDURE


   _

   ( anno2 int, istituzioni int)
   BEGIN

   select 'dbr.report', 'sp_DBR_AL_SCUOLA_DETT','anno_sel=-1','id_ist=1';
   select 'dbr.count', 3;
   select 'dbr.hidecolumns', 1;

   select
   i.ISTITUZIONE_ID,
   i.ISTITUZIONE_DESCRIZIONE as 'Istituzione',
   count(*) as 'Totale alunni'
   from osp.indicatori_completo i
   where anno = anno2 and (i.ISTITUZIONE_ID = istituzioni or istituzioni = 0)
   group by i.ANNO, i.ISTITUZIONE_DESCRIZIONE
   order by ISTITUZIONE_DESCRIZIONE;

   END
   $$
3. 

   stefx, Member

   Ok, I see correctly in administration mode, but from the public url for I don't see the link (as unlogged user)
   Thanks!
   Stefano
4. 

   myDBR Team, Key Master

   I've edit the SP, but this is what an user see: http://www.ddmo.it/link-report.jpg

   Do you have the report using sp_DBR_AL_SCUOLA_DETT-procedure defined inside myDBR and has the user access rights to the report? Other than that your report looks just fine.

   Hte first column should be hidden and don't appear the report link icon.

   Just place the columns to be hidden at the end of the column list.

   --
   myDBR Team

Reply

You must log in to post.