• Replies 3 replies
  • Subscribers 338 subscribers
  • Views 69 views
  • Users 0 members are here
Related

Infomaker-adding attribute to existing custom report

Kanani Reichlin
$organization

Hello,

I know this should be easy, but it's been too long since I've worked in Infomaker and the documentation leaves much to be desired.  I have a custom report which already has attributes in it.  I've added my new attribute to the stored procedure this report is using.  But I'm getting stuck on adding the new attribute as a field on the report.

I tried copying our kidcode attribute field in order to add this "covid-19 vaccine" field but I'm running into a validation error.  I'm hoping some kind soul can point out what simple trick I'm missing/forgetting.  Thanks!

  • $organization

    Hi Kanani,

    Just wondering - was your list of fields populated by the creation of the report referencing the stored procedure or did you add the field to the list manually? If it is the former I'm not sure I know the answer. If it is the latter, perhaps you've made the same mistake as I have in the past, in that the Dbname field isn't an exact match for the field in the SP returned data?

    Martin

  • $organization in reply to Martin Keen (Past Member)

    Hi Martin,

    I figured out where I went wrong...copying the existing attribute rather than Inserting a new column.  I wrote up some documentation if anyone else is looking for this answer in the future.

    • Find the stored procedure that this report is pulling data from. 
    • In the column specifications portion of the screen, right click and select “stored procedure”.   
    •  
    • Open SSMS from the Citrix window and find and modify the stored procedure. 
    • Databases>Impresario>programmability>stored procedures 
    • Right click and modify the stored procedure. 
    • In this instance, I am adding an attibute.  I know this report already has attributes on it, so I am going to copy the existing SQL code for an existing attribute and change the name and ID number for the new attribute. 
    • The order and name of the columns you add here are important.  The name should use underscores instead of spaces.  The column order in the stored procedure must match the column order in the infomaker column specification, so take note of the order when you add it to the stored procedure. 
    • Always do this in test first, especially if you are not familiar with SQL coding. 
    • I executed the modification that added the new attribute to the stored procedure.  Now I need to go back to Infomaker and add the field to the report. 
    • In the column specification area, right click and insert row, making sure add it in the same order that the column was added in the stored procedure.  Add the name of the new attribute, following the existing conventions. 
    • Then you will need to add the column to the design area of the report. 
    • Insert>control> column 
    • Click the location on the design window where you want the data to show up 
    • Choose the column name from the pop-up window. 
  • $organization

    Happy New Year Kanani,

    Glad you got it sorted!

    Martin