Jump to content

Search the Community

Showing results for tags 'REPORT'.



More search options

  • 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 22 results

  1. 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
  2. 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.
  3. 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?
  4. 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?
  5. 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.
  6. 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 to submit proof of placement (Offer letter or Joining letter). They have submitted the proof of working (Payslips and bank statement) for continuous three months . Now i want to count how many candidates got placement out of pass, how many offer letter submitted. How many payslips for first month, second month and third month for batch-wise in a single report which is very easy in excel. But very difficult in caspio. I have shared the screenshot.
  7. 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 not only on load, but also on an AJAX call? Thanks, Josh EDIT: I just realized that it's not because of the combined chart/report that I cannot turn off AJAX, but it is because of the grid edit.
  8. 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
  9. 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 looking for. Thanks!!
  10. 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!
  11. 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 cascade listboxes to update in real time from a multi-select parent listbox (a problem faced by many on this forum and not yet properly solved). So is it possible to use a report datapage with a little bit of JS code, that effectively prevents its results page from being generated (as possible with a submission form)? Obviously I'd then pass my parameters to a separate results datapage, just as I do now. Thanks
  12. codell

    Ajax Table Refresh

    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 my results table. In that calculated field I have already placed "GetUTCDate()" . I named the calculated field "Last Updated: (click to refresh)". Essentially this shows up as a column and displays the date and time the table data was loaded. Filtering by this column refreshes the data and updates the "Last Updated:..." field as well. For me this solution currently does work, however I would be interested in a cleaner way of accomplishing this. Perhaps a method that does not require the use of its own dedicated column in the table is possible. On a side note, the data that I am most interested in refreshing is another calculated field (SQL). This is relevant because (at minimum) I do not actually need the entire table to refresh if only there is a way to refresh these calculated fields. Thanks again for bearing with me. I'm curious to see if others have had a similar problem or could use this solution that I currently have in place. COdell
  13. 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.
  14. Hi all, If someone knows how to hide some records on the Tabular report if Calculation => 5 for example?
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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 it works, so I'm guessing it has to do with the way I'm referencing or calling Palmas Check Box. Does anyone knows why is the if statement behaving differently when the Submission Form is changed to a Detail Report? Thanks!
  20. 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
  21. 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.
  22. 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!
×
×
  • Create New...