Jump to content

Search the Community

Showing results for tags 'report'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • 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

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 25 results

  1. Hello, I have reviewed this page below, but I'm not sure if this is the right solution for me. I have a tabular report, and if there is a blank cell, I would like the background to highlight yellow. What is the best way to do that? See my screen shot below, where ideally, a header or footer code would make these fields jump out as bright yellow. Thank you!
  2. Hi I am new to caspio and not a fluent sql programmer but understand some of the logic. I have a Users_table, and a particular submit form, that includes a submitted_by field for the unique email address of the user. I would like to create a report that lists out the users that have not completed the form on that particular day. And a summary table of the number of users completed vs not-completed. Ideally I would be able to include other filters in the pivot. I am having a problem structuring this in the report, can anyone help out with just the first part? Thanks
  3. I have a tabular report with search form above the results. I was able freeze the first column and it works fine. However, the search form moves with the report when scrolling left and right. Does anyone know how to keep the search form in its fixed position? Thank you.
  4. I want to hide everything below the "Download Data" button in my tabular report DataPage. Tried adding Header & Footer with: <div style="display:none"> </div> But it also removed the “Download Data” button. Any ideas?
  5. I have a report I'm using to search through various fields of my table. I would like to include a search box that can search for a term within/across all of my fields. Is this doable? How? Edit: I've continued to look for this info and I found this article http://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/ But, I don't understand the steps. When I go to create a submission form, I don't know what field(s) to include. I can't seem to tie the form and report together, and the search doesn't end up working. I'm not sure it's even what I'm looki
  6. How can I use Multiselect listbox to perform a search with OR logic? I have separate search and report as described in the video: https://howto.caspio.com/getting-started/display-results-on-a-separate-web-page/ Does anybody have ideas?
  7. Hi! There is a Tabular report with a comment field (Text64000). I want to add a "Copy Text" button, that on click will copy text from the comment field to the Clipboard, so a customer can copy the text without highlighting and copying. Just one click action to copy. I have found some solution, but it does not look like working in the reports: https://www.w3schools.com/howto/howto_js_copy_clipboard.asp Has anybody done it before or maybe you have some working solution? Thanks in advance.
  8. Is it possible to generate customized reports similar to that of Ms-Access? I know we can export as XLS, Access, CSV or XML but how do I create a tabular or a stacked report which I can print to paper? Is there a tool in Caspio where I can create a layout similar to a spreadsheet with labels across the top and data in columns below the labels (Tabular) or a layout similar to paper form with labels to the left of each field (Stacked)? I'd like to be able to print it so export to MS-Word or PDF will be great. Thanks!
  9. Hello all, Thanks in advance for looking at this. I'm looking for a clean way to refresh the data in a tabular search and report without reloading the whole page. I know that enabling AJAX in the Wizard allows the tabular report to use AJAX to filter and page through results without needing to reload the entire page each time. Reloading the whole page mandates that the user enter in all of the required search values prior to seeing the updated data. I am looking for a way around this. I currently have a system that works where I have added a calculated field as the final column in
  10. Hi, i have a table. Which is contain 10 training centres. In each training centre there are 7/8 courses. Each course have 4/5 batches. Each batch contain 30 student. There are training_status column in the table where students have different values like pass, fail, not appeared and ongoing. I want to count how many pass, fail, not appeared and ongoing in each batch. It is coming in good way in pivot (since i dont know better reporting format for same) Now i want to add more field in row. Like after getting pass in training candidate got jobs/ placement. And after placement they used
  11. I have a combined chart and report datapage that I use to display a list of jobs and their status. I would like the list and chart to have dynamic colours according to their status. This is quite easily accomplished, and in fact I have already completed it. My issue comes in place with AJAX. I cannot disable AJAX on a combined chart/report datapage, therefore when I do a bulk edit on my report, the chart reverts back to the default colours. I am guessing this is because the chart loads without running the javascript in the datapage. Is there a way to execute javascript in a datapage
  12. I need assistance to change the background of an element in a gallery or list report when clicked. And get it's reference ID or info as a parameter
  13. Hi I have 3 fields; 'Year', 'Product' and 'Price' I want to be able to show a results table with 'years' across the top, 'product' as a column and 'price' as the data that's relevant to each year and product. I also want to be able to multi-select the 'Year' field in the search page, so that only the User's selection of years is displayed. I know I can do this with a Pivot Table, but this option isn't included in my subscription package. Is there a way that any of the other reports can be used to show this? Thanks for any help!
  14. This could be a totally dumb question, but I'll risk it! My interest is to search my table and show a report. I don't wish to submit data to the table. I've been using submission forms for my search fields. The reason for this is because I wanted to keep my results page on the same web page as the search fields. Submission forms allow me to stay on 'same page', while report datapages force you to show results on a new datapage. Ideally I would have preferred to use a report datapage for the search fields, mainly because there are no silly problems in trying to get multi-select casc
  15. I have a report data page that lists all customers and purchase orders through a left outer join view that shows ALL Customers and Purchase Orders, regardless of the whether the PONum field is blank or contains a PO Number. How can I label the blank fields to show something like "No Orders " instead of a blank field. All suggestions are greatly appreciated.
  16. Hi all, If someone knows how to hide some records on the Tabular report if Calculation => 5 for example?
  17. Hello, My website (gradlook.org) uses Caspio to host a search engine for graduate schools as well as chat forums. I am now looking to create a compare functionality. This is essentially will just a combined table in which the user enters the names of two schools from the same table (preferably with an autocomplete feature). The results are a table with two columns (each school) and each school's fields/stats side by side. I have been working with views but haven't really been able to get anywhere. Can someone point me in the right direction? Thanks, Joe
  18. Hey Caspio Forum ! I am a freshman here. What I want to do is to be able to change 0,00 in my Report DP. Say if any record has this value, automatically change it to blank field, or to '--'. Any help will be appreciable! Thanks guys
  19. Hi! I'd like to know if it's possible to create a report showing only the aggregation I've created, and no all the records (expanded or not). Thanks for the help. Sergio
  20. Hi! I'm new as CASPIO user. I'd like to set up a report data page, with charts if it's possible, showing only aggregation values (no records) like pivot tables in excel. Is this possible? How can I do it? Thanks for your help. Sergio
  21. Hi there, I have the following code in a submission form: <script> window.onload=function(){ if (document.getElementById("InsertRecordPalmas").checked) {var new_value = "Palmas";} else {var new_value = "AAA";} document.getElementById("cbParamVirtual1").value=new_value; } </script> This code puts a certain value on Virtual1 (which is a TextBox) depending on whether Palmas Check Box is checked or not. It works perfectly, but it stops working when I turn the Submission Form into a Detail Report. I know is not the "onload" because I tested it without the if statement and
  22. Hello Caspio Gurus! I have an action log, and in this action log I have three Foreign Key user fields - Assigned, Creator, Completer. (all three which point at tblUser) How might I go about displaying all these users in one report? I tried creating views (qryUserAssigned, qryUserCreator, & qryUserCompleter) and using those views in a view, but I can only use tables when creating a view. Any help will be greatly appreciated. CHAD
  23. I want to know how I could create a HEATMAP in the report page. What i mean by HEATMAP is that I wish to control the background color of the cell depending on the value of the cell. One of the column has four different value eg 100, 75, -75, -100. The color of the background would be darkgreen if the value in the cell is 100 or palegreen if the value is 75 or red if the value is -100 or pink if the value is -75. There are serveral such columns with different values which i want to set the color for. Can someone suggest me the solution to this. Thanks
  24. Hello. I am trying to create a summary report with calculated fields however I am having issues with the report. In the big picture I want to do SQL COUNTS to see if data is in a particular field however I want to group those counts by districts. There are 1202 records and 12 districts. I can not make a summary report that calculates totals for the 12 districts. I am learning as I go but I am trying something new... In one of the calculated fields (at this point I tried a new report with only this calculated field to see if I could get 12 DISTINCT records) I am trying to do a SQL DISTINCT comm
  25. I am looking for a tutorial/video on how to layout a report format that can be edited. I have an extensive member profile that will be viewed and updated by the end user on almost every visit. It is essentially a member dashboard on my site. I want to fit close to 100 elements (mostly text) on a page separated in categories like a medical chart. Any examples of similar work would be appreciated.
×
×
  • Create New...