I have been trying to customize a report (Originally report was Dispatching Report) and get the current units model number to print on the report. I can pull "UnitModelID" to the report but it is just a string of text and numbers an not the ABC text (ie. 5 lb ABC Extinguisher).... I am not sure the use of this string for reporting but is there a way to get the actual model number from the database from this string. I am sure it is just a matter of referencing the unit model list is it not. It is somewhat imortant and maybe should be something that can be corrected for the end-user to make it easier to get this information. Can anyone give me a hand with this one cause maybe I am missing something here.... I have tried to add the report but the upload manager keeps givng me a "invalid file" error. Let me know, if there is anything else you need or info I have missed. You guys are AMAZING!!!! Thanks again in advance.... your help has been great with everything.
One thing has also baffled me about the reports designer is why through script some of these database fields can be accessed by through the "menus" you can only select a VERY limited list of fields..... Can the reports designer not automatically do what the scripts do in the background. I am sure a change sure as this would put AyaNova over the top in terms of customability. I am sure there maybe some inherant design limitation that may not make this possible but it seems to be the single biggest issue in the forums. Not all of us have programing experience to a degree that sometimes the report design seems to require.