Conditionally Highlighting Summarized fields in cross tab - Crystal Report

Are you trying to use the highlighting expert?

mlmcc

I think since this is related to crosstab, though we can get the Total of rows individually for each column field using getTotalValueFor, we cannot compare the same for different column values (companies in this case).

What version of Crystal are you using?

There are ways to access the column/row values that might work but I won't know until I can try a couple of ideas.

mlmcc

Hello @mlmcc and @Raghavendra,

I am using Crystal Version SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer

I tried using highlighting option, but it does not highlights a particular cell background.

As my requirement is to compare the least subtotal.

I created a group for  suppliers/company and created a formula as given above.
But gives me an error saying "This field cannot be used as a group condition field".

My formula :

NthSmallest (1, {@SubTotal},GroupName ({procPurch_Rpt_AnalysisQuotesBySuppliers;1.Supplier Name}))

How can I achieve this on a particular part name and supplier name

Hi,
Let me clarify this, you need to highlight the total value for smallest subTotal right (6414.06 under Total) right?
If so, the points mentioned in my last post will do.
Or are you looking to highlight minimum of each row (for each part)? I think your original question was for Totals of sub totals comparison.

You need to change your formula as NthSmallest (1, {@SubTotal},{procPurch_Rpt_AnalysisQuotesBySuppliers;1.Supplier Name})

To answer your question "How can I achieve this on a particular part name and supplier name", if you are looking for Total of Sub Totals for each Company (Fuji Trading Company... etc.), then nothing else is required, no need to check for Parts.
Can you tell me which values refers to Supplier Names in your screenshots? Is it same as Company Names?

Let me clarify this, you need to highlight the total value for smallest subTotal right (6414.06 under Total) right?
------------------No, Not the last summarized totals. Only the subtotals. Each cell.

If so, the points mentioned in my last post will do.
------------------Yes. It worked same way.

You need to change your formula as NthSmallest (1, {@SubTotal},{procPurch_Rpt_AnalysisQuotesBySuppliers;1.Supplier Name})
-----------------Applied this in the formula field, Out put is  
then nothing else is required, no need to check for Parts.
-----------------Can you please elaborate?

Can you tell me which values refers to Supplier Names in your screenshots? Is it same as Company Names?
-----------------Supplier name is same Company name

Hi,
All the changes suggested in my earlier post were related to highlighting the Total value for Sub Total field.
Is it possible to save the report with data and share? The reason for asking this is I think the formatting with regards to background is not applied correctly and also since the changes are required at each row level instead of just for Total.

Hi

Please Refer this link

https://drive.google.com/open?id=0By-_z66pGEGrS2UzdWJWMjA1NXM

refer Report name : PurchasingExportAnalysisTabReport2

Formula name will be "test"

Hello Raghavendra,

I am really thankful to you for the help. Its what the exact format required.

Working with Cross - tab is sometimes so difficult. Can you please suggest me on can grow functionality w.r.t cross tab. For example, if the data in one cell is large, then it gets trimmed off instead of wrapping it and enlarging of cell.
Even while exporting cross tab to excel it's not the exactly what was designed in the crystal report. Any solution to achieve this?

Once again thank you for the above help :)

-Sailee :)

Hi,
Glad I could help.

With regards to "Can Grow" option, the feature is not supported for Crosstab fields. You can set the width of a column as per the longest data width it can have. There are workarounds like using a mockup Crosstab, but it has limitations that number of columns shouldn't be dynamic, i.e you need to know beforehand how many columns the crosstab data is going to have as this mockup crosstab will have to be built manually.

And for export option of crosstab, different export options comes with different types of options, if you can elaborate which option you used and how exactly you want the output (with headers, without headers etc.) we can look into the possibilities.

And, if your question is not related to the original question we are discussing in this thread, I would suggest you close this question with proper answer marked as correct and any other helpful ones and create a new question, so that it will be easier to track.

Hi,

Okay. I will add my question as a new thread.

Thank you once again!

Proper explanation and Required output provided