Design at runtime

Design at runtime

Posted by: jorgebastos on 14 September 2017, 6:55 pm EST

• 

  jorgebastos

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 September 2017, 6:55 pm EST

  [activereports_archive]Hi,

  I’d like to evaluate AR v9, to insert design at runtime to my application, but in the samples can’t find anything that has what I need, so my question is:

  Is it possible to produce an example of design at runtime with the following:

  • save the reports in the DB
  • the sample has to be with mysql, since the DB I use for all my APPS it’s MySQL (No MSSQL here!)

  Thanks in advanced,
  
  Jorge Bastos[/activereports_archive]

• 

  jorgebastos

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 6:55 pm EST

  [activereports_archive]Forgot to say, if you want I can provide a remote mysql server to provide a live sample.
  
  Just in case C1 tech’s don’t have access to one of.[/activereports_archive]

• 

  sankalps

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 6:55 pm EST

  [activereports_archive]Jorge,

  You can check out the following link for a walkthrough on creating report layouts at runtime:
  
  http://helpcentral.componentone.com/netHelp/AR9/arWLKRunTimeLayouts.html

  Once you have the layout set up in code, you can save the layout using the SaveLayout method:
  
  http://helpcentral.componentone.com/netHelp/AR9/SaveandLoadReportLayoutFilesRPX.html

  Since you wish to save the layout in MySql database, you may try saving it as an XMLDocument and add it to the database column. A generic sample code can be found here:
  
  http://blogs.componentone.co.in/2011/11/04/saving-to-and-loading-a-report-layout-from-database/

  This is not directly related to MySql but should give some idea on how to approach it.

  Regards,
  
  Sankalp[/activereports_archive]

• 

  mysql.jorge

  • Post Options:
  • Link
    Copy

  Posted 29 December 2017, 7:30 am EST

  Howdy,

  I’m returning to this matter, didn’t checked when you posted.
  
  The link you posted for the sample its not working.

  Could you post a sample for design at runtime, for MySQL (not MSSQL), using ado.net directly?
  
  I mean:

  dim con as new mysqlconnection(CS)
  
  con.open
  
  sql=" select * from tblname"
  
  dim cmd as new mysqlcommand(sql,con)

  etc
  
  etc
  
  etc

  Is it possible?
  
  I have an old ARv6 Pro version and i want to upgrade, but have to be sure that AR has this feature to work with MySQL.

  Thanks in advanced,

• 

  mysql.jorge

  • Post Options:
  • Link
    Copy

  Posted 4 January 2018, 4:37 pm EST

  Hi,

  Sorry to pressure, is it possible to reply?

• 

  mysql.jorge

  • Post Options:
  • Link
    Copy

  Posted 21 March 2018, 2:27 pm EST

  Hi,

  I need to regain control in this subject.
  
  Can you please reply?