Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dscoiho
  • Content: Threads
  • Order by date
  1. dscoiho

    Passing Variables between subreports as parameter.

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

    Combine multiple rows to multiple Columns

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

    Crosstab row labels

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

    Date help for Dynamic Year and static Month and Day

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

    Boxes and lines are being covered by cell backgrounds

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

    String statement passed to an "IN" statement

    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')...
  7. dscoiho

    Matching field in one table with two fields in another

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

    Max Date of a Week

    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)...
  9. dscoiho

    Calculation between groups

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

    Reason why this doesn't work

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

    Parameter to Command

    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?
  12. dscoiho

    Help with limiting data

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

    3 month Trailing Date

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

    CASE Statement

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

    Header and Grouping

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

    newbie help again

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

    Newbie help

    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)...
  18. dscoiho

    Auto Fill Records

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

    Automate Query

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

    Line Chart Question

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

Part and Inventory Search

Back
Top