Search results for query: *

Hello all - we are running an older version of Crystal Reports Server v11.5 and I was hoping there is a way to not have to update each report in the repository due to a database connection name change defined in each report (400+ of them) So is there a configuration setting on the server side...

Hello all. CRYSTAL REPORTS 2016 Support Pack 7 Patch 5 v 14.2.7.3248 Just ran into something very strange. I have a dynamic parameter that is populated from the command file query for the report. The parameter is a multi-select list of employees. There are a couple employees that are in...

Any creative ideas or ways to accomplish something similar to a subreport calling a subreport? I know drilling down to a lower group level works well but my client wants to: #1. start with a consolidated financial income statement #2. drill down an income or expense line to the divisional...

Hello all I've been trying to create something like this. It is basically a crosstab of departments & approvers versus the spend limits. I want to show the names of the staff that fall under each dollar value within department. Each summary could be multiple staff names. My current...

Hello all. I am trying to figure out how to write SQL to group data by common values together after they've been identified and assembled together. Using the following sample data, DATA ORDERS TABLE ID 100 ORDER DETAIL TABLE ID 200 Orders_ ID 100 Part_ID 500 PART...

Crystal Reports XI I created a subreport that will be the common header for several reports. This subreport contains Date/Time, a logo and a field from a parameter containing the report name. Then from the main report, I insert the subreport and make it "Re-import when opening". All that...

I'm using CR XI on Oracle 10g. I can not get a SQL Expression to work. Are subqueies (select within a select) allowed in SQL Expressions?

Hello!!! I am using Crystal Reports 2008, Business Objects Enterprise XI R3 with Oracle 10g I have developed a business view (BV) that feeds a dynamic cascading prompt. This issue is tied to the top level prompt in the cascade. The BV data foundation has a couple formula fields. 1)...

Crystal Reports 2008 Oracle 10g Hi all. Need some help with this one. I have a table with records: FLD-1 FLD-2 FLD-3 A A 01-JAN-2011 A B 10-JAN-2011 B C 02-JAN-2011 C C 03-JAN-2011 D C 12-JAN-2011 I need to group/break by FLD-2 but only include the newest record for FLD-1 based on FLD-3...

Same issue in CR 10 & 2008. This is a simply IF statement but for the life of me, I can not see what's wrong. I am getting a "a string is required here" error for code tagged below. Anyone able to shed some light? WhilePrintingRecords; stringVar Assigned; numberVar DaysAssigned...

I need to create a SELECT statement that provides a list of month-end dates from a particular start date to end date.Any ideas? Any help would be greatly appreciated.

I need to create a report of forecasted monthly depreciation expenses for a future date range. So if an asset has a monthly dep. amount of $100.00 and a useful life of 60 months that started 10 months ago, I need to show this asset's forecast depreciation for the next 50 months (month by...

I need to create a SELECT statement that provides a list of month-end dates from a particular start date to end date. Any ideas? Any help would be greatly appreciated.

CRXI I created a formula that originally contain a value from one of 3 table fields based on a parameter and this was used for report grouping. formula: IF {?GROUP} = 'C' THEN TRIM({ARINVT.CLASS}) + " : " + {ARINVT_CLASS.DESCRIP} ELSE IF {?GROUP} = 'P' THEN TRIM({PROD_CODE.CODE}) + " ...

Here is an interesting one. I was asked to create a report structured as follows: (subrep 1) (subrep 2) (subrep 3) (subrep 4) Group Production Shipping C.O.G.S New Orders Daily MTD Daily MTD Daily MTD Daily MTD A 1500 12500 1450...

I have a report that creates a list of records where the layout is a bunch of fixed length fields concatenated together. This file will be processed by other system and requires an exact record layout. The end users of our system use the Business Objects Report Viewer to view reports on...

OK this is a strange one. My report shows 4 fields from a table. After the 4th column I have a subreport that displays 2 shared variables that are calculated in the subreport. After that, I show the individual shared variables from that are also defined in the main report. The individual...

how can I force a page break after printing a certain number of detail lines?

I am considering to bid on a contract to develop reports for a client using the subject products. I do not have Remedy experience and I hear there are technical challenges with accessing and understanding a Remedy database. Any comments or feedback on this topic ? Thanks !!

I've created a report that pulls data from DB "a" and also uses a subreport that matches data from DB "b". It works great while running it from the desktop tool (CR Developer). When I upload it to CR Server, I can only specify one DB and set of credentials to run it from within the CMC...