topic Re: Picture Box Rotation in Qlik NPrinting

Picture Box Rotation

framacdev — Sun, 21 Jan 2018 17:03:16 GMT

Hi everyone,

I would like to know whether it is possible, when creating a picture box, to rotate it directly on Report Designer or I need to define it on the script? Do you know any workaround to do that?

Thank you

Re: Picture Box Rotation

Ruggero_Piccoli — Mon, 22 Jan 2018 08:32:21 GMT

Hi,

In what kind of report?

Best,

Ruggero

Re: Picture Box Rotation

framacdev — Mon, 22 Jan 2018 08:56:31 GMT

I encounter the mentioned issue in PixelReport

Re: Picture Box Rotation

Ruggero_Piccoli — Mon, 22 Jan 2018 09:19:51 GMT

There is not a control to rotate images. To achieve the required result:

Change the scripting language of the document to Visual Basic
Add the image in the template and keep it selected
In the image propreties grid selec BeforePrint event in the script menu
Create a new Visual Basic script and add the code

Private Sub xrPictureBox1_BeforePrint(sender As Object, e As System.Drawing.Printing.PrintEventArgs) Dim _pictureBox As XRPictureBox = TryCast(sender, XRPictureBox) Dim _image As Image = _pictureBox.Image Dim _bitmap As New Bitmap(_image) Dim _graphics As Graphics = Graphics.FromImage(_bitmap) _graphics.Clear(Color.White) _graphics.DrawImage(_image, 0, 0, _image.Width, _image.Height) _bitmap.RotateFlip(RotateFlipType.Rotate90FlipX) _pictureBox.Image = _bitmap End Sub

For more details about PixelPerfect scripts refer to the video

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Picture Box Rotation

framacdev — Mon, 22 Jan 2018 09:59:34 GMT

Thanks a lot for your quick response, Ruggero.

For static images your code works, but if I apply your code, doing data binding, to an object that contains a picture in Qlik Sense, it does not work.

Do I need to change something in the code that you have sent to me?

Thank you

Re: Picture Box Rotation

Ruggero_Piccoli — Mon, 22 Jan 2018 10:59:28 GMT

I tested the code also with a Qlik Sense chart and it works. It is printed rotated in the generated PDF.

Could you share some screenshots of your template?

Maybe a Visual Basic developer can share some ideas.

Re: Picture Box Rotation

framacdev — Mon, 22 Jan 2018 11:22:03 GMT

I have noticed that the previous part of my PixelReport document was set with a level where one picture was stored. I wanted the same picture in another part of my report but rotated, so I have created another detail. What I needed to do was to Insert Detail Report in this section to print the rotated picture.

I did that and your code works great.

Thank you so much Ruggero

Re: Picture Box Rotation

Ruggero_Piccoli — Mon, 22 Jan 2018 11:25:14 GMT

Molto bene!

Please remember to mak my answer as correct so it will be useful also for other people.

Buona giornata,

Ruggero