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

    Forcing page break when rownumber>X

    Does any one know how to force a pagebreak if the details section contains more than, say, 6 rows.
  2. TomBoardman

    Absolute Position for group footer fields w/ varying detail length

    I'm using CR XI. My report paginates after each group and I want to print a group of fields (located in the group footer section) for an address at a specific location on every page. Since each group has varying # of rows in the details section, my address block is being pushed lower on the...
  3. TomBoardman

    Format field in GroupTree

    I am using CR ver 11 and I want to format the grouped field in the Group Tree as single decimal and no thousands comma. I am able to format the group field OK in the report. The group tree is defaulting to 2 decimal places and a thousands comma. Any help? Tom
  4. TomBoardman

    SQL command result won't display in report

    Using CR XI, I have a SQL command defined using the Database expert. The SQL command is simply, Select Sum(Column1) As TotalA FROM Mytable WHERE Column2='A' When I browse the SQL result within the Links tab, the result is correct. But when place TotalA into the page header section, the...
  5. TomBoardman

    Getting logon prompt for unsecured database

    I am using CR for Visual Studio 2005, for a windows ap, with an unsecured Access DB and when I try to print a report, the Logon prompt pops up. The user name defaults to "Admin" and the password is empty. I try to just press ok without entering a password but no success. I don't get the logon...
  6. TomBoardman

    Help with getting proper global var value

    I have several groups with a title "A", "B",etc up to about "H". In the groupfooter I have a summary field for the numeric field in each group. In the report header I have columns titled "A", "B" up to "H". Under each column heading I want to print the group total in the corresponding...
  7. TomBoardman

    Help writing a SQL command to for CR XI

    My CR report is intended to show water delivery activity for a given week but I also need to show the YTD deliveries, by month for the account. I have an account group in the report. Since CR is only going to step through my tables for a given week, I think I need to derive the YTD delivery...
  8. TomBoardman

    Create one report containing results of 4 different values of a field

    I am using CR ver. XI in vb.net and want to create one report that shows the record selection for a field that will be incremented from 1 to 4. I'm trying to avoid creating a seperate report for each of the 4 values. I intend to paginate between values. Any help would be apprecriated! Tom
  9. TomBoardman

    Dates on X-Axis with line chart

    I am using CR 11 and I am trying to display a line chart using a date field for the x axis. I am trying to get CR to display a date in 'Jan-99' format once for each year and show ticks for the other 11 months in between labels. Each record in my datatable has 1) a date field that is the first...

Part and Inventory Search

Back
Top