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 bkrike 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: mjmiller24
  • Content: Threads
  • Order by date
  1. mjmiller24

    mjmiller24

    I have created a stored procedure via how Crystal Reports explained how to do it. Now my problem is that I get prompted for a value for the Cursor and the ID number, my other parameter. So, I am wondering, how do I set up the URL so that it passes the ID number to the prompt? How, also, do I...
  2. mjmiller24

    Stored Procedures

    I am trying to use stored procedures crystal reports 8.5, but I keep getting an error about my cursor. It says it is invalid. After closing out, and trying to just preview the normal report, I get a message that the report is trying to use a closed cursor. Then it says there is an error in...
  3. mjmiller24

    carriage returns in Crystal Reports?

    Hello, I am attempting to write some code where I need carriage returns. I need something like str := "7. Something here"; str2 := "See Attached"; field := {db.ID}; str + chr(13) + str2 + chr(13) + field I have tried the above, but chr(13) just chops off the remainder...
  4. mjmiller24

    formatting output

    Hello, I have a one to many link. I have each record, for one ID printed out. The problem is that I get the output like this: For the ID 343 11. Problem Number 45 34 75 However, I want it to display like this: 11. Problem Number 45 34 75 This is my...
  5. mjmiller24

    if statements

    Okay, I know that this is not that hard. I am trying to implement the following piece of code in Crystal Syntax: if ( Remainder(RecordNumber, 2) <> 0 ) then &quot;SEE ATTACHED&quot; The problem is that I keep getting an error message saying that the if statement has to return a boolean...
  6. mjmiller24

    breaking up text in object?

    Hello, I think this is my last question. I have an object field that could be one or several lines long. I just want it to be three lines long, and then print the remaining lines at the end of the report. Is this possible? The above method of doing things seems a bit outdated, but I may...
  7. mjmiller24

    combining information from 2 separate reports

    My current situation is the following: I have multiple documents for one ID number. I have several other fields that are displayed in the reports also. However, the reports look exactly the same, they almost look like duplicates, except for the different documents. It should be noted that...
  8. mjmiller24

    combining information from one to many relationships

    My current situation is the following: I have multiple documents for one ID number. I have several other fields that are displayed in the reports also. However, the reports look exactly the same, they almost look like duplicates, except for the different documents. It should be noted that...
  9. mjmiller24

    Report Duplication?

    I have a unique identifier that is, say, ID = 35 passed into the report. So, here is the code: <a href=&quot;http://server/dir/str3.rpt?init=html_frame&sf={main.id}=35&user0=user&password0=passwd&quot;>View your Report</a> However, I get the same report duplicated 4 times? If there is only...
  10. mjmiller24

    if statement problem

    I have a phone number extension that, sometimes, has a leading zero(s). Sometimes the field is null, sometimes the leading zero(s) is missing, and sometimes it is formatted properly. I have attempted to write a if/else if/else statement. I only inculded a snippet of code where I numbered the...

Part and Inventory Search

Back
Top