Search results for query: *

Wow! Thanks so much for your help. I just tried it and see that it is working correctly now. Thanks again!!

Hi Mike, I just emailed you a copy of my report with data. Thanks for taking a look. -j

thanks for your quick reply! I tried your version and I got the same results. Individually, the statements work if instr({@HealthCoverage},'Employee and Family') > 0 then "$500" WORKS!!! but when I combine the two with an AND I get no results. And there are rows that match the...

I can't seem to make the formula that I want work!! I'm no programmer so I had one come review my formula and he couldn't figure out why Crystal didn't like it either. I have a couple of formulas that are returning the proper data in their columns. In another column, I am trying to compare...

Here is one of the views that is not working... CREATE OR REPLACE VIEW LEGX_SALARY_ALL_V ( EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, LAST_NAME, FIRST_NAME, MIDDLE_NAMES, CHANGE_DATE, CHANGE_VALUE, CHANGE_PERCENTAGE, REASON, SALARY, APPROVED, RATING, RANKING, GROUP_SIZE, PAY_BASIS...

ok, this error isn't really formula related but I seem to get the best response in this forum so I thought I'd give it a try. I have some sql views written that work perfectly well in other tools (toad, discoverer, oracle reports) but when i try to use them in crystal i get the following...

yep, its a VarChar (description field) so that must be the problem. Thanks for the Maximun operaton tip too. -jessie

I was hoping that it would be just as easy as you described - using a crosstab. But my two issues I ran into there are... 1) I can't figure out how to suppress subtotalling on all the fields I am displaying. This report would not need any totals fields. 2) For some unknown reason, when I...

I have some data that I am reporting on for parts that includes description type columns and pricing columns. If I bring back all the fields in the usual mannner af placing each of them in the detail section, I get multiple rows for each part as it returns each of the column prices. I am...

we are trying to choose a one tool to standardize on for our reporting needs. Currently, we have reports being created/maintained/distributed in both Crystal and Oracle reports. Can anyone give me their opinion on which tool would be the best to use. Or give advantages/diadvantages to both...

ah ah! That works! Thanks, Jessie

We are using v7.0 - I am trying to arrange my groups based on a specific order that the user wants. From the design tab, I right-click on the group (I only have one group header) and select change group. I selected "in specified order" and went to the 'specified order' tab to select...

I ended up getting this to work as the record selection in the select expert: ({OPPORTUNITIES_V.VALUE_1_YR_PROD} >= 1000000.00 and {OPPORTUNITIES_V.WIN_STATUS} in ["Pending", "Win"]) or {OPPORTUNITIES_V.WIN_STATUS} in ["Cancel", "DesignWin&quot...

Thanks for your help!

thanks for the response! I'm needing to filter the records, but just on one group. for instance, if I had... group A record1 200.00 record2 900.00 group B record1 200.00 record2 400.00 group C record1 400.00 record2 800.00 and the formula I need is to only bring back...

I have a report that is grouping by a win_status field. Each record returned in every group contains a $amount field. I'm wanting to filter just one specific group by $amounts greater than 1 million. Something like... If win_status=Pending and $amount > 1000000