Search results for query: *

Thanks lbass!! But isn't subreports a bit slow..performace wise. Can't I write some formula to suppress the duplicate records. Can we do this using some formula? You are so good at writing the formulas :) Thanks, Nikhil

Thanks lbass!! But isn't subreports a bit slow..performace wise. Can't I write some formula to suppress the duplicate records. Can we do this using some formula? You are so good at writing the formulas :) Thnaks, Nikhil

Hi, I have two tables containg the data like this: Table1: EMP_ID MONTH BONUS 1 July 200 1 July 100 1 Aug 300 2 May 300 3 July 400 3 Dec 900 Table2: EMP_ID Month Comments 1 July Happy 1...

Sorry for not providing the complete information in my previous post. Crystal Reports version : 8.5 Datbase - sybase 12.5 connectivity - native driver

Hi, In my application I am exporting the report (without data) files to .rpt files ( with data). But few of the reports fail with "error 507" error message. Following white paper talks about the same but when exporting to Excel through ASP app ( and not to .rpt files)...

Thanks Lbass!! But If I use this formula, It will kind of 'grow' the last detail line. But my 'record count' formula will treat it as a single record. And, the record count will go till 16 ( let's say I have 16 records in the last page) not 18. I want that record count should also go till 18...

Thanks for the reply!! Crystal version - 8.5 Database - Sybase,ODBC connectivity Let's say I have two records in my table Column record1 record2 Now in the report I want to display the data like this: 1. record1 2. record2 3. 4. Though I have only 2 records in the table, I...

Hi, I have to design a report in some format. And for that I am using some formulas with the assumption that each time I will recieve fix number of detail lines in the report page. I want to keep 18 detail lines on the page. So if my database table returns 12 records, even then I want to have...

It looks like I have found a way to achieve this. Thanks Dave!!

Thanks for all your help Dave!! It is working fine when I export the report from the Crystal Report itself. But in my case I am generating this report using the 'exporting process'. Thus we pass the parameter to the report from the ASP pages. I have changed this parameter for the 'multiple...

Thanks dave, but even this doesn't seem to work.. If I use the {system_bills.station_code} = {?station_code} it works fine, but If I use "in" instead of "=" it fails :( {system_bills.station_code} in {?station_code} Any Idea why this is happening. Can't we use ("in") in the record...

I am using the following 'Record Selection' formula ("ALL" in [{?station_code}] OR {system_bills.station_code} in [{?station_code}]) and {customer_accounts.trade_indicator_code} <> "IC" The station_code value is "ROC" But the 'Show Sql Query' shows the follwoing conditions in 'where' clause...

Thanks for the reply dave !! But even this doesn't seem to work..Still In the 'Show Sql Query' I don't see this condition.

Hi, In my report I am using 'station code' as a parameter. These parameter values are retrieved from the database and then they are passed to the report.These values are stored in the database like this: parameter parameter_value station_code "LAX|PHX|SEA|NY" ( In this case...

Thanks lbass!! This worked like a dream..U r genius !! I am still trying to decipher your code :) once again, thanks a ton..

Thanks for the reply but.. I can not do a group on the customer number because first I have to calculate the sum of invoice amounts irrespective of customer account number. Please refer to the provided example.

Hi, I have to provide a report to my company's VP. The data in the table, against which I have to generate the report, is like this: invoice# customer# amount ABC 9999 123 ABC 4567 123 DEF 5678 100 DEF 5678 100 XYZ...

Hi, I am generating few reports using the RDC exporting method. But out of 100, 10 reports are not exported during the process and these 10 reports are not fixed. They could be any 10 reports out of 100 reports. I am exporting the reports from ASP pages. The error which is displayed on the...

Hi, I have a report saved with data. The report is configured for some parameter and contains values for all the possible values.Now i want to access the same report from the browser but while accessing the report i want to display only some specified records depending upon the value of...