Crystal Report

[lothos12345]

Using Crystal Reports I want to display a page per record in the database the report is pulling from, I just have no idea how to accomplish this. Any help offered would be greatly appreciated.

 

[synapsevampire]

Place the fields in the details section, right click the left side of the details section and select format section and select the new page after.

Now you'll get a new page for each row.

-k

 

[lothos12345]

Unforunately this will not work for me, I am already using this section this crystal report gets populated from a stored procedure where I a using a few tables to generate this record. I have a field in the main table that for each record this is field is incremented by one. Ideally when this field changes I would want a new page for the crystal report but I am unsure of where to put this field I have tried the detail section and it created undesired results. With the unioning of many tables to generate this crystal report and I only want the page to change when this field changes on the main table, I am hitting a brick wall. Any help offered is greatly appreciated.

 

[Madawc]

Ideally when this field changes I would want a new page for the crystal report

You should really have explained this first: how was anyone to know from what you posted?

The standard answer would be to group on this field. You can then select 'new page after', as synapsevampire advised. But do it for the group footer.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods change between versions, and higher versions have extra options. In this case it should make no difference.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lothos12345]

My apologizies but in order for this to work does everything else have to be in the group because I have report footer/header as well as fields in the page headers and footers as well. Does this need to be corrected?

 

[Madawc]

Have you tried following the advice you've been given? Crystal is very much trial-and-error, you learn by doing rather than attempting to work it out in advance - much more so than in other languages.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lothos12345]

You are correct I played with Crystal Reports for awhile and was able to find a solution. I thank you for your help.

 

[lothos12345]

I do have another question regarding Crystal Reports. I am using Crystal Reports 9 if this helps. I have created this report in Crystal that is being populated by a Stored Procedure in Sql Server. So basically the application passes an ID parameter to the Crystal Report it inturn sends it to the stored procedure that populates it and displays the information that the Stored Procedure returns as it should. My question is this since the SP is now returning multiple records with different ID I want to be able to make the first record displayed in the Crystal Report the record with the ID that matches the parameter fed in by the application in the first place. Any idea on how to accomplish this. Preferribly if code is code is involved in the Crystal Report I would like it to be the Basic Syntax not the Crystal Syntax. Any help offered is greatly appreciated.

 

[Madawc]

Please start a new post for a new topic. Among other things, the topic header may be useful to someone searching for an answer to a similar problem.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10