What's everyone's experience of using SSRS to build reports for HEAT?
I've been writing a report and after getting it to look and work how I wanted it to in SSRS I proceeded to upload it to HEAT and then spent litterally days going between HEAT and SSRS trying to get something that HEAT will accept without throwing errors. The report mostly works now with the exception of a nested iif expression that - took me almost 2 hours to create, works in SSRS but errors in HEAT. In getting to this point I had to restructure my query several times to account for the fact HEAT only allows datetime not date ranges meaning the user sees a time but the sql ignores it, was unable to filter without setting offset values and had to embed a default set of parameters into the query because =DateAdd("d", -5, Now()) wouldn't work as a default expression - all the time these worked fine in SSRS.
I've essentially got to the point where I can't create reports in HEAT unless I'm willing to give up days flipping between two systems and want a simple table/matrix, with limited filters, no default values (using expressions), the query is structured in such a way that it only brings back static set of results and even then it probably won't work how I want it to.