Data in multiple rows to be printed on one page problem??? 1

[satshergill]

I am using a Crystal Sql query linked to a report. In summary the query return something like the follwing



Name Address Postcode Type
---- ------- -------- ----

CompanyA 123 Street CG15 42G ARCHITECT
CompanyB 234 Road GF15 23G PROJECT MANAGER
CompanyC 323 Lane GF21 2HH SURVEYOR


I have created formulae for each type of company i,e
Architect_name, Archtect_Address, Architect_PCode
Surveyor_name, Surveyor_Address etc....

With each formalae defined as
Architect_name

If Type = "Architect" then
Name


Then I want to create a report with all the records that
correspond to each type on one page i.e



Architect Name:xxxxxx PM Name:xxxxxxxxx
Address:xxxxxxxxx Address:xxxxxx
Postcode:xxxx Postcode:xxxxx



Surveyor Name:xxxxxx
Address:xxxxx
Postcode:xxxx



All above are in detail section

What I get is 3 pages with the Architect details on one page
with all the others blank, the PM deetails on another and the rest blank and so on.....

how do I get all on one page.

Also when using queries, you can't seem to add more than 1 query to a report. Is this true. Not great if you need to retrieve a lot of data with some returning one row and other returning many.....

 

[chelseatech]

What you really need are three detail sections with your labels and formulas for each type and conditionally suppress each section
{table.type}<>&quot;ARCHITECT&quot; // for the first section
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[satshergill]

Thanks for the help
I have this working now but I need Project Manager to be
the first detail. Sorting won't help because P is in beween
A and S

Any Help???

 

[darwin101]

This is not a pretty way to do it but I used this method once.

If Type = &quot;Project Manager&quot; then
'A. Project Manager'
and sort on this