Search results for query: *

I have two reports that I'd like to merge into one two page report. The problem is that I want the 1st page to print in portait and the 2nd page to print landscape. I'm using .NET's crystal designer. Is there a way to accomplish this?

FYI, if VB.NET the sub's name doesn't matter when creating.

Private Sub txtPrice_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtPhone.TextChanged 'do something end Sub

Use this: Syntax was wrong in the post above for create table create table #tempMaxDate (MaxDate datetime) SET @query_max = "select max(date) from " + @link_server +".database1.dbo.table1" INSERT INTO #tempMaxDate exec(@query_max) SELECT @maxfound = MaxDate FROM...

select (cyb_first_name + ',' + cyb_last_name) as fullname should work

What are you trying to do? You have @m as Max(date) that's not declared and you have MaxDate without '@' in front of it. Kinda confusing. Or maybe I'm on crack lol Take a look at this...

That works for some odd reason. Thanks for the work around. It'll buy me some time at least :)

I'm trying to run an application using xp_cmdshell that takes an input parameter.. looks like this: "myapp.exe 32" where 32 is the id of some record in a table. meaning that i only want the program to process one record. when i run myapp.exe without the parameter it runs through...

I originally tried doing this using xp_cmdshell but, it kept hanging so I tried this (which i found via search) and it worked: CREATE PROCEDURE dbo.sp_cmdshell(@cmd varchar(255), @Wait int = 0) AS --Create WScript.Shell object DECLARE @result int, @OLEResult int, @RunResult int DECLARE...

i tried that and it just hangs. i've been researching how to accomplish this using WMI but, I can't find any .NET references and have not gotten a response from my post in the VB.NET forum yet. Thanks for all the help :)

I need to run application on a remote machine. I have this code in VB 6 but, can't seem to get it working in VB.NET (windows 2000 network). Dim strComputer As String Dim objWMIService As Object Dim errReturn As Long Dim intProcessID As Long strComputer = "dev2&quot...

Thanks.

I thought about that first but, the procedure just hangs. I've screwing with VB .NET and WMI but, can't seem to get it working that way either. I'm having trouble finding anything on WMI and VB .NET for this.

I'm in need of a way to kick off application (A) from a desktop application (B) and have application (A) run ON the server it resides and not the machine application (B) is running on. Both Apps are VB .NET applications running on windows 2000 servers. Application (A) requires no user...

I have a subreport where I need to select the top three records from a table "select top 3 * from tblMyReport". Is there an easy way to do this? It currently show all the records. I'm a crystal beginner and am under the gun. Any help would be greatly appreciated.

I think you only want to group by coItem.item since you're only getting back sums for one ship date ("where co_ship.ship_date = @shippingdate"). Everything looks ok though. your result will be the sum of the qty_shipped for a specified date and country.

I'm not sure what you're asking but, maybe this example will help? If not, please try expand your inquiry. select sum(qty_ship) from table where ship_date (between '01/01/02' and '12/31/02') and item = 'cp-10000'

Try the Sum Function: Select Sum(qty) from Table where Item = 'cp-10000' I think that's what you're looking for.

This may help you: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q241/2/49.asp&NoWebContent=1

Would it better to do something like this if your query returns multiple fields or would this cause too much overhead? SET @sql = 'SELECT id, name, address FROM ' + @table + ' WHERE name LIKE ''%' + @name_passed + '%''' Create table #tmp (id int, name varchar(50), address varchar(50))...