User Profile

Collapse

Profile Sidebar

Collapse
RiddleMeThis
RiddleMeThis
Last Activity: Jun 22 '10, 07:20 AM
Joined: Feb 4 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • RiddleMeThis
    started a topic SSRS Exported CSV files have the header on EVERY row
    in SQL Server

    SSRS Exported CSV files have the header on EVERY row

    In SSRS, when a report is exported to csv it seems to output in the following format:
    • <HEADER> <FOOTER> <DETAIL1>
    • <HEADER> <FOOTER> <DETAIL2>
    • <HEADER> <FOOTER> <DETAIL3>
    • <HEADER> <FOOTER> <DETAIL4>

    and repeats like this for every row, repeating the header and footer on every line.

    However I want it to output the header at the top of the csv, then...
    See more | Go to post
    • RiddleMeThis
      started a topic SSRS 2005 | cangrow/canshrink = false | Columns still grow
      in SQL Server

      SSRS 2005 | cangrow/canshrink = false | Columns still grow

      I'm using SSRS 2005 and have set all of the cell's cangrow and canshrink properties to false so that a header will align properly, but where a cell's contents (without spaces) are larger than the cell it does not wrap to the next line, it makes the column grow which messes up any alignments in the output.
      Is this just something I have to deal with or is it possible to make it wrap so that my alignments remain?
      I've tried doing 'Format...
      See more | Go to post
      • RiddleMeThis
        replied to Visual Studio Reporting Services - MultiValue Parameters
        in SQL Server
        Just realised the code I should have been using is:
        Code:
        SELECT AccID, AccName, StartDate  
FROM Account  
WHERE AccID IN (@prmAccID)
        It doesnt treat it like an OR condition, it treats it like an IN condition and so, with account IDs 34 and 35 for example, it would use the following code:
        Code:
        SELECT AccID, AccName, StartDate  
FROM Account  
WHERE AccID IN (34,35)
        See more | Go to post

          Leave a comment:

        • RiddleMeThis
          started a topic Visual Studio Reporting Services - MultiValue Parameters
          in SQL Server

          Visual Studio Reporting Services - MultiValue Parameters

          Hi, I dunno if this is in the correct catagory, hope so, sorry if it's not.

          I'm trying to get to grips with SSRS and having a bit of trouble with multi value parameters.
          I'm using the following code in the data section:
          Code:
          SELECT AccID, AccName, StartDate 
FROM Account 
WHERE AccID= @prmAccID
          This works fine with the default settings, the report prompts me for @prmAccID, so I put in an Account...
          See more | Go to post
          • RiddleMeThis
            started a topic In Crystal, what does COUNT ({table.column1},{table.column1}) do? & SQL equivalent?
            in SQL Server

            In Crystal, what does COUNT ({table.column1},{table.column1}) do? & SQL equivalent?

            In Crystal, I've come across the following code but don't really understand it:
            Code:
            COUNT ({tableName1.column1},{tableName1.column1})
            I'm involved in creating equivalent reports from an old system using Crystal, into a new system with SQL Server 2005 without Crystal, so i need to understand what exactly this statement does so i can do something which produces equivalent results in SQL Server.
            The fact that it repeats the...
            See more | Go to post
            • RiddleMeThis
              replied to A CASE statement using another CASE statement as it's expression
              in SQL Server
              Thats great, thanks very much to both of you, the info you provided has saved me a lot of time and given me other things to consider and research, much appreciated :)
              See more | Go to post

                Leave a comment:

              • RiddleMeThis
                replied to A CASE statement using another CASE statement as it's expression
                in SQL Server
                Hi, thanks for that ck, it works great :)

                To take it one step further though (my example was very simple and stripped down), is it possible to store the output of the first case statement in a variable, then use that variable in other case statements later in the code? Its just that I have quite long cases, and they get used by other cases several times, so to repeat them inside other cases over and over is going to make the query...
                See more | Go to post

                  Leave a comment:

                • RiddleMeThis
                  started a topic A CASE statement using another CASE statement as it's expression
                  in SQL Server

                  A CASE statement using another CASE statement as it's expression

                  Im trying to use 2 CASE statements together in a SELECT query without much luck.
                  The second CASE uses the output from the first CASE as it’s expression (well it’s supposed to).
                  When the 2nd CASE statement is removed it works, but when it is included i get this error:

                  Code:
                  SELECT accountNum

,balanceCalculation = CASE
	WHEN Balance > 5000 THEN Balance *2
	ELSE Balance /2
END
                  ...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...