Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Gus01
  • Order by date
  1. Gus01

    Bar chart - Format Labels (Group and Data)

    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...
  2. Gus01

    Highlight crosstab field background based on another field

    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
  3. Gus01

    Highlight crosstab field background based on another field

    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...
  4. Gus01

    How to adjust the height of a chart

    yes thank you, I agree I am disappointed but it is that what I understood.
  5. Gus01

    How to adjust the height of a chart

    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.
  6. Gus01

    How to adjust the height of a chart

    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
  7. Gus01

    Crosstab : changes between 2 columns

    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...
  8. Gus01

    Crosstab : changes between 2 columns

    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...
  9. Gus01

    Crosstab : changes between 2 columns

    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...
  10. Gus01

    Crosstab : changes between 2 columns

    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...
  11. Gus01

    Crosstab : changes between 2 columns

    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 ?)...
  12. Gus01

    Crosstab : changes between 2 columns

    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 ?
  13. Gus01

    Crosstab : changes between 2 columns

    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...
  14. Gus01

    Crosstab : changes between 2 columns

    hello in a crosstab is there way to display the changes between 2 columns : 2008 2009 2010 Values 10 12 15 Changes - +2 +3 % - +2% +2,5% Thanks
  15. Gus01

    Crosstab : suppress empty lines

    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...
  16. Gus01

    Crosstab : suppress empty lines

    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...
  17. Gus01

    Crosstab : suppress empty lines

    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...
  18. Gus01

    Crosstab : suppress empty lines

    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...
  19. Gus01

    This field name is not known when 0 record

    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...
  20. Gus01

    This field name is not known when 0 record

    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...

Part and Inventory Search

Back
Top