Could be that when you view the report the access statement is throwing away (not using) the bad dict item but sending your output to Report Viewer or PC cannot do so. Note, when using an invalid dict item and sending the output to Report View I also get the same error message that outputting to excel gave me.
* What release of wIntegrate do you have? I'm using 4.2.1. I also have earlier releases of wIntegrate but the 4.2.1 utility programs are probably loaded on my system - I'm sure they are. Check the help-about to see what release you have. I would suggest Viewing it, examine the data to see what column you are missing from the Output dict items you have in the Query Builder to find the bad dict item. If that doesn't work, I guess I'm back to the eliminating dict items one at a time until you get the report to output to Excel. Try outputting to Excel97, later releases won't work as my old friend Kathleen Bodine mentioned (Hi Kathleen). Have a Great Day! > Paul Trebbien > Kore Technologies, Senior Support Tech. > "Solutions that work. People who care." > V 858.678.0030 F 858.300.2600 W www.koretech.com > -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen Sent: Friday, February 18, 2005 10:33 AM To: [email protected] Subject: RE: [U2] wIntegrate query builder question I ran it to the screen with out any issue. I ran it to report viewer and got a timed out error. So I don't think is has to do with the dictionary items. Any other possibilities??? Kevin At 09:37 AM 2/18/2005 -0800, you wrote: >Hi Kevin, > I believe you are running into invalid dict items or dict items that >don't work in your query. It appears you were able to run the report to the >screen without a problem, is that true? In Query Builder, try changing the >output destination to "Screen" and see if it works. > I wondering if you added a dict items to the 'Items', 'Sort', and/or >'Output' fields on your Query Builder screen that may not be valid. > > What happens to me: >* For output to PC (excel), if I have a bad/non-existent dict item I get >that "QueryImport to PC failed Invalid Fields" message >* If I change the Query to go to the screen then I get a different message >for a non-existent dict item: "At #1 [SORT PARTS ABC XYZ] - Keyword 'XYZ' >not recognized" > > You can do the 'old' trial and error testing of your Query and >eliminate 1 dict item at a time until you get it working... > >Have a Great Day! > > > Paul Trebbien > > Kore Technologies, Senior Support Tech. > > "Solutions that work. People who care." > > V 858.678.0030 F 858.300.2600 W www.koretech.com > > > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen >Sent: Friday, February 18, 2005 6:11 AM >To: [email protected] >Subject: [U2] wintegrate query builder question > > >I'm an end user and I've developed some queries using Query builder. I been >able to get the queries to the screen but I now I want them to be placed >into an Excel spread sheet. When I select my output to go to the pc/process >and select the program to be excel and I fire my query. I get a error >window "QueryImport to PC failed Invalid Fields". Any clues to why this is >happening? Can anyone give me places an end user can check. I'd like to >speak with some confidence before I bring it up with my overly strapped IT >department. Any help would be appreciated. > >Kevin >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
