RE: [U2] [UD] Crystal Reports and UniData
David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
There is, unfortunately, a question of market power here. If Access and SQL-Server talk to each other, even if they use a *broken* version of SQL to do so, the market place will expect other databases and clients to talk the same - BROKEN - dialect of SQL. It's all very well a vendor (like IBM, for example) saying we comply with the standard, but if the official and the de-facto standards don't agree, then the smaller vendors (and here I include U2) are likely to get trampled. Like it or not, IBM should treat any problems with a market-influential tool like CR as high priority, even if it is CR that's at fault. In an ideal world, if IBM said CR is broken, and here's how, it would result in CR getting fixed. In the world we live in, CR can probably get away with saying tough, on yer bike, mate. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: 19 September 2008 14:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
No, but they do conform to an SQL standard... Just like Oracle, mySQL, etc. IF IBM is going to publish an ODBC driver, it should be SQL compliant. (At least behave the same as any other ODBC driver would minus the VSG crap) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: Friday, September 19, 2008 9:50 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Crystal Reports and UniData
Aye, matey, and since it is th' 13th annual International Talk Like a Pirate Day, http://www.talklikeapirate.com/we can say Shiver me timbers, and I'll stick wit' a LIST statem'nt! http://www.talklikeapirate.com/ On Fri, Sep 19, 2008 at 7:13 AM, Anthony Youngman [EMAIL PROTECTED]wrote: There is, unfortunately, a question of market power here. . In the world we live in, CR can probably get away with saying tough, on yer bike, mate. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
Hu, IBM doesn't have market power? Maybe someone should tell them. On the Fortune 500 IBM is 15 and Microsoft is 44. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Friday, September 19, 2008 9:14 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData There is, unfortunately, a question of market power here. If Access and SQL-Server talk to each other, even if they use a *broken* version of SQL to do so, the market place will expect other databases and clients to talk the same - BROKEN - dialect of SQL. It's all very well a vendor (like IBM, for example) saying we comply with the standard, but if the official and the de-facto standards don't agree, then the smaller vendors (and here I include U2) are likely to get trampled. Like it or not, IBM should treat any problems with a market-influential tool like CR as high priority, even if it is CR that's at fault. In an ideal world, if IBM said CR is broken, and here's how, it would result in CR getting fixed. In the world we live in, CR can probably get away with saying tough, on yer bike, mate. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: 19 September 2008 14:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
LOL! I think he was speaking of the U2 Market Power vs Crystal Reports Market Power... If I pop my head into a random IT shop in the country and threw out both product names -- which one do you think they would immediately guess is a musical group as opposed to a software product?? g That's why I hope that the U2 group as the IBM U2 Group can either address the issue internally with a fix to OLE-DB provider, or push some of the IBM weight behind U2 and get Crystal Reports to make a change. Either works for me!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: Friday, September 19, 2008 4:16 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData Hu, IBM doesn't have market power? Maybe someone should tell them. On the Fortune 500 IBM is 15 and Microsoft is 44. Jerry Banker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
From: Jerry Banker Hu, IBM doesn't have market power? Maybe someone should tell them. On the Fortune 500 IBM is 15 and Microsoft is 44. (Dead topic for this group?) Despite claims and efforts, U2 is not IBM, where DB2 is. IBM's honorable influence doesn't drive all vendors for every bit of software related to the company. If the U2 SQL server process doesn't process queries like a relational DBMS then who fixes the issue becomes a matter of sheer numbers and ROI, not a matter of we don't comply with IBM therefore we need to make a change. How many U2 sites purchase Crystal Reports and interface them to their U2 platforms? Unfortunately I'm sure there are very few. So CR as a company has no incentive to modify their well-established product to suit an obscure minority. If someone told CR that U2 users have other venues (for fee or low cost) to use their products, I'm sure they would find their cost of a code change is even more unjustified. IBM is only somewhat motivated to investigate the issue and make changes. Customer satisfaction would probably be the biggest drive here - not any mass of U2 users all seeking to use CR. If this were purely a CR issue it would probably be way low on the priority list. But it is in their interest to at least identify what it is in the CR queries that they can't process, and fixing that problem for CR should fix it for other client apps as well. T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Crystal Reports and UniData
I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. We have an engineering case open on this issue and we're working to get it fixed. This case has been open for less than two weeks, though, so we'll need a bit more time to deliver a solution. David, please contact me if you have any questions. I'll try to follow up with you when I can. Best regards, Dave David Peters U2 Servers Product Manager IBM Information Management Phone: 1-303-773-7783 Internal: 656-7783 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2 Mark your calendar! DAVID WOLVERTON [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/17/2008 05:09 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject Re: [U2] [UD] Crystal Reports and UniData I agree with you 100% Tony from the independence makes things 'better' for people who are platform agnostic -- we're talking a 100% UniData solution in all cases, and the issue we're seeing more and more is that prospects want to see that the 'core engine' supports the ability to use BI tools they know and love. The do not want to learn to love what we use now - they want to use CR for their ad hoc BI queries. It's an RFP-deal-breaker more and more in being able to check 'works with Crystal Reports' ... Even if IBM owns Cognos, Crystal Reports is *the* defacto standard in Business Intelligence/ Reporting (sorry IBM). A standard of if OLE-DB (or ODBC) 'works' in my mind is if CR works with it -- it's like the IE browser -- you can carp all day that it's not compliant with the stanrdard -- but honestly -- it SETS the standards. CR is the same way in the BI world So you can't really say that OLE-DB 'works' if a major consumer of the provider won't... That said, before I actually told the client Im working with that they need to start pushing on IBM for a resolution (that is, a resolution beyond 'Huh! Yeah - I had heard that it didn't work.' g) I wanted to ensure it was not something that we had 'missed' in our setup and testing. No one has sung out that a current version of CR is in use using a direct OLE-DB provider connection, which was the main answer we needed to hear. Hey, we make mistakes (hourly if you watch close enough!) so we wanted to ensure that our Crystal testing was an accurate representation of the current state of the UniData art... I do want to say that OLE-DB is working like a CHAMP with DBxtra.Net -- a BI tool we found to see if it was a 'generic' OLE-DB error, or specific to CR. And it's specific to CR. Even so - CR is the 'gold standard' - so we're stuck with it! And, yes - while these kinds of things can be done in any number of ways - we're looking for the 'fewest moving parts for a UniData specific implenetation' and to be able to say that IBM's UniData has an OLE-DB provider that is CR-Ready-- I suspect the 3rd party products would increase performance and give other benefits, but that's a whole 'nuther topic... Thanks again! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
I looked at that SQL and thought what's wrong with double quotes? (but then I don't know SQL that well). I thought quoting field names was mandatory if they contained spaces and optional otherwise. Or should it be single quotes and double is the problem? I'm still having problems with the doubled table name from MS Access ... does anybody know why Access will happily retrieve an ASSOCiation from UniVerse via a linked table, but as soon as you try and sort it, it doubles up the table name and causes UV to throw a wobbly? SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC Is what it does and UV quite reasonably complains about the double TABLE_ASSOC :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 16 September 2008 23:49 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, the best approach may be more indirect. This is another reason why I keep trying to discourage the more direct interfaces between MV-specific SQL tools. Rather than trying to bind CR or any reporting tools to U2, create a Data Access Layer (DAL) that you're comfortable with using any tools you prefer. You can then use this with any future project and enhance it as you find the need. Then create classes for a Business Logic Layer (BLL) that represent the server-side data. These might include CUSTOMER, ORDER_HDR, INVENTORY, etc. Again, you will be able to use these for any future projects. Then you can create a final class, decorated with the .NET DataObjects attribute, that can be used as an ObjectDataSource with any tools that bind with such DataSources - including Crystal Reports. You will probably have a few of these for your various application needs. Not only is your effort on these classes portable to other projects, but you're abstracting matters of the UI (Crystal Reports and their API in this case) from any changes you make to accommodate DAL or DBMS changes. For example, you can now use your CR interface with jBASE, Cachi, SQL Server, or any other database - all you need to do is replace the DAL - and you can use the same DAL and BLL to provide data to MS Office, web services, or any number of other front-end application/interfaces. This also insulates you from support people at either IBM or CR blaming their faceless counterparts for some malfunction. Speaking of which, I'm surprised IBM says CR itself is so broken but I suspect that's motivated in part by their purchase of Cognos. As always, if you'd like assistance, you know where I am. :) HTH Tony Gravagno Nebula Research and Development Technical Editor, LINQ Programming: http://tinyurl.com/5lqroa [link goes to Amazon for book info] ... and other .NET books and publications TG@ remove.pleaseNebula-RnD.com Nebula RD provides .NET-related development and training services From: David Wolverton We want to use UniData 7.1.20 OLE-DB and Crystal Reports 2008 ... and IBM support tells me that CR has 'not worked right since Version 9' (which in itself is amazing, and unbelievable!) So I'm asking the masses -- are you using CR 2008 against UniData 7.1.x? And if so, are there tricks you can share? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
If IBM knows CR has not worked right since Version 9 you would think IBM would have adapted their interface to strip quotes... Obviously CR running in other OLE-DB environments IS compliant. :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Tuesday, September 16, 2008 12:50 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Crystal Reports and UniData We want to use UniData 7.1.20 OLE-DB and Crystal Reports 2008 -- but are having no joy at the moment. The issue is the SQL that gets generated is quoted incorrectly. Example SQL I'm getting from Crystal Reports 2008: Select File_Name.Dict_Name,File_Name.Dict_Name From File_Name I don't see a tunable in Crystal Reports to tell it how to converse with U2 [aka - kill the quotes!], and IBM support tells me that CR has 'not worked right since Version 9' (which in itself is amazing, and unbelievable!) So I'm asking the masses -- are you using CR 2008 against UniData 7.1.x? And if so, are there tricks you can share? I have OLE-DB running smoothing under DBXtra - a nice .NET reporting tool - but I want to show/have Crystal Reports in my supported tool list since it's the defacto tool for the trade in this area. Thanks! David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.21/1672 - Release Date: 9/15/2008 9:21 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC could just as well read SELECT FIELDS FROM TABLE_ASSOC MY_SELECTED_TABLE It does conform to SQL... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 4:14 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData I looked at that SQL and thought what's wrong with double quotes? (but then I don't know SQL that well). I thought quoting field names was mandatory if they contained spaces and optional otherwise. Or should it be single quotes and double is the problem? I'm still having problems with the doubled table name from MS Access ... does anybody know why Access will happily retrieve an ASSOCiation from UniVerse via a linked table, but as soon as you try and sort it, it doubles up the table name and causes UV to throw a wobbly? SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC Is what it does and UV quite reasonably complains about the double TABLE_ASSOC :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 16 September 2008 23:49 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, the best approach may be more indirect. This is another reason why I keep trying to discourage the more direct interfaces between MV-specific SQL tools. Rather than trying to bind CR or any reporting tools to U2, create a Data Access Layer (DAL) that you're comfortable with using any tools you prefer. You can then use this with any future project and enhance it as you find the need. Then create classes for a Business Logic Layer (BLL) that represent the server-side data. These might include CUSTOMER, ORDER_HDR, INVENTORY, etc. Again, you will be able to use these for any future projects. Then you can create a final class, decorated with the .NET DataObjects attribute, that can be used as an ObjectDataSource with any tools that bind with such DataSources - including Crystal Reports. You will probably have a few of these for your various application needs. Not only is your effort on these classes portable to other projects, but you're abstracting matters of the UI (Crystal Reports and their API in this case) from any changes you make to accommodate DAL or DBMS changes. For example, you can now use your CR interface with jBASE, Cachi, SQL Server, or any other database - all you need to do is replace the DAL - and you can use the same DAL and BLL to provide data to MS Office, web services, or any number of other front-end application/interfaces. This also insulates you from support people at either IBM or CR blaming their faceless counterparts for some malfunction. Speaking of which, I'm surprised IBM says CR itself is so broken but I suspect that's motivated in part by their purchase of Cognos. As always, if you'd like assistance, you know where I am. :) HTH Tony Gravagno Nebula Research and Development Technical Editor, LINQ Programming: http://tinyurl.com/5lqroa [link goes to Amazon for book info] ... and other .NET books and publications TG@ remove.pleaseNebula-RnD.com Nebula RD provides .NET-related development and training services From: David Wolverton We want to use UniData 7.1.20 OLE-DB and Crystal Reports 2008 ... and IBM support tells me that CR has 'not worked right since Version 9' (which in itself is amazing, and unbelievable!) So I'm asking the masses -- are you using CR 2008 against UniData 7.1.x? And if so, are there tricks you can share? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.21/1675 - Release Date: 9/16/2008 7:06 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
But won't it then disappear up its own backside with ambiguous field names? Iiuc, listing multiple file names does a cross-product, and as a result if you repeat the same file name, EVERY field will be ambiguous and the SQL will be unable to resolve. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 14:57 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC could just as well read SELECT FIELDS FROM TABLE_ASSOC MY_SELECTED_TABLE It does conform to SQL... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 4:14 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData I looked at that SQL and thought what's wrong with double quotes? (but then I don't know SQL that well). I thought quoting field names was mandatory if they contained spaces and optional otherwise. Or should it be single quotes and double is the problem? I'm still having problems with the doubled table name from MS Access ... does anybody know why Access will happily retrieve an ASSOCiation from UniVerse via a linked table, but as soon as you try and sort it, it doubles up the table name and causes UV to throw a wobbly? SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC Is what it does and UV quite reasonably complains about the double TABLE_ASSOC :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 16 September 2008 23:49 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, the best approach may be more indirect. This is another reason why I keep trying to discourage the more direct interfaces between MV-specific SQL tools. Rather than trying to bind CR or any reporting tools to U2, create a Data Access Layer (DAL) that you're comfortable with using any tools you prefer. You can then use this with any future project and enhance it as you find the need. Then create classes for a Business Logic Layer (BLL) that represent the server-side data. These might include CUSTOMER, ORDER_HDR, INVENTORY, etc. Again, you will be able to use these for any future projects. Then you can create a final class, decorated with the .NET DataObjects attribute, that can be used as an ObjectDataSource with any tools that bind with such DataSources - including Crystal Reports. You will probably have a few of these for your various application needs. Not only is your effort on these classes portable to other projects, but you're abstracting matters of the UI (Crystal Reports and their API in this case) from any changes you make to accommodate DAL or DBMS changes. For example, you can now use your CR interface with jBASE, Cachi, SQL Server, or any other database - all you need to do is replace the DAL - and you can use the same DAL and BLL to provide data to MS Office, web services, or any number of other front-end application/interfaces. This also insulates you from support people at either IBM or CR blaming their faceless counterparts for some malfunction. Speaking of which, I'm surprised IBM says CR itself is so broken but I suspect that's motivated in part by their purchase of Cognos. As always, if you'd like assistance, you know where I am. :) HTH Tony Gravagno Nebula Research and Development Technical Editor, LINQ Programming: http://tinyurl.com/5lqroa [link goes to Amazon for book info] ... and other .NET books and publications TG@ remove.pleaseNebula-RnD.com Nebula RD provides .NET-related development and training services From: David Wolverton We want to use UniData 7.1.20 OLE-DB and Crystal Reports 2008 ... and IBM support tells me that CR has 'not worked right since Version 9' (which in itself is amazing, and unbelievable!) So I'm asking the masses -- are you using CR 2008 against UniData 7.1.x? And if so, are there tricks you can share? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.21/1675 - Release Date: 9/16/2008 7:06 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
Usually, the AS keyword is in use... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 10:18 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData But won't it then disappear up its own backside with ambiguous field names? Iiuc, listing multiple file names does a cross-product, and as a result if you repeat the same file name, EVERY field will be ambiguous and the SQL will be unable to resolve. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 14:57 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC could just as well read SELECT FIELDS FROM TABLE_ASSOC MY_SELECTED_TABLE It does conform to SQL... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 4:14 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData I looked at that SQL and thought what's wrong with double quotes? (but then I don't know SQL that well). I thought quoting field names was mandatory if they contained spaces and optional otherwise. Or should it be single quotes and double is the problem? I'm still having problems with the doubled table name from MS Access ... does anybody know why Access will happily retrieve an ASSOCiation from UniVerse via a linked table, but as soon as you try and sort it, it doubles up the table name and causes UV to throw a wobbly? SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC Is what it does and UV quite reasonably complains about the double TABLE_ASSOC :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 16 September 2008 23:49 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, the best approach may be more indirect. This is another reason why I keep trying to discourage the more direct interfaces between MV-specific SQL tools. Rather than trying to bind CR or any reporting tools to U2, create a Data Access Layer (DAL) that you're comfortable with using any tools you prefer. You can then use this with any future project and enhance it as you find the need. Then create classes for a Business Logic Layer (BLL) that represent the server-side data. These might include CUSTOMER, ORDER_HDR, INVENTORY, etc. Again, you will be able to use these for any future projects. Then you can create a final class, decorated with the .NET DataObjects attribute, that can be used as an ObjectDataSource with any tools that bind with such DataSources - including Crystal Reports. You will probably have a few of these for your various application needs. Not only is your effort on these classes portable to other projects, but you're abstracting matters of the UI (Crystal Reports and their API in this case) from any changes you make to accommodate DAL or DBMS changes. For example, you can now use your CR interface with jBASE, Cachi, SQL Server, or any other database - all you need to do is replace the DAL - and you can use the same DAL and BLL to provide data to MS Office, web services, or any number of other front-end application/interfaces. This also insulates you from support people at either IBM or CR blaming their faceless counterparts for some malfunction. Speaking of which, I'm surprised IBM says CR itself is so broken but I suspect that's motivated in part by their purchase of Cognos. As always, if you'd like assistance, you know where I am. :) HTH Tony Gravagno Nebula Research and Development Technical Editor, LINQ Programming: http://tinyurl.com/5lqroa [link goes to Amazon for book info] ... and other .NET books and publications TG@ remove.pleaseNebula-RnD.com Nebula RD provides .NET-related development and training services From: David Wolverton We want to use UniData 7.1.20 OLE-DB and Crystal Reports 2008 ... and IBM support tells me that CR has 'not worked right since Version 9' (which in itself is amazing, and unbelievable!) So I'm asking the masses -- are you using CR 2008 against UniData 7.1.x? And if so, are there tricks you can share? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.21/1675 - Release Date: 9/16/2008 7:06 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found
RE: [U2] [UD] Crystal Reports and UniData
Exactly. Doing it WITHOUT an AS keyword (as is happening in my case) will cause it to blow up. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 16:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData Usually, the AS keyword is in use... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 10:18 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData But won't it then disappear up its own backside with ambiguous field names? Iiuc, listing multiple file names does a cross-product, and as a result if you repeat the same file name, EVERY field will be ambiguous and the SQL will be unable to resolve. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 14:57 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC could just as well read SELECT FIELDS FROM TABLE_ASSOC MY_SELECTED_TABLE It does conform to SQL... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 4:14 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData I looked at that SQL and thought what's wrong with double quotes? (but then I don't know SQL that well). I thought quoting field names was mandatory if they contained spaces and optional otherwise. Or should it be single quotes and double is the problem? I'm still having problems with the doubled table name from MS Access ... does anybody know why Access will happily retrieve an ASSOCiation from UniVerse via a linked table, but as soon as you try and sort it, it doubles up the table name and causes UV to throw a wobbly? SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC Is what it does and UV quite reasonably complains about the double TABLE_ASSOC :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 16 September 2008 23:49 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, the best approach may be more indirect. This is another reason why I keep trying to discourage the more direct interfaces between MV-specific SQL tools. Rather than trying to bind CR or any reporting tools to U2, create a Data Access Layer (DAL) that you're comfortable with using any tools you prefer. You can then use this with any future project and enhance it as you find the need. Then create classes for a Business Logic Layer (BLL) that represent the server-side data. These might include CUSTOMER, ORDER_HDR, INVENTORY, etc. Again, you will be able to use these for any future projects. Then you can create a final class, decorated with the .NET DataObjects attribute, that can be used as an ObjectDataSource with any tools that bind with such DataSources - including Crystal Reports. You will probably have a few of these for your various application needs. Not only is your effort on these classes portable to other projects, but you're abstracting matters of the UI (Crystal Reports and their API in this case) from any changes you make to accommodate DAL or DBMS changes. For example, you can now use your CR interface with jBASE, Cachi, SQL Server, or any other database - all you need to do is replace the DAL - and you can use the same DAL and BLL to provide data to MS Office, web services, or any number of other front-end application/interfaces. This also insulates you from support people at either IBM or CR blaming their faceless counterparts for some malfunction. Speaking of which, I'm surprised IBM says CR itself is so broken but I suspect that's motivated in part by their purchase of Cognos. As always, if you'd like assistance, you know where I am. :) HTH Tony Gravagno Nebula Research and Development Technical Editor, LINQ Programming: http://tinyurl.com/5lqroa [link goes to Amazon for book info] ... and other .NET books and publications TG@ remove.pleaseNebula-RnD.com Nebula RD provides .NET-related development and training services From: David Wolverton We want to use UniData 7.1.20 OLE-DB and Crystal Reports 2008 ... and IBM support tells me that CR has 'not worked right since Version 9' (which in itself is amazing, and unbelievable!) So I'm asking the masses -- are you using CR 2008 against UniData 7.1.x? And if so, are there tricks you can share? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com
Re: [U2] [UD] Crystal Reports and UniData
Does this email thread confirm that U2's OLE-DB has an issue with Crystal Reports 2008 (or any 'current version' of Crystal Reports)? Do it confirm that it is not working anywhere? And to make sure I'm clear -- Tony - you are proposing a 'middleware' tool to make U2 do something that in theory it should be already intrinsic to the product - is that right? In my mind, if we generate the Schema, I'm thinking the OLE-DB interface should do what I'm wanting without a 3rd party tool - It works fine with other tools - I'm trying to figure out if we're just wrong (Crystal Reports works cleanly at X number of sites and we've made a setup issue ) or if we've found a 'true problem' - that no one can make Crystal Reports work WITHOUT buying something else. Thanks! DW - Original Message From: Anthony Youngman [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: Wednesday, September 17, 2008 11:02:47 AM Subject: RE: [U2] [UD] Crystal Reports and UniData Exactly. Doing it WITHOUT an AS keyword (as is happening in my case) will cause it to blow up. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 16:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData Usually, the AS keyword is in use... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 10:18 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData But won't it then disappear up its own backside with ambiguous field names? Iiuc, listing multiple file names does a cross-product, and as a result if you repeat the same file name, EVERY field will be ambiguous and the SQL will be unable to resolve. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 14:57 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC could just as well read SELECT FIELDS FROM TABLE_ASSOC MY_SELECTED_TABLE It does conform to SQL... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 4:14 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData I looked at that SQL and thought what's wrong with double quotes? (but then I don't know SQL that well). I thought quoting field names was mandatory if they contained spaces and optional otherwise. Or should it be single quotes and double is the problem? I'm still having problems with the doubled table name from MS Access ... does anybody know why Access will happily retrieve an ASSOCiation from UniVerse via a linked table, but as soon as you try and sort it, it doubles up the table name and causes UV to throw a wobbly? SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC Is what it does and UV quite reasonably complains about the double TABLE_ASSOC :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 16 September 2008 23:49 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, the best approach may be more indirect. This is another reason why I keep trying to discourage the more direct interfaces between MV-specific SQL tools. Rather than trying to bind CR or any reporting tools to U2, create a Data Access Layer (DAL) that you're comfortable with using any tools you prefer. You can then use this with any future project and enhance it as you find the need. Then create classes for a Business Logic Layer (BLL) that represent the server-side data. These might include CUSTOMER, ORDER_HDR, INVENTORY, etc. Again, you will be able to use these for any future projects. Then you can create a final class, decorated with the .NET DataObjects attribute, that can be used as an ObjectDataSource with any tools that bind with such DataSources - including Crystal Reports. You will probably have a few of these for your various application needs. Not only is your effort on these classes portable to other projects, but you're abstracting matters of the UI (Crystal Reports and their API in this case) from any changes you make to accommodate DAL or DBMS changes. For example, you can now use your CR interface with jBASE, Cachi, SQL Server, or any other database - all you need to do is replace the DAL - and you can use the same DAL and BLL to provide data to MS Office, web services, or any number of other front-end application/interfaces. This also insulates you from support people at either IBM or CR blaming their faceless counterparts for some malfunction. Speaking of which, I'm surprised IBM says CR itself is so broken but I suspect that's motivated in part by their purchase
Re: [U2] [UD] Crystal Reports and UniData
I agree with you 100% Tony from the independence makes things 'better' for people who are platform agnostic -- we're talking a 100% UniData solution in all cases, and the issue we're seeing more and more is that prospects want to see that the 'core engine' supports the ability to use BI tools they know and love. The do not want to learn to love what we use now - they want to use CR for their ad hoc BI queries. It's an RFP-deal-breaker more and more in being able to check 'works with Crystal Reports' ... Even if IBM owns Cognos, Crystal Reports is *the* defacto standard in Business Intelligence/ Reporting (sorry IBM). A standard of if OLE-DB (or ODBC) 'works' in my mind is if CR works with it -- it's like the IE browser -- you can carp all day that it's not compliant with the stanrdard -- but honestly -- it SETS the standards. CR is the same way in the BI world So you can't really say that OLE-DB 'works' if a major consumer of the provider won't... That said, before I actually told the client Im working with that they need to start pushing on IBM for a resolution (that is, a resolution beyond 'Huh! Yeah - I had heard that it didn't work.' g) I wanted to ensure it was not something that we had 'missed' in our setup and testing. No one has sung out that a current version of CR is in use using a direct OLE-DB provider connection, which was the main answer we needed to hear. Hey, we make mistakes (hourly if you watch close enough!) so we wanted to ensure that our Crystal testing was an accurate representation of the current state of the UniData art... I do want to say that OLE-DB is working like a CHAMP with DBxtra.Net -- a BI tool we found to see if it was a 'generic' OLE-DB error, or specific to CR. And it's specific to CR. Even so - CR is the 'gold standard' - so we're stuck with it! And, yes - while these kinds of things can be done in any number of ways - we're looking for the 'fewest moving parts for a UniData specific implenetation' and to be able to say that IBM's UniData has an OLE-DB provider that is CR-Ready-- I suspect the 3rd party products would increase performance and give other benefits, but that's a whole 'nuther topic... Thanks again! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
We do have one client using UniData against Crystal Reports. We use ODBC for the connection and I'm not sure which version of CR they are using - but it does seem to work well. hth Colin Alfke Calgary Canada From: dwolvert [snip] That said, before I actually told the client Im working with that they need to start pushing on IBM for a resolution (that is, a resolution beyond 'Huh! Yeah - I had heard that it didn't work.' g) I wanted to ensure it was not something that we had 'missed' in our setup and testing. No one has sung out that a current version of CR is in use using a direct OLE-DB provider connection, which was the main answer we needed to hear. Hey, we make mistakes (hourly if you watch close enough!) so we wanted to ensure that our Crystal testing was an accurate representation of the current state of the UniData art... _ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
David, the best approach may be more indirect. This is another reason why I keep trying to discourage the more direct interfaces between MV-specific SQL tools. Rather than trying to bind CR or any reporting tools to U2, create a Data Access Layer (DAL) that you're comfortable with using any tools you prefer. You can then use this with any future project and enhance it as you find the need. Then create classes for a Business Logic Layer (BLL) that represent the server-side data. These might include CUSTOMER, ORDER_HDR, INVENTORY, etc. Again, you will be able to use these for any future projects. Then you can create a final class, decorated with the .NET DataObjects attribute, that can be used as an ObjectDataSource with any tools that bind with such DataSources - including Crystal Reports. You will probably have a few of these for your various application needs. Not only is your effort on these classes portable to other projects, but you're abstracting matters of the UI (Crystal Reports and their API in this case) from any changes you make to accommodate DAL or DBMS changes. For example, you can now use your CR interface with jBASE, Cachi, SQL Server, or any other database - all you need to do is replace the DAL - and you can use the same DAL and BLL to provide data to MS Office, web services, or any number of other front-end application/interfaces. This also insulates you from support people at either IBM or CR blaming their faceless counterparts for some malfunction. Speaking of which, I'm surprised IBM says CR itself is so broken but I suspect that's motivated in part by their purchase of Cognos. As always, if you'd like assistance, you know where I am. :) HTH Tony Gravagno Nebula Research and Development Technical Editor, LINQ Programming: http://tinyurl.com/5lqroa [link goes to Amazon for book info] ... and other .NET books and publications TG@ remove.pleaseNebula-RnD.com Nebula RD provides .NET-related development and training services From: David Wolverton We want to use UniData 7.1.20 OLE-DB and Crystal Reports 2008 ... and IBM support tells me that CR has 'not worked right since Version 9' (which in itself is amazing, and unbelievable!) So I'm asking the masses -- are you using CR 2008 against UniData 7.1.x? And if so, are there tricks you can share? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/