Search results for query: *

Hi, I've the below report structure REport Header PAge Header Group Header DEtails Group Footer 1a Group Footer 1b Group footer 1c I dont want Page header to display in the report if GF 1b and GF1c are displayed. Is there anyway to do this?

Hi, Is there any possibility of moving from one page to another can be done by having an arrow( <- , -> ) somewhere in the report page instead of clicking right arrow and left arrow on the top of report(which is the menu feature of crystal). Can we customize to get it on the report page? Thanks...

Hi, Table structure is like this: Col1 | 1_Cnt | Col2 | 2_Cnt | Col3 | 3_Cnt ---- ----- ---- ----- ---- ----- x | 65 | a | 21 | m | 18 x | 65 | a | 21 | n | 3 x | 65 | b | 29 |...

Hi, I have a report which uses a command and filtering data by an ID in the command like ID = '{?Param_ID}'. I would like to display the corresponding name of the ID on the page header, so I wrote a formula like this: if trim({Command.ID}) = TRIM({?Param_ID}) then {Command.NAME} and placing this...

Hi , My stored procedure insert data in a global temporary table(on commit delete rows type table) in Oracle depending on the parameter we pass to the procedure. The stored procedure returns a result set from ref cursor of this data. When I try accessing the stored procedure through Crystal...

Hi , My stored procedure insert data in a global temporary table in Oracle depending on the parameter we pass to the procedure. The stored procedure returns a result set from ref cursor of this data. When I try accessing the stored procedure through Crystal reports 2008 , it gives me an error ...

Hi, I would like to disable group tree in crystalviewer. My AppServer is JBOSS(JAVA). Is it something possible? If yes, how to do it and it will be disable for all the reports deployed or the only one report which we are doing for? Also, is it something can be done by application developer or...

Hi, I would like to insert a table(not DB table, I need it for formatting)in details section. Is it something possible crystal 2008?

Hi, Is it possible to control/avoid drill down on sub report?

Hi, Can somebody help in getting page footer on each page of sub report. I have this sub report on the details section of main report and only when you drilldown on a group of main report this sub report will display. This is something urgent. Appreciate your help! Thanks in advance!

I have a crystal report which uses a Stored Procedure as data source(which has 4 IN parameters). when I run this from designer in dev environment it works fine. At this time if we go to set data source location "Use DSN Default Properties:" set to "False" and under procedure properties...

I have a report with 11 groups and each group is a drilldown. This report is to display employee hierarchy structure of an organization. If I go on drilldown on each employee the last level may stop at any group level. For example I am an employee and I have 5 levels above me so for my tree...

Hi, I have a crystal report with horizontal and vertical lines. When the report is exported to excel in Infoview, the users want those lines to be displayed on the excel as well. But when I'm exporting the report, it is not displaying the lines. I can check the gridlines option while exporting...

Hi, I'm using CR 2008 with a dynamic cascading parameter. Name: {?@Division} If the user selects ">>" to select all the LOV's in the first parameter box, then I want to display the parameter value as "All" in the report page header. IS this possible in crystal 2008?

I'm using CR 10 and SQL server. I have a table with employee information- Employee name, address and EmployeeLeavedays I want data in this format: EA EB EC ED EE Total Jan 1 2 0 0 3 6 Feb 0 0 0 0 0 0 Mar...

I have this Query. I need a way to optimize this. SELECT DISTINCT /*First SQL*/ SK.key AS SECURE, sl.col1 AS Name, sl.col2 AS Value, SK.log AS KEYLOG, SK.time, ( SELECT max(L.log) FROM dbo.LogTable...

I have this Query. I need a way to optimize this. SELECT DISTINCT /*First SQL*/ SK.key AS SECURE, sl.col1 AS Name, sl.col2 AS Value, SK.log AS KEYLOG, SK.time, ( SELECT max(L.log) FROM dbo.LogTable...

Oracle 10g and CR 10. I have a report where in I have grouped the report first by Audit date and then by departments There is another date in the table called record date. “Total from previous day” is actually the total that is present from prior business day “New items” – count of formula...

Database is oracle 10g. I need to write the following procedure in a single select statement: CREATE OR REPLACE PROCEDURE DB.PARAM (p_recordset1 OUT SYS_REFCURSOR) AS USERID VARCHAR2 (12); CURSOR USERNAME is select distinct uf.USERID FROM DB.USERFUND uf where uf.USERID =...

Hi, I'm new to CE10. I use both CR10 and CR8.5. Deploying CR10 to web can be handled well using CE10. I have a douth whether CR8.5 report be deployed to web using CE10? If yes, are there any limitations to use CE10 for CR8.5 reports? Thanks Inspi