Puiu

Hello I am having a strange problem displaying a report in local mode. It's a rdlc report that works fine on the development machine, but when i move the application and try to display the same report it says "Some parameters or credentials have not been supplied" there are 2 parameters that show just fine on the development machine. the database has exactly the same data in it, only the server is different. practically only the connection string changes on the other computer, and the login used to access the database has full privileges. thanks

Hello I have an application that sometimes requires database updates. however some stored procs updates must not be run on all the servers. I've tried something like: if @@servername = 'MyServer' begin alter proc MyProc ..... end But this doesn't work. I also tried using dynamic sql but also didn't work. Thanks

No, I am using the report tool from microsoft.

In my application I use report viewer (not reporting services) to display invoices. Can anyone help with how i could print like 20 invoices at once? The user would give a command that would ask the software to print from invoice 100 to 120. I am guessing that i should use the print document control but how do i pass the data from the report viewer to the print document? Thanks

I don't know for the first question, but for the second this might help: For i As Integer = 0 To datagridview.Columns.Count - 1 datagridview.Columns(i).SortMode = DataGridViewColumnSortMode.NotSortable Next

I have an xml that looks like this: <Root> <row> <F1>04858</F1> </row> </Root> The only way I know to select from this and make it look like a select from table is this: declare @xml xml set @xml = '<Root> <row> <F1>04858</F1> </row> </Root>' DECLARE @docHandle int EXEC sp_xml_preparedocument @docHandle OUTPUT, @xml select * from OPENXML(@docHandle, N'/Root/row') WITH (F1 varchar(10)'F1') My question: Is there a simpler way to do that? Thanks

It seems that the picture was saved as a 8 bit picture and that's why the error appeared. I've modified the picture and saved it as a 24 bit picture and now it works!

Hi On a aspx web page i'm rendering a RDLC report directly in pdf file. The report has a background image. On the local machine everything works fine, the PDF shows correctly (with the background image as well). The image is embedded in the rdlc file. When I upload it on a server and try to render it it says "Insufficient data for an image". The report is displayed but without the background image.... Any ideeas why?

Hi, I have a rdlc report and a table. In my project i have some 3 datasets built by me (a class with public properties). Anyway, when i dragged an item in my table i accidentally dragged one from the wrong dataset and now in the table's datasets list there is always this dataset that i don't need. Does anyone know how to remove it from there (except for recreating the table), because every time i load the report i have to load that dataset also. Thanks

Hi, I've created a windows forms application (VS 2005) and i would like to place it on server so that other computers on my network run it from there. I already copied the software on the server, but when i try to run it from another computer it simply says that the application has stopped working. Thanks

the situation is a little strange: I have a sql server 2005 database on a remote server. The problem is that on that server there is also running a sql server 2000 instance. even if I specify the instance name in the connection dialogbox it never connects to the sql server 2005 instance (i get the error that says it could not find the server\instance). But it always connects to the sql server 2000. However if i connect from a different ISP the connection works. We couldn't find the problem exactly (if it's at my end or at theirs....). At first glance I'd say it's on my side but i don't know exactly where.... that's why i thought that if i could find a way to reach the server through another ISP (proxy) would work...

Hello, Is there a way to configure the SSMSE (SQL Server Management Studio for Express Edition) to connect to a database server using a proxy? I have the SSMSEE installed on my computer and I want to connect to a remote database but I want to use a proxy to do that. thanx

Hello! I'm having a problem with datetime and smalldatetime parameters. I need to insert a date in a smalldatetime field. The problem is that the date comes from the application in different formats depending on how the computer was set. In this particular case I need to insert a date with hour and minute (13/04/2007 17:45) but on some computers the string returned is something like 13/04/2007 05:45 PM (so i get the error that says it could not convert the string to datetime). I need to insert the minutes like 17:45 so that when the user looks back to know that the action took place in the afternoon and not in the morning. I think the general question would be: how to receive a valid parameter datetime or smalldatetime no matter the settings on the users computer? If you have sugestions for resolving this using either .net code or sql (transact-sql) i'm all years (and eyes :) ) Thank you

Let's say I have a stored procedure SP_Master with a code similar to this: create proc sp_master as begin begin tran exec sp1 exec sp2 update table1 set... rollback end My question: the rollback statement will also rollback the changes made by sp1 and sp2? Thanks

Hello, Does anyone know if Visual Basic .NET 2005 offers support for OCR (optical character recognition) ? Has anyone done anything like this using vb net's classes and not third party software? If i remember correctly Office Imaging had OCR and I thought that maybe there would be some support in vb .net for it. Thanks