Search results for query: *

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

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

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

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

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

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

SQL Server 2000 BOXI I need to check whether a particular date in our database is (within) 24 hours of the current date, and use this as part of the record selection criteria for my report. The date field is stored as a number in the database. (we did not design the db, so we have no control...

Hi, I am using BOXI with Sql Server db. The database is a "help desk" type db where tickets are created, closed, and sometimes re-opened and then later closed again. So one ticket could possibly have been closed twice (or more). I am needing to calculate the time it takes from the date/time the...

Crystal Reports XI (BOXI) Sql Server 2000 Hi, I have a report that needs to use multiple pick parameters and I cannot get it to work correctly. It is not seeing all of the selection criteria, it "falls through" after the first selection (History)- see below - and ignores all of the other picks...

Hello, Crystal Reports XI Sql Server 2000 I have a report that is using a field that is defined in the database as a string field, 21 characters long. My report brings in this field as a string, 21 characters long. I made sure that the display field on the report is large enough to show all...

Hi, Crystal Reports XI (BOXI) Sql Server 2000 I am creating a formula to handle Daylight Savings Time changes. To that end, I have created a DateTime range array that contains the datetime start and datetime end of each year's daylight savings time. This is what it looks like: Shared...

Crystal Enterprise v.11 (BOXI) Crystal Reports v.11 (BOXI) Sql Server 2000 db Hi, We are needing to have reports run in Crystal Enterprise based on instructions from an outside program. This would be the workflow: Outside program talks to CE and tells it to kick off reports based on input...

Hello, I am using Crystal Reports XI with a SQL Server db. I am trying to use a text file as a source file for my Crystal Reports, and cannot get the data into Crystal as seperate fields. It always comes into the report as one big field. I set up an ODBC text driver and defined each field...

Hi, I am having a problem getting correct data out of a database, I'd appreciate any help! I am using Crystal Reports v10, Sql Server database. My report in question is gathering IT asset information (machine name, serial no, model, ip addr., primary contact, etc.). There is a field called...

Does Crystal Reports v. 10 automatically account for daylight savings time changes, or do I have to handle it with a formula? I cannot find this issue on the businessobjects site. If anyone has info, it will be appreciated. Thanks, Rory

Hi, I am using Crystal Reports v. 10 on Sql Server db. I am trying to devise a formula that will pull data beginning at 1:45 pm the previous day through 1:45 pm current day. I tried CurrentDate -1 but I'm not sure how to specify the start time to be 1:45 pm on the previous day. Thanks in...

Hi, I am testing auditing on Crystal Enterprise v10. I published the sample auditing reports but when I preview one I get "There is no data to display. Please refer to Product Documentation for configuration instructions for Auditing." I had already gone into each server and turned on auditing...

Hi, I have just installed CE10 on a test server and am in the process of testing everything before I install it on production. In ePortfolio, in my personal "folder", when I click the "Logoff" box, it asks if I am sure that I want to log off, I say yes, and it never goes back to the launchpad...

Hi, I have an Access database that I am using as a data source for monthly reports. The problem is that the report is using the prior month's data instead of the new data. I am deleting the old table and importing the new month's data into the db, using the same generic table and field names as...