

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Picture Box Rotation
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
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.
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
In what kind of report?
Best,
Ruggero
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I encounter the mentioned issue in PixelReport


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
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.
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Molto bene!
Please remember to mak my answer as correct so it will be useful also for other people.
Buona giornata,
Ruggero
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
