ddigmann
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by ddigmann
-
Well I figured it out. Ok, sort of. I abandoned the function idea in the view and decided to make another view which retrieved the same information. I then did an left join on the table in the first, main view with this new view. This made it all happy and well just plain work. I have no idea why darned thing did not work with the function but it works now. If anybody out there knows why, I would love to hear from you.
-
Can anybody out there give me some sort of answer on this? Even a "You are in the wrong area" or "Nobody knows would help". Thanks Dustin
-
I have created a report which is generated based on the information in a view. The query is more or less Select * from thisView order by thisColumn asc. The problem I am having is that I can see the correct ResultSet being passed to Jasper but the order is unsorted when it comes out. It is only for this ordered column though. If I order based on some other column it is fine. I think it is messing up because my view is defining this column based on the results of a function call in SQL Server (ie select myFunction() as thisColumn from blah). This is the first time I have ever used an aliased function call column to be sorted on and it was worked for all my uses in the past. Are my assumptions correct? What is the best way to fix this? Dustin
