Html button creation from sql result (2 rows)

[aolmo]

Hi all,

I need to create 2 buttons, but this button have to be the current year and the last year.  I have a query in report studio that show result (now) 2015, 2014.  I need the html code to create button from this result.

Can anyone help me?

Thanks.

[technomorph]

Assuming you're trying to populate the cells of a list, and if I've understood your question correctly, you can unlock the list, drop an html item into one of the columns, set the Source Type to Report Expression and use something like this:

'<button type="button">' + [Query1].[YEAR] + '</button>'