Thanks IanWaterman.
Given its a multiple to mutliple relationship between the table. Is there any way in Crystal Reports I can present the data without producing multiple outputs?
Thanks for you swift reply-but the output is still not as I require it to be.
example
Field 1 had 2 records
Apple
Banana
Field 2 has 2 records
Grapes
Pine apple
Now if i group them. The output is as follows
Apple
Grapes
Pine apple
Banana
Grapes
Pine apple
I need a single list with all the...
Hi,
I am a newbie to crystal reports. Currently I have been assigned to generate crystal reports out of Rational ClearQuest.
In the body of the report its quite happy if I select a single field with multiple enteries, it only produces a single report when run.
The problems occur when I place...
Apologies, its the mangements who after reviewing the report have requested an ammendment to the report.
At the moment Introduction section is with the heading number 1.
The sections as stated above(1.pre-req,2.Vendor Software,
3.Internal Software ,4.Problems fixed) are all under heading...
Fantastic LB, that works great.
Just a final refinement. Now the headings are in section 2 on the real report. So Pre-requisits should be 2.1(section 2 part 1), How can I modify this query to show this?
Ash
That looks great, I think we are nearly there, I have applied the Above query, it come back with " The result must be Boolean".
Also when Applying the above query, do I need to place a tag in the sections area so it looks at the query and applies the increment to the section?
Thanks
ASH
Hi,
I am following different fields for each. See the design report attached to make more sense of what I am trying to achieve. So as a normal report I want the Headings incremented according to what is selected.
Let me know if you can view the design...
As this the the first report I have designed, the headings are set out as details a= Pre-requisits
details b= Vendor Software
details C= Internal Software
etc etc
The formula used to supresses the section is under section expert>Supress(NO Drill-Down)
if {ClearQuest.prereq_tab}= 'N' then...
These 4 headings at the moment are headings for sections I have created.
These numbers are neccessary as I am converting a current report which is done manually with heading and subheading and the company wishes to keep the report format.
May it be better if I change the sections into Groups?
Hi,
I am new with Crystal reports and I needed some help on a query that I am trying to build. The report works with VB, on the forms I have a tick boxes that give me the option to select which sections I want in the reports, I have managed to set this up by allowing suppressions of sections...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.