Adding a second dataset

Dale Lewis · Post by **Dale Lewis** » Wed Dec 30, 2009 8:09 am

I am using Stimulsoft Reports.Net as the report generator in Microvellum. Is it possible to add a second dataset in my reports? If so, how is it done?

Post by **Edward** » Wed Dec 30, 2009 8:16 am

Hi

Yes, that is possible to do.

Please use the same technique of adding the second dataset as you used for adding the first dataset.

Thank you.

Dale Lewis · Post by **Dale Lewis** » Wed Dec 30, 2009 8:24 am

Microvellum comes with report templates that are already connected to the database it normally uses to generate reports. I've never actually connected to a database, because when I open a report to modify it the database is already there.

Post by **Edward** » Wed Dec 30, 2009 9:22 am

Hi

Can you add a Connection to any source from the designer? (Xml, SQL, csv or any other connections)

By default it is a button in the Dictionary panel - New Connection.

Thank you.

Dale Lewis · Post by **Dale Lewis** » Wed Dec 30, 2009 9:46 am

Yes, I believe that option is available. I just don't know what information i need to provide to make the connection. The report is already connected to a database called OverdrivePro.mdb. I am trying to connect to another file called Moldings.mdb. Any help is greatly appreciated.

Post by **Jan** » Wed Dec 30, 2009 2:14 pm

Hello,

Please check attached image. Also developers can deny any actions which available in report designer. So may be you can't add new connection and can use only default connection (provided from code).

Thank you.

Dale Lewis · Post by **Dale Lewis** » Wed Dec 30, 2009 3:00 pm

Yes, that option is available. My question is really two-fold.

1) What type of connection do I want to create? The database I am trying to access is a Microsoft Access database called Moldings.mdb.

2) What information do I enter in the dialog box or boxes that follow the selection of my connection type (name, alias, connection string, etc.)?

Post by **Edward** » Wed Dec 30, 2009 3:51 pm

[quote="lewis".dale]Yes, that option is available. My question is really two-fold.

1) What type of connection do I want to create? The database I am trying to access is a Microsoft Access database called Moldings.mdb.[/quote]
You need to create connection to OleDb database.

Please see the part of the following video for creation of 'Connection String'. The same actions you will do when you add a OleDb Connection in the Designer when you create a OleDb type of connection.

http://www.stimulsoft.com/livedemos/dat ... le_DB.html

[quote="lewis".dale]2) What information do I enter in the dialog box or boxes that follow the selection of my connection type (name, alias, connection string, etc.)?[/quote]
name - Connection name
alias - friendly Connection name for the user of the report template (can be the same or can bring some sense to the purpose of the connection for end user)
Connection String - will be formed automatically in the Wizard as it was shown in the video in 1).

Thank you.