Search results for query: *

Finally figured it out! For some reason, Crystal wanted me to convert a Number to a Number using ToNumber!!! Don't know why that was, but it's working now.

I've looked at other threads regarding this, but have had no luck getting my issue worked out. I'm trying to link a main report to a sub-report that is based on a stored procedure. The field in the main report is of data type Number while the Stored Procedure is calling for a parameter of data...

Is there any way for CE to automatically export reports into Excel when the user runs the report on-demand? I've researched all over and can only find where this can be done using scheduled reports. Since many of our reports are based upon live data and users want them in Excel, I was hoping...

Try rearranging in the design mode by clicking on the gray section area. When you click, you should get a hand cursor and be able to rearrange the groups.

Hey Folds - working with CR10 on Sybase. I've got a simple report that lists a bunch of data including Account ID which is also the only Group. The report will list many records. I have inserted a Subreport in the Group Footer as an On-Demand subreport that will create a letter to be mailed...

Thanks synapse!!! Worked like a charm! I was a bit concerned that the lines would shift on me, but they seem to adjust to the relative positions of the text items. Thanks again!

CR 10, Sybase database lbass helped me with this following formula in a previous thread and it works great. I'm trying to work on a couple formatting issues and hope someone can provide some insight. Here is the code for the formula: whileprintingrecords; stringvar array parm := {?parm}...

Thanks LB. Worked like a charm!!!! I was working towards this solution, but just couldn't get to the finish line on it. One follow-up question.....do you or anyone else know of a way to get the final format to appear with the "X" fully underlined? Here is what I've got: display := display...

Howdy - i'm on Crystal 10 off a Sybase database. I'm prompting the user for a multiple value parameter ?Checklist which can hold 1 to 5 different string values with the user selecting which ones to identify with an "X" on the report. I'm trying to create a formula that will cycle through the...

Thanks LB!!! I had tried using the subreport before, but wasn't getting the results I needed because I also linked on PO. It was causing the report to only pull in the first Allot Amount and not the sum. It just didn't occur to me that I didn't need to link on ALL of the relational fields...

thanks LB, my bad on the example data. Here is a revised set: Table1:  Summary             Acct    PO    Expend    Allot 1000-1    PO1    100    125 1000-1    PO2    50     50 Table2: Detail             Acct    PO    Contract    Expend 1000-1    PO1    C01             50...

Hi All - I've been stumped on this problem for a while. I can solve it using 2 SQL COMMANDS, but the performance is horrendous, so I'm hoping someone here can give me some pointers on how to get what I'm looking for. Here is a sample of the data I'm working with: Table1: Summary Acct PO...

Crystal V.10 off a Sybase database. I’ve got 2 tables joined and am trying to get a summary total in a Group Header for one of the data items that only exists in the one of two tables. Here is a sample of the data: Detail Table: TableA.Fld.Actual: $100 TableA.Fld.Actual: $100...