Answer Questions

• Autofreak Programmatically Render Report to PDF

  Hello, I'm looking for an example on how to programmatically render a report to pdf in C#. I don't want to use a url with the rs:Format=pdf querystring. Any help would be much appreciated!! There shouldn't be any extra bytes in the response stream so you shouldn't worry about that. Make sure that you are actually closing the BinaryWriter. Many of the CLR streams buffer internally, so if they are not clo ...Show All

• Amir5656 Wich datatype?

  Hi Group, Wich datatype can I best use for a number with several decimals (can be anything between 1 and e.g.10) If the number has 10 decimals the customer needs the EXACT numbers. They couldn't explain why.... TIA Regards, Sander use the Decimal or Numeric data type! float and real data types only store approximate data which loses precision when the decimal part of the data cannot be exactly represented usin ...Show All

• Dr.B. Can't get SQL Manager to connect to server instance SQLEXPRESS

  I installed SQL Server Express and SQL Server manager, then tried to start manager. SQL Service is running, but SQL Manager attempt to connect to SQL Server instance times-out even though I correctly identify instance as SQLEXPRESS Everything seems to be normal - both SQL Server and Manager are on a single Windows  XP home machine. Any suggestions. Thanks After reading this thread and another one I've trie ...Show All

• ProgrammingHunter PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services

  When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression) Can anyone give me a hint on this one Thanks, Neno This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=232211 ...Show All

• Juan Azuero sseutil.exe - passing variables

  I have not been able to successfully pass variables from the sseutil.exe command line to a sql script file. For those of you unfamiliar with sseutil.exe, it is a free utility that works with both SQL 2005 and 2000. Download it from here: http://www.microsoft.com/downloads/details.aspx familyid=fa87e828-173f-472e-a85c-27ed01cf6b02&displaylang=en The ReadMe.htm file contains this:   -run <filepath> [<var1>=<val1>[,... ...Show All

• xxpor How to connect SQL Server From Pocket PC Device

  Dear members I want to connect SQL Server database from pocket pc device but it gives an error than "Either the sql database does not exist or access denied My Code is SqlConnection conn=new SqlConnection("Data Source=OurServer;initial catalog=Resident;user id = sa;password = sa); conn.Open(); If anybody knows the problem please send some information Regards Bijaya This blog is a great source for connection troubl ...Show All

• oscarjaime SQL Server does not exist or access denied

  Okay...Running SQL Server 2000 & yesterday I was inside of Query Analyzer keying away with no problems.  Exited out of everying like normal, powered my laptop down & life was good. Or so I thought. I started my laptop today & my SQL Server Services Manager shows that my SQL Server is not running. Long story short, I've torn this thing apart and can't figure out why it's not running.  My Client Network Utility has ...Show All

• jerome1234 Failure sending mail: The transport lost its connection to the server

  More and more often, I am seeing this error message in RS subscriptions. I would assume it means the IIS server can't connect to the corporate exchange server. However I was wondering if there is some timeout setting/configuration in RS or the IIS server (or any other kind of setting) I can change to help alleviate this problem. Has anyone else experienced this Or know how to fix it Thanks, Jeff   UPDATE: After looking closer ...Show All

• mashti Tell to split on change of ID

  how can I tell the conditional component to split the records based on change of hdr_HeaderID http://www.webfound.net/split_on_headerid.jpg let me know if you need more info...   here's what I'm trying to do...this is the best way I can think to do all this via your articles I read...I'm still new to all this remember so this may not be correct but here's what I'm working on as the solution at the moment but failing miserab ...Show All

• RaviKalyanK ClickOnce path names are too long for SQL Server Express identifiers

  I'm posting this in the ClickOnce forums as well... My application doesn't include the .mdf and .ldf files, rather it creates the database the first time the application is run using a script that is included in the build. I want to create the database in the ClickOnce data directory. The problem I'm having is that SQL Server complains when I execute the CREATE DATABASE command as follows: CREATE DATABASE [C:\Documents and Settings\xxx ...Show All

• KellyGDownUnder Media Center

  Help, I'm trying to burn a CD using Windows Media Player 10. I keep getting the message-interface not registered. I tried to download WMP, and it says it cannot because there is already a more recent version already installed. Should I uninstall WMP, and then reinstall it. If so, how do i do that, I cannot find it on the control panel! Thank You for your help Amanda, You might find one of these ne ...Show All

• telHand DTS Wizard SQL 2005 - Enable Identity Insert

  I have a large number of Access tables that I need to periodically bring to SQL using the DTS Wizard in SQL 2000 (via Ent. Man). I am only interested in bring over the data from the MS Access tables as I had a separate script (application drive) that would create the SQL tables. The problem is this: with SQL 2000 when bringing over the tables, the check box for 'Enable Identity Insert' for each of the tables was checked , this worked fine. With ...Show All

• Tony1972 Bug with SET options for table-valued functions.

  Hi, I think I've come across a bug in SQL Server 2000 (SP3): If I create a table-valued function with the QUOTED_IDENTIFIER and ANSI_NULLS options both set to ON e.g. SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE FUNCTION dbo.tfn_Test() RETURNS TABLE AS RETURN (SELECT 1 AS test) GO Then when Scripting this function out again (or using external tools to analyse it - SQL Compare f ...Show All

• Archimedez How to integrate reporting services with ASP.Net

  Hi My current situation is how to integrate my application written in asp.net to link to my report server's report  as by default anonymous user can access my report server's report without any authentication. how to configure to make the report server by using form authentication before access the reports  My Application Configuration Web application (Vb.Net) - http://192.168.1.18/mobiFO   Reporting services - ht ...Show All

• crystalreports SQL Server express starting as NETWORK SERVICE!!

  Hello All, I am installing SQL Server Express from the command line using the following parameters INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SAPWD=TEST After the install is done I start the service form the command prompt using start mssqlserver I see that the SQL Server service has started under NETWORK SERVICE account!!! when the documentation i Read on MSDN says it starts in Local System a ...Show All