Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: zeekay
  • Content: Threads
  • Order by date
  1. zeekay

    Slow Performance with SubReports in Crystal

    Hi All, I have written a report in Crystal Reports. The report has one main section and the two sub-reports joined to the main section. SQL for all the three sections is very efficient and runs very quick if I run it in TOAD. But when I join the sub-reports to the main section, the report runs...
  2. zeekay

    How to Reset Running Total Conditionally?

    Hi All, I have a monthly stock and sales projection report in crystal. I am using running total on stock's column. I want to reset the running total if it goes negative. It should start from the row again where it becomes positive. Any help in this regard will be highly appreciated. Thanks
  3. zeekay

    Exporting Crystal Report as multiple Worksheets in Excel?

    Hi Guys, I have a crystal report on Employees table. When I run the report, it shows me employees for all 10 departments. I want to export the report to Excel showing each department as a separate worksheet and one worksheet showing totals. Means, I want to export the report in one Excel...
  4. zeekay

    How to use subtotals in calculations in Footer section

    Hi All, I am writing a report in Crystal on employees table. The report is grouped on departments column. It shows employees of department 10 and their salary totals, then department 20 and their salary totals and so on. In footer, I am showing grand total. I need to show some more calculations...
  5. zeekay

    How to Run Report for All Departments?

    I have Profit & Loss Report in Crystal. I have a parameter field for department. I can select one department at a time to run the report for that department or I can select 9999 department to get a consolidated Profit & Loss report for all departments. I have 100 departments. I want to run the...
  6. zeekay

    Passing Parameters in Crystal Viewer

    Hi All, I have a report which has parameter :p_deptno. If I open the report in Crystal Reports Designer, I can change the parameter and see the data. But if I open the report in Crystal Viewer, I can see the data which is already on the report and can not change the parameters to refresh data...
  7. zeekay

    Parameters in Subreport - Urgent

    Hi All, I have a report which has one main report and two subreports. Just to explain my problem in detail that my report is as follows: Main Repot based on a command (select empno, ename, address from emp where deptno = :p_deptno) Sub Report1 based on a command (select empno, attendace_days...

Part and Inventory Search

Back
Top