Also, even ommiting this line, the problem persists (case-2).
ReportPro 3 for X#(3.6.0.4) Problems with reports using DBFs
- Stavros Spanos
- Posts: 115
- Joined: Thu Nov 12, 2015 4:59 pm
- Location: Greece
Re: ReportPro 3 for X#(3.6.0.4) Problems with reports using DBFs
Because the DBF's are temporary files for the report need stored in the Workstations Temp folder, while the full WorkDir resides on a Server parh (ex. F:\..)
Also, even ommiting this line, the problem persists (case-2).
Also, even ommiting this line, the problem persists (case-2).
Re: ReportPro 3 for X#(3.6.0.4) Problems with reports using DBFs
Stavro,
So you have the dbfs ALSO in the .exe folder? That's what I understand, otherwise I don't see why you would change the data path to it.
Please give me a little time to have a close look to the second part and will get back to you.
So you have the dbfs ALSO in the .exe folder? That's what I understand, otherwise I don't see why you would change the data path to it.
Please give me a little time to have a close look to the second part and will get back to you.
Chris Pyrgas
XSharp Development Team
chris(at)xsharp.eu
XSharp Development Team
chris(at)xsharp.eu
Re: ReportPro 3 for X#(3.6.0.4) Problems with reports using DBFs
Hi Stavros,
One thing I noticed in this report, is that there exist many "Print When" conditions using the varaibles lShowCalls, lShowAppointments and lShowActions, but I don't see those declared anywhere. But removing them still doesn't fix the problem, so there must be something else to it.
Just to let you know, I'm still looking into this case 2, but still haven't found the root cause of the problem. Is this the only report that is giving this problem, or is it more or less all of them? If it's only say one or two more, can you please send them as well, it might help to see what they have in common.Stavros Spanos wrote: ↑Wed Apr 03, 2024 9:10 am Also, even ommiting this line, the problem persists (case-2).
One thing I noticed in this report, is that there exist many "Print When" conditions using the varaibles lShowCalls, lShowAppointments and lShowActions, but I don't see those declared anywhere. But removing them still doesn't fix the problem, so there must be something else to it.
Chris Pyrgas
XSharp Development Team
chris(at)xsharp.eu
XSharp Development Team
chris(at)xsharp.eu
Re: ReportPro 3 for X#(3.6.0.4) Problems with reports using DBFs
Hi Stavros,
I found the problem, it's because of the Seek Expression on the database file of the main section:
nUserId
this should be instead like the ones in the triggered sections, since it uses a string index key:
Str(nUserId,11)
Not sure why the VO version of RP3 does not complain about this..
I found the problem, it's because of the Seek Expression on the database file of the main section:
nUserId
this should be instead like the ones in the triggered sections, since it uses a string index key:
Str(nUserId,11)
Not sure why the VO version of RP3 does not complain about this..
Chris Pyrgas
XSharp Development Team
chris(at)xsharp.eu
XSharp Development Team
chris(at)xsharp.eu
- Stavros Spanos
- Posts: 115
- Joined: Thu Nov 12, 2015 4:59 pm
- Location: Greece
Re: ReportPro 3 for X#(3.6.0.4) Problems with reports using DBFs
OK Chris, this is fixed - thanks!
Re: ReportPro 3 for X#(3.6.0.4) Problems with reports using DBFs
Hi Stavros,
That's great, you're welcome! Is there any RP3 problem still remaining? Except for the one about the "Header and Footer bands" option being unchecked in some reports that should have it enabled that I'm looking into now.
That's great, you're welcome! Is there any RP3 problem still remaining? Except for the one about the "Header and Footer bands" option being unchecked in some reports that should have it enabled that I'm looking into now.
Chris Pyrgas
XSharp Development Team
chris(at)xsharp.eu
XSharp Development Team
chris(at)xsharp.eu