Advertisements

Parameters ignored when passed to Crystal Reports .net

This is a crazy, crazy annoying bug. Basically, when the Crystal Windows Form Viewer is added, the auto-generated code adds two lines that will overwrite the selection formula!!!

Answer came from

https://stackoverflow.com/questions/10584989/select-criteria-not-working-in-crystal-reports-and-visual-studio-2010/15421308#15421308

Resolution

To resolve the issue, follow these steps:

Expand Form1.vb|cs to show Form1.Designer.vb|cs. (form1 denotes the form that contains your viewer)

Double-click on Form1.Designer.vb|cs to show its code.

In the InitializeComponent method, you will find code where the CrystalReportViewer1 properties are set.

Comment out or delete the following two lines:

me.crystalReportViewer.SelectionFormula = ""

me.crystalReportViewer.ViewTimeSelectionFormula = ""

 

 

Advertisements

HP Aruba Procurve Management Software HP PCM

This link is hard to find on the google. Hopefully this helps

https://h10145.www1.hp.com/downloads/SoftwareReleases.aspx?ProductNumber=J9755A&lang=&cc=&prodSeriesId=

 

 

Random ways to cause Bluescreens (For Testing)

The most common is to

  • Open Regedit
  • Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\i8042prt\Parameters
  • Add a new DWORD (32-bit) Registry value here with name = CrashOnCtrlScroll and value = 1
  • Now you close regedit and restart PC
  • Finally hold down Right Ctrl and press Scroll Lock twice to trigger the BSOD.

This can never work through RDP though. So other methods

This might work, but slow

https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2005715

This works well to crash a machine on boot

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ACPI]
"Start"=dword:00000004

Save it as a .reg file and run it. Your computer will blue screen on reboot. Return to last good configuration or change the value back to 0 to fix it.

This also works

The command line interface for the DiskCryptor Open source partition encryption software includes a -bsod parameter, the wiki says it will

Erase all keys in memory and generate BSOD

 

@Tile_App I love you, but one suggestion

So I found some guys keys on the road. It had a tile on it. I was like sweet I should be able to return these easily.

But no. There is no way to email the owner that I found his keys.

It would be better if he scrawled his phone number on the back of the tile, at least I could call him!

So, Tile. How about you add a feature to the Tile app. Found a tile

You press the big E, it snags the serial number (I’m guessing its broadcasting it anyways, I didn’t try to sniff the blue tooth traffic) and lets you message the owner.

Enable a sonicwall to show up when using traceroute

Under Firewall Advanced,

Click Decrement IP TTL for forwarded traffic

DO NOT click on Never generate ICMP Time-Exceeded packets (this makes it not work 🙂

Changing vcenters with #veeam

In case you ever change vcenters, veeam has a nifty tool to help you migrate

https://www.veeam.com/kb2136

 

Working Qlikview Maps Extension Example

I’ve been having a lot of fun experimenting with google maps and Qlikview. After looking at quite a few extensions I finally ran across this one.

GoogleMapsAPIv3Toolkit-QV

http://branch.qlik.com/#!/project/56728f52d1e497241ae69843

Download the .qar file

(Qlikview extensions are easy to install, just double click the .qar file and it will go got town)

Also, get your self a copy of the ‘Google Maps JavaScript API v3 Toolkit Example.qvw’


 

So, first things first. Get yourself your own google maps API key

https://developers.google.com/maps/documentation/javascript/get-api-key

Using your google account you can eventually get to a screen that will give you a key.

Once you get a key, you can open up the ‘Google Maps JavaScript API v3 Toolkit Example.qvw’

Make sure you have changed over to web view (View menu, Turn on\off web view)

Extensions only work in web view (ajax view)

apikey.PNG

Then flip yourself to the Markers tab, right click properties on the extension object, Basic Configuration and paste in your Key into the API Key.

So, next thing I wanted to do was change the icon.

To do this, locate where it installed the extension.

C:\Users\[user]\AppData\Local\QlikTech\QlikView\Extensions\Objects (vista & seven) or C:\Documents and Settings\[user]\Local Settings\Application Data\QlikTech\QlikView\Extensions\Objects.

Drop your custom icon into /lib/images/ and refer only to the filename

Local\QlikTech\QlikView\Extensions\Objects\Google Maps Javascript API v3 Toolkit 2\lib\images

Under properties \ Markers \ Custom Icon URL type in just the filename of your new icon (and make sure its the right size or you will get giant markers 🙂

giant markers.PNG

If you want to have different markers based on some criteria then clear your custom icon URL on the Markers tab, change over to Markers – Additional Configurations

Click Force Multi-Icon Markers

Use an if statement in your function.

Multi-icon.PNG

Cheers