Search results for query: *

Thanks Ibass. I ahve added a parameter on product in both sub reports and added them with the bottom left parameter. It has improved the performance noticeably. Thanks for your help.

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

Hi, I want running total to start with zero again. Thanks. Zeekay

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

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

Thanks Ibass for your reply. Is there a way to avoid hard coding the department numbers in formulas? I am displaying one department on each page. I want the formula to return sum of salary or any other element only for the current department. I mean, if I am seeing department 10 page, then...

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

My report is based on SQL Command. In WHERE clause of my SQL, I am using DECODE function as follows: WHERE deptno = DECODE('{?P_DEPTNO}','9999', deptno, '{?P_DEPTNO}') In this way, if I select any individual department, I get result for that. But if I select 9999 then it results the...

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

Hi Ken, I am able to select only one "Subreport Parameter Field to use" in "Change Subreports Links" screen. I have already selected ?dept here. I can't see any way to select the second column i.e. ?subdept. I want to pass on both of the parameters dept and subdept to subreport. Any idea...

Hi, I have got an additional requirement in the same report. I need to add second parameter to main report and subreports. Currently, I have given Deptno in "Subreport parameter field to use". Its working perfectly. But can I add the second parameter too i.e. subdeptno? Thanks, Zeekay

Thanks Ken. I am trying Logicity now.

Hi Ken, We have Crystal Reports 2008 and Business Objects XI. If I open the same report in InfoView, I can change parameters and refresh data on the report. But the problem is with Viewer. Is third party Viewer the only option in this scenario or some security settings etc. can enable me to do...

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

Hi Ken, The report parameters worked perfectly as I wanted. Thanks very much for your help. I have another question for Crystal Viewer now. I am going to create a new thread for it. Regards, Zeekay

I will do it again tomorrow morning because its Sunday evening and the server is going to be down for backups etc. I will post you what I get. TA

Hi Ken, Thanks for your reply. I have tried your suggestion for one subreport and it has worked. It did not ask me for parameter for that subreport. But now after your change, it is showing me all employees for the given department on the same page. I want to show one employee on a page. When I...

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