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!

  • Congratulations strongm 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: *

  1. dscoiho

    Passing Variables between subreports as parameter.

    Forgot to add to your question, no it wasn't on demand.
  2. dscoiho

    Passing Variables between subreports as parameter.

    I have the Top 20% in the report header and detail in the report footer.
  3. 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.
  4. dscoiho

    Combine multiple rows to multiple Columns

    As always LB you are an unlimited wealth of knowledge. This worked for what I needed. Thank you.
  5. 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...
  6. 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...
  7. dscoiho

    Date help for Dynamic Year and static Month and Day

    Thanks LFCfan that was the solution.
  8. 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.
  9. dscoiho

    Boxes and lines are being covered by cell backgrounds

    The problem I had with using a text box with a vertical line was that one of the fields is "Can Grow" and it give me gaps in the line. The other issue with the text box is that the line didn't need to be at the edge of the field. It is an odd report but that is the format I have to match.[neutral]
  10. dscoiho

    Boxes and lines are being covered by cell backgrounds

    lbass I am using actual lines and boxes (existing format) and the report actlually looks like a spreadsheet so I guess that is why I referred to it as a 'cell', it is actuall just a field with a background applied. I just wanted the line to show over the background. Thanks
  11. 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...
  12. 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')...
  13. dscoiho

    Matching field in one table with two fields in another

    Thanks for all the insight on my problem. I will look more into the join factor due this being common request. The ultimate problem I was having, for some reason couldnt think outside the box, is all fields were text and needed convert to number. This what I ended up with: @Match if...
  14. 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...
  15. 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)...
  16. dscoiho

    Calculation between groups

    The order needs to be in ascending.
  17. dscoiho

    Calculation between groups

    This is a manual crosstab with 7 columns A-G //@Week DATEPART("ww",{Command.POSTING_DATE},0) //Column A 5wk(repeated for B-G) SELECT {@Week} CASE 9 TO 13 : {Command.A} CASE 21 TO 26 : {Command.A} CASE 35 TO 39 : {Command.A} CASE 49 TO 53 : {Command.A} DEFAULT : 0 //Avg of Column A (Repeated...
  18. 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...
  19. dscoiho

    Reason why this doesn't work

    Sorry forgot that part. I want the final result to have RM1 RM2 and RM4.
  20. 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...

Part and Inventory Search

Back
Top