[Adam]

Hello All,

I’m looking into getting NetSuite ODBC Access and possibly using it with Chrystal – does anyone have any experience with this combination?

Thanks

Adam
This is a cached copy. Click here to see the original post.

[dreyes]

RE: Advanced Reporting ODBC Chrystal

I have not used Crystal Reports but we created some impressive custom reports that measure lead source /sales performance by using .NET/SQL.

Unfortunately, the out of the box reports or Saved Searches NetSuite provides simply does not cut it.

Diego

[dnewnham]

RE: Advanced Reporting ODBC Chrystal

I have. I’m only just starting.

It certainly leads to some better reporting but also some other challenges.

Happy to discuss privately if you like. Where are you located?

[psusca]

RE: Advanced Reporting ODBC Chrystal

I’ve been using Crystal Reports with NetSuite for the past 4-5 months and love it… Have been able to produce some very impressive reports. Let me know if I can be of any assistance.

[KevBTR]

RE: Advanced Reporting ODBC Chrystal

Is it possible to access saved search results via ODBC views?

[NeilR]

RE: Advanced Reporting ODBC Chrystal

Originally posted by dreyes

I have not used Crystal Reports but we created some impressive custom reports that measure lead source /sales performance by using .NET/SQL.

Unfortunately, the out of the box reports or Saved Searches NetSuite provides simply does not cut it.

Diego

I’ve been using Crystal Reports 2008 with NetSuite using the NetSuite (latest) ODBC Driver. I want to incorporate my reports into a Web app. I have encountered a problem where the NetSuite ODBC “looses” the DB definition throwing Crystal Viewer errors in .net (C#).

Have you been able to connect to NetSuite without NetSuite ODBC via .net or use NetSuite ODBC in .net?

So far the issues that I am expereiencing prevent me from using the CR’s within .net, but I am able to extract reports that I cannot get via NetSuite reports or saved searches using Crystal, having to manually ignoring “table does not exist” errors to produce my custom reports. The fact that I cannot automate them in a intra web app is a pain.

Do you have any insight into this?

Thanks.

[Svilen Rangelov]

RE: Advanced Reporting ODBC Chrystal

Originally posted by KevBTR

Is it possible to access saved search results via ODBC views?

ODBC views gives you read-only access to database views containing raw data so you cannot access any NetSuite application objects like saved searches.

If you want to be able to access saved searches from an external tool or application you may want to consider using Web Services.

Cheers,

Svilen

[NeilR]

RE: Advanced Reporting ODBC Chrystal

Originally posted by psusca

I’ve been using Crystal Reports with NetSuite for the past 4-5 months and love it… Have been able to produce some very impressive reports. Let me know if I can be of any assistance.

Have you had any issues with “table does not exist errors”. If I ignore these errors the report prints without any issues.

How did you get around these errors?

Thanks.

[NeilR]

RE: Advanced Reporting ODBC Chrystal

Originally posted by psusca

I’ve been using Crystal Reports with NetSuite for the past 4-5 months and love it… Have been able to produce some very impressive reports. Let me know if I can be of any assistance.

Are you getting “table does not exist, do you want to drop fields” when running of verifying a Crystal Report. I am using CS 2008 and get this error on many tables (not all). This makes it impossible to integrate into a C#.net app. I have used CS with .net without problems on Oracle, MSSQL and MYSQL. The problem occurs only when I use NetSuite ODBD.

Do you have any suggestoions.

Thanks.

[dreyes]

RE: Advanced Reporting ODBC Chrystal

To: nrice@sherrilltree.com

We use NetSuiteODBCDriver with a custom reporting engine build in C# to get the information we need from NetSuite.

using System.Data.Odbc;

string cnNS = “Dsn=NetSuite.com;uid=youraccount@domain.com;pwd=* *****”;

OdbcConnection cn = new System.Data.Odbc.OdbcConnection(cnNS);

NetSuiteODBCDriver

Diego

[Adam]

RE: Advanced Reporting ODBC Chrystal

Well I started using Crystal with ODBC and like what I can do with the data, it’s proper reporting which you just can’t get with the default NetSuite reports and searches. So I would really recommend it. No doubt I will find some limitations but that’s to be expected.

Something odd that I have found is that the whole lists of some data such as companies and dates do not show the whole list (when selecting from the filters in Crystal) but if you enter the company name or date range in the Fomula Editor the data gets pulled through without any problem – Weird. It’s as if there is too much data to display in the drop down.

I have yet to have some fun with the NetSuiteODBCDriver in C#

[jwc@vardata.com]

Could I please have your contact information to discuss your experience with NetSuite and Crystal Reports? Thanks very much.

[Author]

Posts