Recent content by earljgray

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