topic Re: NPrinting crashes when adding data labels from cells in Excel template in Qlik NPrinting

NPrinting crashes when adding data labels from cells in Excel template

StefanE — Mon, 16 May 2022 08:42:31 GMT

Hello Everyone,

Everytime I want to change data labels from value to value from cells, Nprinting Designer crashes and the error message reads "RPC server is unavailable"

Just for the record: I'm working with regular combo charts, not pivot charts.

Does anyone else has this problem and is there a way to fix this?

Thanks in advance and kind regards

Stefan

Re: NPrinting crashes when adding data labels from cells in Excel template

Ruggero_Piccoli — Mon, 16 May 2022 12:43:32 GMT

Hi,

Be sure that you have the screen zoom level set to 100%. September 2020 is quite old so I also suggest to upgrade to latest version (May 2022 right now) to benefit of all solved bugs.

Best Regards,

Ruggero

Re: NPrinting crashes when adding data labels from cells in Excel template

Frank_S — Mon, 16 May 2022 15:44:42 GMT

It's not clear what you are doing exactly.

Can you elaborate if:

You are attempting to create a combo chart with Qlik Sense straight table data using MS excel
Or are you trying to modify Qlik Sense combo chart properties inside the NP designer. The NP designer example below is with QS combo chart object dropped into the NP designer excel template.

I've stopped trying to repro the issue until you can provide more details or exact steps to reproduce the issue, if you are using a Qlik Sense combo chart or if you are trying to create a combo chart in the NP designer using MS excel tools.

Kind regards...

Re: NPrinting crashes when adding data labels from cells in Excel template

StefanE — Tue, 17 May 2022 11:48:22 GMT

Hi Ruggero,

Thanks for your reply! I checked the Zoom level and it is at 100%. We do have an update of our NPrinting version planned for this summer so maybe some "problems" will be solved that way.

Kind regards

Stefan

Re: NPrinting crashes when adding data labels from cells in Excel template

Ruggero_Piccoli — Tue, 17 May 2022 12:08:22 GMT

Hi,

Thanks for the feedback. You can also try to do the same action on a new template to understand if it is related to a specific template of if it happens every time.

Best Regards,

Ruggero

Re: NPrinting crashes when adding data labels from cells in Excel template

StefanE — Tue, 17 May 2022 12:22:31 GMT

Hi Frank,

Thanks for your questions. Of course I can elaborate:

So what I basically have are Actual and Budget values I want to display in a combo chart. I also add a separate line with values for data label positioning with the higher value of the two (acutal or budget):

Next, I activate data labels in the chart tool. This solely for the column data label position line.

Following this, I select data label formatting, in the option menu deselect "value" and select "value from cells"...

What I want to do is exchange the values, only used for data label positioning, with values from the Actual data row. Selection of the Actual data row leads to the error.

This works fine in the created Excel report, but not when I try to do this in NPrinting Designer.

I hope this made it a little more clear.

Kind regards

Stefan

Re: NPrinting crashes when adding data labels from cells in Excel template

StefanE — Tue, 17 May 2022 12:28:01 GMT

Hi Ruggero,

Unfortunately, It is a common problem across all (our) Excel templates.

Kind regards

Stefan

Re: NPrinting crashes when adding data labels from cells in Excel template

David_Friend — Tue, 17 May 2022 18:25:53 GMT

Are you using Office 365?

Re: NPrinting crashes when adding data labels from cells in Excel template

Frank_S — Tue, 17 May 2022 19:48:11 GMT

Hi @StefanE

I've done additional testing and found that NPrinting tags used in the template editor or in MS excel result in the combo chart option to become disabled.

MS Office doesn't like the < and> tags. The OK button is 'greyed out' whether as a stand alone spreadsheet or when used within the NP template editor.

Further, inserting data directly into the NP template editor is not a supported method for building reports.

It is necessary to use NPrinting table or image field Tags etc within the template editor to create NPrinting reports.

Since MS excel doesn't like those open and close tags which represent NPrinting report data, then it looks building an MS combo chart with Qlik Source data is not possible.

Did this ever work for you before? If so, it may be a change in the way MS excel processes NPrinting tags (open close < > tags).

Thus I would recommend that if you need a combo chart as an NPrinting report, that you build it in Qlik Sense, reload your NPrinting connection, then use the combo chart object tag (as shown in my original response) to create your report with.

Kind regards...

Re: NPrinting crashes when adding data labels from cells in Excel template

StefanE — Wed, 18 May 2022 06:26:02 GMT

Hi David,

Not yet. We use Office 2016.

Re: NPrinting crashes when adding data labels from cells in Excel template

StefanE — Wed, 18 May 2022 06:57:45 GMT

Hi Frank,

Unfortunately, this issue is independent from <> tags. They play no role in this. If you insert hard coded data and try to change the data labels with "value from cells" you can select a range of values, but then it crashes after pressing "ok".

Take a simple data set like below, make a bar chart out of it, activate data labels and then try to change the data labels from value to value from cells and select i.e. the regions. If this works for you, it's probably my old version of the template editor.

Kind regards

Stefan

Re: NPrinting crashes when adding data labels from cells in Excel template

Ruggero_Piccoli — Wed, 18 May 2022 09:12:20 GMT

Hi,

In my opinion we need to test if this issue still appear on latest version or if it was solved. I checked the release notes but I think the best way is to test directly. If it is not solved it needs to be investigated by developers.

I suggest you to open a support ticket with all details we need to reproduce (include a qvf and some templates where the issue appears and a link to this conversation) so we can test on May 2022. If May 2022 solves it will become an upgrade issue.

Best Regards,

Ruggero

Re: NPrinting crashes when adding data labels from cells in Excel template

StefanE — Wed, 18 May 2022 13:12:39 GMT

Hi Ruggero,

I guess I have to resort to that option. I'll see what they can find out.

Thanks and kind regards

Stefan

Re: NPrinting crashes when adding data labels from cells in Excel template

StefanE — Thu, 19 May 2022 14:14:05 GMT

So, just a quick update. I couldn't find a solution for my issue but at least a workaround that works until our NP Update.

What I did was I activating data labels for data label positions. At first values from column M were shown. Then, I edited every data label and referred to the values in column H, the Actual values.

It's not ideal and manual labor but it works for now. Let's see if the Update helps...

Re: NPrinting crashes when adding data labels from cells in Excel template

francesco_menin — Tue, 15 Jul 2025 10:22:29 GMT

Hi all, I'm sorry to get back to this issue but I see that current NP version has still this issue.