Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dpatrickcollins

  1. dpatrickcollins

    Crystal Reports NO_DATA event?

    Hi all, I am using Crystal 10 integrating with vb.net 2003. What happened to the "NO_DATA" event or better yet, what is the best way to determine whether a report has returned no data or not in the .net environment using the Crystal 10 API? Thanks, I have scoured the web today and can find...
  2. dpatrickcollins

    Calculating the first/last day of the week for the month

    Those are good questions. In my case, I arbitrarily assumed that Kentoy wanted to include the the outlying weeks (beginning with Sunday). Additional logic could be implemented to exclude less-than-half partial weeks, etc., pretty easily. My hunch is that the users simply do not want to see...
  3. dpatrickcollins

    Calculating the first/last day of the week for the month

    //First define the begin date of the month: local datevar begin := Date({?year}, {?month}, 01); //Then back it up to first of that week: begin := DateAdd("d", - DayOfWeek(begin) + 1, begin); //Lastly make that your new parameter: {table.date} >= begin //You would do something similar with...
  4. dpatrickcollins

    summary of sum?

    The simplest way I can think of is to convert your table links to a SQL statement that pre-consolidates your "multiple-gift-on-same-day" rows into a single row using GROUP BY. Then, your Crystal experience is fine. In other words: SELECT ID, DATE, SUM(AMNT) FROM TABLE GROUP by ID, DATE If that...
  5. dpatrickcollins

    Exclude Holidays and Weekends

    dadyswat, I would suggest table linking to define the join. If I recall, certain versions of CR will not support different operators for joins between the same table pair. (Sorry, it's 1:00 a.m. here and I'm too tired to verify). CR10 supports it for sure, however.
  6. dpatrickcollins

    Exclude Holidays and Weekends

    dadyswat: Your welcome. Synapsev is right; we are favoring expediency over best practices with this solution. If in your case you have a date period specified by a begin and end date, I don't see how the data table approach will not lead to either some row inflation --- simply for the fact...
  7. dpatrickcollins

    Exclude Holidays and Weekends

    This is a shot in the dark, but it seems to me you would want to abandon the dates table altogether and adopt the following formula: //Excluded Holidays this year (list incomplete for demo) Local datevar array holidays := [date(2005,12,31), date(2005,11,24), date(2005,07,04),date(2005,02,14)]...
  8. dpatrickcollins

    Problem with StringVar formulas

    MJR, Combining global variables with grouping has in my experience been a little dicey due to the way Crystal's "pass" technology works. Let me suggest a way I implemented recently with an identical data structure. The following assumes first and last name are required fields and present: 1 )...
  9. dpatrickcollins

    Need to suppress a portion of total unsuppressed groups

    Can you qualify what portion you need to suppress? For example, any portion so long as it is 19/20ths of the total? Please qualify the portion that needs to be suppressed.
  10. dpatrickcollins

    Help with Record Selection

    Stormtrooper, In case you are wanting to see ALL TRANSACTIONS of facility 88888 (and those like it), place the following in the Group Selection Formula: Maximum ({AMT}, {FAC_NO})<0 This will show all transactions, but only of those facilities that had no positive entries. If you are wanting...
  11. dpatrickcollins

    Crystal: Natively Connecting to SQL SERVER

    This seems like an obvious question but one I cannot find an answer to: Is there a way to connect a Crystal Report to a SQL SERVER database natively, i.e. without requiring an ODBC datasource? Code snippet: With crConnectionInfo .ServerName = "ServerName"...
  12. dpatrickcollins

    Controlling Sort When Using Hierarchical Grouping

    I am using the hierarchical grouping feature in Crystal version 9.0. Problem is, I need data that is at the "same level" to be sorted by something other than the unique ID. Example using an "manager/employee" scenario: John Smith (Manager of . . . ) Alice Jones Sally Black Bobby...
  13. dpatrickcollins

    Cannot Connect to MSDE Remotely from W2K machine

    I have a sql server database successfully installed (using msde) on a server running windows xp professional. I can connect to the database locally as well as remotely from any windows xp machine. However, when I attempt to connect on any machine running window 2000, I receieve an error stating...
  14. dpatrickcollins

    Defining Date Formats for Line Chart

    Hi Manifester, Answer is no. I am a little fuzzy on the details of the question I originally asked here since it has been so long, but no, I did not find an answer . . .
  15. dpatrickcollins

    Looping &quot;poor practice&quot;... what is the alternative?

    Yes. I'll try at least. In English, the query is saying, "Give me all the rows you find (main part of query) that simply have no (NOT EXISTS) prior segment within the past 90 days. That is the definition for "beginning segment" we have chosen (and I believe it holds). The subquery FYI...
See more

Part and Inventory Search

Back
Top