Jump to content

Reports - date/time parameters not pulling information


Recommended Posts

Hi all,

I am back in work after an extended period of leave, and have come back to multiple (broken?) updates within our instance, some of which have gone unnnoticed for months.

At present, I am trying to work out how to fix a report which should run on a date prompt but no matter what combination of options I choose the report is pulling blank each time. I've taken a screenshot below of how it is built, is there anything glaringly obvious I've done wrong as every single column is empty when run!

image.thumb.png.d7bd187ba7bd4ec1d673696e2f4f25f1.png

Link to comment
Share on other sites

James,

You're right! I deleted the date filter and it's still pulling empty. How odd! 

We have one report that is working brilliantly, so I'm thinking I may just make copies and change the date fields.

Thanks for helping me work through that :)

Link to comment
Share on other sites

Happy to help.  With the Date options removed, you'll just need to look a the remaining options.  As they are all AND statements any request would need to match all the statements.  My guess is that it is that last statement to do with asset types.  Not sure how you are doing the join to the table storing the asset types.  Should these be assets rather than asset types?

Link to comment
Share on other sites

  • 3 weeks later...

James,

I'm not sure on the assets point, I'll take a screenshot of where they're currently sitting in the system and see what we've got them built as... my confusion comes from the fact all these reports worked perfectly until March, and then seem to have broken. I was told there was an update in Service Manager around that time but can't find anything that would link this issue to that.

Lauren

Link to comment
Share on other sites

image.png.b343169bf3a4c270bbde0b62b32b4a18.png

 

They are all sitting within Asset Management here, so we could assign them to the job for reporting purposes. I believe this was done when we first built in 2017/18 as we didn't have the supplier set up atm.

Lauren

Link to comment
Share on other sites

21 hours ago, lokent said:

image.png.b343169bf3a4c270bbde0b62b32b4a18.png

 

They are all sitting within Asset Management here, so we could assign them to the job for reporting purposes. I believe this was done when we first built in 2017/18 as we didn't have the supplier set up atm.

Lauren

@James Ainsworth apologies, forgot to tag you in the response :)

Link to comment
Share on other sites

image.thumb.png.c6fba333d383c7ec63eceb5c465a1c69.png

 

Forgive me, I rarely built reports previously and so I think this is what you're asking for? Doesn't appear to be any joins

Link to comment
Share on other sites

@lokent 

3 minutes ago, lokent said:

I rarely built reports previously

Ok, no worries. Download the report definition file and send it to me, e.g. post it here. If there are any concerns about private data (although is a report configuration) then you can send the file via PM.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...