Active Reports 12 Parameter Bug

Active Reports 12 Parameter Bug

Posted by: connor.shepler on 23 July 2019, 4:52 am EST

• 

  connor.shepler

  • Post Options:
  • Link
    Copy

  Posted 23 July 2019, 4:52 am EST - Updated 30 September 2022, 8:32 am EST

  Within the Active Reports 12 I have two parameters within a report which accept an additional parent parameter of ‘StartDate’. When Selecting NULL for ‘StartDate’ the following parameters return the exception:

  “! Has outstanding dependencies”.

  Within the ‘Username’ and ‘Accession’ DataSets I have written the query to evaluate if ‘StartDate’ IS NULL or IS NOT NULL. This functions properly within Active Reports Designer Preview within this exception. It fails when run from Active Reports 12 Server as you can see in the screenshots.

  I have attached the ‘Username’ and ‘Accession’ parameter queries to this topic for further explanation.

  

  

  514×560 12.5 KB

  

• 

  connor.shepler

  • Post Options:
  • Link
    Copy

  Posted 23 July 2019, 6:08 am EST

  If you have other questions just ask!

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 23 July 2019, 5:47 pm EST

  Hello Connor,

  Could you please check with the attached report and see if the issue is also reproducible with the same?

  Also, please share the exact version of the ARS that you are using.

  In AR12S Sp3, some issues related to the null parameter were fixed. Could you please check with the latest build.
  
  http://cdn.grapecity.com/ActiveReports/ar12/hotfixes/ActiveReports12Server-v12.3.9686.0.exe
  
  http://cdn.grapecity.com/ActiveReports/ar12/hotfixes/ActiveReports-v12.3.17417.0.msi

  If the issue still exists, it is possible to share a demo report along with the database so that I can replicate the issue at our end.

  Thanks

• 

  connor.shepler

  • Post Options:
  • Link
    Copy

  Posted 23 July 2019, 10:55 pm EST

  I am using Active Reports 12 v 12.2.9198.0

  Also, I’m unable to see the report you have attached to your response.

  NOTE: The “! Has outstanding dependencies” Error does occur with the Report Designer Preview.

  BUT, after you move make a selection THEN move the selection BACK to NULL it works.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 23 July 2019, 10:58 pm EST

  Hello,

  Please find the attached report.
  
  Also, could you please check after installing the latest build.

  Thanks.

  rpt_CascadedParam.zip

• 

  connor.shepler

  • Post Options:
  • Link
    Copy

  Posted 24 July 2019, 12:25 am EST

  user id=qatester;data source=10.98.4.70;initial catalog=Northwind;password=qatesting;

  Fails to connect to SQL Server.

  The cascading parameters in your attached report are the exact same process I am following in my report.

  Can you confirm if my version of Active Reports v12.2.9198.0 has the known defect with NULL parameters?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 24 July 2019, 8:35 pm EST

  Hello Connor,

  This is also reproducible with the latest build. I have escalated the issue to our development team(274433) and will inform you once I get any information from them.

  Thanks.

• 

  connor.shepler

  • Post Options:
  • Link
    Copy

  Posted 25 July 2019, 1:24 am EST - Updated 30 September 2022, 8:27 am EST

  Thank you. I am waiting to hear back!

• 

  connor.shepler

  • Post Options:
  • Link
    Copy

  Posted 5 August 2019, 12:13 am EST

  Mohitg, do you have any update for me regarding this defect being resolved soon?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 5 August 2019, 1:47 am EST

  Hello Connor,

  I have asked the development team for an update.

  Thanks.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 5 August 2019, 3:00 pm EST

  Hello,

  As per the developer team, we will provide the hotfix in the next 2 weeks if any major problem not occurred.

  Thanks.

• 

  connor.shepler

  • Post Options:
  • Link
    Copy

  Posted 8 August 2019, 3:18 am EST - Updated 30 September 2022, 8:27 am EST

  Thank you for the update!

  Regards.

• 

  Sergey.Romanov

  

  • Post Options:
  • Link
    Copy

  Posted 15 August 2019, 5:58 pm EST

  Hello ,

  the issue with nullable cascading parameters was fixed for HTML5 Viewer.
  
  however, we found the same issue in WebDesigner preview, and developers team is still fixing it(ETA ~1+ week).
  
  please let me know if you want to get a hotfix without WebDesigner part.

  Thanks,
  
  Sergey Romanov.

• 

  connor.shepler

  • Post Options:
  • Link
    Copy

  Posted 23 August 2019, 5:48 am EST - Updated 30 September 2022, 8:27 am EST

  I’d like a hotfix for the HTML5 viewer!

  Any update to the ETA for the WebDesigner preview fix?

• 

  Sergey.Romanov

  

  • Post Options:
  • Link
    Copy

  Posted 26 August 2019, 1:45 am EST

  Hello ,

  here is a link to the hotfix for HTML5 Viewer:
  
  http://cdn.grapecity.com/ActiveReports/ar12/hotfixes/ActiveReports12Server-v12.3.9692.0.exe

  hotfix with the designer’s preview is on a way to QA team, so it should be ready in 2-3 days if QA tests will be passed successfully.

  Thanks,
  
  Sergey Romanov.

• 

  Sergey.Romanov

  

  • Post Options:
  • Link
    Copy

  Posted 28 August 2019, 5:57 pm EST

  Hello ,

  i apologize for the delay. QA and developers are busy with v13.2 release.
  
  i will post a link to the hotfix here as soon as it will be ready.

  Thanks,
  
  Sergey Romanov.

• 

  connor.shepler

  • Post Options:
  • Link
    Copy

  Posted 3 September 2019, 1:45 am EST

  Has the designer preview hotfix been completed as well now?

• 

  Sergey.Romanov

  

  • Post Options:
  • Link
    Copy

  Posted 3 September 2019, 5:07 am EST

  Hello ,

  i have to apologize one more time. there are the technical obstacles with the fix in WebDesigner.

  Thanks,
  
  Sergey Romanov.

• 

  Sergey.Romanov

  

  • Post Options:
  • Link
    Copy

  Posted 22 September 2019, 6:29 pm EST

  Hello ,

  the issue in WebDesigner’s preview has been fixed in the following hotfix:
  
  http://cdn.grapecity.com/ActiveReports/ar12/hotfixes/ActiveReports12Server-v12.3.9748.0.exe

  Thanks,
  
  Sergey Romanov.