Search results for query: *

Hi, Has anyone had any luck with getting DBase III files/directories to work correctly in SQL 2005? The connection and queries run fine in VS/BIDS, but when I deploy them to the server I get the following: The Microsoft Jet database engine could not find the object '<TABLENAME>'. Make sure the...

Hi all, Running SSRS 2005 on a Windows 2003 server. We are having a problem getting a report to run in SSRS when it seems to run fine locally (in VS 2005). It is using a DBase III database to connect to, but my thinking is that the SSRS account does not have access to that folder. Does anyone...

Hi all, I'm using Excel XP with SQL Server 2000. I have a DTS that creates an Excel file via data from the SQL Server. In the past we have used the "Close Connection" checkbox at the end of the step, but this will also close the SQL connection and drop the temp table(s) we need to complete the...

Hi, I am using SRS 2005 and would like to hide the last line if it is the last record of the dataset. Any suggestions? Thanks! Brett -------------------------- My new website coming soon!

Hi all, I am a CR programmer and just started writing SQL Reports recently. I have written a report with 1 parameter in VS 2005 that works great in VS (preview) and the report server. Here is my problem. I want to be able to run it in a VS 2008 VB.net Windows application. When I copy the report...

Hi all, I am using SQL 2005. I have a stored procedure that does 13 separate selects into a temp table and then does an full outer join to merge them together. It seems like the server is not waiting for one select/insert to end before it starts the next one as I get data for January, March...

Hi all, I have a database called "Membership" on our SQL Server. I want to import/export everything (tables, data, stored procedures, functions, etc.) from the Production server ("sqlserver") to the Development server ("sqlserver\dev"). The biggest problem I am having with DTS is that a lot of...

Hi all, I am using SQL Server 2005 and have the following T-SQL query: SELECT DISTINCT tiMNMmbrno, ttMNMnincr, tvMNMntype, tvMNMrelat, tvMMBclass, tsMMBmyear, tvMMBmpref, tcMNMfirst, tcMNMmidle, tcMNMlastn, tvMNMgnrtn, tcMADline1, tcMADline2, tcMADline3, tcMADcityn, tvMADstate, tcMADzipc5...

Hi all, I have made a Crystal Report using VS 2005 in ASP.net, CR.net (v10.2?), and VB.net. My report has about 10-15 subreports and I would like to dynamically assign each of them to a different table (with VB code). Any ideas? Currently the report works fine and even exports to pdf with the...

Hi all, How do I separate results from a stored procedure in CR.net 2005? The following dataset is being returned from a SP and I want to put each returned value into it's own formula field for display. Dividends (SP Field Name): 12 Months 18 Months 24 Months 30 Months 36 Months 42 Months 48...

Hi all, Anyone know where I can find good sample code for: A) Showing a Crystal Report in asp.net via vb.net B) Passing a parameter to said Crystal Report (programatically) C) Exporting said Crystal Report to pdf programatically. All of the examples I have or have seen do not seem to work...

...create a subreport like Crystal in Reporting Services 2000 using VS 2003. Anybody? Thanks! Brett

Hi all, I am trying to send a text file of IPL commands to an Intermec printer. What I want to do is push it through to it's IP address (192.xxx.xxx.xxx) instead of having it directly connected to a Seiral/COM port. Has anyone ever done this? I guess any way to send raw binary data to a printer...

Hi all, I am running VS.net 2003 with asp and vb on Windows XP. I have a text box that does an auto post back if the text is changed. I also have a submit button. Currently, the user can do this 3 ways: 1) If the user inputs a part # and clicks the submit button (without tabbing off of it)...

Does asp.net give you any way to do the following? <select> <option style="background-color:green; color:white">Pass</option> <option style="background-color:red; color:white">Fail</option> </select> I am using asp.net 2003 w/ vb.net 2003. Thanks in advance for the help! Brett

Anyone know what the javascript is (or example) that I could use to change the background color of a combobox based on the value selected? i.e. "Fail" = red "Pass" = green I am using asp.net and vb.net 2003 for the combobox. Thanks! Brett

What event is triggered when a user clicks next/prev/exit of a bound record on a form in Access 2003? Thanks for the help! Brett

Hi, In Access 2003, while on a record, I update one field of the record. The problem is, when I try to move to the the next (or previous) record, I get a "Write Conflict" confirmation box. Is there any way to get rid of this? I do want to save it, but without the confirmation box. Access thinks...

Hi all, If I have a form set to "not shown in taskbar" and the user clicks off of it to lose focus, is there a way to keep the focus? Also, when I re-show the original form, how do I force the form to "get" focus? This is probably an easy and obvious solution, but I'm frustrated. Thanks...

Is there a way to allow a user to specify a date range and then populate a dataset/datagrid with that information in VB.net 2005? I am currently using a combobox that populates the datagrid based on what the user has selectedx in said combobox and it is working fine. Can a dataset use two "?"s...