cross tab highlight a row 2

[njahnavi]

Hi I am using crystal report version XI release 2.
I have a cross tab report which has in the rows like 4 categories and in the columns like 2 categories.

I want the crystal report to highlight the whole line of "Row # 2 Name "

Any help would be greatly appreciated.

 

[Madawc]

For an ordinary field, you can right-click on a field and choose [Format Field]. This can be made conditional on a test.

Not sure if this will work in a crosstab. If not, you'll need to replace it with a mock-crosstab.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Select the cells you want colored and right click->format field->border->color->background->x+2 and enter:

if gridrowcolumnvalue("rowfield") = "Row#2Name" then
cryellow else
crnocolor

You should plug your rowfield into the gridrowcolumnvalue function and replace the curly brackets with quotes as shown, and then set it equal to the instance you want colored. This would have been easier to demonstrate had you provided the actual row field and the instance you wanted colored.

-LB

 

[njahnavi]

Thanks for the reply.
I am aware of doing for a particular field however i want the complete row line based on the value of a particular field.

I have a cross tab report where it shows values for each job against each date in the coming 6 months.

I want the column/row line to be highlighted or doubled anything that will catch the eye if it is a friday .

Thanks for any help

 

[njahnavi]

sorry please neglext the previous post i have posted. I have done it with out noticing the LB reply.

I guess i should have done a refresh before posting it.

sorry for any confusion. LB I will try and let you know if that solution worked.

 

[lbass]

You can use the above formula for all cells in a row. Select them simultaneously. For the row label, you might need to use:

if currentfieldvalue = "Row#2Name" then
cryellow else
crnocolor

-LB

 

[njahnavi]

if gridrowcolumnvalue("Reports_Load.aF_rJob") = "Row#2Name" then
cryellow else
crnocolor

I tried to mimic the formula you have given and it says "a number is required here" pointing to "Row#2 Name"

 

[lbass]

You should be replacing "Row#2Name" with the value for the particular row you want colored. If it is 1234 then the formula should be:

if gridrowcolumnvalue("Reports_Load.aF_rJob") = 1234 then
cryellow else
crnocolor

-LB

 

[njahnavi]

LB I tried both your formulae however i still get the same error saying "A number is required here"

I am giving you whole information. Please have a look

I have cross tab where in the columns i have two values
1)MOnth Year
2)Date of that particular month only weekdays.

In rows I have values like
1)JOb
2)Trailer COunt
3)Easil count

IN summary i have 3 values like

1)Trailer Count formula
2)JOB Erection Count Formula
3)Total Count formula

I have to have 3 summaries because the formulas are like that.

now the issue is the report want the column line next to every friday to be thick so that it will differentiate from week to week.

Also the report has to have highlighted the row which has the job summary which occurs after every job. I want that complete row to be highlight with some colur.

Pelase let me know if still some info does not make any sense

Thanks LB

 

[njahnavi]

I have generated a picture what my report is looking like.
I have obtained the row part by using your valuable advice however i want to generate the rose lines in the report for every friday pelase let me know if thsi gives a clear idea of what i am speaking.

IN the row part i dont want to see the black lines in betwween the olive colur for "Erection Row"

I want to have the Rose lines or Thick black line for everycolumn which is a Friday.

The column in database is {calendar.clanedardate}

 

[njahnavi]

I tried to attach a pictue however it is not taking it..how to attach a picture in the post.

 

[lbass]

I don't know what you are referring to by "lines". In the customize style tab->format grid lines, you can remove particular lines in the grid, but there is no option for customizing the lines.

I've never used the attachment option (below), but you do need to upload the file to some webwite, e.g., box.net.

-LB

 

[njahnavi]

By Lines i mean grid lines and i want the grid line of a particular column to be 0.5 and all others to be hairline.

Thanks for your support LB

 

[lbass]

As I said, there is no way to customize those lines in an inserted crosstab, so if you need that kind of control, you need to create a manual crosstab instead.

But are you saying you would be satisfied if you could color the background for all Fridays a rose color? If so, please clarify what your column #2 is--are you using a field with a date type and then displaying the weekday? Or using a formula? If so, what is the content?

-LB

 

[njahnavi]

Thanks LB for quick response.
I thought I can get away with Rose colour however now we want only the grid line to be thicker.
I will let them know that we dont have option to do that.

However my column #2 is a datefield and I have used format filed option to show only the day i.e 1 2 3..31.

field name is "calendar.calendardate"

I am really thankful for the continuous support provided.

 

[lbass]

Try:

if dayofweek(gridrowcolumnvalue("calendar.calendardate")) = 6 then
color(200,0,100) else
crnocolor

Not sure the exact rose color you want, so adjust the rgb values accordingly.

-LB

 

[njahnavi]

Thanks LB.