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 gkittelson 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: jaw5
  • Order by date
  1. jaw5

    Subreport criteria selection

    I have a school report that I want to run by grade which shows the credits the student has earned by category and this works fine. I added a subreport to show the currently scheduled courses, but the only one that prints is the one for the first student. In the SQL profile for the subreport, it...
  2. jaw5

    Page break between a report and subreport

    I have a report with a subreport which both display vertically. Is there a way to force a page break between them if the main report is so long that it forces part of the subreport to the next page? Both the report and the subreport have variable number of lines with column totals for each...
  3. jaw5

    creating header record for data upload

    Thanks for all of your help. I really appreciate it. Sorry to be such a newbie!
  4. jaw5

    creating header record for data upload

    This is an import file. I want 1 line for each record in the query, but I need a header line for the file that contains a description of the version of the software that we are importing the file into. I tried make a main query for the header, with a subreport for all of the detail lines, but...
  5. jaw5

    creating header record for data upload

    I'm am using Impromptu, but the only options that are available are "Include column headings", "Quote strings", "Delimiter character", "ASCII value", and the value for end of line (CR LF, LF CR, CR, LF)
  6. jaw5

    creating header record for data upload

    I'm creating a file for a data upload that needs 1 header record for the file. how can I make a header record a separate line in a csv file using cognos ?
  7. jaw5

    Date formatting for upload

    I have a date formatted as mm/dd/yyyy date in a database and I need to extract it for an upload. How do I extract it as an 8 character numeric field? I've tried extracting the year,month,day - but when I try and concantenate, I get a sum rather than a string. HELP!!!!

Part and Inventory Search

Back
Top