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
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.
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.
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]....
I've been doing research on reporting suites for a project my company is about to undertake, and have narrowed the candidates down to Active Reports and Crystal Reports. During the demo yesterday, it was clarified to me that one of the capabilities our client would like is the ability for the end-user to create custom reports integrated into the Web-Based client. I know that both packages have options for integrating an end-user designer to a WinForms based app, but I can't find a definitive straight yes or no answer for either suite as to whether or not it's possible to attach them to an ASP.Net based app.
View 2 RepliesI am new to vb.net and am trying to design a routine that will allow the user to search for a record and return the results in a datagrid. Then double click on a row within the datagrid to view a more detailed form. I have been able to build the search form but am having problems with the double click event.I found a sample application on the Microsoft web site which is doing this on a smaller scale. The sample is built on the Northwind sql database and searches the customer table when you double click a row in the datagrid the following Microsoft code runs and opens a detailed form.
[Code]...
I am developing an application in which I would like to let the users design some forms and decide the fields that are in the form.An example is better than a poor explanation, so let me put the example of Microsoft CRM in which you as end user can define a form, the fields in that form, or customize existing forms by adding or removing fields.
View 5 RepliesI am designing a database using access 2010 and I ve been asked to design the user interface with Visual basic.I actually have designed tables and their relationship and did some queries according to the requirements. how do I create user interface in VB from this point knowing I don't have any form and report designed in access?
View 6 RepliesI'm redesigning an old VB6 application into VB.net and there is one thing I'm not sure on the best way to do. In the VB6 application whenever we created a new instance of a component, we would pass in the user details (user name and the like) so we new who was performing the tasks. However, no that I'm redesigning I've created some nice class designs, but I'm having to add in user details into every class and it just looks wrong.
Is there a VB.net way of doing this so my classes can just have class specific details? Some way so that if my classes need to know who is performing a task, they can get the information themselves, rather than having it passed in whenever the objects are created?
This is a related to my last post, but not enough to make sense as a tag on question.I have a collection(of myClass) that is exposed as a public property in a user control.When I add an item to the collection in code I would make the call collection.add(new myClass) and of course the constructor for myClass is called.When I add items to the collection via the design time menu the constructor for myClass is not called.... of it it is called, I can't see any evidence of it.
View 3 RepliesI'm trying to make a simple User control that houses one collection of a class that I've made. After building the control All works as planned and then randomly when I try to go to the design time interface for the form I placed the control on I get an error page with the following:
To Prevent Possible data loss before loading the designer, the following errors must be resolved:(ignore and continue: which about half the time works and the control shows up and the other part of the time all of the controls on the page are missing)
The one error is the following:Object of type'System.Collections.Generic.List'1[StaticGraphPlot.clsStaticCurveData]' cannot be converted to type System.Collections.Generic.List'1[StaticGraphPlot.clsStaticCurveData]'.
[Code]...
I have a multitude of VB .NET programs that generate reports in Excel that I populate from an SQL Database locally. My boss wants me to port all these to ASP.net so that users could then access these reports with dynamicly generated results on a browser page.Before jumping onto imbeding Excel objects using ASP.NET from the code I have in VB .NET I was wondering on what kind of approach to use. What could be the most effective way to convert/display these reports in real time to the user via a Browser?
View 1 RepliesI have created a user control that mimics what a label does. I realize I could have inherited the label control, but I am working on understanding the process. I wish to add items to the control. normally (in the code of my project) would do:
Form1.Label1.Controls.Add(mylabel)
After creating mylabel in the code of course.
[code]....
I have a UserControl class in a Windows Application project. One of the properties of it is a collection of another class that I have defined. I can't seem to find a good example of how to get the standard collection editor working for it at design time.I got it working using some example code I found to a degree, but the data in my collection doesn't get saved. When I exit the form and open it back up in design time the data isn't there any more.Here is my class:
Public Class Gauge
Inherits Control
Private WithEvents _Captions As New CaptionCollection
[code].....
I'm trying to hone up on my (beginner) coding skills & I would prefer that the the 'Designer coding window', not the 'Design window', wouldn't interfere with these studies. Sometimes it's there & sometimes it's not. I don't understand it at this point & would prefer it wasn't there. All I need is the 'Design window' & the 'regular coding window'.
View 2 RepliesI have the following Query:
SELECT *
FROM tbl_Muffins
WHERE OvenLoadId IN (
SELECT OvenLoadId
[code]....
The idea of the query is that I want to specify an OrderId, and I want all Oven Loads that have items from that order in them, as well as ALL OTHER ITEMS in those loads, even though they could be from other orders.The query works as expected, but I'm not able to use it for my Crystal Report I've written it for.I have put this query into a User Defined Function, however I'm unable to use a call to that function as a table source in my Crystal Report. I am using Visual Studio 2003 (I know it is old, the client refuses to upgrade).
I am creating a user control that contains a panel as well as 4 string and integer properties. I would like to display the text of the properties in the user control during design time.
View 3 RepliesI am creating a User Control where I have a property called Items. Items is of type LibraryPanelBarItem Collection (custom class) which contains a collection of LibraryPanelBarItem objects. I would like to be able to add these at design time by using the Collection editor that VS uses for adding things such as treenodes/listviewitems. Ideally I would also be able to declaratively add them to the html syntax. I can get the Items property to show up but I get no intellisense to add the items between the opening and closing tags. [Code]
View 1 RepliesHow can I basically lock a default property so the user cannot edit it? For example, if I wanted to lock the BackColor property, how can I make it so the end user of the control can't edit it?
View 1 RepliesI never got into detailed error processing too much when I played in VBA/VB6 a lot. Mostly then, if you ran into a user error (such as some input of theirs failing a validation test of some kind), you popped a MsgBox() with some error information and the critical (or warning) icon, and safely aborted out of the code
In .NET, my reading basically points to exceptions as the end-all in error handling. It looks to me that if you know a spot of code where a user can screw up, you're supposed to catch it with either try...catch blocks (for things like data conversions), or standard if...the...else constructs for other things, and then throw a new exception if needed.
Isn't throwing an exception essentially a forced crash of a program in a sense (granted, you get the option of continuing)? Or are exceptions geared specifically for things like data conversion errors and other "things that shouldn't happen", and resume use of MsgBox() and friends for minor user screwups?
Consider the case of where you have a TextBox that is only supposed to accept numeric data (or heck, just a specific set of characters). Barring some other trick that lets you restrict that field (let's just assume it's freeform, programatically), it would seem a bit of a waste to throw new exceptions everytime they type in an invalid character, or even if the error checking doesn't happen until they press a submit button (like on a webpage). Popping a MsgBox() seems more sane in that case.
So what's the straight dope on exceptions and throwing new ones on user errors? How about if your program also exposes a programmatic framework? Bad usage of one of the programmatic functions definitely seems like new exception territory to me.
I have a usercontrol which overrides the property Text. But this property is not shown at design time.If I rename it to caption or value it is shown in properties at design time but Text is not shown.
public Class SomeControl
Inherits System.Windows.Forms.UserControl
Public Overrides Property Text() As String
[code].....
I've got a VB.Net form application that dynamically loads user controls based on which navigation link the user clicks on. I'd like to make it easier to use at Design time by putting a link of some sort to open the User Control at design time. The link would go onto the form in the space where the User Control will be going. This just saves a little time from having to browse through the files to open the correct file.
View 2 RepliesI am trying to implement a controlling design logic that prompts the user for a length and the area to calculate until he or she enters a number less than zero in the length to end.So far I have it where I believe it�s doing the calculations but it�s not ending when I input a number less than zero or zero.
Sub Main()
' Declare Length As Float
Dim Length As Double
' Declare s, c, t As Float
[code]....
I am creating reports in Crystal Reports that is integrated within Visual Studio 2008, and I noticed that some of the features are disabled. One is the ability to link tables with a Right Outer Join or Full Outer Join. I also cannot "Show SQL Query" in Crystal Reports. Is this something I can enable or do I have to purchase or upgrade?
View 1 RepliesBasically, I am looking for a method on how to preview reports from a datagrid or it can be from the access database which populates the data to the datagrid (then displays this in the datagridview) in vb.net vs 2010.I believe there are two methods using the ReportViewer or using Crystal Reports, but so far, I have no idea how to get them to work. The first idea would be favourable - using the data from a datagridview (which may of already been sorted, filter etc) and be able to produce a report on that.
View 1 Repliesi am developing an application in vb.net having crystal reportsi have stored all my reports in a folder called report in my applicationbut initally when i executed i got a error msg like the report doesnot exixts in debug folderso i copied all the reports from report folder to debug folder & its workingany changes that i mke in report folder needs to be copied into the debug folder alsois it possible that the reports be executed from reports folder only & not from debug folder as everytime i need to make changes in the debug folderhow can i chnage the path to reports folder
View 1 RepliesI have created my webpage in asp.net in 1024*768 resolution, my problem was that when i change my monitor resolution then the controls in my webpage will be displayed in unmanaged manner .
How to arrange items in my webpage which support multiple resolution ...
Whatever the resolution of my monitor the controls in my webpage will display as it is as managed in 1024*768 reolution !
I seem to have reached a limit on the size of the form. I cannot make the form longer and I need to add more fields. Is there a limit on how many fields can be included in a form?
View 1 RepliesI'm making a control and I am trying to finalize my design time properties grid. I have several List(of Class) items as public properties and when I click on the design time menu (while testing the control) there is the word "Collection" and a button with an ellipsis (...) that brings up a neat pop up with the buttons Add/remove and all of the public properties of the collection's class on the right hand side. Basically for a non-collection instance of a class (with public properties) I'd like a similar button to show up. I know I could put all of the properties in the main control class and group them, but I like the pop up box feature. Anyway to duplicate this? (think font grid item etc.)
View 3 RepliesHow can we create a report in vb.net without using any crystal reports
View 11 Replies
