Search results for query: *

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.

CR XI Sql Server 2000 Grouping by: Location Ticket # I have a summary of total minutes appearing under the location group, but I need to show the group summary total in the “hours and minutes” format. I don’t know how I can do this on a summary field that is in the Group 1 (location) footer...

Thanks LB. That really clears a lot of things up! I really appreciate your advice..will put into place right now. Have a good day! Rory

Hi LB, Thanks for the reply. This is the formula: if {@Est Comp Date} < {@Close Date} Then true So of course, I want to count the "true" and use that in the crosstab. When I create a summary on this formula, I choose "count" and put the summary at the group (assignee) level. The number...

Sql Server 2000 Crystal Reports (BOXI) Hi, I have created a report that is keeping track of help desk tickets for a certain group of people. The report is grouped by the name of who is assigned to work the ticket. In a crosstab, I need to show: Row: Assignee Name column/cell: 1. count of...

Thanks LB! I totally missed the currentdate as opposed to currentdatetime. Once I used the currentdate, it worked perfectly and I got all the records I expected. So now I can have a nice weekend and hope you have one too. Rory