Hello,
I use CR delivered in Visual Studio 2005.
I have two questions on the format of bar charts (see attachment):
- Is it possible to customize the appearance of Group Labels, to expand the length of the text
- When data is requested 'Show as a percentage of', what is the right format for...
Great !
Before posting, I had tried without success by adding {table.state} to the crosstab but I didn't know the tips for formatting the crosstab.
Now it works !
Clever tips, thank you LB
Hello,
In a crosstab, how do I change the background color of a field based on another field.
For example: Table(Year, Label, Value, State)
The crosstab is: Column=Year, Row=Label, Field=Value
2008 2009 2010
Label1 val1 val2 val3
Label2 val4 val5 val6
The formula on the field...
Correct.
The height of the chart should be proportional to the number of groups to display (and the size of the bar will be almost always the same)
Thank you for your suggestion.
There is no way to change the Height property of the chart once the report is opened.
Hello,
Is it possible to adjust the height of a chart (horizontal bar) depending on the number of rows (groups) that will be drawn ?
(Crystal Report 10)
Thanks
Gus
That is correct, the report can be run on different databases with different customers.
Each customer has its own set of data, with ranges in different years at each customer.
Since the information of minimum year (and maximum) to be displayed is contained in the database, I do not wish to...
The years to be displayed are determined by the data in the database.
To know the range of years, I can use a formula with minimum or maximum({A.Year}), but as you say, I can not use this formula in a summarize field, and manual crosstab uses summary fields.
So I am looking for the value of...
Thank you for your reflection.
The crosstab is a part of a main report and is found in several reports. The choice of a subreport facilitates the update.
I do not know in advance the number of years to display. But the width of the page displays only the last 7 years. There is different cases...
Unfortunately, I get "Load report failed" when I use the formula minimum({A.year}) to replace the {?StartYr} parameter.
To retrieve the first and last year in the Main report, I thought that creating a first subreport which return to the Main report these years.
Main report
firstSubreport...
Very good! it works perfectly, thank you.
It remains to determine the first and last year to display.
I can not use subreport, because this report itself may be inserted in another report.
Do you know if there is a way of knowing the first and last year of data (sorting + first / last record ?)...
True, the maximum number of columns are the 7 latest years;
So I have to create a formula for each year?
@ValueN (N= 0 to 6)
if {A.Year} = Maximum({A.YEAR}) - N Then
{A.Price}
Else
0
How to calculate the increase ?
Thank you for your reply.
And sorry for the percentage increase, manual calculation ...
I don't know the number of years to display, so I don't think I could use a manual crosstab.
I can not show the increase between two columns,
1) I have to filter to select only certain rows
formula f1 : If...
The field is already in the detail section and the formula is in the 'x+2' button of the field.
With a true formula (in the detail section), it shows 'NULL'.
What do you mean by 'no column field to suppress, just the summary itself and its label.'
There is always a summary on a field in a...
With 'maximum' directly on the field in the crosstab, the result is OK.
That's cleverer than the runningtotal ! Thanks.
but unhappy, the empty line is still in the crosstab ... (I verified that 'suppress empty rows' is on)
I don't really understand which value has the "empty" field.
This...
Thank you for your answer.
In fact in the report, there is a main table 'M', wich is linked (left outer join) with secondaries tables S1, S2, ... on field 'Year'
The table M contains all the possibles values for 'Year', but 'Year' is not the primary key.
The secondaries tables contain...
Hello,
In a crosstab with a single column (Year) and multi Summarized Fields (for example : # Dogs and # Cats), is it possible to suppress a line when the values for each year is Null (or Zero).
With this data :
Year Dogs Cats
2008 5 Null
2009 2 Null
2010 3 Null
crosstab =
2008 2009...
I get it by double clicking it from a list of field names, and the report is shown when there are rows in the table Tb.
But sorry, I found the problem in the program, outside the report.
There is effectively no columns (no fields) in the table Tb, when the table is empty, so that's why the field...
Hello,
I have a report with 2 tables :
Ta --> fields (ANNEE, Fa1, Fa2)
Tb --> fields (ANNEE, Fb1, Fb2)
Link = Ta.ANNEE --> tb.ANNEE Left Outer Join
and this formula for knowing if there is 0 record in table Tb :
If IsNull({Tb.ANNEE}) Then
0
Else
{Tb.ANNEE}
But when there is no record in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.