Search results for query: *

What I am trying to do is first select all records that are open. A record would be open if it has an invoice date and no payment. Invoice records are found in these fields: {CONTACT2.UDATEINV}, {CONTACT2.URIDATINV}, {CONTACT2.URODATEINV}, and {CONTACT2.UINTINVDAT} Payment info is found in...

I am trying to figure out how to create a formula selection that would look for "BRIAN" and then the date as noted in the example would be the next operation. So basically "BRIAN today" with the spaces in between are what I am looking for. Suggestions on the advanced formula for this...

I'm trying to figure out how to display the data that I need from 2 tables. Below is what I have for criteria including the joins. Ref is not showing up on the report. Table Names: Contact1 ContHist Links for Database Tables: (Under Database Expert) Contact1.LastDate -> Conthist.lastdate...

I've searched through a few of the threads and was unable to come up with a solution other than partial here and there solutions with regards to this. Thus, I am creating a thread that I hope the senior guys here can help for everyone in the future to review I would like to create a formula...

When using this selection statement is brings up the data for the first 2 fields (udaterecd and udateinv) but it will not bring up data from ustaterep: {CONTACT2.UDATERECD} = {?Date for Status Report} or {CONTACT2.UDATEINV} = {?Date for Status Report} or {CONTACT2.USTATREP} = {?Date for Status...

I'm using the formula for "yesterday" but the report will actually be used for "today". I have to use "yesterday" to compare to the actual report that was generated in the original program that I'm converting over to Crystal Reports. I have the following in my selection statement: ( (...

I have a request from one of my users that they be able to "add" another custom field or two to a report on the fly. They would define the name in a text field and the other two fields would be number values that would be added to a calculated sum value. Would I have to ask for the parameters...

When I type in this selection formula {CONTACT2.UCLMYR}>{?Claim_Year} and {CONTACT2.UCLMNO}={?Claim_Number} it brings back EVERY record. I want it to bring back only the one record that equals the prompted claim year and claim number for the report.

How would one go about creating a page of summaries from all Groups? Basically I'm looking at taking a calculated value for each group within the footer of the group and I want to create a summary page that has the group name and the calculated value from within the footer of that grouping.

http://www.tek-tips.com/faqs.cfm?fid=1329 has ideas on creating subreport with passing parameters to subreports. Is there another way to pass ?startdate and ?enddate to a subreport or maybe its better to pass a selection into a subreport. I'm trying to filter "exceptions" to rules i've...

Using this equation I'm getting only partial results. I want each of the conditions to be checked. If statements only check one and move on. How can I rework this selection query so it checks for ALL the conditions and displays ALL the records within the search dates? if {CONTACT2.UCLMNO} >...

I am writing a report with CR11 and the company I am doing this for has a quirky way of doing calculations. They have several conditionals and variables that are used based on which vendor is being used and the specifics of the job. What I am trying to account for is a automatic selection for...

Is there a way to automate report generation and email them? What if parameters are involved like selecting dates (which could be programmed in if needed).

I'm working on developing out reports for Goldmine in Crystal Reports XI. It shows a container in Goldmine for Crystal and the Crystal extensions for Goldmine were loaded on the workstations. What do I need to do to get it so that the management can view the reports I'm creating. They have...

I have a connection to the Goldmine database with Contact1 and Contact2 selected for tables. Contact2 was where all my reports derived their data. When I add a field from Contact1 into the report, all the data disappears in the report. Is there something programatically that I need to do or...

I am trying to create a report in CR11 that will pull data from the db based on 5 weeks worth of data. The user would be prompted when running the report for each date and it would calculate the next 7 days worth of data from within the database. These dates necessarily do not have to be "in...

I am trying to color code results from a formula. The formula is a local formula and the results are calculated and vary on every record accessed in the Details section of the main report. Is there a way to color code from within CR11r2 other than under the formatting formula section, like...

I am trying to color code results from a formula. The formula is a local formula and the results are calculated and vary on every record accessed in the Details section of the main report. Is there a way to color code from within CR11r2 other than under the formatting formula section, like...

Thanks to Gary Parker for his help getting the lastdate formula working properly for me in a whole lot less code too! Being that I am a newbie at CR and have XIr2...I used this to call the LastDate formula and find the difference between it and the current date. It brings up 0s. What am I...

I'm working on a formula that is not calculating all the fields properly. What I am trying to do is calculate the days since the last action on a contact and below I have the code for it. CONTACT2.UDATERECD=Date ticket was opened CONTACT2.URIDATREC=Reinspect the ticket for problems...