Using CUIC 9.0 or 10.5 for creation of custom UCCX reports.
- I've created a SQL Stored Proc, and a report template based around it.
- I then modify the SQL proc to add a new column. The new column doesn't show in the report.
- To get it to show, I have to edit the report definition; click 'create parameters' then 'create fields'.
- Doing this means I then have to redefine all my parameters and fields - names, types, formatting, summary rows etc etc.
- How can I add a new field that is returned by the SP to the CUIC report without rebuilding it in this way?
That is the only way to add a new field. The definition will retain your existing parameters, formatting, etc. etc., although the order of the parameters may shift - I always check them. Otherwise it's no big deal. Of course when you are done with the definition, you still need to go to the view and add the column there - when you open it, it will say that the definition has changed and automatically add your new field at the end of the columns, that may not be where you want it to go.
That's not my experience - hitting 'create parameters' blanks them all. Is that not normal?
I have a 9.x and 10.x CUIC that do the same.
I confess that I have not used stored procedures in reporting for a while. What I get with a SQL Query or Anonymous Block is after "Creating parameters" - and resetting their datatypes (which is lost), I hit "Create fields" and I get the behaviour I described above.
If I get some time today I'll play with a stored procedure and see what difference it makes.
Great - what I get is sort of the opposite. It can determine the datatypes of the params, but loses the display names, what was set as start/end time, etc. All fields lose any summary settings applied. Pain.