dbr.sum in linked report - popup

(5 posts) (2 voices)
  • Started 4 years ago by ajdjackson
  • Latest reply from ajdjackson
  1. ajdjackson, Member

    Hi

    Strange one here.

    I have a simple linked report that contains a popup for drill-down functionality. The report contains a dbr.sum statement. The report runs as should when run directly ie the column sum is shown. However when the report is run a linked the report no sum appears. The rest of the report is correct.

    Also how do I hide the underscore from the link in the master report? I've tried

    select 'dbr.css', 'a.link {text-decoration: none;}'; select 'dbr.css', 'a.hover {text-decoration: underline;}';

    but this doesn't work.

    The linked report code is as follows:

    CREATE PROCEDURE sp_DBR_Grp_Bal_Detail(inCompID int, inNom int, inMon int, inYear int) BEGIN

    declare inEDate date;

    set inEDate = last_day(str_to_Date(concat(inYear,'-',inMon,'-01'),'%Y-%m-01'));

    /*select inCompID, inNom, inMon, inYear, inEDate;*/

    case inCompID

    when 1

    then

    select 'dbr.sum',3; select 'dbr.colstyle','Val','%0.0f';

    select a.Nominal_Code as 'Nominal[Nom]', c.name as 'Description[Desc]', sum(a.amount) as 'Value £[Val]' from hilmark.hilmark_journal a join hilmark.tblhilmark_coa b on a.nominal_code = b.tblhilmark_nominal join hilmark.hilmark_ledger c on a.nominal_code = c.account_ref where b.tblhilmark_coa_ref = inNom and a.Date <= inEDate group by a.Nominal_Code having round(sum(a.amount)) <> 0 order by 2;

    else

    select 'Finished';

    and the code calling this report is:

    select 'dbr.report','sp_DBR_Grp_Bal_Detail','[Val]','inCompID=CompID','inNom=Nom','inMon=(inMonNum)','inYear=(inYearNum)','popup';

    Thanks

    Jake

    Posted 4 years ago #
  2. myDBR Team, Key Master

    There is really no reason for the dbr.sum not to show up in a popup. Please double check your report and check using the JavaScript debugger that you are not hiding the summary row with CSS (likely in main report).

    To hide the undescrore from links use:

    select 'dbr.css', '.cell a {text-decoration: none;}';

    --
    myDBR Team

    Posted 4 years ago #
  3. ajdjackson, Member

    Hi

    You were right. DOH!

    I have the following in the main report:

    select 'dbr.css', '.summary_level0 {display:hidden}';

    as I wish to hide the grand total in the crosstab un that report.

    I have put the following into the linked report:

    select 'dbr.css', '.summary_level0 {display:block}';

    but this doesn't show the summary again :(

    Any thoughts?

    BTW the select 'dbr.css', '.cell a {text-decoration: none;}'; works great.

    Thanks

    Jake

    Posted 4 years ago #
  4. myDBR Team, Key Master

    Note that when you apply CSS to a report, the report is one webpage, so any generic CSS you apply, apply to all report elements. A popup report is embedded into the main report which makes it part of the webpage.

    The solution is to be more specific with your CSS. First give the report objject a class with dbr.resultclass:

    select 'dbr.resultclass', 'main_report_object';

    Then you can use CSS which is only for that object:

    select 'dbr.css', '.main_report_object .summary_level0 {display:none}';

    --
    myDBR Team

    Posted 4 years ago #
  5. ajdjackson, Member

    Hi

    Thanks.

    I twigged on to what I needed to do and thankfully it was the same as you suggested.

    What I was aware that the embedded elements were part of the same page.

    Cheers

    Jake

    Posted 4 years ago #

Reply

You must log in to post.