Problem with microsoft report

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
HviVisser
Posts: 5
Joined: Wed 20 Feb 2008 15:22

Problem with microsoft report

Post by HviVisser » Wed 20 Feb 2008 15:45

I have a problem using MyDirect.Net with Microsoft report.

I am using visual studio 2008 and MyDirect.NET 4.30.24.0

I take the following steps:

1. Using the corelab dataset wizard I create a dataset pointing to my MySQL database. I can select correct table from my database and can see correct records.
2. To my project I add a report.
3. To this report I drag a table.
4. To this table I drag records from my DataSet from the Data Source view. A header and a datafield is added to my report design.
5. To my form I drag a report viewer and select the report (.rdlc file) created in point 2.

Then I run my example and when it is finished I can only see the record heading, and no datafields are displayed. (When I preview my mysqldataset I can see the data)

When I repeat the same test with Microsoft sql server it works correctly.

What am I doing wrong?

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Thu 21 Feb 2008 11:57

Try running our test project here:
%Program Files%CoreLab\MyDirect.NET2\Samples\All Languages\ReportingServices\
See if it works in your environment.

HviVisser
Posts: 5
Joined: Wed 20 Feb 2008 15:22

Post by HviVisser » Tue 18 Mar 2008 11:31

The reportingservices example doens't run with Visual Studio 2008.

I have updated MyDirect.Net to version 4.50 but reporting still doesn't work (same problem).

So I am still not able to create a microsoft report using MyDirect.Net

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Wed 19 Mar 2008 08:47

Could you make step-by-step screenshorts or a small flesh movie to reproduce the problem?
Please send them to my email (alexeyman*crlab*com), please.

HviVisser
Posts: 5
Joined: Wed 20 Feb 2008 15:22

Post by HviVisser » Thu 10 Apr 2008 10:30

Your mail solved my problem.
The problem was:
When I added the report viewer the dataset which was added wasn't active and no connection was set.

Thanks for solving my problem.

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Thu 10 Apr 2008 11:21

This is just the way PgSqlDataTables are working in PostgreSQLDirect .NET.
Feel free to contact us if you encounter any other issue with the product.

Post Reply