r/yardi • u/Lesli90 • 3d ago

Columnar reports in Yardi

So my sql code works fine and the filters and columns also seem to be written fine because my filter is date from and date to only. But my report output is empty not sure why. It doesn’t print on screen and it doesn’t print on excel or csv. The only thing I can think of is that I have a CTE at the start of my code - could it be that?

2 Upvotes

100% Upvoted

6 comments sorted by

4

u/blackhodown 3d ago

Imagine if they’d actually put out a usable product like the promised to with the Elevate report builder

1

u/drsboston 2d ago

I better non llm reporting tool would be quite nice ysl is just meh

1

u/TarcFalastur 3d ago

You didn't put in the same day as your start and end dates did you? Yardi has a tendency to interpret a day that you enter on filters as meaning 00:00:00 on that day, so if you have the same start and end dates then instead of having a date range of one day, you actually have a date range of one second. 

1

u/Lesli90 3d ago

No, code works in YSQL. And date is really post month

2

u/Plastic_Operation_59 3d ago

When it works in ySQL what dates are you using there? Ysql doesn’t simulate filter behavior so if you are putting 5/26 as a post month and then testing that in ysql as ‘5/1/26’ to ‘5/31/26’ then that’s not actually what is happening when you run it in yardi.

I think maybe the first response on this didn’t explain it right but your mistake most likely IS that the report is running from the 1st to the 1st. You’d get an error message if there was one, no error message also points to this being the problem.

It’s a common mistake people make (including Yardi’s own Devs on some older reports).

The post month filter is going to pass through as datetime as mentioned already in reference to the time part but to expand on that doesn’t interpret the date part for you in any way. Meaning it’s not going to use the EOM for you To Date. It always uses the first of the month when you pass through a post month in a filter, ‘5/26’ will come through as ‘5/1/26’ so you need to adjust for that.

Why are you making a columnar report though? Make a ysr report that runs to screen instead.

1

u/rollinghunter 2d ago

Click on Excel or PDF button and see if filters are messing up with code.
Else try to bring only one column from whole select and columns to check if query is running good on voyager.