Bug in PDF-Report with WHERE-Clause

Scriptcase 7 Bugs
#1

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!

#2

Hello,

Issue reported to our bugs team.

regards,
Bernhard Bernsmann

#3

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

#4

Hello Bernhard,

i have send two test applications and the sql file.

#5

Hello,

I will “update” them as well.

regards,
Bernhard Bernsmann

#6

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

#7

Hello Reinhard,

I will get in touch with our bugs team.

regards,
Bernhard Bernsmann

#8

Hello Reinhard,

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

regards,
Bernhard Bernsmann

#9

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 …?

#10

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

#11

Hello Reinhard,

I will contact our bugs team.

Thanks!

#12

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.