Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.
Hi Mike,
See the screenshots below.
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
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
What is the latest Agnes?
Are you still working through this or did you get it resolved?
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?
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.
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
Thanks a lot Mike! It is really helpful!
Thanks Jagan, it turned out I have null values in my sales rep table.