Recent content by Bufsabres

SQLBill: Still running against the as400.

The database resides on an iSeries Server (AS/400), we are in the process of deploying a new SQL server. I would like to pull the data into the SQL server nightly and create reports from there. But currently I am altering existing reports and I am having trouble with what seems like a join...

I am new to statement writing, and I am altering someone else's reports created in MS Visual Studio.NET 2003 in the Microsoft Developement Enviroment and deploying the reports through Reporting Services.

Thanks for responding, I tried the code and here is the message...Could not generate a list of fields for the query. Check the query syntax or click Refresh Fields on the query toolbar. ERROR [42S22][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0205-Column COMPANY not in table TMP in *N.

I am trying to correct a statement where two tables do not have any unique information ... BIQUERY.TBLNEWOEE OEE and BIQUERY.TBLDTIME DT. I am trying to use a second subquery to alleviate the problem but I am not able to do so. What is the best way to segreate the BIQUERY.TBLDTIME DT in a...

Great! Thanks.

I am trying to create two new rows in a report with information gathered from one. Production Quantity-"ProdQty" and Scrap Quantity-"ScrpQty" from one column "production". In the Where clause I specify criteria from another column "WH" as follows 'PQ' OR 'PW' OR 'SP' OR 'S1'...'S7'. How can I...

I am trying to fill in two rows in a report with information gathered from one. Production Quantity and Scrap Quantity from one column "production". In the Where clause I specify criteria from another column "WH" as follows 'PQ' OR 'PW' OR 'SP' OR 'S1'...'S7'. How can I make only the 'PQ' AND...

Internet Explorer, it was created in Microsoft Word 2000

There are two links on the webpage. One shows the hand and the other does not. I would like to know how to change the link that does not show the hand, so ppl know there is a link there. I does this in Internet Explorer 5.5 and 6.0.

Internet Explorer either 5.5 or 6.0 edited with Microsoft Word 2000

I would like to know how to change the properties of a hyperlink. Currently the hyperlink does not show the hand to indicate there is a hyperlink under the cursor. How do I change the hyperlink to show the hand?

Do you mean add a trusted site to my Internet Explorer's security tab? And which site is that?

I am running Windows XP Pro and Office 2003, have applied the service pack, re-processed the cubes and nothing, same error "Unable to browse the cube".

I have taken out the record source from the form and it works just fine. Thank you for your help.