Recent content by mgason

Hi, yes I have 2 questions up related to audio! Not sure Javascript is the problem. I am trying 2 completely different methods. Either would be OK if they worked. With this method the audio works fine testing locally in the browser, popping up a window with a helper player BUT when on the site...

Hi, Not sure if the problem is Javascript, but seems plausible. I am a complete noob to Javascript. I have a page with some mp3 audio. Rough working version can be found here. All the buttons call the same sound at the moment, it's not a bug. http://museum.spps.org/audio_testing.html The sound...

I have a database field that is set to "suppress if duplicated" in the format field dialog. Can I have TEXT fields in the same section suppress if that database field is duplicated? How would I do that? thanks Mark

Thanks, I decided on the lbass solution, mainly because my brain was heading that way already. I was under the wrong impression that 'suppress if duplicated" would suppress ALL A's after the first. Now I have another problem though which I failed to include in my first post. Recipe A could have...

Hi, can I suppress a record if the one immediately before it is a duplicate. here is a simple version of how my data might look in the database... Recipe description batch time A some recipe A-1 12:45pm A some recipe A-2 12:46pm A some recipe A-3...

Hi, I have a report that takes a really long time to display, in fact Crystal displays not responding for a while, but if left it finally does display. We are talking minutes. It does access several tables. I can see why it is slow. Is there anything I can do that might speed it up. Change when...

Hi, this is really a two part question. 1. how can I have a filed in a group header only appear if it is not the same as in the previous group. basically a suppress if duplicated but for the group header. 2. I have 4 groups, the last is hidden, drill down OK. clicking an item in group 3 opens...

thanks I think it is working just as desired mark

Hi, I have 3 tables. Each has a field batch_id. In my record selection statement I select batch_id's from tableA whose timestamps fall between a start and end parameter. tableB is linked and I get data for those same batch_id's. tableC is my problem. I want to exclude any batch_id that appears...

Hi, thanks for the reply, a sub-report is fine I think. layout wise display in the header is desirable. lets go with that. The less desirable layout would be in the group footer. I am curious how that would work too, as I could not get that to work either. If you have time for 2 explanations...

Hi, we are not quite understanding your solution I think. we tried but could not get it to work. I am going to make a better attempt at an explanation of our data just to be sure. Group1 Recipe_AA NEED TO SHOW SUM OF FORMULA HERE Group2 Batch ID_A THIS IS THE FORMULA diff(first-last...

if you have time check out my new post, continuation of the same problem http://www.tek-tips.com/viewthread.cfm?qid=1525343&page=1

Hi, I have data that is grouped. Batch_Ids are grouped by recipe. inside that group timestamps are grouped by Batch_ID. I have a formula which gets the number of seconds between the first and last timestamp for each batch_ID group. It is displayed in the batch_ID group header. this is the...

that works just fine thanks

Sorry forgot to say Crystal XI also to be clear, the problem is making sure I have the first and last date/time to calculate the diff from.