Recent content by rorymo

Thank you lbass!!! Worked like a charm.

Hello all, I got it to work by removing the ) after the "All" and using "like" instead of "in". CODE: (If {?Category} <> "All" then {chgcat.sym} like split({?Category}[1], ", ") else true) Now I just need to get it to work with the wildcard. Thanks, Rory

Hi Lbass, Those are examples of the data that is in the field. (possible values for the category field) What might be entered at the prompt would be ADR.HW* or ACS* or All if they wanted all of the records for some reason. BTW, I tried Ian's suggestion but still did not get any results. (If...

Thanks Ian, I'll try that. Lbass, The category parameter is for change order categories for a Service Desk application. Some examples are: ADR.HW.UNIX ACS.SW.SYS.Platform.Linux There are hundreds of these. I used the subscript because I kept getting the "This array must be subscripted"...

SQL Server 2000 Crystal Reports 2008 Hello, I am trying to get a multiple parameter record selection formula to work. Specifically, I cannot get this particular parameter to return records. I have checked the links already. (There are records that meet the criteria in the database.) Any...

Hello, CR 2008 BOE 3.1 SQL Server 2000 We have a scheduled report that was running correctly and returning data as a pdf. On the weekend, 2 instances of the report pdf both show a grey screen with a white box, no data. The report title or heading information is not shown, just a blank box. The...

Thanks. I'll try those options. I appreciate your help. Rory

CR2008 SQL Server 2000 Hello, I have been trying to incorporate this into a report, and can only get so far with it before I hit a wall. I found a couple of threads where someone had a similar problem but there wasn’t anything there that I could use. Problem: I am trying to modify a report...

It worked great! Thanks!

Thank you Ian! I would have never thought of that. I appreciate your fast reply. Have a good weekend. Rory

Sql Server 2000 Crystal Reports 2008 v 12.2.0.290 When I run a report that has this record selection statement, all of the expected data is returned except the date statement part is being ignored. Instead of finding records that have open dates beginning 10/1/2009, it goes back to 10/1/2008...

Thanks to both of you for the reply. I'll check the link to Ken H. And I'll create a default for the range. I really appreciate your help! Rory

Thank you COSpringsGuy, That worked when the "range" is chosen first, but when the "month" is chosen first, it forces you to make an entry into the range field. This is the code I put in: if {?Month or Range} = "customized range" then {@Open} = {?Range} else if {?Month or Range} = "month"...

CR XI SQL Server 2000 I am having problems in using two types of parameters in a report, one date type and one string type. I want to show one only when it is picked, not both of them. For my parameter {?Timeperiod} the choices are: choice 1 "month" - which would return records with an open...

Thanks LB! That worked.