Referencing Fields in Report SQL

[Gabriel Beltran]

Hi,

I've been working a little with your software and think that all the ability to change things, through the script interface is great.

I have been messing with the reports to try and get them to fit my needs, and made some changes, but am having some issues using combo boxes. In my report screen if I textfield and reference that field in my report script through the sql using the '[fieldname/]' convention, than it works great. For example:

I will have a textfield called employeeID, in my sql I am using '[employeeID/]' to reference that box. If there are no results then I get a sql message stating that there are no results found. Which is fine. I know this works, because if I find entries, then it creates the report. Otherwise, I get the message, but in the sql message, instead of displaying '[employeeid/]' it displays what I typed in the box. So I know it recognizes it.

The issue I have is when I try to change from a textbox to a combobox. No matter what I put in the combo box, I get no results found and the message has the '[employeeid/]' instead of what was placed in the box. I'm not sure why it wont recognize what is coming from the combobox. I am populating my combobox from the database, so I know the fields are correct, but for some reason it won't work.

Since I'm not sure what the issue is, I was hoping you could offer some insight.

Thanks ahead.

[Paul Jones]

The stuff to set up report parameters is only considering text-boxes.  combo-boxes, check-boxes, list-boxes, etc  are all skipped when the report’s URL query string is calculated by the applet.   You could create a feature request but your issue is not really related to Web Time Entry at all and we have no reports that use combo-boxes  (more of a jRivet framework thing).