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. rsknut

    Formula for numbering pages

    The item is a set of inventory item ids. The user can enter a range of inventory item ids for reporting. In the report I want to specify how many pages each inventory item uses (i.e. using the PageNofM function in the header section) and the total number of pages in the report (again using the...
  2. rsknut

    Formula for numbering pages

    Hi, Is there any way to have two different PageNofM on a report? I want to be able to show the number of pages of a particular item at the top and the number of pages for the entire report at the bottom. i.e. - Page Header - Page 1 of 4 Page Footer - Page 1 of 72 Thanks in advance!
  3. rsknut

    Errors bind value and memo field

    We are upgrading PeopleSoft 7.5 to 8.4 and Crystal Reports 6 to 8.5. When going through the reports to verify the database to make sure all reports are still compatible and ready for testing, I get two errors that I can't seem to work out. Error 1: 'Bind value to large.' I believe it has to...
  4. rsknut

    Connecting a Subreport with store procedure to the Main report

    Right click the subreport you want linked to your main report and select Change Subreport Links... From there, select the fields in your main report that you want linked to your subreport and move them to the Field(s) to link to:. Then, select the appropriate parameter fields from the drop...
  5. rsknut

    text datatype to memo?

    Hi, I am having troubles with Crystal changing the datatype of my text254 fields to a memo datatype. Why is this? The text254 field is a PeopleSoft 8.4 field and is a mixed case character field of length 254. When I verify database it will not recognize the text254 fields as strings but rather...
  6. rsknut

    Crystal Reports and PeopleCode

    Hi, I'd like to run a crystal report which reports from a temp table loaded by a SQLExec procedure in PeopleCode. How is the CreateProcessRequest function used and what are the parameters needed to pass the process to the process scheduler? Also, how would I set it up so that the report would...
  7. rsknut

    Database field not listed in formula editor

    The data type of the text field is of mixedcase character type. I'm not familiar with memo and blob data types? Could you explain? Thanks again!
  8. rsknut

    Database field not listed in formula editor

    Hello, I have two text fields of length 254 in a query created in PeopleSoft Query. In Crystal, I am unable to view the two text fields in the formula editor. Why? The text fields do show up as database fields in the field explorer window, though. PeopleSoft version: 8.4 Crystal Reports...
  9. rsknut

    Upgrading software for Crystal Reports 6 to 8.5?

    Hello, We are upgrading our Crystal Reports 6 for PeopleSoft to 8.5. Is there software or a tool that would batch upgrade all Crystal 6 reports to Crystal 8.5 so that the new Crystal version will be ready to be used with PeopleSoft 8.4. Thanks in advance...
  10. rsknut

    Crystal Reports for PeopleSoft upgrading

    Hello, We are upgrading our Crystal Reports for PeopleSoft from version 6 to 8.5. Is there any software or tool that I could use to batch upgrade the version 6 reports to the new version 8.5 so that they will work for our PeopleSoft 8.4. Thanks
  11. rsknut

    subreport dependent on another subreport

    Hello, I am creating a report that contains four different subreports. The problem is that one of the subreports use data for parameters from another subreport within the main report. For example, main report subreport_1 LINKED TO main report subreport_2 LINKED TO subreport_1 I tried using...
  12. rsknut

    two groups on same line

    I need to group by two fields but I would like to have my report formatted so that I can have two different groups on the same section as such: X Y group#1 group#2 //two grouping sections on one line group#2 group#2...
  13. rsknut

    Hierarchical Grouping Not Right...

    Crystal Reports 8.5 Oracle8i Stored Procedure Hello, The report I'm creating uses Crystals hierarchical grouping tool to create a parent-child relationship. The report is also grouped by the following: Group#1 - Root Value (there can be more than one root [parent] in each report) Group#2 -...

Part and Inventory Search

Back
Top