Search results for query: *

Working in Crystal 2008. I have a 12 row output in SQL server - one record for each month of the current year. There are several columns containing information that I need for each month to display MTD info per object: JAN FEB MAR..... Item 1 MTD MTD...

Here's the issue: we have a query comprised of several CTEs that eventually reduce to a final select. The scenario is: An employee's activity can be in one or more of 5 stages of activity. Employee Activity Stage Joe Activity A 1 Joe Activity A1...

The situation is this - a general sales manager has multiple sales people reporting to him/her. We generate a monthly sales report for each sales manager which is a summary of all sales efforts. We generate a monthly sales report for each sales rep which is a detail of all their sales efforts...

Trying to replace case statement in a Where clause with boolean expressions. Need help in getting this resolved. >> SQL Server 2008 R2 >> Three Parameters - Start Date, End Date, Employee [The Full name of the employee is required.] >> There is a MODIFIEDBY field which contains the full names...

Crystal Reports 2008 Excel 2010 xlsx Spreadsheet >400 columns 65 rows There's the specs - the question is this.... Changing datasource from SQL Stored Proc to a vendor-supplied worksheet. The connection to the Excel SS is fine; when the mapping window comes up, however, not all the Excel...

Here's the issue: Report is based on a stored procedure that will return rows which look like this: ACCT NUMBER Field1 Field2 Field3 Dec Susp 30393359 Group1 Group2 Group3 1 1 30393359 Group1 Group2 Group3 1 0 30393359 Group1 Group2 Group3 1 1 30393359 Group1 Group2...

I have the following SQL as a stored proc: @Branch varchar(255) AS Select MTGTERMS.LOAN_NUM as loan_number, br.BRANCH as branch from XX_MTGTERMS as MtgTerms INNER JOIN XX.BRANCH_INFO as br on MtgTerms.lnkey = br.lnkey where br.BRANCH IN (@Branch) (This is abbreviated, but forms the core...

Environment: Crystal 2008 Oracle 11 Stored Procedure A stored proc was updated to include a new field which would form a new group in the report. The report has been in production prior to the addition of the fieldfor three months. Followed the procedure...

A client has the following specification for record selection based on a report being run relative to today's date: Daily = M, Tu, W, Th, F where Monday execution start date is populated with the prior Friday date, and end date is populated with the prior Sunday date. the Tuesday execution...

Basios ========== Windows XP SP 3 Corp Network WSS 3.0 IE8 ========== I've been uploading documents to our corp site for several months when, as of last week, the ability to upload ceased. I have (according to the IT people) full access to that particular site... There is NO ERROR when...

I have a combobox, unbound, which was created using the combobox Wizard. At the time, the table (Salary results) on which the combox is based held two columns: ID and DATA. The ID column was removed and the RowSource property changed from SELECT [Salary results].[ID], [Salary results].[DATA]...

I have a Crystal Reports v8.5 Report that has been working fine 'forever' It is invoked by an ASP page using the Report Viewer. When the report is executed, it displays the message "User Cancelled" immediately after the viewer window is opened, even though the user did not cancel the report...

We have a legacy app (VB4/32) which is VERY DB dependent (DAU JET 3.0). One of the clients is updating hardware/software and introducing XP into their shop. They have successfully installed the app on 98/nt/2000 over the years. The installation on the XP test machine went OK - however the...

We use Crystal 8 professional edition (due to client constraints). Reports are generated by ASP page using the Crystal ActiveX viewer to view the report. Parameters are sent to a stored procedure to populate the report with data (Oracle 9i). The site maintains 15 reports; 14 of which export...

I appreciate the fact that 'Duplicate Records' is a hairy ol' chestnut, but the issue we're working on can't be resolved with a canned code snippet - unfortunately. Before looking at the table, here are the business rules: 1. A unit can be entered into an inventory table, A stock number and...

Have been working in CR 10 and just recently gained access to CE10 and the Repository function. Created a Command Object (with parms) in a report to replace direct 'calls' to the underlying db. Along with the Command Object, in Data Expert, I have two additional tables which link to the Command...

Have a non-VB application that collects parms from a user and wants to pass the parms to a report published on CE10. Need advice as to how to pass the parms to the report then direct print the report (no viewer). The front-end application is written in Flash...(not my choice). This is...

Environment CR 8.5 WinNT Current SP VB6 Getting an error 525 when running this code (extraneous stuff taken out: Dim db As Database Dim rs As Recordset Set db = OpenDatabase(dbWhere) Dim exportdll As String Dim exportformat As Integer exportdll = "u2frdef.dll" exportformat = 0...

Environment: VB6 SP5, CR 8.5, Using CRWRAP.BAS and GLOBAL32.BAS Procedure Objective: To export a Crystal Report Report Definition to a TXT file for further processing (parsing, extraction of table/field names). There are over 600 reports to be examined. The program opens the appropriate folder...

Environment: W2K SP2 256 MB Memory IE 6 SP1 When right-clicking on the Desktop IE Icon, the 'standard' shortcut property page [GENERAL | SHORTCUT | SECURITY] is displayed. When in IE, the TOOLS | INTERNET OPTIONS is not available (not disabled - invisible!). Any suggestions as to (1) why this...