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

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

I need to write a subquery to pull a count of orders from one table to include in a query of customer sales so customer table has customer name and order table has customer id and order id and I need a query to pull customer name and count of orders

I am trying to create a report that needs to link two different rows of data into one. I have a mortgage and a 2nd mortgage and these are both individual rows in our tables. The Mortgage id is 123456 and the 2nd mortgage id is 123456x2nd I need to create a report that shows the detail from...

I have a field in my database that is html code and contains the tags and the data from a comment field. My field data looks like this: <TaskHistory> <Save When> <OpenAssigned to> <Comment> This is the info that I want to display in my report! </Comment> &lt;br /&gt; I need a formula to...

I have 3 numeric fields and I need to find the median of the 3 fields. What is the formula to do this?

I need to return a value from a subquery where a field in the main query is joining on a field in the subquery. Main Query has Loan#, DocTypeName, CreatedDate SubQuery has Loan#, CancelDate I need results to return Loan#, CreatedDate, DocTypeName from main query and CancelDate from SubQuery...

I am trying to create a report that counts records based on a Fiscal Year to Date formula. First current FYTD through the prior month end, then Last FYTD through the prior month end, then a formula with the difference between the two. How do I write a formula to count based on Beginning FY...

I am trying to create a formula to concatenate 5 notes fields and each of these note field can be either NULL, blank or filled. When I try note1 & note2 & note3 & note4 & note 5 I get no results if any of these fields are NULL or blank. Is there a formula to show a blank space if the field is...

I have a max field that the results should be between 1 and 4. I want to sum this field in column 1 if the results = 1, sum in column 2 if the results = 2, sum in column 3 if the results = 3 and sum in column 4 if the results = 4. column 1 column 2 column 3 column 4 3 5...

Does anyone know best practices for having a backup of all reports and report schedules in the central management console? I accidentally deleted a folder full of reports and cannot retrieve it. Thanks

I have a varchar field that is populated with either all uppercase letters or camel case. I want to be able to filter out the words that are all uppercase. Is this possible. So field equals ABC CO Def Co GHIA LLC I want to suppress all except the Def Co fields?