I want to populate the tree view from database for diff crystal reports name in such a way that i have :
[Code]...
So when user clicks on the caption node and presses the button, corresponding report has to open.
I am trying to figure out how to export a crystal report into a PDF file from an ASP.NET application. I got it to work, however, I want the group tree to show up as bookmarks in the PDF. From what I've found on google, the way to do this is to declare an instance of the CrystalDecisions.Shared.PDFFormatOptions class, then set the GroupTree property to true.However, this class does not seem to exist. I don't know if its because I am using Crystal Reports for Visual Studio 2008 or what, but it is not there. There is a class called CrystalDecisions.Shared.PdfRtfWordFormatOptions, however, the GroupTree property does not exist in this class.
View 2 RepliesJust wondering how I can populate the child node in the following coding (I am able to populate the parent node but still wondering how to list out the child nodes)
===Extra Info===
I have a class to retrieve the Category Table (CategoryID, CateogryName, ParentID) and stored it via List<T>, when I need it, I declare CateogryDAL pass it to CateogryData.
[code].....
Since there doesn't seem to be any way to load old VB6 (ActiveReports) reports in .Net, I need to recreate dozens of reports in .Net. I'd like to do this in the least painful way possible.In VB6, the original authors simply did something like this for every report:
adoConn.ConnectionString = globalConnectionObject.ConnectionString
adoConn.Source = ReportFunctions.GetAllUsers()
GetAllUsers() returns an SQL string which selects a bunch of fields; those fields are then used in the report.Now:How can I do something similar in .Net (either using the built-in Crystal Reports, or the built-in "Microsoft Reporting Technology")?I can't get "Database Expert" to recognize globalConnectionObject (an ADODB.Connection object); and if I fill a dataset and do
report.SetDataSource(dataSet)
It tells me "The report has no tables."How do I populate a Crystal Reports report!? (the connection string/data location is not known at compile time)
The database strutcure is:
Id Name ParentId
1 File NULL
2 Open 1
3 Save 1
[Code]....
I am using the database PostgreSQL.
I am trying to learn how to populate a tree from a database, I did this same thing back in Vb6 and am trying to learnhow to do it in VB.Net, but I am having trouble with the code. From looking on the web I have piced this together, but I think it may be far off. It just jumps out put leaving the tree blank; and it gives no error message. I put in a try error catch and it cannot convert the data to a double, but even if I take this out it does not work. It is stuck at the line with: dr("CustomerID") <> hID I was using this to check for a parent node, I can take it out, but it still does not work; I am afraid that I am be way off here. I am using the Nothwind database.
[Code].....
I am working on VB.NET(Visual studio 2008)..I completed developing my application and i need to deploy the application. I tried it and faced problems in some areas like adding crystal reports to the setup and deployment. I created a setup file to my application and everything is fine except crystal reports...its showing the error like; An error occurred in crystalDecisions.Reports, crystalEngine threw exception.
View 2 RepliesI've used programs before which have a treeview type panel which has a text box... what is this and how can I do it?
View 4 RepliesHow to generated crystal reports?
View 1 RepliesI have a list of my menu strip in a table with columns
1.SlNo
2.Menu Name
3.Menu Parent No (SlNo of Parent Menuname)
I need to load this menulist from table to a tree view. As if they are in the Menu Strip. That is Sub Menus Should Come under Appropriate Main Menu upto 4 levels of sub menu i use.
i have a treeview filled with directory structure, now want to drag some file name from treeview and drop it to GridView.
i tried with the Item_Drag event it works for drag only...but GridView's DropOver event doesn't work what can do ?
I want to select a node from my tree view, whatever I select is going to get a record from my database, I need a unique ID in each node so it will collect the correct document relating to the selected node.
How can I do this? the name of the node maybe used more than once? Each row in my database has an ID and Title, the title is the name I guess the ID being unique needs to be tied in somehow.
I have a program that uses crystal reports and sql database. When I right click and try to click report in my program on my formreportviewer I get this error.
Conversion to "" to type integer is not valid.I have been looking for days. How can I find where this error is happening??
I'm running through this tutorial found here: report_from_multiple_tables.htmwhich teaches how to pass a parameter text field on a vb form to an embedded Crystal Report in visual studio. I've followed it all the way through however when I attempt to build, I received the error:
Name 'CrystalReportViewer1' is not
declared.
[code].....
I have this code where I get the tree view of a table in access database..what I want is ..I want to add nodes on each base on it's ID...
this is the table
CODE:
And the treeview's output will beme will be a child node of Pet base on ID_Menu same as the ID...
I thought I was done with the tree view control until i realised that my tree view control was behaving differently when it came to sub nodes . I have attached my treeview pic and also a sample tree view.
(-)D:
|_config.msi
|_netfile.sys
[Code]....
Since I clicked on subfolder1 i was expecting the msgbox to display D:Folder1Subfolder1 but unfortunately the msg box doesnto even have the name of the node i clicked on but when i use selectednode.text I get the correct node text. Anyways why isnt my full path working. I then tried manually designing the entire scenario using tree node editor and the code which i mentioned above works. But whenever i populate the trr programatically the above problem starts.
how to create Crystal Reports for Visual Studio 2005 for a Client Server application? The problem I faced is that when I created Crystal Reports for Visual Studio 2005 where the Crystal Report is displayed in the client application it does not get refreshed with data entered. It only displays data that was entered during the time of development. I think this is probably because the database path changes when deployed in a new environment while the Crystal report keeps referring to the database location at development time.
View 1 RepliesI am using crystal reports in visual studio 2005 to generate invoices. I want to sort different categories of products. I'm using group by on category field. How can i set a specified order in crystal reports for categories.I have for example 3 categories namely 'Recipe', 'Plain Spices', and 'Horeca'....The crystal reports shows them in ascending or descending order but i want Recipe data at top, then Plain Spices and Horeca in the end...!!How can I achieve this in my crystal report that has already been made?
View 2 RepliesThe vb.net code for populating tree view from the SQL Server Database is given in following link: [URL]I tried the code given in the above link to solve my problem but I was unable to change the code of SQL Sever for Postgres Database. I want to do the same thing using vb.net and database Postgres.
View 1 Repliestell me wat is the difference between crystal reports created in vb and in vb.net??how to create crystal reports in vb??
View 1 RepliesI'm trying to make alterations to an existing Crystal Report form in a VB.net project I've inherited, and it's my first time using Crystal Reports. For clarity, I'm using Crystal Reports under Visual Studio 2010, not the standalone Crystal Reports.I've had a good go at looking through all the functions and variables listed in the CR Designer, and can't find what stored procedure is being used to call for data.
View 1 RepliesI have some Crystal Reports connecting to a Sql Server db that I would like to detect whether the connection is trusted or whether I need to supply the log on info (reports are not supplied by me so I can't control the connect method). If I just blindly supply login credentials, it won't connect if it is a trusted connection.The following does not work:
oRpt = oCR.OpenReport("C:MyReport.rpt")
if oRpt.Database.Tables(1).ConnectionProperties.Item("Integrated Security") = True then
'trusted connection[code]....
It gives the following error:Operator '=' is not defined for type 'IConnectionProperty' and type 'Boolean'.
I cannot find how create a construct in vb.net for IConnectionProperty. I can't find any documents from Crystal that explain it.I am using Crystal Reports XI - Developer
I'm trying to use crystal reports in my database that i have made using vb 2010 and access 07, I'm trying to make a new crystal report in vb, have gone add new item, crystal report, etc but when i go to specify the new connection using the Microsoft office 12.0 access database engine )LE DB provider i keep getting a catastrophic failure error 0x8000fff?
View 2 RepliesI'm using crystal reports 9, visual studio 2008, and oracle 9i in this project I'm doing. My crystal reports pull data from an oracle database, and are displayed on a CrystalReportViewer on a windows form. How would I make this connection using vb.net code?[code]...
View 1 RepliesI have deployed a Visual Studio executible module written in VB Net 3.5 SP 1 with Crystal Reports. When the user tries to view a report(s)they are prompted to login in to the data base that has been data sourced into the report module. The correct database was verified before the build was made. The developer is able to run the report in a run mode on the local machine where the VB project was created. In the properties section in the project the following check boxes pertaining to reports were checked on:
Crystal Reports Basic for Visual Studio 2008(x86, x64)
Microsoft Visual Studio 2008 Report Viewer
Notes: If the executible module is deployed to a machine that has Visual Studio 2008 installed, the Reports run fine without a database login prompt.If the executible module is deployed to a machine that does not have Visual Studio 2008 installed, the user is prompted for a login. The data base is a SQL server 2008 database.
When i make Setup of my project then my crystal reports keeps old database path how can i resolve it please help me.
View 2 Replieshow to create a setup in vb.net that comes with a ms access database and the .net framework if it is not existing in the system.. and also a crystal report... and also i want my database go automatically to C:
View 9 RepliesI am creating a visual basic project for class. It is all running as intended though I am not sure how to set up the login to database function. When you click the link for the specific report it should display the page. But I get a login to database page. I am just wondering how I set that up so that one can actually see the information. ie:
[Code]...
How do I open my Crystal Report in VB code (RPT files) on password-protected Access 2007 database? Ever since I protected my database with password, my Crystal Report generates an error.
View 3 RepliesI 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 Replies