Search results for query: *

Worked perfectly. The NOT(SuppressionLogic) was my culprit. I added the NOT and was good. Thanks.

Hi, I am using Crystal 8.5 on Oracle 8i. I am summing up my Totals Sales Amount on GF1. My detail line has a Format Section formula, where I am suppressing duplicate lines. The problem I am facing is that my Summed Up Totals on GF1, is adding up these suppressed values as well. I need help...

I am using Crystal 8.5 Hi folks, I am trying to come up with an easy to use formula to compute my Open Balance field. My client needs to see the details of Invoice Payment history. The table below shows the detail transaction of an Invoice# 112234, ( Amt= 30,000) that was paid on three...

Thanks, Isadore for that valuable link, man. It was just what I needed. I struggled with that stuff for over 2 days and after deciding to post I got the solution to my problem in 2 minutes !! Mulema.

My DataGrid hyperlink works correctly after following the help from this forum. When I click on the hyperlink on the datagrid Column, it reads and transfers my ID# to Form2.and populates my textboxes correctly. My problem is that, this action opens Form2 on a new browser. So I have Form1 and...

Hi all, I would like to know how to do this, with a parameter (i.e if its possible at all) I have a report with two groups GH1, and GH2. I would like to know how, using a parameter, I can have the report change its grouping order to GH2, then GH1. I do not want to suppress any of the groups...

Hi all, I just created my first Crystal Report using ASP.Net, and followed the example I found online. - This is what I did. - I decided to use an already workable report created in Crystal Report version 8.5. This report passes in 2 parameters. (Order#, and Product# ) - Using Visual Studio Dot...

Jzelhart, Please I have a similar issue. This is my very first ASP.Net project and I am just as blank. I tried your example and it work great for a single string,(ie. I was able to poplate only one textbox) but I want to pass multiple strings. I am reading from a DataGrid with 6 columns, and...

Hi! 123ASP, Did you get a solution to your problem. I am facing the same issue, and would like to know how you got it working. Thanks

OK Brian These are the posibliites. If you chose: {?Order_Type} = "By Transaction Date" then {?Date_Range} will = the Transaction Date field If you chose: {?Order_Type} = "By Manufactured Date" then {?Date_Range} will = Manufactured Date field If you Choose...

Hi All, I am in the process of merging some reports that were designed at various times over the last two years. These three reports use the same underlying view, so the columns are all the same. I use CR version 8.5. The first report pulls and groups Warehouse information by their...

Mike, Thanks for your quick response. The error was as a result of my position of my parenthesis This is what I came up with. ( NOT ({TABLE.NOTES} LIKE '*released*' ) OR NOT ({TABLE.NOTES} LIKE '*Released*' ) OR NOT ({TABLE.NOTES} LIKE '*RELEASED*' )) Thanks...

Hi All, My brain has gone into recess.(I am using version 8.5.) Problem : I want to display records where the Notes field <> &quot;*release*&quot; ( ie. Only records where the Notes field doesn't have the word 'release' anywhere in the sentence should be displayed.) I tried using this...

Thanks, Synapsevampire. Unfortunately the 3 formula Method which I had earlier tried couldn't work for me because, my detail line is suppressed (not used) since I am eliminating duplicates, I evaluate once for group #3 I attempted this formula in the Evaluate Tab but didn't get the required...

Hi all,I know this is a dumb question, just having a bad day. Can't think right. I created a Running Total field, using the Inbuilt funtion. -- running Total Name = ITM_CNT -- Field to Summarise = Item_Codes -- Type of Summary = Count -- Evaluate = On Change of Grp #3 --...

Crystalguru, I am aware of your solution but it doesn't work for me because of my report layout. RH - ( Need to Dislay my Counts here )* -- GH1 - Catalgue# GH2 - (suppressed) GH3 - Pack #, Dates etc. [ Created a running total count formula here ] Detail ( Suppressed ) GF3 - Suppressed GF2...

Hi Crystalguru, I have a similar issue, but my user wants me to put the Count Summaries on the Report Header. I have tried unsuccesfully to do this. Any ideas ? Please help. Thanks.

Nilsen, This is what I use for my Crystal version 7.3 reports. Works just fine, and you shouldn't have any problem. WHILEPRINTINGRECORDS ; STRINGVAR ARRAY Input := {?COMPLEX }; NUMBERVAR howmany := COUNT (Input); Input [1] + IF howmany > 1 THEN ', ' + Input [2] + IF howmany > 2 THEN ', ' +...

Had no luck with this approach. The report fails, with message &quot;Error in formula code. Contact seagate software &quot;.

Jcfowl I tried your suggestion but ran into another hiccup. &quot; This Array must be subscripted &quot; error. Any suggestion on how to subscript this thing. My search couldn't find me a good enough example to work on. ({TABLE.PRICEPERUM} >= {?PRICE RANGE} and {TABLE.PRICEPERUM} <= {?PRICE...