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 ...
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 ...
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 ...
... comment_count
FROM
my_joomla_db.jos_content
ORDER BY
id
Importing the joomla categories to Wordpress: (still to do: sections as parent categories?)
SET @CountCategoriesAlreadyEntered:=(SELECT ...
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 ...
... 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 ...
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 ...
... 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) ...
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 ...
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 ...
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 ...
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 ...
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 ...
The Issue
After modifying a report and on running it, Report Builder 2.0 returns the following error:
An error occurred during local report processing.
An error has occurred ...
... is mostly done in ZohoCreator. I could have setup webhooks to go directly to Zoho Creator but I don't find Zoho Creator reliable when receiving and responding to webhooks.
Important!: For the REST ...
... Report in ZohoCreator
l_CsvLines = List();
l_ApplicableProducts = Products[Display_in_Widget=="Yes"] sort by Product_Name;
for each c_Product in l_ApplicableProducts
{
l_CsvRow = List();
l_CsvRow.add(c_Product.Photo);
l_CsvRow.add(c_Product.Product_Name.replaceAll(",", ...
... }
// Setup a config to find this record (use a custom report that only has the 2 searchable fields)
var config = {
appName : "joes_quote_builder",
...
... void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID)
Trigger: On Demand when button in report is clicked
Purpose: This will send a ZohoBooks invoice directly to its recipient
Inputs: ...
... has the scopes as specified in the function header. Also note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter. The most important tweak in order for the below ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.