Jump to content


  • Content Count

  • Joined

  • Last visited

  1. I have a tabular report containing afield that has a lookup table associated with it (1 to many relationship). How do I do a search in the table for rows that have a value that is contained in a lookup table. E.g.I have lookup table of Department ID & Department name. In my tabular report of employees with Employee ID, Employee Name, Department ID (each employee belongs to a particular department) I want to search for Employees belonging to a department, using the department name rather than Department ID. And I want the search to be able to use "Contains" e.g. bring up all Employees w
  2. Don't forget to disable Ajax to force the javascript to be executed every time the page is displayed, otherwise it is often only executed if you refresh the page.
  3. Solved ! Now displaying user-specific logos. After quite a few hours experimenting, now I can display logos (or whatever) in a Header in a Results page, that can be conditional on a table value. The trick was to set variables & use document.write(variable). <script> // var1 is the Company A logo (it's clickable & takes you to the home page) // var2 is Company B logo (it's clickable & takes you to the home page) var1='<img alt="" src="https://URL of Company A.png" style="width: 301px; height: 61px; vertical-align: top;" /> <br />&nbsp; &
  4. Want to display a different header according to value of field from user authentication. Code logic works fine, but the HTML I want to be executed does not work. Here's a sample script. The Italics part after the "if" statement works well on its own, but with the conditional code, it is ignored. Rules can't be used (I think) as they do not operate with Header or Footer blocks in a Data Page. <script> if("[@authfield:User_Company_Name]" == "ABC Ltd"){ Welcome [@authfield:User_Name] to your account &nbsp; <a href="https://www.myurl1/" target="_blank"><i
  5. I am using a Tabular Report to view data, and update some fields. There is a field I want to use as a unique key to a lookup table and display the description from the lookup. For example, I have rows of data regarding trees. For field tree_name e.g. "Oak Tree" I want to display the Latin Name which would be contained in the lookup table "trees_and_latin_names" with key of tree_name (and another field with the Latin Name in it) . Having solved this, if there is no value in the Tabular Report, I'd like the user to be able to type in their own value, this being written to their own data (not
  • Create New...