Jump to content

Search the Community

Showing results for tags 'tabular report'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Found 16 results

  1. How can I hide some columns in tabular report without having extra spaces? I have some calculated field which I need to hide.
  2. I have a Tabular report in which Bulk Edit is enabled. I would like to have a Javascript that will allow to automatically put a check in the Select All check box and automatically click the BULK edit link. Is this possible?
  3. Hello, I would like to create a calculated field in tabular report datapage that displays a column in related table as a concatenated string. For Example, many of my apps use the tblPlants as a data source. This is a table of plant species that has a one-to-many relationship with many other tables. I would like to present a field in the report that lists the the botanical gardens for each plant is found in from the tblBG as a string. SELECT STRING_AGG(tblBG.Garden,",") FROM tblBG WHERE tblBG.PlantID = [@field:PlantID]; I get an error that say there is a syntax erro
  4. Hi guys, Is it possible to print the tabular report excluding some data? I have a tabular report, where we keep some data and one of the column is important for analytics, but should not be included in the printed report. It is a report with totals and aggregations, so I want to see in the printed report the totals without the aggregated fields, only the total without the data it combines. I know it might be possible to create two different datapages, but it is not good practice to use a datapage just for printing a single report sometime. Does anybody have any JS or
  5. Hi, I'm trying to hide two columns in a tabular report if one of the fields has null values or is empty. I've tried the following Java Script several different ways, but can't seem to get it to work correctly. A submission form feeds this tabular report, and if the user doesn't enter values in the 'Qty' field, it should be hidden on the tabular report. <script> var stl='none'; var tbl = document.getElementsByTagName('table')[0]; var rows = tbl.getElementsByTagName('tr'); var EmpQty = ("[@field:Employee_Productivity_Qty]").length; if (EmpQty<0) { for (va
  6. I am trying to create a pop-up child form in the form of a Tabular Report datapage, as I want the user to be able to edit information relating to existing contacts or add a new contact for the organization; the organization is unique and represented by Org_ID on the original Submission Form. For additional records, I hope to set the inline insert value for the organization to its Org_ID, which is the parameter I want to filter the report on. If at all possible I would like to hide this Org_ID, and show the organization name either in the tabular report or ever better in the report Header.
  7. I want to created a multi record audit function, ie the client clicks on a check box to approve a record in a list. There could be many hundreds of lines in the list. The approval is for a parent table from the criterior specified in the child table. I created a view for this and make the parent table the editable table in the view and I have a field for the checkbox in the view. However if I have multiple records in the child then in grid edit in a tab report I would need to click on all rows of the child table. I want to only click on one check box from the parent ta
  8. Hi there, I have a tabular report datapage, that I am using to display calculations from my table. I want to show week number, and what has happened during that week. So far I have 2 columns other than week number, number of cards updated, and total number of updates. The calculations I am using are working fine, but it's showing each number as a separate row. So if the calculation for week 6 is 7 updates, it shows 7 rows. See attached screenshot. Below is my code. Anyone know how I only show each line once (so there's only 1 row for each week number) Number of cards update
  9. Hello, I saw this How-to article on changing the background of a row based on the value of a field: http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/ However, I need to delete the row instead of changing its background color. Also, I need to delete the row when a calculation returns a blank value. Is this possible? I don't know how to write JavaScript code.
  10. I have two tables - accounts and invoices. I want to create a tabular report where each record contains the sum of AccountBalance by AccountType and uses calculated fields to return data from the invoice table. How do I create a tabular report that is first grouped by AccountType so that I can eliminate multiple rows and provide a higher level report? Can this be accomplished with a view of Accounts? ACCOUNTS Account# AccountType AccountBalance 1 1 50 2 1 50 3 2
  11. Sharing this in case you need to show the text instead of ID value in report datapage. Steps: 1) Make sure you have a table that has your lookup values 2) Add a Calculated Field in your Tabular Report DataPage and insert the code below SELECT LookUpTableDisplayText FROM LookUpTable where LookUpTableIDvalue='[@field:IDFieldInDataPage]' 3) If you want to hide the ID column, you can use the steps below.
  12. I need to ensure that values in a column in a tabular report are between 0 and 100 (They are meant to be a percentage impact figure to be entered by the user). I studied the JS example of creating column totals in a tabular report (see http://forums.caspio.com/index.php/topic/3171-js-calculate-column-sum-in-the-result-page/ ) and modified the code as follows, but I cannot get the script to fire at all. I added a number of debugging statements to no avail. I have tried an "onsubmit" type of call as well, apart from the below example. Ideally there should be a way to fire this at the end of addi
  13. I need to combine two (at times more, but once I can resolve for 2 I can easily extend) fields into a third field and commit the value back into the database, all the while working with fields in the results page of a tabular report. The example on the forum, ( http://forums.caspio.com/index.php/topic/3200-js-concatenatecombine-two-fields-into-one-field/ ) , is good but only for submission forms, and the comments on extending it also apply only to update forms or detailed pages of tabular reports. So basically it can't work within a given row in a table as it stands now. I have also checked
  14. I am trying to get the freeze headers in tablular report script to work and am unable to get it working. I have followed the instructions at the link below but it is still not working. Has anyone had success in getting this script to work? It is for a tabular report in an iframe inside an Caspio HTML datapage. http://forums.caspio.com/index.php/topic/4678-j-freeze-header-in-a-tabular-report/
  15. I have a number of instances of the user moving from one tabular report on a parent entity, by clicking on one of the records, to go another tabular report on the child entity. I am passing parameters through the query string. I have noted that if I happen to delete a record in the parent tabular report, and THEN click on some other record to drill into the child tabular report, then only the parameters of type [@field:XXX] get passed correctly, and other parameters of type [@XYZ] get dropped. This dropping does not happen if I have not deleted any record in the parent tabular report. This fun
  16. I am trying to implement logic on search fields such that the same column needs to be compared to two different values with an OR in between - like USERNAME = null OR USERNAME = [@authfield:USERNAME]. It is not accepting such entries; the auto editor keeps changing both the OR branches to equate to the same thing. Is there a way to implement such logic?
  • Create New...