This topic is locked

different table in report

2/10/2008 5:42:16 AM
PHPRunner General questions
D
danaci author

hi,

dear jane,

can I show field different table fields in reports?

ex. I have table1=ages, table2=company, table3=other
in Header bands company_name company_address vs

-----------------------------------------------------------------

in detail bands name, birthday, age

in detail bands name, birthday, age

in detail bands name, birthday, age

in detail bands name, birthday, age

in detail bands name, birthday, age

---------------------------------------------------

in footer bands company_author1 company_author2 other table fields1

in footer bands company_author1_sign company_author2_sign other table_fields2 vs vs

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7517&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />

J
Jane 2/11/2008

Hi,
this task can be accomplished creating custom view on the Edit SQL query tab and adding some custom events on the Visual Editor tab.

You should be familiar with PHP and MySQL for that.

D
danaci author 2/12/2008

dear jane,

sql create for different table is not problem.

problem is table fields not focused header band and footer band.

I need for header and footer band table fields place.

Only place pagination band.
I want this report template
-------------------------------this header part--------------

title(table fields)

company name: table fields1

company adress: table fields2

company tel : tabşe fields3

-------------------------------this detail part----------------

name1 surname birtday ...........

name2 surname birtday ...........

name3 surname birtday ...........

name4 surname birtday ...........

name5 surname birtday ...........

name6 surname birtday ...........

name6 surname birtday ...........

name7 surname birtday ...........

name8 surname birtday ...........

name9 surname birtday ...........

..

..

..

----------------------------this footer part -------------
company author name || personel name || personel name2

table fields..................|| table fields........ || table fields.....
problem is not placed header and footer part table fields
what can I place table fields in header and/or footer part.
thx.