Problem: After deploying Tableau dashboards, you are not able to display the dashboard using trusted ticket method. Error returned: "Could not locate unexpired trusted ticket <ticket_number>".
Solution: Although there could be various reason for this error, you might want to check if the IP address in which the Tableau dashboard is going to...
Thursday, November 27, 2014
Wednesday, October 29, 2014
Report cannot be Displayed
Error:
- Event not fired.
- Microsoft.Reporting.WebForms.HttpHandlerInputException: Missing URL parameter: IterationId
(This is only part of the long error message).
- Report loads forever (never stops loading).
Solution:
On the aspx page, add attribute: EnableEventValidation="false"
For my particular case, I was trying to display a report (SSRS),...
Tuesday, September 23, 2014
Combine Rows into a Column

Happened to find a way to combine rows into a column. I find it quite useful, and it comes in handy.
For illustration, suppose we have UserGroup & Users. We want to list the users belonging to each group.
UserGroup:
Users:
If we do normal joining of the 2 tables, it will...
You may be intersted in
Related Posts
Updating Table Containing Xml Column via LinkedServer
If you are trying to update a table containing XML column via Linked Server in SQL Server, and you are not able to, you are not alone. There...