help on formatting

[sameer11]

Hi All,

1). Can we do row headings in Cross tab so that the heading show up on every page of the cross tab? How can we do that?

2). Iam using a formula as a cloumn heading to show up in the cross tab and want the part of text to be printed in bold, but how?

@column heading This is what iam doing)

'Category ID: '+{table.category_ID}+' ' + chr(13)+chr(13) +'breed1 breed2 breed3';


This is how I need the column heading to appear:



Category Id: Cats ( This needs to be bold)

Breed1 Breed2 Breed3



Thanks in advance for any help provide

Sweetie pie

 

[synapsevampire]

All sounds strange, but to bold something click it and select the BOLD icon on the titlebar.

As for the column headings, by default they show up on every page. If you're using a formula with a chr(13) and trying to manually place labels, I think that you misunderstand how cross-tabs work, your headings should be the Column in the Cross-tab expert.

Oterhwise you might want to create a manual cross-tab using Running Totals or some such.

-k

 

[lbass]

If you mean you want a heading above the row labels, there isn't a good way of doing this, but there is a method for creating a label along the left hand side. Create a formula like:

whilereadingrecords;
"Breeders"

Insert this formula as another row field in the crosstab and then drag it to the topmost position. This now acts as an outer group that contains all rows. If you want to, you can click on the label in preview or design mode->format->common->rotate text->90 degrees so that it prints sideways. You can then narrow the column and format it to center the text. Within the crosstab expert, go to the customize tab and check "repeat row labels on each page." This will allow the row labels to appear on virtual pages.

For the bold text you wanted, I don't know why you are using returns and multiple breeds within the formula, but to create a formula with one word bolded, use:

"This is the " + "<b>"+{table.cat}+"</b>"+" that I want."

Add "whilereadingrecords:" in front of this, if you want to use it as a column field in the crosstab. Then while in preview or design mode, select the formula->go to format->paragraph formatting->text interpretation->HTML.

-LB

 

[sameer11]

Can anyone help me creating a manual cross tab like report. i tried doing the cross tab but having trouble formatting it the way the user want it.

Here is want my user want to see the report

in some case we have more than one cartergory and when that is true I need to display the results as below shown example:
and find if the id is existing in all the type tables. I have worked out get the data right
I hope I made myself clear.




id desc status user catergory: cats catergory: dogs
typ1 typ2 typ3 typ1 typ2 typ3


1 aaaa a xxx there-no table-there there-not there-there

Thanks in advance,

Sweetie pie

 

[sameer11]

even the cross tab report i have tried to do show up in report header section how can I get it into the page header section or page footer section???

Any help is greatly apperciated

Thanks,

Sweetie pie

 

[lbass]

Before deciding to use a manual crosstab, try concatenating your row fields in a formula {@userid}:

totext({table.id},0,"")+" "+{table.desc}+" "+{table.status}+" "+{table.user}

Then insert a crosstab and use {@userID} as your row field. Add {table.category} and then {table.type} as your column fields, and count of {@userID} as the summary field.

You cannot place crosstabs in page headers or footers. They belong either in report headers or footers or group header or footers.

-LB

 

[sameer11]

Lbass,

I have tried to create a fromula as u said but I have a date field too and it error's " A string is required"

Thanks,

Sweetie Pie

 

[Madawc]

TO show the date, say Totext({your.date}), which turns it into a string.

You can also format it, e.g.
Totext({your.date}, "dd-MMM-yyyy"),

Madawc Williams (East Anglia, UK)