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

Yes, I'm trying to find "BRIAN todaysdate" and have it be dynamic as you've written to show these values every day the report is run. I've actually thought about making it dynamic for the name of the user too to expand the report. Unsure how to put the beginning part with the name and...

Also have considered using the trim feature..but unsure how to use it in this manner

Not all the fields are formatted the same way unfortunately. As such, I am getting an error with that particular code. I've tried looking for alternatives to do this... This was a thought but it doesn't work if instr({CONTSUPP.CITY}, 'BRIAN') > 0 then (split({CONTSUPP.CITY}, " ")[2] =...

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 was able to find out the problem. By browsing through the data, I noticed that recid was not the same for all records. By name it is, but by key, it was a randomly generated number/character combination that had most of the same the info, but 8 bits were off. Given that it is not a primary...

Yes, conthist.ref does have data that matches the criteria. I have created a different report with each table only and have pulled the data by itself, but I want to combine the 2 tables into the one new report.

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

Utilizing the Insert Summary option, you can choose weekly and monthly within the selection. The problem that I am having is summarizing the fields using the count feature has 170 pages with the data on random pages. I want to have this all displayed into a one page summary.

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

Convert Database NULLS to Default was not checked in Report Options. Upon checking the box, the items that were missing now show up.

still is happening in VS2010. Any thoughts on what to look for in Goldmine? Its weird the SQL is right and pulls right, even when the equation is changed so that one of the other statements is requesting data before the other subset of data, the new data shows but not all the data from all 3...

I'm going to test this in Visual Studio 2010 with Crystal 2010. If it shows up with the data...maybe I have a buggy version of Crystal.

fisher: If I use 1 or 2 criteria of the OR statements in Crystal, it provides the correct data. If I add the 3rd statement, I do not see the 3rd statement's data.

To answer Ian's question: Are you sure there is no group or section suppression hiding the USTATREP data? There is no suppression at all within the report as far as I know.

Direct access to the server shows the missing items using the sql query. Where in Crystal would it be set to not show all the data then?

{?Date for Status Report} in [{CONTACT2.UDATEINV}, {CONTACT2.USTATREP},{CONTACT2.UDATERECD}] returns only 5 total records and it should return 50 something

There is no other selection criteria besides what was shown.

SELECT "CONTACT2"."UADJNAME", "CONTACT2"."UINSFIRST", "CONTACT2"."UINSLAST", "CONTACT2"."USTATREP", "CONTACT2"."UINSCO", "CONTACT2"."ULOSSTYPE", "CONTACT2"."ULSLOCCIT", "CONTACT2"."ULSLOCST", "CONTACT2"."UCLMCLS", "CONTACT2"."UCLMYR", "CONTACT2"."UCLMNO", "CONTACT2"."UCLMADJ"...

As noted, each of the criteria DOES have data that it returns. I'm comparing against the original form that I'm rewriting into Crystal. That is how I noticed Status Report was missing data. Once I realized that, I've tried multiple modifications using brackets to break up the equation...