Recent content by nikhil27

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