Concatenate multiple columns in a report
I've a report where I want to also create some charts where on horizontal axis I want to show year,quarter, month, week of year as four fields to be concatenated separated by comma.
Is there any built in way to do that. Or should I have a virtual table and manage it using SQL. BTW, maybe unusual, but I want the same report version work error free on both Oracle and SQL Server.
Let me know if you need anything for this.
BMC Software, India