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?

That worked like a charm...thank you so much

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

sry, nevermind, I found my extra field causing this to double the amounts. I also found out that I need to Suppress your formula in GF3 but leave my original formula for the Shared Variable showing the totals for each record group

I created the formula as requested: WhilePrintingRecords; Shared CurrencyVar SubTotalCostTotalMain; //pulls from subreport CurrencyVar GT:= GT + SubTotalCostTotalMain; //creats new GT Variable for RF grand totals When viewed in GF3 it doubles the amounts and does a running total for each...

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

Clarification... I need to report that within a specific date range there were # Open Tickets. I then need to state how many Open Tickets that are TOTAL without a date range. The date/time will always be populated.

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?

This can be closed. What I did was put in a Group Selection Formula: DailyWork.Date=Maximum(DailyWork.Date) I then put the DailyWork.ID in the Details and put a Running Total field Counting the DailyWork.ID Not quite sure why I couldn't get it to work in a sys.formula field but this works.

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

Correct Formula: Shared DateVar DueDateVar; If IsNull(@DueDateVar) Then 0 Else 1 I manually typed in 'DueDateVar' whereas if I inserted the field from the field chooser it is actually '@DueDateVar'

DISREGARD - Issue Resolved

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

Sorry if I sound like an idiot so please bear with me. When using your Forumla provided Crystal gives me an error: 'A number is required here' at the 'gt' part I do not see how the formula you provided Sums up the amounts from my sys.Total. From what I can tell it is only providing some sort...

In the GH2 I have an actual Database Field called OriginalValue In GF2 I have a Summary field that Sums up a Database field in the Details section called ApprovedAmount In GF1 I have a SYS.Total field as follows: (Sum ({Prime Contract Change Orders.PrimeContractCO~ApprovedAmount}...

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 tried that as well but still no luck. Not sure if this matters but I am using Crystal 8.5..