Search results for query: *

I'm trying to add a new record in my form using a 'Command Buttom'. Below is my code. Private Sub Command11_Click() On Error GoTo Err_Command11_Click Dim intnewrec As Integer stDocName = "frmrentals" DoCmd.GoToRecord , , acNewRec Exit_Command11_Click: Exit Sub...

SQL 2000 Crystal XI I have a group on a report {class_group_desc} I need to have a DISTINCTCOUNT for each {ad_num} Formula {@emp}: distinctcount({@dist})-1 Formula {@dist} If {mc_period_dates.period_year} IN [2006] AND {mc_period_dates.period} = 5 AND...

SQL Server 2000 Crystal 9.0 I'm having problems getting the following fields to link into my Crystal report: @year, @period, @start_period_CY, @end_sun_CY, @start_period_LY, @end_sun_LY Below is my Stored Procedure CREATE PROCEDURE [bc].[Test_Fri] @year int = NULL OUTPUT, @period tinyint...

ODBC 2000 Crystal XI My Stored Procedure is below. I would like to do a ROLLUP on each prod_code. Which is best ROLLUP or COMPUTE SUM to use for quick processing time. I've never used either. I would appreciate anyones help. Thanks in advance. ( @year int , @start_date_CY varchar(10) ...

Need help with using NOT IN in a Stored Procedure. I've tried various ways, but data still is incorrect. Maybe someone can tell me what I'm doing wrong. Thanks in advance for your help. SELECT ad_num = mc_ad_detail.ad_num , source = mc_acct_master_view.source , adv_type =...

I read the article 'parameter sniffing'. Below is my 'Stored Procedure', which fields do I need to create index on to speed up the performance. I've created indexes on region, territory, insertion date, but it still is taking forever to process. Thanks in advance for anyones help. (...

I'm trying run a Stored Procedure using Query Analyzer. The Stored Procedure has two parameters (@start_date_CY and @start_date_LY) they are datetime which I do a convert SELECT CONVERT(varchar(8), @start_date_CY, 1). The following is my exec: exec [brxmas].[mc_119employment2_sp]...

SQL 2000 Crystal 9.0 If someone could please tell me what I need to do in order to get the correct data, I would appreciate it. Report Filter: {mc_period_dates.period} <= {?Period} and {mc_period_dates.period_year} >= {?Year} -1 I'm trying to get the sum of CY Inches when using the following...

SQL Server 2000 Crystal 9.0 I created a report that uses a Period table in the database. Our Period Calendar is 544. Users need to be able to see the Period Calendar to select date criteria. See example below: Period 9 - September start_date = 08.29.2005 = Default Calendar 08.28.2005...

SQL Server 2000 Crystal Reports 9.0 I have a Crystal report using the following parameters: Year Period start_date end_date When creating the start_date parameter - how can I display the calendar so the user can select the date? There is a period_dates table in the database. I appreciate...

CR 9 SQL server 2000 I created a 'Crystal' report which uses parameters to select correct data. 1) Parameter ?Period (number) 2) Parameter ?start_date (date) 3) Parameter ?end_date (date) I want the user to have an option to select by Period or Date Range. When I enter start date and end...

ODBC 2000 I have a question about duplicate reports processing when I schedule reports using 'Report Scheduler Pro'. When I schedule reports the radio button 'Once' is selected, but it always runs a couple reports a second time. For example see below: Scheduled specific reports Rpt 200...

ODBC 2000 Crystal 11.0 LB I really appreciate the information you sent above. The only issue I'm having is if I add the following for my lineage in the 'Running Total' that it doesn't count my Group Class Desc class_int My report gives me the correct # of Ads and Revenue $$, but NO...

ODBC 2000 Crystal 11.0 I created a Crystal report grouped as follows: 1) Class Code Desc 2) Class Code Int 3) Ad # Class Desc Class Int # Ads $ CY $ LY Line CY Line LY --------------------------------------------------------- LiveStock 915 55 874...

ODBC SQL 2000 Crystal 11.0 When I open a 'Crystal' report I get the following message: This report uses an invalid printer. The default printer will be used instead. I click ok. But, when my report finishes processing some of the fields don't show when I 'Preview'. See example below: 722...

ODBC SQL 2000 Crystal 11.0 I have two groups: 1) ad # 2) insertion date I need to show all ad # in ascending order by date 05/02/2005, 05/03/2005, etc. In the example below ad # 36688 has 5 ads, but I only want to see one line (sum). The problem I'm having is it groups by ad #. If I group...

ODBC SQL 2000 Crystal 11.0 I have a 'Crystal' report as follows: Grouped By - Insertion Date Here's what prints on the report ad # acct # date # of ads Lineage 12786 3157262 5/8/2005 1 4 12786 3157262 5/8/2005 1 4...

Crystal 9.0 ODBC Connection SQL 2000 Is it possible to create a duplex report (front and back) and if so is there a way to specify the start page of a new region to appear on the front side of a two page duplex report)? Example: Rep#1 with their specifc information may cover three pages and I...

Crystal 9.0 Connection ODBC MSQL 2000 Hopefully someone can help me....Thanks in advance. Instead of using a subreport which takes forever to run, lbass suggested that I use crosstabs, which works great. My problem is I not getting the correct % for each category. The report shows the total...

Crystal 9.0 MSQ Server 2000 ODBC Connection I have a Crystal SalesRep report that I run via 'Report Scheduler Pro'. This report is grouped by Rep # with their individual accounts. There is also a page break after each rep. This report is saved as a .pdf file. My question: Is it possible...