Search results for query: *

I am using Crystal Report 2008. I have one subreport that displays top 20% summary and I need to pass an unique id which is a string to a detailed subreport of the top 20%. Any information would on how to best resolve this would greatly appreciated.

I am using Crystal XI2. I have the following sample of how the data is structured. Column A Column B 1 A 1 B 1 C 2 B 2 C 2 D 2 E 3 F and I need Column B to either column with one row for Column A, or concatenated would work. I can have up to 22 columns. Column A Column 1...

I am using Cryatal XI r2. I have a crosstab: The rows are grouping by State and City with column by each week and a count of people over trailing 12 months. The issue is I want state to populate on each row when exported. 7/6/2008 7/13/2008 7/20/2008 IL Chicago 10...

I am using SQL Server 2005. I am trying to get date function where year changes each year but my month and day stay the same. I need for ex... '2008-12-01' current, next year it would be '2009-12-01'. It will always be the beginning of the static month. Thanks in advance.

I am trying to format a report with lots of data and I need certain cells to be shaded. I also need to have some vertical lines and boxes seperating the data. What is happening is that as the lines pass through the cell backgrounds they are overwritten by the background. I have tried moving...

Using SQL Server 2000 I have the following example that is used multiple times through queries TERR IN('I01','I02','I03') Terr is VARCHAR. I am not sure how to do it or if it is even possible to change the example above to the following DECLARE @ABC VARCHAR(??) SET @ABC = ('I01','I02','I03')...

Using CR10 and SQL Server db. I have a table that has City State Zipcode and I have another table that has State Zip_Start and Zip_End with an Identification Field. I am trying to match Table 1 using State and Zipcode and return the ID field from Table 2. My problem is that linking to stat is...

I am using SQL 2000 and I have the following query. SELECT C.CONTACT_ID, TH.TRADE_YEAR, MAX(TH.POSTING_DATE) AS ENDOFWEEK, DATEPART(WK,TH.POSTING_DATE) AS WEEK, ISNULL(CASE WHEN TH.TRADE_CLASS IN ('S','Z') THEN SUM(TH.GROSS_AMOUNT)...

I am using Crystal 10 with SQL Server. Data sample below is currently what I am producing. With this sample the 5 week Total Sales and 5 week Moving Avg are in the same grouping. Currently being group by Quarter. What I am looking to include on this report is on each grouping take the avg...

I am using SQL Server 2000 this statement gives me this error "Incorrect syntax near the keyword 'AND'". DECLARE @TERR1 VARCHAR(15) SET @TERR1 ='RM1'AND'RM2'AND'RM4' SELECT RP.TERR1 FROM dbo.REP_PROFILE RP WHERE RP.TERR1 =@TERR1 I can get this to work for single item but not for multiples...

I am using C10 and SQL Server. I am curious if anyone knows if you can link a Main report parameter that I already pass to some subreports (which are commands) but pass it on to the SQL command directly as a parameter?

I have the following query I am working on. SELECT FM.C_NAME, (CASE WHEN O.C_ADR_1 IS NULL THEN 'No Address on File.' ELSE O.C_ADR_1 END) AS 'Office Address', O.C_CITY AS CITY,O.C_STATE AS STATE, C.CONTACT_ID,TH.FUND,TH.TRADE_CLASS, ISNULL(TH.GROSS_AMOUNT,0)AS 'GROSS AMOUNT', O.OFFICE_ID FROM...

Using SQL Server 2000. I have two Fields that I trying to limit to: TRADE_MONTH(int) TRADE_YEAR(int) What I am trying to do is get the previous 3 fullmonths. So today is March 2007 I need December 2006 to February 2007. Trying to keep from having to manually input the numbers to query my...

Does anyone have an idea on either better way to write the statement below or why I cant use "TO" for then results? Trade Month field is a number between 1 and 12 and I cant use the date field in our tables due to certain limitations. TRADE_MONTH=(CASE WHEN DATEPART(MONTH,GETDATE()) = 1 THEN 1...

I am using CR10 and DB2. I have a report that is grouped by region and then grouped by contacts. I have several subreports attached to the region grouping and I have a new subreport linked to the contacts. I do have a report on main under contact grouping showing the contact's address etc. I...

OK didnt realize that I need this to be sequential. So below I have attempted to do that but when I run the numbers I get -1 on all my MIF_ORDQUAN no matter what MIF_PARTNUM. If anyone out there could point out what could be wrong with the Procedure. ---------------------------------- DSCMOF3c...

I am trying to get the following to compare partnums and update the Quanhand with the ordquan. Any suggestions would be helpful. drop procedure P1; create procedure P1 is ws_PARTNUM NUMBER(10); wsmif_PARTNUM NUMBER(10); ws_ORDQUAN NUMBER(5); ws_QUANHAND NUMBER(4); ws_QOH NUMBER(4)...

Ok not sure on how to approach this due to still learning basics. I am using a Access to setup a daily work completed database. I have form that would list daily work that could be checked if it was done. What I am looking for is when these are checked and click on button to either close or...

Ok I am a novice at this but would like some guidance. I am using Access 2000. I am looking run a query that would pull from a list like (ABC, DEF, A11 etc..) seperately save to a new folder for today's date, as the code queried into excel. So the saved item would be C:\060706\ABC.xls. That is...

I am using CR10 with ODBC connection on DB2. I have a line chart that shows cumulative total for each month but limited to previous month (currently April) seperated by current and previous year. The data is based off a running total of this formula if {TRANSACTION_HISTORY.TRADE_YEAR}=2006 and...