Search results for query: *

I have a table with 2 columns called Department and Order Num, Order Department 1 Dept01 1 Dept02 1 Dept03 1 Dept04 1 Dept05 I need to have a new table with prev dept in the thrord column like Order Department Prev.Dept 1 Dept01 START 1 Dept02...

Hi I have a Table that defines progression of document. Here is the table1; Name Dep1 Dep2 Dep3 Dep4 Route1 Acct Admin Sales Invoice Route2 Acctg HR Sales Invoice etc. Then I have another table2 Route CurrDept other columns Route1 Accounting etc What I need...

Hi, I have a report where I put a picture object in details section and its Graphic Location.property changed at run time. Report looks fine when previewed on the screen, however when printed only random picture shows up. All picture files in WMF format created in AutoCAD. Any Ideas ?

Hi, I have a report with some sub-reports in it. I am trying to controll page alignment in the sub depending on the result sent in the main report. Is there a way tyo control portraitvs landscape page orientation ? Thanks

I have the following xml file, I am trying to get a LINQ to have Filename and Manifest # in one collection. I have made 2 queries that work fine (see bewlow), but how do I make one query for this messed up XML. Thanks for any help Dim file As XElement =...

I have two perfectly working views and I need to join them but dont know how. Here is statement #1 SELECT CAST(foy.SOChangeLog.SONum AS varchar(12)) + '-' + (CASE WHEN SUBSTRING(TheChange, 8, 1) = ':' THEN CAST(SUBSTRING(TheChange, 6, 2) AS varchar(12)) ELSE...

Hi, How can I show only nth page of a muly page document. So far if I just inser a PDF file it shows only 1st page. Any heplp would be appreciated. Thanks

Hi, I'd like to know if some knows how to have a variable name of a variable. For example I have an array that collects somethig about a customer but I dont know exactly which customer yet, thus I would like to define this artray after customer number. so I am looking for something like this...

Hi, I've made myself a little function that helps me barcode things. The only problem is that the result of the function need to appear in IDAutomationHC39M font. Is there a way to code the font into this function. Thanks Function (stringVar ToBarcode) "*"&ToBarCode&"*"

Hi, I am trying to figure out how to set a TaxAutority(PST) that would depending upon location to which receipt is posted would figure out whether or not PST(TaxAutoruty1) should apply. For example if I receive part AB101 to location 1 (production) no PST should apply, however if I receive part...

Has anyone been sucessfull at devising a report where the detail section would be the address list of a customer and the footer would be a google map displaying those customers ? Is this even possible though google maps API ? Thanks

Hellow gurus, I have a question about a join that I use in one of my reports. Please suggest alternative solution if possible. Here is what I have Table 1 (left table) is an inventory master file and table 2 is the GL master file. All I need to do is link those tables in such a way that when I...