Search results for query: *

Hi There, I am working in SSRS 2008. I have a parameter to pull 'All' of a set of records or it will pull one. What it won't do is allow someone to select two or more. It is either one or All. I found the standard 'Select All' was killing my report -- like 5 minutes. This 'All' workaround runs...

Hi All, I have a stored procedure and am having to use it in a Crystal 7.0 report on Windows XP. The report doesn't like the way the procedure pulls so I had to alter the stored procedure: I took the table that it was pulling from "Trip_Vitals" and created a view "V_CUST_LLA_Trip_Vitals" that...

Hi There, I read that in Crystal 10 you can create a new line in a string series using chr(10) or chr(13). Is there anything that works for Crystal 7.0? Example: 'Cancellation Reasons Count' + chr(10) + 'Cancelled by FD PTA: ' & {#CancelbyFDPTA}

Hi There, Using Crystal XI, Windows XP I've been reading through the posts and have had some luck with (@reset,@accum,@display). I have for fields: StreetName, PrimKey, BigPage, SmallPage The data example: Group: 1st Street Details: 1st Street; 21976; 3104; 2073; 1st Street; 21972; 3104...

Hi There, I need to take a datetime and add 7 hours to it to give me a new datetime in Crystal 7.0. Such as datetime 8/26/2008 20:00:00 and convert to 7 hours ahead: 8/27/2008 03:00:00. I know versions 8.0 and higher have the DateAdd ability -- what can be done in 7.0? I haven't been able to...

Hi there, I am working in Crystal 8.5, Win XP, but have to save down to 7.0 for our software reports -- RescueNet. I was using DateDiff and this was causing an error -- not in crystal 8.5, but in the RescueNet. So, I used the following formula instead of using DateDiff to get the seconds...

Hi there, I'm fairly new to Access 2003 and am used to Crystal. I have a table of billed accounts (Acct, DateFrom, DateThru, Rebill, DropDate) -- there are other fields but these are the main ones. The options for Rebill are null and R2. Null means a first-time billing. This table covers...

Hi, I am using Crystal 8.5 with an ODBC to a SQL server. The report I am creating will run within a software program that only allows certain parameters but will let the crystal report prompt for its own parameters (just not so nice looking) I have a monthly report. I want the user to select...

I have two main tables EMPPER and EMPFUNDA connected by EMP_ID. EMPPER (EMP_ID, and other fields I don't need) EMPFUNDA (EMP_ID, FUND_DATE, ACT_TYPE, ACT_AMT, etc). The ACT_TYPE is an E or an M and employees usually have both with and amt specific to that TYPE (The amount varies and can be...

Hi there, I am working with Crystal Reports 8.5 in Windows XP with an ODBC. I have a Central Schedule Report that pulls by date then it lists APPTS by time. I have to pull in a separate table that pulls STAFFMTGBLOCKS that has no table field links to APPTS. I've pulled it in as a subreport...