Search results for query: *

Hi Dear Experts, I am using Crystal Reports for Enterprise. Is it possible to change grouping depending on selected parameter? There are two Multi-select Parameters: 1)Programs 2)Regions or "ALL". Main Report has two groups - Programs and Regions. Main report has no data, only grouping...

Crystal Reports for Enterprise Hi Experts, In order to display percentage previous records in group footer of main report, I placed a sub-report in the group header of main report. The sub-report calculates running totals that are placed into shared variables. The main report retrieves the...

Crystal Reports for Enterprise Dear Experts, I would appreciate if you can help! How to create Percentage of Previous Record for FY group? Here's a sample of data. The entries with stars are latest in FY. Selection Group Filter: Activity Date= Maximum(Activity_Date, Fiscal Year). Region1...

CR 2008 Hi dear specialists, please help me with the idea how to CONVERT ROWS TO COLUMNS. We have data in the following way: User_ID Assignment Type COTESYL EMSS Primary COTESYL NSSS Secondary COTESYL NCSS Secondary COTESYL MANAGER Secondary ELBAFA NSSS Primary ELBAFA NCSS Secondary...

CRXI There is a subreport in the report. The subreport contains two fields - project_id as a link to the main report and allocate_amt in Details section. But I am using Group Footer to display the last record of the report always with the summaries. So I need to put another subreport with the...

I am new in Cognos. Please give me an idea what kind of prompt to use and how to create query calculation to filter. I need to create a parameter Report Status. (2 choices: Due within 30 days or Overdue). If "Due within 30 days" is chosen, then the report will return records where Due_Date...

Hi, I am using CRXI Currently report shows: Task number Permitted Rewarded Balance 1 1200 150 1050 1 1050 350 700 2 200 150 50 3 300 150 150 3 150 100 50 3 50 50 0 The user...

CRXI Please give me advice me how can I suppress group footer if there is no data in the report. The report has two groups. Groop-1 footer contains summary totals and appears on the new page (I am using New Page Before). If there is no data displayed in the report, this page shows up as a...

Hi, CRXI SQL Server We have an accounting report that has columns with running totals for fields - {#run_approved},{#run_paid}, {#run_cancelled},{#run_refund}. The last right column has formula @run_balance: {#run_approved} -{#run_paid}-{#run_cancelled} +{#run_refund}. The results of...

CRXI, SQL Server 2005 I need to suppress a details' last record of the group. How to make it? Please give me ideas what formula can be used for it? Thanks very much.

Please help me with formulas reverse to summarizing: Placed in Group Header: //{@resetBalnce} whileprintingrecords; numbervar payment; numbervar cancelled; numbervar refund; numbervar balance_sum; payment:=0; cancelled:=0; refund:=0; balance_sum:=0...

CRXI Hi, I have placed a copy of the detail and group header fields in the report footer, and then used a conditional suppression formula on these sections:onlastrecord. But the last record is not suppressed, it appears twice - in group header,details and report footer. What can be the reason...

CRXI Hi, The report contains 3 groups - Programs, Departments, Status of Projects. Options of all groups: Repeat Group Header on Each page Group Footer #3 - New Page After with formula: not onlastrecord. The problem: Group Header #1 appears twice when the group#1 is changing: Program1 Program2...

CRXI The report has a field proj_due_date. We need to define status of the project and number of days (overdue) that past proj_due_date Status If more than 20 days between current date and proj_due_date then status is ‘In Development’ If less than 20 days between current date and...

CRXI I have a report that contains details section, amount totals and a signature in the report footer. The client wants the signature should not be on a page by itself (at least one row of plan details and the total amount must be on a page with the signature). Can you help me with the idea...

CRXI I have a string field in the report which is a date. It can be 040209 for April 2nd, 2009. When the report is exported to CSV format, the field becomes as 40209. I need it as 040209. I tried to convert it to number or date, but when the rpt. file is exported to CSV format it becomes 40209...

CR XI Hi, the user wants each row should be consecutively numbered. Top row should start with # 1. There should be no duplicate numbers. It seems very simple. I did not find in help. Give me idea how to create it. Thanks.

CRXI I have several details sections in the report. When I am exporting it to CSV format, it shows all rows of details sections not as additional rows, but as columns. Can anybody give me ideas how to solve this problem? Thanks.

CRXI SQL Server I have memo field in the report. I am exporting the report to csv format. The text of the memo field, that is displayed in the report, does not include entire field. The text is cut. Please help me - how to make displaying in the report the entire field!! Thanks very much!!

I was trying to put the field from Field Explorer into the details section. But I am receiving the following error messages and CR XI R2 is closed: crw32.exe has encountered a problem and needs to close. We are sorry for the inconvenience. Another message: The instruction at "0x5ad71531"...