Fields disappearing from report after group is added!

[barc0001]

Hello all;
I am working with Crystal 8.5 and MAS90. I have a report that essentially prints the sales orders out, listing the items, the number ordered, price, total, etc. in the Details section. When I added a group to sort by generalized product line, two of the fields, the comments1 and 2 fields disappeared from the report, even though other fields from the exact same table still print fine. Here's specifically what happens:

Before the group was added, report details would print as follows:

<item number> < Item desc> <total ordered> <price> <amount (price x total ordered>
<comments1>
<comments2>

Repeat for each record.

After the group is added:

<item number> < Item desc> <total ordered> <price> <amount (price x total ordered>

and blank space where the comments fields would normally print.

Of note is that the Item Number, Total Ordered, Price, and the comments fields all come from the same table. If there was something about the group that caused the table to get gorked, they'd all disappear as well, wouldn't they?

Any ideas?

Thanks

 

[synapsevampire]

Are the fields physcially missing from the report, or just the ouput?

If it's just the output missing, I'd guess that you also have a smaller record set now too.

Since this is a new field (the group), perhaps it has something to do with your join/selection criteria.

I've exhausted the topic of a LO and when it is applicable, but this sounds suspiciously similar.

If this field is from a child table, then you are asking that the report only show rows which have that child.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[dgillz]

I too am suspicous of join type and record selection formula. Maybe you could post your record selection formula? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[barc0001]

The additional fields that disappear are from the same table, not a child table. The comments fields are probably still in the report, but as they are in a subsection that is suppressed if blank, they are effectively missing. I tried moving the comments fields into the first section as well where the item number, item description, etc are displaying/printing, and that made no difference either.
The group does not limit the record set at all, it's just there to organize the information in a specific order, there are 7 categories that each item printed belongs to and the group is there to gather them together in a specific order.

 

[synapsevampire]

Are you sure that this table isn't really a View, query or SP? It might contain a parent child relationship, from all indicators, that's the problem.

So what you're saying is that you get the exact same number of records with the group as without, yet some fields are missing? I didn't mean to imply that the group itself has a criteria to limit rows (records), I was asking for the number of rows returned with and without the group inserted.

Check it, I'll bet you find that it's returning less data, which explains the lack of comments (you didn't get those rows), and will confirm that the group is on a child within.

Which means that you can probably create a formula field to group on which will take into account the generalized product line, using an if to check the condition of the Generalized Product Line, and return the value if applicable, or Blank or some such when they're not.


if isnull({myfield}) then
&quot;No Generalized Product Line&quot;
else
{myfield}


Might work...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[barc0001]

Hi there;
No, it's not a view or a query, they're simply different fields in the same table... I do get exactly the same number of records with or without the group. Essentially, like I say, it's printing a sales invoice, and just using the group to organize the items on the invoice into product lines. The contents of the invoice (as far as the number of items) is the same, but the optional comments fields for these items on the invoice disappear.

 

[synapsevampire]

OK, I'm stumped...I'd Love to see this in action. As you describe it, a grouping can alter the values returned from the select.?.

I've worked with MAS90, with SQL Server as the backend, and I never experienced this, though they have a number of Views and Tables exposed for querying, which is why I suspected a LO condition.

Someone else here may uncover something, otherwise it sounds like a tech support call to MAS90 is involved.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kenhamady]

That is weird. I assume that you did you look at all of the output to see if the comments are only in later invoices?


It could also be that the comments are designed to only print when the records are in a certain position. What section of the report are the comments on? Try creating a brad new details subsection and inserting brand new comments fields onto it from Insert-Field Object menu, and see if they show up at all in your grouped report. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[barc0001]

SynapseVampire:
If you're familiar with MAS90 and have access to it, you might be able to see it live and in color for yourself. The fields in question are located in the SO_20CRWSalesOrderDetail table.
Ken: I've tried moving the items to different subsections and creating new subsections, etc, with no effect. I even created a new, simple report (as opposed to the monster that I have to actually have finished) and the problem appeared as soon as I added the group.

Thanks
Barclay.

 

[IdoMillet]

This is just a hunch, but it shouldn't take long to test it out.

Go to: File, Report Options

Have a look at the 'Perform Grouping on Server' option and if it's ON, turn it off.

hth,
- Ido CUT (Crystal UTilities): e-mailing, exporting, electronic bursting & distribution of Crystal Reports:

http://sobpc02.bd.psu.edu/CUT/CUT.htm

 

[synapsevampire]

Sorry, I haven't worked with MAS90 for a few years. Manufacturing contracts are rare for data warehousing/business intelligence in the Bay Area, I was in Washington when I used it.

I seem to recall that they exposed tables, Views and SP's for reporting, hence my suggestion.

Did you try creating a formula field as I suggested and grouping on it?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com