Recent content by CappsRLO

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