Search results for query: *

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

I would except it runs fine in an Oracle environment. I just don't know how to get it to work in a Crystal Reports environment.

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

okay, thanks.

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

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

Hello, I forgot to send a reply to these messages yesterday. The last suggestion, from Geoff, worked great. Thank you all for your help!

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

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

To answer the first set of questions, I am attempting to deal with two separate entries (documents) that have the same ID within the same report. I am not sure if that is the best method. I still can't get it to work. I guess I am not implementing the suggestions, from EarlGray, quite...

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

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

I have tried everything everyone has suggested, but I am still getting duplicate reports. I can say that the IDs are definitely unique. My tables are linked via the unique IDs, so there should only be a one to one relationship. I have also tried setting the reports to report only distinct...

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

Ah. Okay. Thank you. I was a little worried.

Okay, that didn't give me any errors, but now I have a different problem. Let's say I create a formula like this {table.area_code} Also note that there are no null values for the area code. Now, I name the formula areaCode. I compared the number of returned results from @areaCode to the...

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