Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Have the SQL queries in eastern Europe make structural Expression Builder (JavaScript)?
cmbr25
Can anyone help me in that sense, I'm ready with a function that returns the frequencies of students from all disciplines of a class and must now be returned in the correct dates of birt frequencies only the discipline and I have a problem returning the crosstab any time the two months to list all disciplines and I'm usuando the page break to separate the disciplines. Now able to filter the dataset refers only to bring the disciplines that passes through an in, but I can not pass these disciplines statically now need to get the codes of the subjects of the table, for each school year the codes change.
I help my friends collaborators.
Find more posts tagged with
Comments
CBR
Hi,
trying to understand what you want to achive:
From all i understand you have set up a database stored procedure that return the frequencies of students from all disciplines of a class (not sure what you mean by fequencies but that shouldn't make a difference).
Now you want to set a filter that only shows frequencies you are interested in...is that correct?
You now want to know how to let the user select one of the frequencies and how the value choosen by the user can be used in the stored procedure to only return the appropriate frequencies?
cmbr25
<blockquote class='ipsBlockquote' data-author="'cbrell'" data-cid="85564" data-time="1321903389" data-date="21 November 2011 - 12:23 PM"><p>
Hi,<br />
<br />
trying to understand what you want to achive:<br />
From all i understand you have set up a database stored procedure that return the frequencies of students from all disciplines of a class (not sure what you mean by fequencies but that shouldn't make a difference).<br />
<br />
Now you want to set a filter that only shows frequencies you are interested in...is that correct?<br />
You now want to know how to let the user select one of the frequencies and how the value choosen by the user can be used in the stored procedure to only return the appropriate frequencies?<br /></p></blockquote>
<br />
<br />
<br />
often a student would be the student's attendance status P - Present and F - False.
cmbr25
<blockquote class='ipsBlockquote' data-author="'cmbr25'" data-cid="85566" data-time="1321903861" data-date="21 November 2011 - 12:31 PM"><p>
<br />
<br />
often a student would be the student's attendance status P - Present and F - False.<br /></p></blockquote>
<br />
<br />
<br />
What I need is that when the user selects the next page (I use the page break - to switch the data on the presence of students by discipline) is dynamically passed the course code for that page only appears that the data subject . How to do this using the disciplines that already have in my dare query the function that gets created in postgres table courses directly. I ask this because if I tell the codes of the separate disciplines in the filter dataset report is displayed correctly, getting it wrong over all disciplines through an "in" (8,18,20,27).<br />
<br />
Portuguese:<br />
O que eu preciso ? que quando o usu?rio selecionar a pr?xima pagina ( eu uso o page break - para alternar os dados dos alunos com as presen?as por disciplina) seja passado dinamicamente o codigo da disciplina para que naquela pagina seja exibida somente os dados daquela disciplina. Como fazer isso utilizando as disciplinas que ja tenho na minha consulta atreves da funcao criada no postgres que pega direto da tabela de disciplinas. pergunto isso por que se eu informo os c?digos das disciplinas separamente no filtro do dataset o relatorio ? exibido corretamente, ficando errado se passar todas as disciplinas atraves de um "in" (8,18,20,27).