topic Re: Applying RGB codes in Pixel Perfect in Qlik NPrinting

Applying RGB codes in Pixel Perfect

Arthur_Fong — Fri, 13 Sep 2019 06:33:51 GMT

Hi all,

How can we apply RGB codes into a formula object?

I have 3 formulas created via pixel perfect and the colors have to be assigned according to the RGB codes given by our client.

Any idea?

Thanks and regards,

Arthur Fong

Re: Applying RGB codes in Pixel Perfect

Daniel_Jenkins — Sun, 15 Sep 2019 05:16:18 GMT

Hi Arthur,

We will need more information than that if we are to understand your requirement. Not sure what the screenshot is trying to convey either. If you provide a simple QVW/QVF and a mockup report of your expected output explaining what you want colours to be based on you may get a more helpful response. PixelPerfect is really quite powerful and there is a chance similar solutions have been provided in the past. For example here's one that sets the background colour based on the value of a field: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Npriting-Conditional-Format-Rules-Pixel-Perfect/td-p/1097125

HTH - Daniel.

Re: Applying RGB codes in Pixel Perfect

Arthur_Fong — Sun, 15 Sep 2019 05:25:48 GMT

I think my question is pretty straightforward.

Instead of changing the foreground color with the fixed colors in the settings on the left panel, is there any way we can assign RGB colors into the selected pixel perfect text object or formulas?

Re: Applying RGB codes in Pixel Perfect

Daniel_Jenkins — Sun, 15 Sep 2019 05:56:04 GMT

Hi Arthur,

That clears up the requirement for me.

You can use script to format the control.

Example:

Lets say your Formula control has name label1

You can add C# code in the BeforePrint event

I used RGB(0,100,45) like this:

private void PixelPerfect_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) {
label1.ForeColor = Color.FromArgb(0, 100, 45);
}

Which results in:

HTH - Daniel.

Re: Applying RGB codes in Pixel Perfect

Arthur_Fong — Sun, 15 Sep 2019 08:30:13 GMT

Do we have a complete documentation on using scripts in pixel perfect report?

Re: Applying RGB codes in Pixel Perfect

Arthur_Fong — Wed, 23 Oct 2019 04:13:54 GMT

I found a better way to apply RGB codes in pixel perfect without using scripts.

In the desired label properties, select foreground dropdown and click on any colors on custom tab.

Then, change the RGB code displayed to the designated RGB colors.