HELP!!!!!!!!

[kdm72]

I am new to Crystal and I have to create a report. Enclosed is small sample of my data. I want to display this information as one record instead of if being several records. I tried creating variables and setting each variable name to its value, but the data was displayed with rows in betwween them. Do anyone know how to do this?

VARIABLE_NAME VARIABLE_VALUE WORKUNI
REQ_NAME John Doe 102805
RQH_ALLOC_PRI 00 102805
RQH_APPROVAL_VAL 000000000046.3300 102805
RQH_BUYER_CODE 102805
RQH_COMPANY 2150 102805
RQH_I_TOTAL 000000000000.0000 102805
RQH_N_TOTAL 000000000046.3300 102805
RQH_QUOTE_FL N 102805
RQH_REQUESTER doe1234 102805
RQH_REQ_LOCATION XXXX 102805
RQH_REQ_NUMBER 0047735 102805
RQH_X_S_TOTAL 000000000000.0000 102805

 

[synapsevampire]

Since you don't post anything technical, it's difficult to assist you.

Try grouping by the Workuni, then create formulas to acquire the values, as in:

whileprintingrecords;
stringvar Name:="";
stringvar Alloc_pr:="";
...etc...
if {table.VARIABLE_NAME} = "REQ_NAME" then
Name := {table.VARIABLE_VALUE}
else
if {table.VARIABLE_NAME} = "RQH_ALLOC" then
Alloc_pri := {table.VARIABLE_VALUE}
else
...etc...

Place this formula in the details section and suppress the details and the group header sections.

Then you can reference each of the variables in the group footer, as in:

whileprintingrecords;
stringvar Name;
"Name := " Name

whileprintingrecords;
stringvar Alloc_pr;
"The Alloc_pri = " & Alloc_pr

...etc...

-k

 

[kdm72]

synapsevampire,

I am not sure what you mean "Since you don't post anything technical, it's difficult to assist you."

My datasource is Oracle 9i. The table name is WFVariable. I am trying to create a report that will let the user see that status of their requisition in Lawson and who was the last person to approve it. I am trying to create a report that would list the information like this:

Company Location Req# Requester Total Approval
1000 XXXX 1234 John Doe 1200 (subreport)

The approval information comes from a seperate table WFMetrics. The field I am pulling from it is end_date, end_time and approver. To get the last approver I was going to go to pull the max date and time which would be the last approver on the list. The issue I was experiencing was this.

I created variable for each of the variable names, but when I went to print preview it looked like this

Company

XXXX

1234

John Doe
1200

I hope this explain my sitiuation more.

Thanks Karen

 

[Whitebat]

Hi have you already solved your problem ?
If not I would try to underlay the sections. ( Section Expert and then check the underlay section checkbox)

Regards,

Whitebat