VarChar to Numeric in SSRS
I am trying to convert from a varchar to numeric format using the “Expression” in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to “Sum” the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The Value expression for the textrun ‘wo_udf81.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function [...]

Answer Question   |  May 14, 2013  3:25 PM
SSRS 2008, SSRS reports

Convert from text to number – exporting to Excel 2003 from SQL Reporting Services 2008 R2
Hi I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying “The number in this cell is formatted as text or preceded by an apostrophe”. I have to sum my report values and this can only [...]

Answer Question   |  March 29, 2013  9:37 AM
Microsoft Excel 2003, SSRS 2008

Stored procedures
What is meant by stored procedures? What is purpose of them and where can we use this stored procedure? Can any one provide the information regarding this? Thanks in advance.

Answer Question   |  February 12, 2013  6:33 AM
SQL statement, Stored Procedures

Run Oracle Procedure in SSRS dataset
Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.

Answer Question   |  January 28, 2013  7:43 PM
Oracle, SSRS, Stored Procedure

SQL or T-SQL
This question related to this thread: http://itknowledgeexchange.techtarget.com/itanswers/difference-between-sql-and-t-sqlmicrosoft-sql-server-2000/ So if I want to study SQL server, should I first study SQL and then T-SQL or just dive right in to T-SQL.

Answer Question   |  November 8, 2012  10:13 PM
SQL Server, T-SQL

SQL server
i want to copy  the store peocedure from one database to another . iam using sql2005

Answer Question   |  June 14, 2012  11:11 AM
Stored Procedures

New Data Field in Stored Procedure
When I add a new data field in a Stored Procedure, how do I make the new field available to the Crystal Report?

Answer Question   |  May 3, 2012  3:09 PM
Stored Procedure variables

How do I subtract 3 days from current date only when current day = 2, so that I retrieve the previous Fridays date?
I am new to using T-SQL, so there is probably an easy way to accomplish this, but I can’t seem to get it right.  I want to retrieve the previous day’s date (requires a weekday) to use as a comparsioin to a date field in the table, format is YYYYMMDD.  When the current date is [...]

Answer Question   |  April 10, 2012  7:59 PM
T-SQL, T-SQL 2008 R2

Accessing Report Permission Using An Stored procedure in SSRS
I have created an Report and I want to give Access  to only few to View Report. Is there a way to use a  Procedure to grant access to Users. 

Answer Question   |  February 27, 2012  6:55 AM
SQL Server, SSRS

Filtering a select based on the value of one column and the max value of another column
I’ve created a temp table and need to further select some data from it. Seems simple. The temp table contains thousands of orders, an action code (C or D)and a seq_ID for each order. Each order has multiple instances of the C and D action codes, but I only want a list of those where [...]

Answer Question   |  February 28, 2012  6:07 PM
SELECT, Temp Tables

Automate SSRS report
I have a monthly task where I have to run an SSRS report for each contractid we service and export each one to excel.  The problem is that there are over 800 contracts and the tool only allows me to enter 1 at a time.  I would like to somehow enter maybe 50 contractid’s and [...]

Answer Question   |  December 8, 2011  4:17 PM
SSRS reports, Visual Studio

SSRS 2008 R2 Trendlines
I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet http://technet.microsoft.com/en-us/library/dd207034.aspx refers to a ‘Values’ area and an option to ‘Add Calculated Series’. The ‘Values’ area I see does nothing on a “Right-click” and the option to “Add Calculated Series” I cannot find anywhere.

Answer Question   |  October 25, 2011  8:19 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008

How to configure parameters display in SSRS 2008?
Hi, I know it wasn’t possible in ssrs 2005 to have parameters displayed into more than 2 columns. My question is has it be solved in ssrs 2008r2 ? If yes, how can I do it ? If no, is there a possibility to walk around this issue ? Many thanks, Sonia

Answer Question   |  March 31, 2012  11:29 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008

SSRS authentication in workgroup environment
Can a workgroup be configured to authenticate to reporting services to run reports? If so, could someone please assist me in this security setup as we are currently experiencing difficulty. Our Windows 7 “server” authenticates fine but none of the current client computers are able. Thank you.

Answer Question   |  March 31, 2012  2:51 PM
Reporting Services, Reporting Services Configuration Manager, SSRS, Windows 7, Workgroup Servers, Workgroups

t-sql and AS400
I want to develop a TSQL query. First I need to determine if all the numbers in one of the fields are in numerical order and also find the missing holes in the number sequence. Secondly I need to sort by another field and by a particular criteria.  The words that I need to sort-by [...]

Answer Question   |  March 31, 2012  12:34 PM
AS/400 Query, SQL, SQL Query, T-SQL

SQL Server Help
Hi all, I am running into a little bit of a problem. I need to insert records with a stored procedure into a table based on the information selected. From the info selected, it decides what table to insert it into.  Example: Select top 1 SerialNo from dbo.Serial –returns ‘ASEEADL1234567′ based on the 8th letter [...]

Answer Question   |  March 31, 2012  8:36 PM
INSERT SELECT statement, SQL Records, SQL Server, SQL Server administration, Stored Procedures

Ageing Report T-SQL
Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for each period The Billing table is pre-populated with the charges per month as per the amortization schedule when a client [...]

Answer Question   |  March 31, 2012  1:29 PM
MSSQL, SAP Aging Reports, SQL 2005, T-SQL

SQL query working differently in sql plus and SSSR
I wrote down a sql query for creating a SSRS report. The query is fetching different no of rows and data in SQLPlus and SSRS. I am worried how same query can fetch different results in different environments. Please help me.

Answer Question   |  March 31, 2012  8:34 AM
SQL Query, SQL Server, SQL Server Query, SSRS reports

Backup started running 2x longer
Hello, We have a 3573 L2U drive which we are using as a standalone tape drive.  Our backup jobs started running nearly twice longer than our normal run time last week.  IBM SSR replaced the drive, cable and terminator.  However, still after replacing, backup still ran long.  Do you have any idea what is causind [...]

Answer Question   |  March 31, 2012  5:32 PM
Backup, IBM, IBM Ultrium 3580, OS/400, SSRS

Stored Procedure and crystal reports resources
Can anyone please tell me where to buy store procedure and crystal reports book in one.  Thanks.

Answer Question   |  March 31, 2012  5:41 PM
Crystal Reports, Crystal Reports Stored Procedures, IT Books, Stored Procedures