Dear all,

I'm new to dotnetnuke, i developed a simple module that shows a list of products and allow the user to edit/ delete them ...

Now I'm about to start developing a managment information sysytem , with some complex  business logic  and reports ...

I have some questions

1. I want to use Nettiers tempalate to generate the DAL , entity classes instead of following the Provider/ controller pattern that is commonly used in the modules ,and i want to know if this could cause any problems(like trust issues ..)
2. I need a good reporting engine or tool , maybe i will use Crystal reports ... Is there any problems with crystal reports in DNN ?
3. I need to reference the portal user as a foriegn key in my application database  , and i want to know which table to refence ?
4. For every customer ,there will be a sub portal inside the main portal , and all portals  will runs on a centralized database .
5. I want to use DNN portal because of the caching, security , drag/drop , managmenet / logging, themes, and to display a statistical data on the main site of the portal .
6. I want to implement some kind of audit trail in the applciation , is there any logging classes in DNN for thi purpose ?

as i'm in analysis phace, is there any recommendation or something that is very important to take it into consideration ?

all ideas and thoughts are mostly welcomed ! please I need some help ..

Thanks

All of what you want can be developed in or out of the DNN framework.  But you want quite a few things that change the basic core of DNN, so why not simply code the entire system yourself.  The reasons you give for wanting to use DNN are either already in ASP.NET or you would need to write them either way.

Jeff

 Anas,

Here is my take:

1. I'm not familiar with nettiers and therefore don't know exactly what you might be generating - but I doubt that you'd run into any problems here. Realistically (and especially if you're not selling your module(s) to the public) you can use any technique you like.
2. I have experience with MS Reporting Services and DNN modules (BTW, never use reporting services 2000 if you have a choice) - but I don't think you'll find any explicit problems with using Crystal Reports in a DNN world. I know one of my co-workers has done this (on a relatively small scale) for one of our clients.
3. The primary key for a DNN User is "UserID" and is stored in the Users table (sometimes named dnn_Users).
4. I'm not certain I really follow this one - could you elaborate?
5. All great reasons! :)
6. Not that I'm aware of - I think that this would need to be custom for your module (but you could always re-use some .NET code you find/have elsewhere within your module).

Take care,

Ian