Dynamic reporting

[Phrog30]

Can anyone recommend a free, or relatively cheap, dynamic reporting tool that could work with advanced hmi? I've seen several online, just curious what current advanced hmi users think.

James

[Archie]

For generating reports from database data?

[Phrog30]

Yes, sorry that would have been helpful info. I'm using mysql.

James

[Archie]

I use the ReportViewer found in the Reporting group in the ToolBox. It has a report designer built into Visual Studio with a wizard to make it easy to get started.

[bachphi]

If you don't see ReportViewer in your Toolbox, it needs to be installed thru Control Panel - Program& Features - Visual Studio -Change - Select Microsoft SQL Server Data Tools.

[Phrog30]

Thanks, will give that a shot.

James

[Phrog30]

I started using the reportviewer.  I'm having an issue after upgrading to the latest version of AdvancedHMI.  Before I upgraded things looked like photo #2.  After the upgrade, it looks like photo #1.  The reporting still works, but I'm not able to edit in the dataset designer.  I did some research and tried everything I know.  Can someone help on this?  I'm sure it's something simple, but so far it has me baffled.  This is not related to AdvancedHMI, but I'm hoping the .net/Visual Studio experts might know.

Edit, don't pay attention to DataSet1, I was playing around after the fact.

Thanks,
James

[Archie]

If you stored your connection string in a setting, then you will have to first create that setting in the new project. Then when you import the dataset, only add the xsd file. Visual Studio will bring the rest automatically.

[Phrog30]

The connection string was already there.  I did what you said and it now looks closer to what it did, but still doesn't allow me to edit anything.  It will run, but it also ran before, so nothing really changed.

[Archie]

What are you not able to edit? Did you try to go to the Data Sources window, right click the Dataset and select Edit with Wizard?

[Phrog30]

I'm trying to edit the queries.  The data preview will not work either.  There are a few ways to edit, but yes, I tried right click as well.  When I try to edit there is nothing there.  I would take a picture but just imagine nothing, that is what I see.

[Archie]

I'm not sure what you've got happening. I just created a new application, added the connection setting, then added an XSD file from another project, Rebuild the Solution, then it let me open the data set in designer.