Search - Joel Lipman .Com

1. SQL Server Reporting Services: / Category /; Created on 05 March 2020
2. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; What? This is an article to document how to produce a report which when exported to PDF will display images without a user wall. Why? Our client needs to send a report to suppliers that include ...; Created on 26 January 2024
3. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... report to show these photos. How? The following is simply the steps to create a data table in ZohoAnalytics, then the code to list a ticket's attachments and push them to the ZohoAnalytics data table. ...; Created on 05 December 2023
4. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; What? Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template ...; Created on 05 May 2022
5. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; What? The aim of this article is to document how you can display a Creator report to the user, that they can select (tickbox) multiple records in that report, and then have a button that loops through ...; Created on 06 December 2020
6. SSRS No Delay for First Report of the Day: / SQL Server Reporting Services /; What? This article describes a solution our reporting server administrators found to cut the loading time of the first report of the day. Why? Take any SSRS report, if one of us was the first ...; Created on 11 April 2014
7. Problem creating SSRS report subscriptions: / SQL Server Reporting Services /; What? A quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from ...; Created on 11 November 2013
8. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; Why? I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able ...; Created on 02 December 2011
9. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; How to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular ...; Created on 17 November 2011
10. SSRS Repeat Headers in PDF Report: / SQL Server Reporting Services /; The Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header ...; Created on 26 October 2011
11. SSRS Redirect after a report is run: / SQL Server Reporting Services /; What? This article serves to describe several workarounds or proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference ...; Created on 12 August 2011
12. The ReportServer Database: / Databases /; ... as to what this database is and how it populates its data. View: ExecutionLog InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ...; Created on 08 August 2011
13. URL passed settings in Reporting Services: / SQL Server Reporting Services /; Thought I'd put a note on how to remove the toolbar using the URL as I didn't find this clear on the net. Tried it and it didn't work. That's because I was using the Reporting Manager URL rather than the ...; Created on 11 February 2011
14. Alternate row background colour in Reporting Services: / SQL Server Reporting Services /; ... 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) ...; Created on 04 February 2011
15. Parameters not being used in report processing: / SQL Server Reporting Services /; Once again I've spent a whole morning going in the wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder ...; Created on 07 January 2011
16. Blank columns issue when exporting to Excel (Data Only) from Crystal Reports: / Excel /; Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue ...; Created on 15 June 2010
17. Crystal Reports: Exporting to Excel omits column headers: / Excel /; If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions ...; Created on 03 June 2010
18. Change Regional Settings for your Report: / SQL Server Reporting Services /; Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that ...; Created on 17 May 2010
19. Report Builder 2.0 - Hide Series1: / SQL Server Reporting Services /; ... Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident ...; Created on 06 May 2010
20. If Then Else in Report Builder 2.0 Expressions: / SQL Server Reporting Services /; Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm ...; Created on 06 May 2010