Show variables in report header

[HGrigsby]

Hi

In Supportworks I used to add a header to my reports to show the variables selected, for example

"Logged between &[uv_argf1] and &[uv_argt1] " to show the date range I had run my report over, or any other variable such as team or department, analyst or team.

Is there a way of doing the same in service manager reports, it was a really useful when you have a lot of the same reports to run for different departments.

Helen

　

[NeilWJ]

Hi Helen,

While we don't support this right now I don't think this will be a problem to add. I will have a chat to api server team and see what we can do.

Cheers

[HGrigsby]

Thank you - it would be great if we could have the feature back!

[HGrigsby]

@NeilWJ - is there any update on this - it would be so handy, we have loads of reports that would really benefit from this.

[NeilWJ]

Hi Helen,

I did ask and it was agreed it could be done. However we went through a recent phase of completely changing report delivery and the introduction of scheduling and it appears, unfortunately, that this got left behind.

With the introduction of scheduling it really needs to be done as it would make sense in the title to be able to refer to the scheduled date/time report is setup to use. I will speak to api team tomorrow and try get this put into development asap.

Thanks

Neil

[HGrigsby]

Thanks @NeilWJ

It would really help us out if we could have this soon.

thanks

Helen

[NeilWJ]

@TrevorKillick   Can we co-ordinate this week to get this done. I can't see it being much effort as per my suggestion in reporting workspace.

Cheers

[TrevorKillick]

@NeilWJ @HGrigsby

Platform support for expanding variables in the report title as well as the report name used for the file name will be available in next Platform Release, when this is available i will post back hopefully should be the next week or two. 

Neil is also adding support to the Report Builder User Interface to allow you to set the value of the runtime arguments to a more friendly name, this should be available before the platform release. 

Kind Regards

Trevor Killick

[HGrigsby]

@NeilWJ @TrevorKillick

Hi Both

Has this feature been released yet?  If so how do I use it?   I am sure I saw it in a release note somewhere!

Could you let me know?

Thanks Helen

[Victor]

@HGrigsby yes, it has been deployed. For each filter that comes from a user prompted value you can now define a variable reference:

You can then use this variable reference in the report title (for example) using this format: &[<variable_reference>]. Looking at my example above that woudl be &[abc].

[HGrigsby]

Thanks Victor

I've got it to work to show if I use the Date logged is greater than it displays

IT Tickets by Source - Logged After 2018-07-01 00:00:00

Is it possible to get it to do any of the following -

• Format the heading so that it shows date only? 
• Use with a between date field?
• have more than one, for example be able to show the date and the team?
• use it in reports that don't need user to select a value - scheduled?

Helen

 

 

[Kevin Kennedy]

I see that this topic is several years old.  As a Hornbill neophyte, this doesn't seem to be working for me.  I have tried a number of different combinations to inject the current date into a report title, without success.  Or suggest an area of the Wiki to read that will help?

 

[Victor]

@Kevin Kennedy welcome!

Can you detail (and, if you have, some screenshots) on what you are trying to achieve?

[Kevin Kennedy]

 

Victor -

Thank you for the rapid response.  We are just switching to Hornbill Service Management, and I have not yet had any training on reporting.  I have managed to figure out the fundamentals on my own, but some of the details elude me.  For my reports, I would like to have the run date added to the end of the Title to show on the report (see above)contents, so that if someone has a printed copy, they are able to tell how long ago the report was run.  I have tried several methods to inject the date into this title, without success.

[Victor]

2 hours ago, Kevin Kennedy said:

I would like to have the run date added to the end of the Title to show on the report

@Kevin Kennedy right, I understand what you need. But I'm afraid it is not possible unless, you have a filter with a user prompted value in which you type in the run date. Meaning, when you run the report, you will be presented with a popup where you can input a value which will be used in the report filter, for example, all request raised before [you type in the date here].

But just having a variable that puts the today date in there, I'm afraid that we don't have. I will point developers to this thread perhaps they can add something in the reporting engine to include the date run in the generated report files.

[LouiseT]

+1

We'd find this very useful.

[Kevin Kennedy]

I'm also assuming that the variable cannot be a user prompted date range.  Here is how I set up the filter.

Note the Variable Reference is usdr, for user specified date range.  set up the report heading like I thought it should be:

However, when I run the report, I get the following:

 

Which, I will admit, is a very pretty chart, but has failed to translate the date range into the title.

 

Any guidance as to how to do this properly?

 

 

[Kevin Kennedy]

@Victor@James Ainsworth Thanks to @Yodit for inspiring a solution to my problem regarding the inclusion of "between user specified dates" in report titles.  Whilst she was writing a quick report to troubleshoot a problem, she offhandedly mentioned that she could instead of using the double sided "between", it could be written as a greater-than or equal to a user prompted date, and a less than or equal to a second user specified date.  Brilliant!  When done that way, and including the variables start & end for my user prompted values, I was able to produce this, which was exactly (or close enough) what I wanted.