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
  • Content: Threads
  • 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

    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...
  3. 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
  4. 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
  5. 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...
  6. 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...
  7. Gus01

    Replace a running total to show in GroupHeader

    Is there a way to replace a running total, to show the total in the groupHeader ? Group Section Group1 Group2 Group3 Total = summarize fld1 evaluate : on change of group Group3 Reset : on change of group Group2 Thanks for help !
  8. Gus01

    GroupTree - Drill and Lens

    Hello, Where is the option in a report to show / hide the lens visible on GroupTree in CR viewer ? Thank you for your help
  9. Gus01

    RunningTotal on formula using whileprintingrecords

    Hello, I may be missing something? In this faq : http://www.tek-tips.com/faqs.cfm?fid=2323 I see: "To summarize second-pass formulas, create running totals using variables and the WhilePrintingRecords function." But the following formula @f1 can not be selected for RunningTotal [CR for...
  10. Gus01

    Compare Summary or RunningTotal with the previous group

    Hello, Is there a simple way to compare the sum of a field with the sum of the same field the previous group (like previous() on a simple record) ? Ex: group fld1 2006 100 2006 110 2006 120 2007 200 2007 210 -> Sum (fld1, 2007) - sum (fld1, 2006) = (100 +110 +120) - (200 + 210)...
  11. Gus01

    GH section, number of lines in the Group

    Please, What is the best way to know in the GroupHeader Section (variable or formula) the number of lines in the group ?
  12. Gus01

    Display a number preceded by the + sign

    Hi, Does anybody know how to display a number preceded by the + sign if positive? and that this number does not become a string, not : '+' & {MyNumber} eg: + 26 Thank you for your help
  13. Gus01

    How to number pages, indicating number of pages for each group

    Hello, Have you any idea how to number the pages of a report by starting with 1 at each change of group and also indicating the number of pages for the group. For example: Page x of n Either Invoice No. 1: Page 1 of 3 Page 2 of 3 Page 3 of 3 Either Invoice No. 2: Page 1...

Part and Inventory Search

Back
Top