Search results for query: *

member table contains: member.member_id (PRIMARY) member.related_to member_product table contains: member_product.member_id (PRIMARY) member_product.product_type_id (PRIMARY) member_product.form_received related_to contains the member_id of the parent company. If there is no parent company...

My statement is: round(365/rwh_model.energy_factor* CASE WHEN rwh_model.gas_type='propane' THEN 41045/91,333*95.500 WHEN rwh_form.energy_source='oil' THEN . 41045/138,700*149.793 END) AS EAECkbtu, Yes, I can (and will if I have to) calculate out the portion of the formula after the "THEN" but...

I am trying to create a one page summary to show ranges of efficiencies for gas heaters. Here's a sample data set: FlowRate GasType Effy 2.5 propane .72 2.4 natural .71 2.6 both .70 3.5 both...

I tried to do this in a typical CREATE VIEW <NAME> AS SELECT DISTINCT <FIELDS> FROM <TABLE> WHERE <CONDITION> but had no success because I need to find the min and max of a certain field. The multiple WHEREs are what throw me off. I came up using multiple select statements then creating a...

Here is my code... CREATE VIEW public.wh AS SELECT DISTINCT model.model_number, model.fuel_type, model.efactor, 41045/model.efactor*365/100000 AS ngas_use, 41045/model.efactor*365/91333 AS pgas_use FROM (etc… I'm trying to determine the annual energy use (represented by ngas_use & pgas_use) of...

I recently installed an Imac for an employee. The computer is running Panther and is currently printing to a Lexmark S1650 printer via Appletalk. The printer is plugged directly into the network and is given an IP address. The problem is whenever she prints, a blank sheet is "printed" as...

I recently installed an Emac and an Imac for two office employees. They are both running Panther and Lotus Notes 6. The problem I am having is that, whenever they send atachments, they are being compressed. I know there is a box that you can uncheck when attaching the file but that does not...

Is there a way to change the field type in Crystal 9? I have a databse field with the &quot;can grow&quot; feature enabled in my report. some records are longer than 254 chars. We recently upgraded to Crystal 9 because of 8.5 issue with this limit. However, it is still cutting off the...

Greetings. Can anyone help me with this situation? This is my evaluation statement: if {form_custom_footnote.footnote_nbr} <> 0 then &quot;Additional Footnotes&quot;; However, it only evaluates it for the last record pulled/displayed instead of if it is true anywhere in the entire section...

I created a report listing model numbers and their associated footnotes. I have the explanation key for footnotes displayed in a group footer using a crosstab. It is rigged so that a single column is based on a formula that numbers the footnotes and a summarized maximum that displays the...

I thought this would work but it won't. I want to add the contents of the field to a string declared variable and separate the results with a comma. Please let me know what is wrong with my syntax if this is even possible (no reason it shouldn't be). I have the IF-THEN statement twice+...

I am putting together a report of equipment information. I have it grouped by company first, then model name, etc. The details section contains the model numbers. However, some model names share the same model numbers, i.e. have all of the same model numbers in common. I want to list all of...

I am using a simple formula to display a complete list of custom footnotes in the group footer. If a unit has 5 different footnotes (stored in 5 separate rows in the same table with unique &quot;footnote_nbr&quot;), how would I go about checking for and printing all of the footnotes? A loop of...

I apologize for posting daily... I am grouping and using a formula for the title. The code reads a true/false from the DB and is supposed to determine which title to use and then group by the title. It is grouping fine but only &quot;NATURAL OR PROPANE GAS&quot; is appearing while...

I apologize for hoggin resources today. How would I trim a declared strin variable so that when printed it looks like &quot;1,2,5,6&quot; instead of &quot;1,2,5,6,&quot;? Please see my previous post today for details as to why.

Why does this return &quot;True&quot; in each case instead of printing the numbers if its true and blank_chars if it isn't? I'm only reading true/false from the DB. numberVar i=0; while i=0 do ( i:=i+1; If {furnace_model.electronic_ignition_ind}=&quot;1&quot; Then &quot;1,&quot...

Greetings. I am new to Crystal and, at the risk of sounding too new, have a problem with an &quot;if then&quot; statement. I'm using Crystal 8.5 to create a directory of products from our DB. Certain products either have a feature or don't, hence the 0/false or 1/true stored in the DB. I...