Search results for query: *

Please comment more if you can - here's my progress so far. For the moment this seems to be working - (I'm testing a LOT more before submitting ) I put the code to fetch the new ID ID in the oncurrent event. Towards the end of the oncurrent event I save the record. Together these 2 things...

OK, when I add the code to the On Dirty event handler I get a significant when I add the code to the oncurrent event, what happens is I click on my "add new task" button and 2 rows pop up, one with the correct new task number (and a pen beside indicating that row is being edited) and a...

Thanks for your answers so far, I'll try out some of them. Nobody has a suggestion for the "nuissance new row" issue yet As one of the answers above suggested, I tried putting the code not in the default property but in some event - right now I disable 'allow additions' and have an 'add...

The big problem behind this is that I want to fill in one of the fields in a form with a default value. The current expression in data-->default value looks like this [race number] is a FK to the main table's primary key. =(1+Nz(DMax("ID","[race tasks]","[race number] =" & "[race number]")))...

Yes, I just confirmed it. the 'show all headers on drill down' option does a lot of what I just did manually (suppressing headers at some points, forching them to show at other points). ; ( At least I learned how that works.

I just realized (one more of) my problem. In case you didn't realize I'm almost a total newbie to CR. I've only been using the charts until a couple of days ago, not really looking at the actual tabular reports. turns out I've had a misconception about what appears at the final drill down...

on this one particular report there are 2 groups. they did not want to see group headers at all on the top page, but sokme explanatory text. So I just set some headers to hide. (I've forgotten at the moment which action caused the headers to turn off for details). A side effect of this was...

It's just the way things worked out with the client. They wanted modified group 1 headers with group 2 footers, ("can I get this heading, but change the words, with this set of numbers, ....") and modified group2 headers with the details, ...

Thanks (again) for another answer. I'd like to get a general understanding as well, so I can figure it out myself next time (and for anyone else who finds this thread) What I understand so far In my 'suppress this component' formula, if the final expression evaluates to true the component...

Using CR 8.5, I want to suppress one of the group headers until the details section gets displayed. I created formulas // {@true} as whileprintingrecords; booleanvar flag := true; // {@false} as whileprintingrecords; booleanvar flag := false; I drag the false onto a different header, and in...

I need to do dozens of reports using the same set of data presented different ways. In my searching I noticed some stuff in CR 9 about saving & reusing some work in other reports but nothing turns up for CR 8.5. I don't know, can't pinpoint any specific reason, I'm just having a very difficult...

That's great. The key I was missing was whilereadingrecords. I had defined several formulas but without whilereadingrecords none appeared as an item I could enter into the crosstab. The text field overflowed (too many records) & I had to change it. Instead of staying with the date field I...

using Crystal 8.5, Sql Server 2000, trying to do a crosstab and the associated chart (the chart's the most important thing, I've been told) I have a date field which I'm using as the item running across the top (that is, a date as the "column" heading). I'd love to instead use just a number...

Another thread told me I need to post more detail, so belatedly, here it is. sql Server 2000 Crystal 8.5 (just Crystal, no Dev Studio).

Apologies about the lack of detail. I got frustrated with no search results & rushed the post. sql Server 2000 Crystal 8.5 (just Crystal, no Dev Studio).

Just thought of this after the last post (marking outliers). Are the chart elements (columns, labels, etc...) exposed to the formula mechanism, ie are they programmable. I can find no info on this. The kind of thing I've googled for (web and USENET) is "crystal reports" with "mark maxima"...

This sounds impossible to me, let's see if y'all agree. Can I make the columns of a chart all one color, say yellow, except let's say 1. the 1, 2 or 3 highest outliers red 2. the lowest 3 outliers green Other things to achieve the same goal -- labels that convey the same info -- some kind...

I must be missing something, I hope this is not a smack my head question. How to flip the x & y axes? Exact same information, just swap the axes. I think I looked through every dialog box/menu & searched google for (in addition to "crystal reports" & chart) exchange, change, flip...

To madawc, I will remember the advice, It's Crystal 8.5, with data from SQL Server. I didn't start a new thread because I found this thread through a search. I assume a similar search will point the next person here. And thanks to lbass, I would never have guessed that answer.

I cannot get this to work with date parameters (specificallly a date range) It gives me no error message but selects no records. (if isnull({?daterange}) then True else {tblAnalysis.SessionStartTime} = {?daterange}) this did give me an error if {?daterange} =