Assuming report is required, the following 91 results were found.
-
open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers): // // Generate a CSV of a Report in ZohoCreator l_CsvLines = List(); l_ApplicableProducts = Products[Display_in_Widget=="Yes"] sort by Product_Name; for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any room bookings for that month. This is "Reinventing"...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
So this is an article to document the methods I use to get an image uploaded in a form to display in a report or on another page. Why? There might be different articles out there and discussion forums that do cover this but it takes me so long to find...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
in some cases only as an additional link in the form. The example below is for use in a customer portal on the click of a report button (report workflow). How? This will create a popup using the built-in popup of Zoho creator and gives you the freedom...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
modules are so custom/bespoke the documentation has started to genericize. My client has seen the Goals or Objectives report under "Organization Reports" but would like some additional fields/columns added to it. Turns out, it's a system report you...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
Mod 2, "#ffffff", "#eeeeee") or =IIF(RowNumber(Nothing) Mod 2, "WhiteSmoke", "Garamond") This is telling the report to be white (=#ffffff) in row 1 (odd row numbers) and a very light grey (=#eeeeee) in row 2 (even row numbers). The first row being of...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
hides the entire Tablix which kinda defeats the purpose of having anything there. I want my end-users to have faith in my report. The report just returning blank can also mean "I don't know". I want the report to either return the correct value or say...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
being returned, all pretty much useless to me. Well the "for some reason" turned out to be because my detail view on the report was displaying a report/document template. How? The quick answer is: Add the fields you want to the detail view of the report...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen in Report Builder 2.0 which I've stopped using as my day job wants us to use Business Intelligence Development Studio for all our SQL...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report processing. The Group expression used in grouping 'table1_month' returned a...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
> Contacts > Layout > Standard Add the section: "Latest Survey" Add to it the fields "Response ID", "Survey ID", "Scheduled Report Generation Time" Save and close the CRM function You should know how to set up a CRM function as a REST API function but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
-1, e.EventFinish) --Set the maximum times the Dates cte can recurse OPTION (MAXRECURSION 100) 1. Create a new report: We're going to run the wizard here but without it just add a matrix with [time] in the "column" and [room] in the "row" and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Development Studio 2008 Often happens to me and not sure why. You open the project and the window panel for the Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars before I found this. Open a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
are trying to select a cell to have an outline border but then cells around it without a border. You may find that BIDS or Report Builder (however you're building your report) will apply the border to some cells and sometimes a whole section of the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
being transparent. I want the first column to display an image based on the status result. If I simply insert an image, the report would use the background color of the report. How? The issue exists if your image has transparent areas but displays the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports view. Why? A client wanted a "Save" button on their form as well as a "Save & Close" button. The "Save" button would...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
to replace the AppOwner, AppName, FormName and connection name (which has scopes "ZohoCreator.form.CREATE" and "ZohoCreator.report.CREATE") v_AppOwner = "myCreatorAppOwner"; v_AppName = "myCreatorAppName"; v_FormName = "eBay_Webhook_Payloads";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
ZohoBooks. Why? We need to create a profits/losses dashboard in Zoho Analytics as we can't control the out-of-the-box PNL report that comes with Zoho Books. We needed a dataset that took into account "Delivery" as a separate line item on the purchase...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What we want: Contact Name Lead Source Campaign 1 Campaign 2...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
team folders and public folders)? If you have Zoho Creator, then add a form called "Image" and duplicate the "All Images" report to a "Public Images"; publish this report; browse to it in an incognito window, click on the image, right-click and copy the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *