Search results for query: *

We are trying to develop a Report in Crystal XI that will pull a URL Link to a picture from a table in the DB and display that as a picture in the Report. Is this possible?

I have a formula that will display data in the Details section into one line like this: ItemA ItemB ItemC prints out as one line like this: ItemA, ItemB, ItemC The solutions requires three formulas: 1) In the Group Header place the @reset formula: WhilePrintingRecords...

I have a subreport in GH3 which contains a CurrencyVar @TotalCost that SUMs a specific field and is brought to the Main Report GF3 showing totals for the Records in that Group. Now I need to show a Grand Total for all the Records but if I put that same CurrencyVar in the Report Footer it only...

I have a main report which I have created a StartDate & FinishDate as Report Parameters. They are not hidden so the user has to enter these 2 dates to run the Report. I have another Report which Displays a second subset of data which also use the same 2 Parameters prompting the user to...

I am utilizing the following query to deliver some numbers for a specific date range. Now I need to include the same data but without a date range into the same report. What would be the best way to do this? SELECT company.company_name, COUNT(service_req.id) AS Expr1...

I have a very basic Matrix Report which counts records per region for the last 7 days. Now we need an extra column on the right which needs to count all records per region, not just for the past 7 days. Is it possible to add this extra column?

I have a table with 3 records ID Date 1 10/8/2008 2 10/9/2009 3 10/9/2009 I need to generate a formula to count the number of records for the Max Date so my result should be '2' records for the date '10/9/2009' Here is the formula I am using and it is not working. It is...

Crystal 8.5 Previous Formula: If IsNull({SubmittalRegister.SubmittalRegister~DueDate}) Then 0 Else 1 In the previous formula I was using an actual field in the MAIN report. Now we want to use a Shared DateVar from a SubReport but it won't let me use it in a IsNull New Formula: Shared DateVar...

In my report I have a total of 8 fields in the Details section. Only 2 of the 8 ever have different data. Currently each row duplicates for each time there is new data in the 2 fields. It would look something like this: 001 Row 1 05/10/2008 123 999 001 Row 1 05/10/2008...

Using Crystal 8.5 I have a Summary report showing multiple records with details for each record. I have a SYS.Total field which calculates the sum of a field in a group header + a field in a group footer. Now I am trying to get a Grand Total but it won't let me create a Sum of the SYS.Total...

I have 2 fields that I am trying to calculate the difference between however one of the fields may be null for some records so I am using a 'if,then,else' formula as follows: if isnull({Requests for Information.RFI~DateResponded}) then {Requests for Information.RFI~DateCreated}-currentdatetime...

I have a list of records which contain a Bolean field (True,False). In the SQL DB the value shows as 1 or 0. I am unable to find a formula to give me a number for records that are True and False. Example: Records that are True = 100

I have a Start Time and a End Time field in Crystal. These are Date/Time fields but formatted as Time such as: Start Time = 09:10 am Finish Time = 09:20 am The calculation formula I use does not output the result in a Time Format. I would like the output to be: 00:10 Also I plan on putting a...

When running the below SQL Query I keep getting the following error: Server: Msg 4924, Level 16, State 1, Line 1 ALTER TABLE DROP COLUMN failed because column 'ContractDef' does not exist in table 'zContractDefault'. For some reason it is only returning the first 11 chars of the column name...

Is it possible to install Windows Server 2003 on a desktop running Windows XP and run the two Operating Systems on the same PC? I need to evaluate Server 2003 & SharePoint but don't want to have to buy a new PC to do it. Thanks in advance