Search results for query: *

I am trying to schedule a report to run automatically in the morning for a date range of yeartodate through yesterday. When I run yeartodate it includes data from the current date but I only want data for dates that are complete. Is there an option to run year to date - 1 day?

I have a crystal report with invoices that I want to send to each individual recipient and I have created a publication to do so. I have selected delivery rules to Deliver only if report contains data, but it keeps sending a blank pdf to customers that do not have an invoice for the current...

I have a crystal report with invoices that I want to send to each individual recipient and I have created a publication to do so. I have selected delivery rules to Deliver only if report contains data, but it keeps sending a blank pdf to customers that do not have an invoice for the current...

I tried that. I updated the formatting, then dragged it into the text box and the formatting was gone. I am just highlighting the field in yellow if it doesn't match another field in the report. The highlighting works when I just add it to the report but as soon as I copy it into the text box...

I am trying to format a field that is embedded in a text box. I used to be able to right click and have an option to format embedded field, but it is no longer there. Is there a workaround for this?

I am trying to pass the total count per month from a subreport to a main report to the same month. So I will have a main report with # of widgets created by month, then the subreport will have a count of widgets destroyed by month. I want to share a variable so I can display the destroyed...

I have increased my screen resolution to 107% so that my info is a bit bigger. I am now noticing that the excel status bar's font is too big and I can't read the average, count, sum, etc. Is there a way to reduce the font size on the status bar or increase the space that the info is...

I figured it out when you asked the question of where the subreport was placed. I had the comparison in a detail section that was above the subreport, when I moved it below it worked perfectly. THANK YOU!

Subreport formula - in the report footer of subreport WhilePrintingRecords; Shared DateVar L2EstCloseDate := Date({Status.sEstCloseD}); Main report formula - in a detail section below the section that the subreport is in WhilePrintingRecords; Shared DateVar L2EstCloseDate; L2EstCloseDate This...

This works and I am getting the date in both the subreport and main report, but I am trying to highlight the field if they don't match. I have a different string field that works perfectly but the date field is not working. This is the formula I am using for the string field and it works if...

Yes there can be a variety of different results depending on the customer. 0 to 50. I appreciate the advice and will try your suggestion of handling it with the front end app. Thanks

I have a report with a subreport that I want to see if the datetime field called estimated date = the datetime field in the main report call estimated date. I need to convert these fields to not be date time because I only want to compare if the dates are the same not the datetime. I currently...

Is there a way to create a join that will join 2 tables, the first table has a record of a acct # and name, the 2nd table has multiple rows by account # and I want them to show the result as one row with new columns for each row field data. So table Customer has Customer ID and Name Table...

I am trying to find a fiscal year to date selection. I have the forumla to get the fiscal year begin date but I need a formula to get the last day of the previous month end. So if I run report on 7/5, it runs through 6/30 or if I run the report on 4/28 it run through 3/31.

So Sorry! Thank you everyone for your help!

I am looking for a crystal select formula, this appears to be a sql formula. How can I use this from within Crystal?

My fiscal year ends 6/30 but what I am trying to do is just get the month end date for the last full month. I want my info to be for the Fiscal Year to date for the date ending the last full month. So if today is May 15, I want data from 7/1 to 4/30 or if today is June 2, I want data from...

What is the easiest way to write a formula to find the prior month end date? I am trying to create a formula to find a "Fiscal year to date" when I am running the report in the middle of the next month. So if I am running report on the 7/15 or 7/1, etc., I want the "Fiscal Year To date" to be 6/30

borrower table loan# borrower 123 Joe 123 Jane 123 John 234 Sue 234 Sid 987 Jim 987 Joe loan table loan# lender# state 123 555 NY 234 666 NY 987 777 CT Outcome: Loan# Lender# State #of Borr 123 555 NY 3 234 666 NY 2...

borrower table has loan# and borrower loan table has loan#, lender#, state I want to see: Lender#, State, Loan#, count of borrowers