i 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 am developing a vb.net windows application with crystal report and ms access. My database is stored in bin folder. I cannot bind database to report after deployment. How can I set the database location in report?
View 3 Repliesdim cn as oledbconnection
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:valid.mdb")
[code]......
I'm developing an application which relies on several files to be copied over to a specific location on the users hard drive ("C: est") when they run the program for the first time, and am having a hard time wrapping my head around how to account for the fact that the original location may be in a different location for each user.
Any ideas for either getting the path where the files would be and then copying them to the desired destination?
How to create a dynamic report?
View 1 RepliesI 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 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 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 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 RepliesI created a button instead of the print button in crystal report because i need to record the report printed report serial number, date and time to the database. when i click on the button, dialog box appear. if i click on the ok button , system record the printed report details to the database and report printed successfully. but when i click on the cancel button , system again recording the printed report record.
[Code]...
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
Is there any way to set the crystal report data source location to the application.startup-path?
have a nice day
im from malaysia andive been using this forum for months now as a guide an reference for visual basic coding.i never posted a question before as i could find all the the answer to my problems in other user's thread. this is my firs post, as i cant seem to find the answer anywhere here.
[Code]...
directly here is the issue:a "OpenFileDialog" on a windows form is made to choose a picture and then insert it into a rdlc report under VB.net 2008 so i need the exact command to access any picturebox in the rdlc report.
i used to do the job under VB6 as the following:Set ReportName.Sections("SectionName").Controls("Image2").Picture = LoadPicture(fileName)
how I can reference a report variable in the Report Properties Code Window of a local report? I have tried Variables!Claimant.Value (for a variable called Claimant) but I get an error "Reference to a non-shared member requires an object reference." I have tried qualifying it with Report. and also with the report name in front of it but I get errors with this also.I have the variable CLaimant defined in the Variables section of the Report Properties.
View 3 RepliesI use VB2008 and database access and Crystal report.my problem : when ever I change location the database. I will always change location in my report from crystal report. It's very difficults and waste the time because I have many report. how to set up location only 1 place and impact to many report.
My VB Code :
Dim dbname1 As String = "D:AF_SoftwareDBDBAF1.mdb"
Public Strcon As String = "Provider=microsoft.jet.oledb.4.0;data source=" & dbname1 & ";jet OLEDB:Database Password=999"
make code in crystal report , if i want change drive to drive Z / or somthing else.now, i am go to the report and click change location.
I am pretty new to the vb community and very new to this forum. I am glad I found this place too because its an extremely helpful place due to how much time a lot of you have put in helping others and such; great work.
Well on to my question that I wasnt able to find out exactly using my search. What I want to do is use opendialog to select a location to an access database and then take that location, and use it to update my connection string db location. Would it be possible to edit the path at runtime like that using an opendialog? Also, if that is possible, would it be able to save that location to the program so that I wouldnt have to be edit again. The reason why I just dont hardcore the location into the database is because there will be many different computers that the program will be installed into and the person I am making this for wants the flexibility to move the database around at will.
I am using the following code to establish a database connection to my datagridview and Access database. Here I am giving my file path name to the connection. This code works fine only on my computer. To make this code run on another computer I need to change the database pathname in the code. Is there anyway I can make this connection dynamic so that I can make this program run on any computer
Dim Data1 As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:\Users\Desktop\Work\Visual basic\alldata.mdb")
Dim Case1 As OleDbCommand = New OleDbCommand("SELECT * FROM case1", Data1)
[code]......
In my database I have this "C:UsersLauraDesktopUni AnimationBluedot.gif" in a table called "images" and within a colomn called "image" I thought this code would work but I don't understand the error message I am getting. PictureBox1.Image = ds.Tables("Pipelining").Rows(inc).Item("image") If anyone could give me a hand that would be good
View 2 RepliesI am looking to make a database call based on user input. The line I am using is:general_read.CommandText = "SELECT * FROM general WHERE Business_Name = '" & business_name & "';"
business_name is dynamically loaded from:Protected Sub btnLoad_Click(sender As Object, e As System.EventArgs) Handles btnLoad.Click business_name = txtName.Text
[Code]...
The error that is being shown is: Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.I'm assuming it has something to do with the variable not being set before the database call is made, but I'm not entirely sure.
i am having a trouble about adding a file location (e.g. c:/bla/blahblah)to a database i have my code here
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\WindowsApplication2\Database1.mdb"
AxWindowsMediaPlayer1.settings.volume = 100
[code]....
everytime i add a mp3 file to listbox it should get the file location and pass to the database but it seems my database is empty?
I want to Backup my Database to a location and restore it afterwards. The problem is , i want to keep my program open. I seem to have a problem with this, the connection stays open. How can i do this , close connection and open it again without data loss?
View 7 RepliesI'm trying to construct a database driven VB.Net app that pulls a list of registered accounts from a database and displays the usernames of throes accounts in menu, so the user can select one and a new form open (where they work with it).what I have so far is the constructor for the MDI parent window.[code]What I want to happen is when a user clicks on the context menu a new MDI child form is created and the data in user is passed, however because AddressOf doesn't like passing data this doesn't work.I've looked at delegates and landa expressions but don't think either of them do what I need, the other option is to make my own subclass of the ContextMenuStrip class, which 1) handles the clicks the way I want to and 2) sounds like a nightmare.Before I launch into what I think will be a hell of a lot of work, am I missing something? is their a simple way to do what I want to do? or if not will sub-classing ContextMenuStrip work and if not any ideas as to what will (and if it will, any ideas as to how to start learning how to do that)
View 1 RepliesI often need to change the location of my Access database. Since ini files are outdated can I create a dll file to store the location?
View 4 RepliesI have made a small app with a SQL Database, published and installed it on my desktop pc with the express version.What directory does .net place the database in that has been installed.
View 3 RepliesI need to change my [code]...
if i change it under settings it is working but i want to be able to change it in my running application, or when the application is opened for the first time i should be able to put in die path for the database.
I need my program to connect to a database within my application i.e.What I have:
m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = C:Documents and SettingsmeroneyfMy DocumentsVisual Studio 2008ProjectsAsset Manager 2008inDebugDatabaseAssetManager.mdb"
What I need is: m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = DatabaseAssetManager.mdb"
I have used:System.Windows.Forms.Application.StartupPath & "ImagesSystemDefaultImage.bmp"
for loading of images within the default directory. but this returns the app path but also includes "System.Windows.Forms.Application.StartupPath" in the string?