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!

Register Log in
  • Congratulations IamaSherpa 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. jat139

    How To Vertically 'Truncate' A Subreport

    Hi, I have two variables in the report which are calculating two running totals within GH2. The post which I followed suggested to put the variable in the 'Format Field'-->'Display String' section of what I wanted to total. The total is printed in group footer one using WhilePrintingRecords...
  2. jat139

    How To Vertically 'Truncate' A Subreport

    CR 2013 ODBC Datasource Hi, I have a subreport which has data in Group Header #2 and Group Footer #1, all other sections are suppressed. I'm hoping to vertically resize/ truncate the report so that only Group Footer #1 is viewable. I've tried resizing with 'Can Grow' unchecked, however...
  3. jat139

    Retrieval of distinct records from duplicated records

    Ah, thats a valid point, thanks for your insight
  4. jat139

    Retrieval of distinct records from duplicated records

    Wow thanks, some very interesting points you made. I'm a newbie to CR/ SQL so I still have a lack of understanding/ misconceptions around many things. I never thought to do a concatenation of those 2 fields to create a unique identifier for each EventLog, that's a very cool approach. And yes I...
  5. jat139

    Retrieval of distinct records from duplicated records

    Hi there, I'm getting duplicate records in my report due to a left join which is fine, however, I can't figure out a formula to return the distinct records. Here is the SQL for those interested: SELECT "TransHeaders"."ID", "TransHeaders"."TransNo", "TransHeaders"."Branch"...

Part and Inventory Search

Back
Top