Bug in PDF-Report with WHERE-Clause

Hi,

given report type: Records per Line

SQL-Command (Master):

SELECT MasterID, field1, field2, field3 FROM table_master WHERE [B]MasterID = 1[/B]

SQL-Command (SubSelect):

SELECT SubID, MasterID, field1, field2, field3 FROM table_sub WHERE MasterID = {MasterID}

This works fine …

I want now a multipage pdf and change the SQL-Command (Master) to:

SELECT MasterID, field1, field2, field3 FROM table_master WHERE [B]MasterID IN (1, 2)[/B]

In this case, SC prints a “mixed” record set … = Bug!

Hello,

Issue reported to our bugs team.

regards,
Bernhard Bernsmann

Hello Reinhard,

Our bugs team followed all steps you described but was unable to simulate the issue.

Could you export your application to bugs@scriptcase.net?

regards,
Bernhard Bernsmann

Hello Bernhard,

i have send two test applications and the sql file.

Hello,

I will “update” them as well.

regards,
Bernhard Bernsmann

E-Mail send: at 14.08.2013
Response at: 21.08.2013 (“We simulate your problem …”)
Solution: ?

Hello Reinhard,

I will get in touch with our bugs team.

regards,
Bernhard Bernsmann

Hello Reinhard,

I was informed by our development team that this is actually the default behavior of Records per Line Report.

regards,
Bernhard Bernsmann

Yes, but that is regardless a bug!

This “information” has by the way now take nearly a month. Do you understand why most people do not think much of netmake support? Or pay for it …?

@John L. Santos: this problem / bug is not solved …

Hello Reinhard,

I will contact our bugs team.

Thanks!

Hello,

I talked last week with the developers regarding this problem. It really is a default behavior of the application,
the application Report PDF uses the FPDF PHP class, and not even the FPDF allows this behavior.
We’re checking out a workaround using a foreach, as used in the body of the PDF.
Once I get some feedback, I send you a response.