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...
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...
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.
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?
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".
Yes it is. I have two buttons one the form, one to enter a date range and the other to run a macro which has 6 queries and a report. The record source is the last query before the report. What should the record source for the form be?
The error is The database engine could not lock table 'ProdSum4' because it is already in use by another person or process. I get an action failed on my last query before my report when I use my command button to run my macro. However when I just run the macro, it works fine. Why do I get this...
The error is The database engine could not lock table 'ProdSum4' because it is already in use by another person or process. I get an action failed on my last query before my report when I use my command button to run my macro. However when I just run the macro, it works fine. Why do I get this...
Steve:
That works just fine. I guess I was not through filtering my data. One has to remember to query just the information needed for the report.
Thanks
I am creating a one page weekly Production Summary Report with job# down the left and the days of the week broken down by three shifts across the top. I am quering the information into text boxes using the "IIf" function. I would like to have only one line per job on my report but end...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.