C# - Class Design For Reports In .NET Application That Use A Conglomeration Of Data?

Jul 20, 2011

I can articulate my question well enough to get some clear and usable feedback here. I have reports (like paper reports) in my .NET application that have data bound to them. Typically the reports are a combination of many data elements across several busniess entites that may not all relate through an Inheritance hierarcy, etc. This makes it difficult to get all the needed data placed together to bind to the report.

So what I have done before are make 'Report' classes with data elements specific to supporting the reports they are bound to, and on the back end might be tied to specially created Stored Procedures that bring this data back (maybe several joins across many tables to get the right data needed). So if I was to make an analogy to the database world, I am essentially 'denormailizing' the data structure to get all of this data into a single class to make it easy to bind to the report.

However on the hard line OOP concepts and architecture design, one could say that a report is just another 'thing' to bind data to, and its class should not be designed just to suit the needs of data binding. In this thought process, I would actually need to make my class design be able to create the relationships needed to get all of the data together properly to still be bound, but not create any special 'Report' classes. I find this difficult to do sometimes. It is much easier to create these relationships in the back end stored procedures and then just output the resultset to be almost immediately bound to the report.

So what is the right way to solve this? If I create these specialized report classes with really no behavior, am I introducing an anti-pattern like the Anemic Domain Model?I could use some feedback, and please speak up if my question and scenarios did not make sense.

View 1 Replies


ADVERTISEMENT

Class Hierarchy - Data Design In An RPG Game

Aug 10, 2010

how to organize the classes within my RPG project that I'm making. I've tried to implement a battle system but I am not comfortable with my initial results. This is the basic layout I currently have for my classes. [Code] clsCharacter contains statistics pertaining to one character, including magic available to that character to use. Also includes what weapons that character has equipped. clsTeam contains multiple clsCharacter, as well as a list of items that each clsCharacter in the team can use. clsBattle contains two clsTeams. One team is the player and the other is the computer. Now, this is a wonderful way to organize data. However, I see limitations with this approach. For instance, to pass data from Battle to Character, it has to pass through the team class and vice-versa. Plus, if I use Properties, it transfers data as ByVal instead of ByRef, so I cannot guarantee that I'm editing the original and not a copy of the passed object (IIRC)

In addition, I feel it is just messy code to include methods within the clsCharacter class that invoke this: MyTeam.MyBattle.DoAction(). Plus, the clsCharacter might not even be in the battle at the time - I don't won't to bog down that class featuring code that is exclusive for battling when I also need to be concerned about moving around the map, saving/loading data, etc. So, any suggestions? Right now, I'm burnt out of ideas. One idea I have so far is to include a function for the clsCharacter that exports a list of all possible moves the character could make, and if the character is CPU choose the most optimal one, and if Human than wrap it up in some nifty GUI so they can choose what action to take. But at the same time, how do I use that information within the context of the battle?

View 2 Replies

Class Hierarchy - Data Design In A RPG Game Where Classes Overlap?

Aug 19, 2010

This is a followup to the question I asked here:

[URL]

I understand the answer in the post above, which is absolutely amazing, by the way. It's about implementing interfaces with a class. However, what if a class needs to share features with another class?Yes, that class can an Interface. However, let's use this sample definition.

[code]...

Or, in other words:An equippable item can perform acts outside of its typical usage of a shield or weapon. But not all items can act as a sheid or weapon.I mean, I could create a class that implements IWeapon, IShield, IMagic, IUseableItem, etc. But there should be a better way than returning NULL when those interfaces are called.

View 2 Replies

How End User Can Design Himself Reports In .net

Feb 5, 2012

I need to create vb.Net reports, where end user can design himself labels,text box,combo box and can move or resize in grid like editor.i am pasting the sample image which i am looking for.when ever user clicks the command button new Texbox or label should create on grid where he can change or move.

View 2 Replies

Adding A Reports Application Or A Crystal Reports Application?

Dec 22, 2010

I'm using VS 2008 to develop a solution which will report on data mostly contained in SQL Express databases, across two servers. It will be used by up to about 10 XP clients. I am unfamiliar with the Reports Applications. Will I need to buy extra licenses to use a Crystal Reports application? Why are they both included in VS? What is the basic difference between them?

View 3 Replies

Option For User To Design Custom Reports

Dec 10, 2011

How can I give option to user to design there own reports? i.e. They should be able to define
1. Report Title
2. Reports Fields(When they click on Work Order button they should be able to view Work Order Table column and they should be able to select columns then a report should be composed. Then all the Column should be in the form datagrid. Is it possible.

View 10 Replies

Database - Design And Deploy A Data Driven Desktop Application?

Jun 28, 2011

I am designing a desktop application that will be driven by local data. I am trying to determine the best way to accomplish this. The database would contain about 10-12 tables if I use a database and I would imagine no more than 10000 records in any one table (but honestly 99% of users would not have more than 1000 records). I am thinking about using SQL Server Compact.

Is this a good solution? I can certainly include this in my installation, but I am just wondering if anyone knows of a better solution? If this is the best solution, how would you suggest that I create the tables upon deployment? Should I just run "queries" with create table statements in them from my vb application or include a database file or what?

View 1 Replies

How To Use VB - Design A Program - String, Data Enadled Application And Refactoring

Jul 20, 2008

Dont understand where to start on visual basic iv been leaning alot about computers over the months and i would now like to design a program and to be honest its all new and i dont no where to start or what any of these woulds mean like string, data enadled application and refactoring.

View 3 Replies

Override The Design Time Connection Settings Of Crystal Reports

Nov 5, 2009

I�m converting some Crystal reporting functions from VB 6.0 to VB .Net 2008, have reports up and running, and I�m not quite sure how to approach one aspect. The issue I have is most of the Crystal reports connect to a database and run a stored procedure. The connection properties are set up in the report usually pointing at the development region. At run time I need to be pointing to either development, user acceptance, or production. I know what environment I�m in from a configuration file but don�t know how to go about telling Crystal what environment and stored procedure to point at. In VB 6.0 it was:

CR1.Connect = "DSN=" & A.ReportServer & ";<<Use Integrated Security>>;DSQ=" & A.ReportManhattanDB
Where A.ReportServer and A.ReportManhattanDB contain the connection poperties. The stored procedure is passed via:

[Code]....

View 3 Replies

2005 : Crystal Reports Application Or Windows Application To Generate Pdfs?

Apr 13, 2011

I currently have a simple crystal reports application which generates a crystal report and in the built in viewer provided by VS2005. There is a drop down where you can select options to change the criteria of the report. I wish to convert this app to a windows executable which will take all those select options and generates pdfs based on the crystal report. the executable will be triggered by windows task scheduler...or maybe command line app?

Obviously this will be somewhat of a re-write. What would be the best way to start this as? a crystal report application or a windows application.

View 2 Replies

[OOD] Class Design For With Database Back End

Feb 6, 2010

I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends. I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea of how I would go about designing the classes for the system, the bit that I don't know how to do is, how I would go about getting the data to and from the database.

For example with my other applications, I have done a couple of things;

1) Gathered all the data when the application started up, creating the objects then. Then when the application closed sending the data back to the database.

2) Have the code which deals with getting the data in the specific class, so the student class for example would take only one constructor argument which would be the studentID, then the class code would connect to the database and populate the object fields as appropriate.

3) Variations of the above. I have also looked into LINQ, which seems like it would be very useful if you don't expect your classes to deal with any business logic and just data, but I suppose it would be possible to create a wrapper class that would include the business logic.

[Code]....

View 1 Replies

[OOD] Class Design For With Database Back End?

Mar 11, 2010

I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends.I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea of how I would go about designing the classes for the system, the bit that I don't know how to do is, how I would go about getting the data to and from the database

View 3 Replies

Use MultiLineStringEditor Class From System.Design Namespace?

Feb 20, 2010

Me need use MultiLineStringEditor Class from System.Design namespace.I add reference as file (as in the .NET tab, it no) from

c:Program FilesReference AssembliesMicrosoftFramework.NETFrameworkv4.0System.Design.dll

and Visual Studio show in References

System.Design.dll
.NET
0.0.0.0
False

<The system cannot find the reference specified>

View 1 Replies

What Are The Features Of The Controller Class In The MVC Design Pattern

Aug 13, 2009

In the MVC design pattern we must use a controller(s) classes.

What are the fucntions (features) of the controller apart from handling communication bewteen Model and View?e.eg; can we include input validation code in the controller?

View 4 Replies

Populating Rdlc Reports From Data In A Form OR Data From An MDF Table

Mar 27, 2008

I have a simple windows form that i would like to send the values of a few textboxes and comboboxes to an rdlc report after saving them (I have VS 2005 standard, so no crystal reports) - it's as follows:

-1 form
-3 textboxes - textbox1, textbox2, textbox3
-1 label - label1
-1 combobox - combobox1
-5 buttons - button1, button2, button3, button4, button 5

the textboxes are labeled length, width, height the combobox is labled unit of measure and contains two options - inches or centimetres the label has text of "your total cubic inches/centimetres is:" - followed by the unit of measure selected.the buttons are labeled save, calculate, print, print preview, and exit.Having said all of the above, the save, calculate and exit button code is easy enough and is good to go - it's print and print preview i'm stuck on the solution i'm after is to take those values and send them to an rdlc report that immediately prints (calls up the default printer dialogue) without preview or anything when the print button is clicked and also have a print preview function as well for when of course the print preview button is clicked.The report has already been created with the titles mentioned above..

View 1 Replies

Base Class With Shared Fields And Functions Good Design ?

Apr 22, 2010

I've got a BaseDataClass with shared fields and functions

CODE:

I have several classes that derive from this base class. The derived classes have all Shared functions that can be called directly from the BLL with no instantiation. The functions in these derived classes call the base Init(), call their specific stored procs, call the base CleanAll() and then return the results.

So if I have 5 derived classes with 10 functions each, totaling 50 possible function calls, since they are all Shared, the CLR only calls one at a time, right? All calls are queued to wait until each Shared function completes.

Is there a better design with having Shared functions in your DAL and still have base class functions? Or since I have a base class, is it better to move towards instance methods within the DAL?

View 1 Replies

How To Create Reports In Application

Apr 27, 2009

I have developed a windows database application in vb.net 2008 express and sql express 2008. Is there a way to create reports in the application?

View 2 Replies

Get List Of Table Fields When Using A Class (function Or Method) In Design Time?

Aug 2, 2010

Let say I have a function inside a class which require 4 parameter (table name,field name,field value, return field) When I use this function my form, such as

myclass.Search("customers", <-- after pressing the "," a popup list will be displayed that contain all the fields in "customers" table.

View 19 Replies

IDE :: Design A ContextMenuStrip In A Designer Without A Relation To A Specific Form Or UserControl Class?

Oct 16, 2011

in VS 2008, is there a way to design a ContextMenuStrip in a designer without a relation to a specific Form or UserControl class? For example,if you need the same ContextMenuStrip in Form1, Form2 and Form3, in which of them am I to design the ContextMenuStrip? Do I have to add a "pseudo-Form" to the project that contains my shared ContextMenuStrips and create only one instance of that Form, or is there another way? I consider this a programmatic hack, that's why my question is whether the IDE offers something better.

View 10 Replies

Add Crystal Reports To Deployed Application?

Sep 27, 2010

I want to know how i can add reports either crystal or microsoft to a folder called reports in my application and then for them to be displayed in my menu tool bar under reports and then for them to run once clicked. I know it can be done its just how it is done.

View 2 Replies

Multithreaded Application And Crystal Reports

Nov 16, 2009

I have developed a multithread Windows Application that requires to print various Docss/rpt's off. The problem is I get a "Load Report Failed" error message when creating a new instance of my embedded crystal report.

View 3 Replies

Design Patterns - Inheritance - Do All Properties In The Derived Classes Have To Be Declared In The Base Class

Aug 8, 2011

Background:I have a base class and several inherited derived classes. The derived classes don't always need to have the same properties. If any properties are shared among the derived classes, those properties would live at the base class level ('Contents', for example).Similarly, GoodDocument below has 'GoodThings' but would not want/need to have 'BadThings'.I want to treat instances of both 'GoodDocument' and 'BadDocument' as type 'Document'

public mustinherit class Document
public property Contents as string
public sub new()...

[code]....

View 3 Replies

DB/Reporting :: Deploying .Net Application With Crystal Reports?

Oct 8, 2008

I have a project that uses a crystal report and I'm planning of deploying it.The problem is, is there a common setup for the components that was used in my project so I don't need it to manually register on the client pc?

View 2 Replies

Design For .NET Scheduler Application?

Jan 27, 2010

I wish to develop an application in VB.NET to provide to following functionality and hope you can give me some pointers on which direction to take.I need some kind of "server" type component which sits in the background monitoring request from users and performing various task. (this component can be install locally or centrally)
The users submit an instruction to the "server" to perform a certain task at a designated date and time. (or perform the task straight away)

The "server" would perform the task at the desired date and time and inform the user the result of the task.I have thought of using a central database to which the user writes the instructions. The "server" could read from the database to obtain the instructions, and write the result back to the database.

I want a fast reaction to the instructions, so the "server" must poll the database every few seconds; I fear this may be detrimental to performance. Also how do I get the server to perform the task at the desired time? Again checking all outstanding tasks against the current time is not very efficient, so I thought about utilising the Windows Scheduler, but I am not sure of the best way of integrating this functionality.

View 2 Replies

.net - Porting Crystal Reports Application (VB 2003, Framework 1.1)?

May 17, 2012

I've been asigned to a new project. I have to mantain an application wich was made in Visual Studio 2003 (VB.NET, Framework 1.1) and Crystal Reports wich came included with the IDE. The application is absolutely what we call "legacy code" :).Just to make the test, today I've tried to convert the application in Visual Studio 2010. The converter is offering me download SAP Crystal Reports, with no cost and no registration.The question is: Does anybody has experience with this components?. Is feasible to migrate an application as described to VS 2010?

View 1 Replies

Application - When Try To Run The Publisher, It Fails And Reports That It Is Missing An XML File

Feb 22, 2009

I have just written an application in visual studio 2005, and would like to publish it for use on another computer. When I try to run the publisher, it fails and reports that it is missing an XML file that is located in the bin folder. I have checked the bin folder and the file is there. I am not sure what I am doing wrong? Has anyone else seen this type of error before?

Also, I should point out that while I was creating this app, I would some times copy the project to my desk top, and then change the name of the project folder. For example: myProgramV0 would be come myProgramV1. Then I would copy this back into where I normally keep my VB projects. I do not know if this had an effect on the program or not.

View 1 Replies

Database Application Design Recommendations?

Mar 22, 2012

The main purpose of the my app that I need your help with is, to deliver an always (or close to) up to date a list of files for the user to choose from for a variety of common purposes. For instance, opening the selected file in its native client editor application so the user can make changes. Another purposes would be to print the file, and I have others.

If nothing else (meaning recommendations for a better design that still keep my desired in mind) I'd like ideas on how to update my complex DataSet (background processing options, what's the most efficeient/quickest way to update my DataSet) as the list of files changes while my app is running and my app is designed to never close due to the long amount of time it take to load it initially.

The list must be always kept up to date while my app is running because not only the intial loading of data takes a lot of time but updates (new/modified/deleted) could potentially take too long depending on not only how much data to update/add (new files) but how efficeient my code is in updating the list. To be perfectly clear: If a new file is created then it need to be somehow (automatically preferably or manually i.e. button code) add to the list. If a file is deleted then it needs to bet removed from the list. And if the file has changed, perhaps some of it metadata or thumbnail image have changes so update the file's data in the list. All of which (new/modified/deleted) need to be as real-time as possble without degrading the server too much and without the user waiting more than a handful of seconds.

Listing all the files as quick as possible whether that be with or without metadata initially is very important because most of the time the user is going to filter (or scroll the list by typing) for a partial file name. Once the user filters/scrolls to the desired file there's a very good chance that he/she isn't even interested in the metadata, most of the time the user wants my app to open the selected file in its native client editor application so he/she can view or modify the file. The initial
load time of the data doesn't concern me as much as updates because the user can possibly do other things while it initially loads all the data as long as it not too long (more than a few minutes). From there the updates will either be automatic if possible (most desirable from a users standpoint) or the user initiated (e.g. button). Plus I'm thinking the updates might need to be done with a few different background processes (multiple threads) because I think I need one for periodic updates (e.g. every
15 minutes) and one background process for page updates meaning whatever the user has either scrolled to or filtered for, more accurately all files currently display to the user will be systematically update in the background so the user can still operate my app.

I'm currently using SqlDataAdapter.Fill to fill a DataSet object variable (which is bound [BindingSource] to a DataGridview control) to first populate the DataSet from the SQL query and then prorgammatically adds records (DataRow) for local files but please make recommendations. I don't mind big changes or starting over if necessary, I just want the best app possible based on the aforementioned criteria. I'm not sure if it complicates matters but I've also added custom columns in the DataSet for some special needs (thumbnail of files, booleans for tracking custom statuses). For the local files I'm currently populating the DataSet prorammatically (iterating a path/file string collect made by System.IO.Directory.GetFiles) since the list is first (and very quickly) populated with Vault files (which is always a far larger list than the local files) so . Again, I don't have to take this direction, make recommendations.

View 11 Replies

VS 2008 Application Design Opinions?

Sep 17, 2009

I am making a small application for a friend, to help her update her website. The website is a very simple one, using a menu (table of links) in one frame, and the content in the other frame. The content consists merely of pictures, with some information (text) below each picture. Because my friend has no clue how to change her website (let alone upload it and the images to the right FTP folders), I decided to make an application that does that for her.

I had decided on the following design, but now I'm having second thoughts whether or not it's a good idea:

1. I use a Database to store the information and path to each picture.

2. I generate the content HTML files completely from scratch every time an update is required, retrieving the image path + info from the database and generating the correct HTML code from it.

3. I save the HTML files and upload them + all the images they use to the FTP.

She can now add, remove and/or edit any items in her website, in each category, and it works fine at the moment. But there are a few problems:

1. When she decides to remove a picture (from the database), the actual image will stay on the FTP server. She only has a maximum of 100 MB capacity, so having 50 unused images on there is not very efficient. To remedy this, I simply remove all the images before uploading the new website, so there will only ever exist the current images.

2. When her site gets larger, the amount of images will increase, possibly to about 80 MB. I don't think she'll want to wait for 80 MB in pictures to upload when she only changed a typo in one of the picture's descriptions.In the past, the whole site is uploaded at once without considering which changes were made, so that wasn't very good. I decided to keep track of which categories were changed, and only upload the categories that have been changed. This reduces the amount of images to upload, but there still could be around 10 MB in a single category, which is acceptable but still not ideal.

3. The images she has chosen have to remain on her computer, because they are uploaded again every time she updates here site. If she removes them, they will not be found and cannot be uploaded. Now, the images would still be on the server, so there really isn't any need for her to keep the images. But, due to point 1, they get deleted, so I don't have them anymore.

View 2 Replies

.net - Displaying Data In Reports For ASP.net?

Jun 22, 2012

I would like to know if there's anything that can display data differently than what's stored in the DB.Here's my example. I have a column called Active and in the DB table, 0 represents Active, -1 represents InActive.In my report, when showing whether or not a listing is Active, I'd rather have the words Active and Inactive rather than 0 and -1.

View 3 Replies

How Are Data Reports Created

Feb 9, 2010

how are data reports created in vb? explain also the use of it

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved