Search results for query: *

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

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

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

Hi, I do understand how to use datediff to get the difference between two date/time fields. BUT I have a report which has returned a long list of date/times. I have ordered those by time. How can I write a formula that gets the diff between the earliest and latest date/time. thanks mark

Hi I have data like this BatchID1 ingredient1 weight ingredient2 weight ingredient3 weight BatchID2 ingredient1 weight ingredient2 weight ingredient3 weight I group my weights by BatchID giving a report that looks like above. Currently I have BatchID in ascending order. The customer wants the...

Hi, I had a problem with my chart displaying 2 decimal places in X axis labels even though the data they come from showed 3 places. There was no way in the chart expert or options to alter axis label precision I found the setting for default numeric field precision for the whole report found in...

Hi, I have a bar chart. It pulls data from one table "WeighmentReport" In the Chart Expert data tab... It is set, on change of "weight" field giving X axis of weight intervals. show values is batchID, giving a y axis which is a count of batches. This is fine so far. But each BatchId has a...

Hi, I have weighments that have a time stamp in the database. The user selects a date range from which to retrieve a list of all weighments. How can I group those weighments by a preset time interval. For example if they are allowed to select a single 24 hour period. How could I group...

Hi, I need to control a bar chart X axis in a specific way. I am wondering if this is in any way possible using crystal reports 11. Could formulas somehow control the axis, or massage the data to get the result below? If the answer is a definite NO then does anyone know if Xcelsius could achieve...

Hi, I have a crosstab with.. column head = machine name field. row head = recipe field cells show weight and batches required. I want to add labels in the row head so that it shows the layout below, (Pounds and Batches just being text).. {Recipe field} Pounds Batches...

To be honest I had no idea what to name this post. Here is the problem. Tables.... Ingredient table Ing column powderA powderB powderC oilB Cut-bag#1 (does not display) RawMaterial table Code Description powderA mylar elastomar powderB black nerosene powderC...

Hi, I have a group set to Hide, drill down OK. Is there any way to setup the equivalent of a page header for the drill down? thanks mark

Hi, I have a database field that has a long string with colons at various irregular points. I wish to display only the characters to the left of the first colon. This is not conveniently at the same number of characters. How can I do this? Also can I group by that formula? Thanks Mark Gason

Hi, we have a customer using CR7 inside a VB app. The report displays fine in the viewer. When you select print a simple dialog allowing you to select which pages to print appears. The printer is preselected. You can not change it. How in can we make a standard windows print dialog appear for...

Hi, I not a SQL expert, I need to write a query to make these changes... I have Batch ID's stored in a table. They have 3 parts separated by colons Recipe:Revision:Unique ID. I want to update the records with a paticular Recipe and change them to a new recipe name. (changing real customer data...