Crystal Reports OpenDocument Syntax doesn't work and shows an error rather than the correct Crystal Report.
As an example I was trying to launch a Crystal Report using the OPenDocument syntax with Business Objects BI4.0
The URL was as below but was displaying a database login box and then not using the parameter supplied in the URL.
The display of the database login box was fixed by setting the parameters in CMC as detailed here.
The Workflow parameter not working when passed in to the URL was a more simple answer when eventually found!
lsSpWorkflowID=34850
The syntax for passing a parameter into an OpenDocument Crystal Report is to prefix the parameter with the text &lsS followed by the parameter name from the report such as pWorkflowID=34850
What isn't so obvious is that the letters are L, S, S (that is lower case L, lower case S and upper case S) but can appear as ISS (capital I, lower case S and upper case S)
As soon as I changed the syntax from ISS to LSS the report worked perfectly and displayed without requesting the parameter to be entered first.
Monday, 6 January 2014
Running Crystal Reports Database Login Needed in BI4 for Viewing
When trying to view Crystal Reports in Business Objects BI4 a database Login box pops up when viewing a Crystal Report via SSO Single Sign on.
OpenDocument parameters can be used to pass in details to a Crystal Report so that it can be viewed directly from a URL but you may also get a login box for the underlying database.
This database connection cannot be set within the Crystal Report and it isn't advisable or helpful for users to have to enter database credentials every time they want to run a report.
The answer is that an option needs to be set via Business Objects CMC Central Management Console. Right click on the Crystal Report that you want to run. There will be an option top select Database Configuration.
Choose this option and a page will appear allowing you to set the database credentials. Change the drop down to "Use same db login as when report is run" and specify the custom details for the report
OpenDocument parameters can be used to pass in details to a Crystal Report so that it can be viewed directly from a URL but you may also get a login box for the underlying database.
This database connection cannot be set within the Crystal Report and it isn't advisable or helpful for users to have to enter database credentials every time they want to run a report.
The answer is that an option needs to be set via Business Objects CMC Central Management Console. Right click on the Crystal Report that you want to run. There will be an option top select Database Configuration.
 |
| Running Crystal Reports Database Login Needed in BI4 for Viewing |
Choose this option and a page will appear allowing you to set the database credentials. Change the drop down to "Use same db login as when report is run" and specify the custom details for the report
You should then be able to use the OpenDocument link to view the Crystal Report without a login box for the database appearing
VW Passat 2005-2010 (B6 model): How to Change DippedHeadlight H7 Bulb
Despite the Owners Manual advising that a VW dealer should change any blown bulbs on the VW Passat B6 it is actually quite easy to replace the H7 headlight Bulbs on the 2005-2010 model Volkswage Passat.
This video shows you how to change the bulbs on the 2007 VW Passat B6 car
This video shows you how to change the bulbs on the 2007 VW Passat B6 car
Sunday, 5 January 2014
Whos On Heart Competition 2014 - Name The 3 Voices to Win Big Money!
UPDATE - June 2014 - Two names now guessed correctly - Stevie Nicks and Ben Miller
Whos on Heart is back again for 2014. I'll be adding all the wrong answers to the list as before so you can check names.
Listen to the Whos On Heart Voices
The list of answers for last year, 2013, will also be online shortly.
The Whos on Heart competition has begun today (6th January 2014) and the difference to previous years is that the top prize is not a fixed amount but increases by £100 each time a wrong answer is guessed from £30,000 upwards.
The prize for the first and second guesses remain at £10,000 and £20,000 as last year.
Whos on Heart is back again for 2014. I'll be adding all the wrong answers to the list as before so you can check names.
 |
| Whos On Heart Competition 2014 |
The list of answers for last year, 2013, will also be online shortly.
The Whos on Heart competition has begun today (6th January 2014) and the difference to previous years is that the top prize is not a fixed amount but increases by £100 each time a wrong answer is guessed from £30,000 upwards.
The prize for the first and second guesses remain at £10,000 and £20,000 as last year.
Monday, 2 December 2013
VW Passat Estate (B6 2007) Tailgate Rust - Volkswage 12 Year Anti-Corrosion Warranty Claims
When cleaning our VW Passat B6 estate recently I noticed that there was significant rusting and corrosion around the numberplate light area on the rear tailgate. This seemed to be specific to the number plate light area and not spreading to other areas of the boot/trunk. From a quick search on Google it appeared that this was a commonly reported fault with the B6 Passat and due to the design of the light units allowing water to settle in the light area.
I took the Passat to the local Volkswagen dealership to check if this was covered by the standard 12 year VW corrosion warranty. Happily after a few checks to confirm the paintwork depth and that the car had not been resprayed or damaged the VW agent confirmed that the rust would be repaired by VW under the anti-corrosion warranty and booked the vehicle in for the work with a courtesy car provided for the duration of the works.
On the booked date the car was duly delivered to the VW dealer and the loan car provided - a VW UP! that is obviously much smaller than a Passat estate which took some getting used to! A few days later the update from VW was that the rust could not be repaired so the whole tailgate was being replaced instead which would delay matters.
Almost 3 weeks after dropping the car to VW the Passat was collected following the complete tailgate replacement. On inspection it seems that the design of the rear number place lights has been changed presumably to avoid the corrosion and rust that has occured in this instance.
 |
| VW Passat Estate (B6 2007) Tailgate Rust - Corrosion Warranty |
On the booked date the car was duly delivered to the VW dealer and the loan car provided - a VW UP! that is obviously much smaller than a Passat estate which took some getting used to! A few days later the update from VW was that the rust could not be repaired so the whole tailgate was being replaced instead which would delay matters.
Almost 3 weeks after dropping the car to VW the Passat was collected following the complete tailgate replacement. On inspection it seems that the design of the rear number place lights has been changed presumably to avoid the corrosion and rust that has occured in this instance.
 |
| VW Passat Estate (B6 2007) Tailgate Rust - Corrosion Warranty |
 |
| VW Passat Estate Rust - Claiming Replacement under Corrosion warranty |
 |
| VW Passat Estate (B6 2007) Tailgate showing new light holder design on replacement |
Monday, 11 November 2013
Oracle Apex 4 - Chart Legend Always Shows as Uppercase
I was recently developing an Oracle Apex 4 application with charts and found that the chart legend was always shown as uppercase text regardless of what was in the chart settings.
In Oracle Apex 3.1 all chart legends were converted to inital capitals so regardless of what text was entered the legend text always showed the first letter in capitals and the rest lower case. This behaviour was changed in APex 4 so I was surprised to find that all the legends were showing as upper case in this APex 4 application when the text entered was a mix of lower and upper case.
Fortunately this was a simple one to fix and the answer was that the text was not enclosed in double quotes. As soon as this was done the legend text for the Apex Chart was displayed correctly as mixed case rather than all upper case.
select null,
to_char(created_date,'MM-YY') Date,
sum(decode(TYPE,'SERVICE', 1,0)) Service ,
sum(decode(TYPE,'MAIN', 1,0)) Main
Showed on the chart legend as SERVICE, MAIN but the code below showed correctly.
select null,
to_char(created_date,'MM-YY') "Date",
sum(decode(TYPE,'SERVICE', 1,0)) "Service" ,
sum(decode(TYPE,'MAIN', 1,0)) "Main"
Shows legend as required as Service and Main
In Oracle Apex 3.1 all chart legends were converted to inital capitals so regardless of what text was entered the legend text always showed the first letter in capitals and the rest lower case. This behaviour was changed in APex 4 so I was surprised to find that all the legends were showing as upper case in this APex 4 application when the text entered was a mix of lower and upper case.
Fortunately this was a simple one to fix and the answer was that the text was not enclosed in double quotes. As soon as this was done the legend text for the Apex Chart was displayed correctly as mixed case rather than all upper case.
select null,
to_char(created_date,'MM-YY') Date,
sum(decode(TYPE,'SERVICE', 1,0)) Service ,
sum(decode(TYPE,'MAIN', 1,0)) Main
Showed on the chart legend as SERVICE, MAIN but the code below showed correctly.
select null,
to_char(created_date,'MM-YY') "Date",
sum(decode(TYPE,'SERVICE', 1,0)) "Service" ,
sum(decode(TYPE,'MAIN', 1,0)) "Main"
Shows legend as required as Service and Main
Monday, 7 October 2013
VW Passat B6 Heated Mirrors Not Working - Replacing Heater Element Passat Mirrors
We've had our VW Passat B6 (2005-2010) model for 3 years but until recently it wasn't our main car so didnt often get driven. As such I didn't get to test out all the features and found that the heated mirrors didn't seem to be working and clearing frost/condensation on cold days.
As of today I've realised there is part of the switch that isn't visible from the driver's seat position that you need to turn the mirror adjustment dial to so that the heated element comes on and will clear the any condensation from the mirror glass. The dial needs turning 180 degrees so that the dial is away from the default rest position and pointing to the heater element sign - obvious really - at least if you can see it properly!
If the heated mirrors on your VW Passat B6 aren't working then this would be a first item to test to check if they can work before taking to a garage for the mirrors heater element to be replaced.
As of today I've realised there is part of the switch that isn't visible from the driver's seat position that you need to turn the mirror adjustment dial to so that the heated element comes on and will clear the any condensation from the mirror glass. The dial needs turning 180 degrees so that the dial is away from the default rest position and pointing to the heater element sign - obvious really - at least if you can see it properly!
 |
| VW Passat B6 Heated Mirrors Stop Working - Replacing Heater Element Passat Mirrors |
If the heated mirrors on your VW Passat B6 aren't working then this would be a first item to test to check if they can work before taking to a garage for the mirrors heater element to be replaced.
Subscribe to:
Posts (Atom)