Search Result

Collapse
9 results in 0.0039 seconds.
Keywords
Members
Tags
crosstab
  •  
  • sanndeb
    started a topic Highlight max value in a subtotal row of a crosstab
    in SQL Server

    Highlight max value in a subtotal row of a crosstab

    Hi guys hope you all are fine....

    I'm totally new to SSRS 2008 & stuck in a problem. So please help. :)

    I have a crosstab report from northwind & I'm able to heighlight max value for each row with the expression below :
    Code:
    =iif(Fields!SalesAmount.Value = Max(Fields!SalesAmount.Value, "Year2"),"LightBlue","Transparent")
    where "Year2" is my row group against year. There...
    See more | Go to post
    Last edited by NeoPa; Sep 7 '11, 10:08 PM. Reason: Tidied up messy post and made picture viewable
    • bknabl
      started a topic Access 2003: Union Query Problem
      in Access

      Access 2003: Union Query Problem

      I'm very new to creating union queries. I understand the purpose but not how to properly implement it for my purpose. So far I've created to perfectly fine crosstab queries. One shows input on a date ordered, the other shows the out put on a date completed.

      I am trying to combine these two charts into one chart. The code I've got so far will only show one date. I am looking to have 2 (4 if you count the break down into the two material...
      See more | Go to post
      • christian85
        started a topic Crosstab subqueries
        in Access

        Crosstab subqueries

        Hi everyone,

        I can't seem to get this query right. It seems that crosstab queries don't support subqueries or is it? How should i rewrite this? It's too nasty to expand the whole query in four statements and union them together...

        Code:
        SELECT t1.companyname AS Supplier, t1.questionid, t1.Assigned, t1.Question, t1.Weight, c.CategoryName AS Category, t1.Score
FROM (

SELECT s2.companyname, q.id as questionid,
        ...
        See more | Go to post
        • christian85
          started a topic Records as columns in updatable table
          in Access

          Records as columns in updatable table

          Hi,

          I have three tables: question, teammember and assignedQuestio ns

          A question can be assigned to multiple teammembers, this will be recorded in the assignedQuestio ns table.

          What I want now is a list of TeamMembers as columns in a datasheet with the questionnumbers on every row and checkboxes as a value for every cell so that I can assign a question to every teammember. Like this:

          _____Member1__M ember2__Member3...
          See more | Go to post
          • tcusolle
            started a topic Vertical table to Horizontal
            in SQL Server

            Vertical table to Horizontal

            have a page that dynamically builds forms input fields from a table allowing users to enter input into the form. Each input is a field in a _info table.

            I would like report showing all of the entries of a user in one line. Each field entry is a row. So I need to take the vertical data and make it horizonal. There are many different forms with different configurations so must be dynamic. I’ve come across a lot of articles for cross-tab...
            See more | Go to post
            • jenniferhelen
              started a topic How can I transpose a table/query in Access?
              in Access

              How can I transpose a table/query in Access?

              I am working with a query that has 6 columns and 101 rows; I would like to transpose the rows and columns. I have tried using a crosstab query but Access limits the row "fields" to 3 and this was not producing the desired output. I saw a comment in a thread about using a pseudo row field as a work around but I do not understand how this works.
              Another option I tried is from the following link and attempting method 2: http://su...
              See more | Go to post
              • east7
                started a topic Transpose into fixed column
                in SQL Server

                Transpose into fixed column

                Hi all,

                I am using SQL 2000, and I have following table with 2 columns, ID and TIME

                ID | TIME
                A | 07:01
                A | 12:05
                A | 13:01
                A | 15:09
                B | 15:07
                C | 06:52
                C | 12:47
                C | 17:03
                D | 07:00
                D | 18:12
                D | 18:57
                D | 21:04

                Now i want to transpose them into another existing table with 7 fixed columns: ID, T1..T6
                ...
                See more | Go to post
                • Mysterydave
                  started a topic Creating a total from a tricky report
                  in Access

                  Creating a total from a tricky report

                  Hi,

                  Here is my problem:

                  I have a report which lists Application numbers, Offer numbers and Firm Replies numbers for a subject i.e. Geography as 3 rows. My column headings also list subjects so you can see the Joint Honours combinations. As not all Subject combinations are possible there are many null fields. For example Geography with Geography. With a rather large IIf statement in a text box I can create a row total,...
                  See more | Go to post
                  • Mysterydave
                    started a topic Crosstab Query Adding Pivoted Columns
                    in Access

                    Crosstab Query Adding Pivoted Columns

                    Hi,

                    If I have a cross tab query which counts an [id number] and pivots on a [status] for a [course], how do I add a new row heading that will sum only a certain few status's. E.g. The [status] field has "A", "B", "C", "D". I want to add a row heading that is the sum of [id numbers] under "A" and "D"?

                    Thanks
                    See more | Go to post
                    Previous template Next
                    Working...