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: *

  1. NickieP

    Display records with identical field data

    Group on Statute code suppress rows where case <> group1 If you want just a list, rather than a report , Hide the group names but show the Statute code on the detail line so : Statute Code 28-701A case1 Statute Code 28-701A case3 This works if each record has both a statute code and a case...
  2. NickieP

    Order of values in the Legend of a stacked bar graph (Crystal 9)

    Then I'd double check the source data. Check there's not a space before the "J" in January.
  3. NickieP

    Order of values in the Legend of a stacked bar graph (Crystal 9)

    Hi, If your data starts at the end of year 1 into year 2, could your groups be Year & month rather than Months (1 -12)? This would make Jan(month 1 year 1) appear before Dec(month 12 year 2), where you just want Jan-Dec - regardless of year. Instead of group by month, group by month number...
  4. NickieP

    Hi I am trying to get a page foote

    Hi, I presume whole data set is a billing batch so : If G1 is Customer, G2 is Invoice(or credit note) your footer should be in G2 something like :[field.docname] [field.docno] page n/n - if you have credit notes, this work as Credit Notes will say "Credit Note", rather than hardcoding the...
  5. NickieP

    Conditional Row Suppression

    Create a formula field @Server&App {serverfield}&" "& if isnull{applicationfield}then "" else {applicationfield} Group on @Server&App (suppress detail) to get a list of all the servers and the applications, inc server if no application There's more than one way but if you just want a big list...
  6. NickieP

    Crystal Reports 10; MS SQL Server 2008 R2. Hide Header for cross-tab in footer.

    Create 2 formula fields: @SwitchPageHeaderOn WhilePrintingRecords; booleanVar ShowPageHeader := Yes place it in the group2 header(make font white on a white background to hide it) @SwitchPageHeaderOff WhilePrintingRecords; booleanVar ShowPageHeader := No place it in the group1 footer in...
  7. NickieP

    create month end dates when dates not passed

    Use a spreadsheet or Access table of all dates to link to the existing data. Link New.Date field from this new date table to Existing.Date field (left outer joing from new to existing field) Use the date filter on the new.date i/o existing date Then you will have all dates, with null in dates...
  8. NickieP

    Summarize Formula Which Uses PREVIOUS Function In Crystal - How?

    At detail level, try a formula field @timeinroom where it clears up all the instances of bad data here first at line level, using IF and case statements etc. You should then be able to refer to this new field and use PREVIOUS in a 2nd formula field or use running total functions on the new...
  9. NickieP

    I give...and need assistance with MINIMUM DATE AND CONDITIONS

    I would have 2 separate formula fields, one for diagnosis date, one for location. Then concatenate these in a 3rd field @Diagdate&"-"&@location group on these using specified groups so many options will be grouped together if required, or cross tab the results. Great if few locations and few...
  10. NickieP

    Duplicate Values being Calculated in my Running Total Formula

    oops, sorry forgot you were doing running totals. you can have a formula field that only counts the the first instance in the group @newfield if group1,fieldemployeenumber = previous(group1,fieldemployeenumber) then 0 else fieldsalary then sum or count the @newfield If the data...
  11. NickieP

    Duplicate Values being Calculated in my Running Total Formula

    Section Expert;details add a formula to suppress current row if a record for the same thing already exists (you must already have something in common to know you don't need both records). E.g. if an employee is in two teams, but you only wanted to show one team per employee without grouping the...
  12. NickieP

    Dynamic Parameter s not showing as list but blank

    Try database, set datasource location in the bottom pane, find the new connection(ODBC etc)and the DB With the table or whole DB highlighted in the top pane(current data) highlight the corresponding table or DB in the bottom pane(replace with) -if they agree(such as if pointing a test DB...
  13. NickieP

    Replacement for HP DesignJet 3500CP PS3 Printer Driver (Windows 7)

    Use Microsoft XPS Document Writer, set up a new paper type of large dims, call it Crystal. Make your reports use that paper size on that printer. It doesn't default to the new size, (unless they fixed the bug), but any reports you save that paper size on will keep it.
  14. NickieP

    Dynamic Parameter s not showing as list but blank

    Select the parameter and choose edit. Check the list of values has the radio button for "dynamic" checked and is pointing to the field with the options you wich to choose from e.g. country, city,person etc... CR may have defaulted the parameter to static and so is expecting you to type something...
  15. NickieP

    How do i create address labels in crystal 08 - repeat the same data ?

    Try creating a spreadsheet with one column numbered 1-8 8 because you need 8 repeats as there are 3 labels per row. If there was one label per row your numbers would have to go up to 24. Add s/sheet as a datasource, but don't link the tables You may get a warning, ignore it. Add the number...
  16. NickieP

    Dynamic shading area

    If you only want the group name shaded, put it in a text box and format that rather than shade the section of Group Heading. You can make it grow but this isn't ideal if you don't want wrapped text, but want all headings on one line and only shaded to the end of the text. You could conditionally...
  17. NickieP

    Using Excel as Data Source for Crystal Reports

    When Excel is used as a table in CR, CR looks at first 10 or so rows on a column, if they are numbers in a text field (but later rows are text) it will decide all of the column is numeric even if the column format is set as text - hence text fields don't show in CR. Test this by changing the...
  18. NickieP

    MS access linked table security

    I have mine set as ODBC's, then save p/w with rpt
  19. NickieP

    Label Printing in desktop computer and not in LapTop

    In the printer's settings, go to finishing(may be under advanced options)and change pages per sheet and possibly page order

Part and Inventory Search

Back
Top