Add static data to some of the columns in an excel report
17:35 May 22, 2025
Hi Community,
We have a case where we are using excel reports that will output an excel that has data about order lines and need some fields to be generated dynamically and others to be static
For the dynamic fields it is easy, but for the static fields does any one have any idea on how to implement it?
One that is not adding one field in the order lines object per column in the excel report(this is the only solution I can think of now and it is not a very good one)
Thanks,
Luis
Like
1 comments
20:43 May 22, 2025
You could add some bogus column and then in the template use a formula to replace it with some static value. Either that or use a database view for the report and have the static values there. Not sure it’s possible without something like that.
Ryan
Show all comments