Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

agnes_li
New Contributor II

Access violation error only occurs with specific fields

I use NP designer to create an excel report. When I use the "Add Page" feature to add "Sales rep" as the page field, it always give me the following error when I hit "preview":

Access violation at address 01C8CB32 in module 'NPrinting.exe'. Read of address 00000000

I have a table that stores the sales rep information such as rep name, rep team and rep group. Not just the rep name I mentioned above, if I use rep team or group, I will get the same error. If I use other fields for example the product category, year or whatever, it worked fine.

Does anyone know why? Thanks a lot!

Tags (1)
1 Solution

Accepted Solutions
lubicz99
Valued Contributor

Re: Access violation error only occurs with specific fields

Couple things for you to consider and try.

1)     Any chance you have any null values in your sales rep table?  You can build a table box in QV to view all records

2)     Are you using Section Access in your QV document?  If so, what user name and password did you set up to access your QV document in the Source setup in Nprinting

3)     Try saving the Excel template with your sales rep paging, then build a task for this report and run the task so that you can see the log and see what is causing the error.  It should at least tell you what step in the process it is failing

If you have not resolved it, please post the screen shot of the log so that perhaps the forum members can help further

Hope that helps get you going  

11 Replies
lubicz99
Valued Contributor

Re: Access violation error only occurs with specific fields

If you are still getting your error, can you post a screen shot of your template screen, with the page + expanded to see what you are using for your paging option.  Might be helpful to see the report fields expanded as well.

agnes_li
New Contributor II

Re: Access violation error only occurs with specific fields

Hi Mike,

See the screenshots below.

Error.png

Error1.png

For the sales rep ID, I added a filter (picked some sales reps) to the report and previewed it again, the error disappeared. The report was created successfully. But the Sales Rep Team page option still cannot work even with the filters. I am confused.

My guess...

1. Is it possible that it has something to do with the field name?

2. Could it be related to the data size?

Thanks,

Agnes

lubicz99
Valued Contributor

Re: Access violation error only occurs with specific fields

Couple things for you to consider and try.

1)     Any chance you have any null values in your sales rep table?  You can build a table box in QV to view all records

2)     Are you using Section Access in your QV document?  If so, what user name and password did you set up to access your QV document in the Source setup in Nprinting

3)     Try saving the Excel template with your sales rep paging, then build a task for this report and run the task so that you can see the log and see what is causing the error.  It should at least tell you what step in the process it is failing

If you have not resolved it, please post the screen shot of the log so that perhaps the forum members can help further

Hope that helps get you going  

lubicz99
Valued Contributor

Re: Access violation error only occurs with specific fields

What is the latest Agnes?

Are you still working through this or did you get it resolved?

agnes_li
New Contributor II

Re: Access violation error only occurs with specific fields

Hi Mike, Sorry for the delay!

I just checked #1 and I think this could be the sticking point here. I do have null values.

So in order to use the page function smoothly, I need to make sure there is no null values in the table right?

MVP
MVP

Re: Access violation error only occurs with specific fields

Hi,

Check whether you have Section Access in your app?  If yes then give full access to the user which you are using to login .

Regards,

Jagan.

lubicz99
Valued Contributor

Re: Access violation error only occurs with specific fields

Hard to imagine you would have sales without a sales rep name attached.   However, the better place to resolve would probably be in your QV loadscript.  When loading your SalesRep field with your data, use this

if(SalesRep<> Null(), SalesRep,'Other') as SalesRep

This will assign all Null values to the name Other, which you can replace with whatever you want.

I have read several posts on this forum about issues when using null values in cyclic groups and paging.

Good Luck

agnes_li
New Contributor II

Re: Access violation error only occurs with specific fields

Thanks a lot Mike! It is really helpful!

agnes_li
New Contributor II

Re: Access violation error only occurs with specific fields

Thanks Jagan, it turned out I have null values in my sales rep table.

Community Browser