[vargas]

Hello, Need some help, using Crystal 8.5

Need to show in one page Project and theproject attibutes description for each project.

Project table is related to projectattributes and project attributes is ralted to table entries.
I created diferent formulas based on the code_tableid in the table entries. When I put projectid in crystal form is fine, then adding the formula fields based on the codetableid the fields are not grouped in the same form. data will show in different pages.
example.

project id =100 this id contains 3 attributes in the project attributes table. table entries contains descritions to related to project atrributes. created a formula A,B,C.
A = if({TABLEENTRIES.CODETABLESID}=1004) then {TABLEENTRIES.DESCRIPTION} else ""
B = if({TABLEENTRIES.CODETABLESID}=1005) then {TABLEENTRIES.DESCRIPTION} else ""
C = if({TABLEENTRIES.CODETABLESID}=1006) then {TABLEENTRIES.DESCRIPTION} else ""
Need one form for each project id showing theresults of 3 formulas A, B,C.

Currenlty It only shows one page showing formula A. next page showing formula B and third page showing formula C.

Any sugesstions. Thank you in advance

[DrewAllen]

It sounds like you have a page break after each detail section, when what you need is to create a group on the project and then move the page break to after the group footer.

Another option is to flatten the information for yourself. Currently, you are getting one record for each combination of project and attribute when it sounds like what you want is just one record for the project with separate fields for each attribute. I'm not sure if FE supports this the way that RE does, but you'd need to add three separate instances of the attribute table with the appropriate filters applied to only get one type of attribute per instance.

Drew

[vargas]

Thank you Drew, I followed your instructions. I do not have a break on the detail section. I also followed your instructions on creating a flatten the info. I added an alias for each attribute. How do you filter data for each attribute. The formula A is based on its own alias table, B and C.
A=if({TABLEENTRIES_COLLEGE.CODETABLESID}=1004) then{TABLEENTRIES_COLLEGE.DESCRIPTION} else ""
B=If({TABLEENTRIES_DEPARTMENT.CODETABLESID}= 1002) then{TABLEENTRIES_DEPARTMENT.DESCRIPTION} else ""
C=if({TABLEENTRIES_FUND.CODETABLESID}= 1003) then {TABLEENTRIES_FUND.DESCRIPTION} else ""

Is this correct? also how do I fileter for each attribute. thanks

[DrewAllen]

Are you using export or ODBC to pull in your data. This is something that you would do in your export. I don't have access to FE here, so I can't tell you what steps to follow.

Drew

[vargas]

thanks. I am using ODBC.

[DrewAllen]

If you can create views, then you should create a view for each of the attributes and then join to each of those views rather than the whole attribute table. You'll want to use a left outer join.

If you can't create views, you have a couple of options, but they can get complicated. From the simplest to the most complex:

Use three sub-reports: one for each attribute. Filter in the sub-report for the appropriate attribute.

Create three formulas: one for each attribute. In the group header (or footer) calculate the maximum of that formula.

Simulate views by editing the SQL statement. First use the Database expert to join to three copies of your attribute table using OUTER JOINS. Then go in and edit the SQL expression so that the join criteria for each of these tables includes the attribute description being equal to one of your three attributes. You'll want to use a different attribute description for each of the three tables. Once you do this, you'll no longer be able to use the GUI Database Expert to modify your report without losing these edits. This option is not for the faint of heart.

Drew