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

Thank you for your responses.... Here is the code snippet create table #num (Stage INT) insert into #num Values (1) insert into #num Values (2) insert into #num Values (3) insert into #num Values (4) insert into #num Values (5) ;with cte_Raw as ( SELECT reps.CSRReps_user_role_id...

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

Thank you for your reply! Let me clarify - there will be only 1 manager report with 3-6 rep reports on the same form. We use a semi-automated system which takes an Access report form, generates the report for a specific image (tied to a distribution table of names), creates a PDF of the report...

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

Thanks... as it turns out, a more convoluted query was required to capture another aspect of the table. I appreciate your response! Crystal Reports Design/training/Consultation earljgray@gmail.com

Thank you! I hadn't had the chance to pop it into the procedure - but I will on Monday!!! Crystal Reports Design/training/Consultation earljgray@gmail.com

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

Thank you!! Crystal Reports Design/training/Consultation earljgray@gmail.com

Thanks! Trying this out now.... Crystal Reports Design/training/Consultation earljgray@gmail.com

Thanks for the comment!Q Unfortunately, the sheet comes from a third-party and 'is what we have to work with'... I was hoping there was no intrinsic column limits set in Crystal - but it appears it will chop off anything after 255 columns..... Crystal Reports Design/training/Consultation...

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

Thanks! Not used to Running Totals - being a VBA and programming type (go to formulae first to solve ALL the world's problems!) Anyway, did a quick test, looks good! Need to set up a couple more and go from there!!!! Thanks again!!! Crystal Reports Design/training/Consultation...

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

To RTag: Nope, no formula, and no fields removed/replaced with new. Just a standard procedure that had 1 field added. The {new field) is shown on the left quadrant; other fields of the same type (but not to be mapped to) are on the right. Thanks To hilfy Tried Set Location. Even set the...

Unfortunately, not. All the procedures are tucked into a packlage body which forms the data source for numerous reports, each calling their own procs from within the package. Becasuse of the File DSN and the package concept, unless you REALLY go out of your way, it's almost impossible to select...

Answers... Oracle 11g Stored Proc File DSN is used - uniquely IDs that one DB Crystal Reports Design/training/Consultation earljgray@gmail.com

Hi! Thanks for the interest in this little problem.... No, no parms at all. Straight call to a Stored Proc., one that was in service for a while before getting the added field. Crystal Reports Design/training/Consultation earljgray@gmail.com

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