I need to make a report but my columns will be chosen in run-time. I used to make report with crystal report by filling my data to query table and connect this query table with designed report by crystal report. but this time the user will choose the fields in run-time.
View 3 RepliesOn runtime about the number of columns to show (mainly remove columns that are available and then shift the remaining columns).. I can view the reports in a report viewer normally all I need is to be able to edit the columns in run time.
View 1 Repliesi have tride to generate report by using in built functions of report viewer. but it disply only the default color in to the legend. in my report i am showing chart report by using student marks and their name. the chrt bar color get changed as per the students marks means if student is pass then the the report bar display with green if failed then with red color i want to show the legend with student pass and fail status but on my x axis i have given a only a marks column value and it s showing only marks lable in legend but i want to show it with their status means pass with green color and fail with red color if anybody have the answer of this query plz reply immediatly
View 1 RepliesI have a variable defined as follows:Dim iRows As List(Of String())I've also been converting that to a list of lists just to make it easier to work with.Dim iRows As List(Of IList(Of String))I would like to bind that list to a GridView using the contents of the nested array/list to dynamically define the columns. I don't know ahead of time how many columns there will be, but I do know that they are all the same throughout the list.
View 2 RepliesHow to create a dynamic report?
View 1 RepliesI have a table called Foo and I have two columns: Lorem and Ipsum, so the scheme of the table is:
Foo(Lorem, IpsumID)
I also have a table called IpsumTypes, which looks like this:
IpsumTypes(IpsumID, IpsumName)
I would like to write a LINQ query which will have the following result:
Headers: Lorem, IpsumName1, IpsumName2, ..., IpsumNamen
Values: Loremi, count(IpsumName1), ..., count(IpsumNamen)
Each row represents a group of Lorem value and the number of each possible IpsumID in the group. New rows can be added to the IpsumTypes table, rows can be deleted too, so I need dynamically generated columns, because at the time of writing the code I'm not aware of the possible values of Ipsum. How can I achieve this? Is there a magical Linq query which solves this problem, or should I get the values from the database and parse them separately, if speed counts?
I am trying to generate a report using Crystal studio that takes a public variable from the vb.net application. I think the best way to do it is to just dynamically give the filter to the report at runtime, but I can't figure out how to set it up to take any information at runtime.
View 1 RepliesI work on representation layer . My friend work on datalyer( back end) I only get a value which is datatable type. How can i show it to crystal report.
View 3 Repliesi am using b.net 2005. i am generating a crystal report. but when i work in a different computer i have to set the location of the database of the report before i generate. is their any dynamic way to set my database location to the report.
View 1 Repliesi am generating a crystal report. but when i work in a different computer i have to set the location of the database of the report before i generate. is their any dynamic way to set my database location to the report.
View 2 Repliesi want to make a dynamic report in vb.net 2005 any one would like to i wish that at runtime i would be able to add some column or remove
View 12 RepliesI've been googling around to find a way to dynamically assign a DataSet to an rdlc report but i was unable to find a clear method to do it.Does anyone know if there is a way? I end up trying to use this method because i also found no way of adding parameters to the rdlc report. The VS documentation is vague on this issue..
View 4 Repliesbuilt rdlc report with report wizard, now i want to add columns dynamically to existing rdlc report instead of adding columns of drag them from the data source. i am using vb.net
View 2 RepliesHavent done this yet, trying to figure it out, I have been reading different post concerning temp tables to use with a report viewer and have been left confused. I have 2 tables that I would like to combine certain columns with to use in a report viewer.
I can itenerate through each table to retrieve what I am wanting, but how do you create a temp table to use in a report viewer? Will this table use an adapter and binding source?
I re-wrote this to make it more readable. If you want to skip right to the chase, look at the ALL CAPS comments in the code blocks. All necessary code has been included for debugging. I've searched multiple forums (including ASP.NET), and the MSDN library and cannot fix this >.<
[Code]....
GridView SORTING of DYNAMIC Columns and Data Source Scope
View 2 RepliesI would like to add controls like textBox in GridView from code on the fly.
In my project i have one Grid in that i can't decide how many rows and columns are there. so that i just give it DataSource. This working fine. [code]...
Is there a way to dynamically create properties at runtime in VB .NET using introspection?
e.g. Suppose I had a class
Public Class Foo
Public Property Bar() As String
get
...
end get
[code]....
Is there a way to create property Bar at runtime?
I have a .NET library which I know can be fairly easily linked from VS project to reference it from code. However for security reasons I want to place the DLL file in another location on the disk and reference it from code including executing methods and passing method parameters. What is the proper technique to accomplish this?
View 4 RepliesI am trying to create a number of objects depending on the width of a row of an array, is there a way I can change the name of the variable being Dim 'd as I don't know how wide the array will be.
I have been trying something along the lines of:
pseudocode
For x as integer = 0 to UBound(MyArray,2)
Dim Object & CStr(x) As Object Type
Next
Is there a simple way to re-ordering the columns of a DataGridView that are bound to a DataSet at runtime?
I can do it simply via the DataGridView "Edit Columns" dialog at design time but have to remember to do this every time make changes to the form (remove or add the DataGridView to the form).
I'm new to VS 2010 reports. I build an rdlc report based on a a table with 18 columns. From these colums, 3 of them allways have the same content so i would like to put them at the report header. When i do this i get a page for each single record, which is understandable. I worked with other tools that allow me to build report headers beased on SQL queries but it seems that VS does not allow such thing. Will be there any way to achieve what i want?
View 1 RepliesI know hoe to add a control at runtime to a form, what I would like to know is if there is a way to add code programmatically at runtime as well?
[Code]...
I have a .NET library which I know can be fairly easily linked from VS project to reference it from code. However for security reasons I want to place the DLL file in another location on the disk and reference it from code including executing methods and passing method parameters.
View 1 RepliesI use VB. NET 2008. I'm starting to work with the Tab Control and command will want to know about techniques such as adding tabs at runtime using this control.
To illustrate what I'm saying, just take one checked on your browser or in the VB (Start Page, when we add other forms to our project).
i have to convert html page(report which is dynamic in nature i.e. different for different user to pdf at runtime how can i do that.
View 6 RepliesI am working with a simple game idea. I wanted to have two players running around shooting each other (very low graphics, like circles and squares). I've got this far; I have the ability to move around both characters, and change directions etc. ive also been able to set up my shooting. Only problem I run into is getting the bullet to move! I cant use a preset timer, because if I used that, I could only shoot one bullet at a time, so I would need to create new ones dynamically.
So my question is; how does one add dynamic timers to a form on runtime, and alter the tick sub so that it moves the picturebox (bullet) and once it can be moved, (I was thinking about using player locations in relation to the bullet, and if they were equal than the health would go down or whatever, but unfortunately, this means it would have to be directly in the middle of the player, which would be odd..
This for a semi-automated application. Basically the user provides a list of parameters (entered as an offline spreadsheet). The application automatically selects the required report and logon information. Each line in the given spreadsheet will be used as parameter values for a certain report.Therefore the requirements for this (vb.net) applicaton include:
- dynamically select a different Crystal reports
- each report may read data from different tables from an Oracle database.
An old application of mine that had done something similar and it works normally. Those Crystal reports retrieve data from a SQL server stored procedure. (The stored procedure reads data from Oracle using linked server concept). I do not have to set the logon information dynamically in the vb.net code because every report uses Trusted Windows logon concept. The application can also pass dynamic values to different Crystal report parameters without problems.Then I modify this old application for the required new set of Crystal reports. Because these reports access Oracle database via ODBC and not every report reads from the same Oracle schema, it appears I have to write codes to pass ODBC Dataset and its logon information (the users do not want enter it everytime). The application does not run after the change. The report printout shows blank. Although I can accomplish what is needed by modifying each report to use Stored procedure. But this is not prefered and not a simple task because of the number of reports.I have tested each report and it does run normally in interactive mode.I am not sure if I need to write codes to set the datasource for these 'new' Crystal reports. In my test codes I set the reportsource for my CrystalReportViewer object to an non-typed report. Is there anyone who can show me sample codes that
1) achieve odbc logon
2) select a report dynamically for preview/printing
3) pass values to parameter
I want to allow the user to select which table they want to be displayed in the datagrid by selecting the table name from a comboBox - this bit I have managed but I want to limit the number of columns displayed. Each of my tables have the same fields (it is for a plant database, there is a table for each type of plant tree, shrub etc) so I know the column headings but
View 2 RepliesI have a nested content page within a master page, upon load the the page retrieves from a SQL a list of controls to create (Field Type, FieldName) i.e. String, Username.The function loops around the list creating the controls on the webform in a Placeholder, this part works perfectly. The problem that I am experiencing is the request to obtain the value entered by the user in the dynamically created control, I need to perform this call following postback/callback.
If I take the Content page and make it a standard aspx page with no master page the application works fine. Unfortunatley taking the page out of the master page is not an option (unfortunatley a restriction by my client)