Search results for query: *

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

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

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

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

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.

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

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

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

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.

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

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

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

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

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

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

Veejc and Vongrunt, The original query (mine) would retrieve ALL discontinous enrollment dates aka first segments. Maswien's query (thanks for the brilliant assist) further limits it to only the FIRST of discontinuous enrollment dates, according to the spec.

Hi Veejc: Yes, I was missing a dimension of your spec, but here goes again. :) I am going to try to turn this thing on its head: Thought: If you are truly looking for the earliest enrollment date, where enrollment equals the first date of continuous rows whose lapse do not exceed x days, then...

Here you go. Let me know if this is what you were wanting to achieve. Select Top 1 MH.EnrollmentDate From MemberHistory MH, MemberHistory MH_recent WHERE /*must be same member */ MH.MemberID = MH_recent.MemberID and /*must not be same history record*/ MH.EnrollDate <>...

Thanks snowcrash. My Code is: rs.Requery Since the time of posting, I have concluded that a parameterized recordset cannot be requeried. Is this true? For example: dataenvironment.QueryName set rs = dataenvironment.rsQueryName <parametervalue> rs.requery

I would suggest converting it at the detail level, not the summary,and especially not while using "whileprinting records". In other words, create a formula "durationhours" which would do your above calculations, then subtotal that and use it in the crosstab.