Need helps ASAP with data being displayed

[MrHelpMe]

Hello,

I am currenty using crystal 9 advanced developer edition and have a report with 3 groups. One of the groups is department and the details are in the details sections. Nowe what I need is to display one department with it's details on the top of the page on each page and for every other group I need to say new page after. So basically my data should look like this

IT Services
Joe Smith 1234 Smith St 555-555-5555

IT Services
Smith Jow 2876 Ton St 555-5555-555

How can I get the value of one group to always display at the top of the page and get all other values from the group to be places on a new page. Hope this makes sense please let me know. I am trying to avoid subreports here. I am aware that I can do it with a sub but do not want to use this because the stored procedure is rather lengthy. Thanks and have a great weekend.

 

[synapsevampire]

Sorry, it's not clear to me.

You showed:

IT Services
Joe Smith 1234 Smith St 555-555-5555

IT Services
Smith Jow 2876 Ton St 555-5555-555

Where are the page breaks supposed to go in the above example?

Try posting example data and then showing how the output would look based on that data.

-k

 

[cisscott]

If i understand right, it seems that the "details" should actually go in the page header section of the report... Maybe I didn't follow the question correctly.

 

[MrHelpMe]

Sorry guys,

What I am saying is that at the top of each page there should always be one group that will always be there followed by by the next group. So for example in the database there are three values for name
1)Joe Smith
2)Cindy Lyn
3)Craig Rogers

My report is now grouped by name and in the details section I have other info. like address, city, gross purchases etc. If I run my report it will show the three values from the database and there associated fields in the details section. Hope this is clear thus far.
What I need the report to do is display every new group on a different page, however, I need one group(i.e Joe Smith and it's data from the details section) to always be displayed on each page followed by the new group and its values.

ie.
First Page

Joe Smith
1234 home st. toronto $12345.79
Cindy Lyn
219 Concession St Hamilton $20000.00


Second Page
Joe Smith
1234 home st. toronto $12345.79
Craig Rogers
659 lava st Burlington $50000.00

Etc
etc

Bottom line is one of the groups will always be dispayed on each page with a new group. Is this possible. Hope this is clear. Also keep in mind that the details of the group that will be shown at the top of each page can change too. Therefore, I do not simply need to just hardcode this data. Thanks.

 

[kskid]

Still in the dark. Based on your output, how does Cindy Lyn and Craig Rogers link to Joe Smith, which appears to be the same person based on your example.

Need more details on Table fields and selection criteria (i.e. Show SQL Query), grouping, etc

 

[MrHelpMe]

sorry wichitakid,

But it doesn't matter how Cindy and Craig link to Joe Smith. The bottom line is that I want Joe Smith's information to repeat on every page. This is what I am trying to gather. Joe Smith needs to be the first thing displayed on every page of the report followed but the next value in the grouping. The problem is that the value Joe Smith is grouped off a field on the report. I hope this is clear now.

I.E. Say for instance I have a names database field with 3 names:
Wichitakid
Salvatore F
Joe Smith

Now I base group 1 off the names field. In the record set, Wichitakid will come first then Salvaotre F and then Joe Smith. I go one step further and say new page after each new value in the group. Now the 3 names are displayed on different pages. 1 page Wichitakid, second page Salvatore F, and third page Joe Smith. Now say for instance I want to get Salvatore F and it's associated details to display on every page, how do I do this. I'm not sure what else I can provide you guys. I can't give you the SQL because I haven't created the report. I'm in the is it possible stage of planning.

 

[synapsevampire]

I'm not certain how well you understand databases, but it sounds like the nature of your data does not lend itself to this, so you might use variables to store the first rows values, and then display wherever you'd like them.

You might place the following formula in the Report Header:

//@firstrowvalues
whileprintingrecords;
stringvar Name:= {table.name};
stringvar Address:= {table.Address};
stringvar City:= {table.City};
stringvar Phone:= {table.Phone};

All of these variables would then be available anywhere in ther report, and would only have the first row values in them.

To display them, create formulas, as in:

whileprintingrecords;
stringvar Name

-k