Hello Lee,

I saw you did some tutorials about DotNetMushroom. Unfortunately I currently do not have the time to go through all of this, therefore I' d like to ask you some questions.
Is it possible to build 1:n datastructures with that system ?
Is it possible to create forms with subforms like in microsoft access which access their data directly from the related tables?
(For example you see the customers on top of the form an all their orders in the subform on the same page)
Is it possible to style the forms easily ?

Since some time I'm searching for a module with similar features ms access provides. The first glimpse gave me some hope that DotNetMushroom could probably be something like that ?

Thanks for your help

Matthias

Simple answers: yes. DotNetNuke and DotNetMushroom are built on top of MS SQL Server, a full, SQL-compliant relational database. DNM lets you draw data from any data source.

Depending on what you really are trying to do, you might find Reports, Form and List, SGSV from Tressleworks.ca, and a bunch of other modules more appropriate.

It sounds as if you have a particular application in mind. Knowing some of its details would be useful in responding to your question.

Hello Joe,

thanks for your immediate reply.
Yes I have something in mind that I'd like to do. It's about displaying data of our photovoltaic-installations.
I need one form to display the general data of the installation such as adress, geographic location, pitch of the roof and things of that nature.
This is in the 1-Table. The n table holds information about the energy yield of the systems. I want to be able to display the daily, the monthly and the yearly data on a kind of tab-form.
On top of that it would be nice to have the opportunity to show the data in bar-graph charts with a drill-down function. That means you show for instance the data of a year on one chart, than you click on - let's say the month april - and you get the monthly data for april of that year.
I' m sure there are several way's to realize that but I've not the expierience to figure out which one is the most flexible and extensible.
The charts shoud be something like that: Dotnetcharting
Is there any dnn module that uses dotnetcharting ?

Thanks for any ideas ...

I'm not familiar with Dotnetcharting, so I can't answer that question.

Besides Reports, Forms & Lists, and SGSV, there are other third-party modules that might help you.  Check Snowcovered.com.

Hi Matthias,

Yes, using DotNetMushroom RAD, you can display 1:n data structure using queries. In the header template you display the 'parent data' and in the normal/alternate template you display the 'child data'.

Evan

What does SGSV mean ?  I never heard of that...

I already checked Snowcovered and I know there are a lot of modules. But I' ve not the time to try all of them therefore a recommendation of an experienced dnn user who had the same problem would be great...

@Evan,
that Sounds good.
thanks for your reply. I'll give it a try when I find some time...

Matthias

SGSV is "SQL Grid Selected View" if I remember correctly.  It is from Tressleworks.ca.  It is very inexpensive, as are Paul's other modules.  I believe that there is a charting module, too.

That sounds interessting too.
I'll check it. Thanks a lot.

Hi Matthias,

May I add that as of v.1.3, DotNetMushroom RAD has an inbuilt Charts control which enables graphical representation of data: http://dotnetmushroom.com/DNMRADDow...fault.aspx

Cheers
Justin (DotNetMushroom Team)