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

Great, thanks!

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

EDIT: The first variable declaration above should be NatGas_MinEF instead of NatGas_MinEffy.

I got it! I did the 4 formula thing I described above. These are what I came up with for the natural gas, the propane are the same with the obvious changes: numberVar NatGas_MinEffy:=100; If ({directory_rwh.gas_type}="natural" or {directory_rwh.gas_type}="both") Then...

My apologies, CR9. I'm about to try creating 4 formulas (a min and max for each fuel type) that will dump the result in a global number. I'll then try to print the number in the flow rate group footer. I hope it works but will appreciate additional suggestions.

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

Thanks! your suggestion helped me out greatly. It took me a while to get the formatting down but it worked beautifully! FYI, here is what I did: CREATE VIEW public.wh AS SELECT DISTINCT model.model_number, model.fuel_type, model.efactor, round(365/rwh_model.efactor* CASE WHEN...

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 did as you instructed and it seems to be working out well! I have received word a single person was not able to open an attachment, compared to just about everyone before this change. Thank you so much!

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

The problem was caused by settings in the ODBC driver. From within Control Panel, ODBC Data Sources, User DSN tab, PostgreSQL30 configure, Datasource: check &quot;text as LongVarChar&quot; and &quot;Unknowns as LongVarChar&quot;. Leave &quot;Bools as Char&quot; unchecked. Last, change Max...

Anyone? Please?

I have saved my original 8.5 files and new 9 files in separeate directories. I have verified the database as well.

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

First, my apologies Ngolem. I mistakenly I supplied enough info. I have records grouped by company, fuel type, output, etc. They all usually share footnotes. However, the footnotes section was conditionally supressed in a group footer. this condition only depended on the last record...

I still have the IsNull formula in my details section but it is not in the second dropdown menu of the insert window: &quot;Insert a field which calculates the (count?) of (my formula 'additional footnotes test' does not appear in this list)&quot;. @additional footnotes tests formula reads...

Yes, I see a 1 or 0. The 0 occurs for the last record displayed (as well as two others in the section). All others are 1.