I have my crystal reports file accessing data from msaccess database.now while loading report i need to pass the logon info of the msaccess database along with the database name from vb.net.
[Code]...
I have tried my best but failed so i have decided to discuss with u all about this matter.when i run Given below code on my current system it's OK but when i install this on my client machine then it gives my a window during call Print button event that ask for User Name and Password which are filled according to my setting.But there is no database name that is given by me. Any one can help me about this problem.
Thanx for this.Private Sub btn_PrintOC_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_PrintOC.Click
[Code]...
Iam workin wid crystal reports have a problem i jus want to create a crystal report dynamically not by using crystal report wizard rather by using a blank crystal report and connecting to the database server and generating the report from the database manually....
View 1 RepliesI am exporting crystal reports information into an excel spreadsheet and now I am trying to open up excel so that the user can view the page but however I cannot SEE the excel file. in Task manager there is EXCEL.exe which shows that maybe excel opens up but the spreadsheet is not visible.
Imports CrystalDecisions.Shared
Imports Microsoft.Office.Interop.Excel
Imports Microsoft.Office.Interop
Private Sub btnPrintExcel_Click(sender As System.Object, e As System.EventArgs) Handles btnPrintExcel.Click
[Code] .....
how to Load Image in Crystal report Dynamically?Im creating students id in crystal report.the image is accessible through path "C:mysoftwarepicturesstudent001.jpg"
View 3 Repliesi have a pretty standard crystal report that shows a quote for materials for various customers - i also have a form, lets call it form1 for arguments sake - on form 1 i have two data grid views - one attaches to the customer table, one attaches to the quote table. Customer and quotes are linked on customer number at the database level.
i dragged and dropped these on to the form and they work great, as i scroll through each customer in the customer datagridview, that customer's respective quotes show up in the quotes datagridview.
now the problem - as a third tier, i have a crystalreportviewer that has all the nice graphics and presentation of this quote, company logo, etc etc, i've also done all the standard report sources etc etc, but the darn thing won't cycle through the quotes as i scroll through them in the quotes datagridview.
am i missing something simple? all i want to do is highlight "abc company", see their list of 50 different quotes pop up in the quotes datagrid view, then click a quote number and see the quote display in the fancy smanshy crystal report viewer so i can then print or export or whatever.
dynamically passing image to crystal report from a disk in vb.net 2005
View 1 RepliesDoes anyone know how to pass values from adynamically created gridview checkboxes to a crystal report?Is it possible? I am using asp.net, vb.net and mssql. Here's my grid minus a few boundfields:
<asp:gridview id="grid" runat="server" autogeneratecolumns="False" cellpadding="4"
forecolor="#333333" gridlines="None" emptydatatext="No Products registered for this company...">
<RowStyle BackColor="#EFF3FB" />[code]............
have an application written in Visual Basic, .NET 3.5 (VS2008)... and have reports created in Crystal Reports 2008 .[code]...
I want to change some parameter values when report displayed in report viewer at runtime... The user should be able to modify these values.
I m using .net , I create some temporary tables at run time, how to print these table data thru crystal report
View 1 RepliesI have 6 to 7 tables with state information in them. They all have the same field names. I have a Crystal Report that is based on one of them. I want the user to be able to select a state and change the Crystal Report to use that table instead of the one it was based on.I mean when user select text in combo box and then click on "OK" then report show (using only one rpt for all the tables of same fields).i have the database name"Rajab" in which the all the tables have same fields and structures now the problem is that i have designed an rpt now i want that if user select any table from the list of combo box then through this rpt the data of every table shows. how can i use that rpt for every table because i don't want to use seperate rpt for every table i want to use only single designed rpt for 6 to 7 tables.
View 2 RepliesI have to change my sql server and need to point all my crystal reports to that new server at runtime, some reports has StoredProcedures embeded inside and those are the problems.[code]....
View 2 RepliesI have a report and is working with .netnow i needload images in runtime by passing the values in .net or load the image by dbthe control that i using isthe crystal report viewer, i have found codes in the web that refer this:
"crxReport.Sections(3)""CrReport.Sections("Details").ReportObjects("Picture1")=? "
but with the control what i using i dont have that option :(what is the control that i need load to the project that have that options?or is some especial version of crystal report?
I am working in vb.net, visual studio 2008, with the crystal reports that comes with it. I have a push model: creating a dataset, putting data into it, making that a report source, and putting the report source onto (or into) a crystal reports viewer control (not neccessarily in that order). It works -- for the first page that's displayed.That report has two pages. If I click on the control to go to the 2nd page (where I have no data displayed yet), then on the control to come back to the first page, it displays with no data -- just the background text is there.I can see my dataset-loading code executing in the debugger, and as near as I can tell the database is no longer giving me back any data
View 1 RepliesI have a Crystal Report that I am trying to access thru my VB.Net app. My problem is that I keep getting a "Database Logon" prompt (see screenshot). My code is below and I think I might have more than I actually need. I created the report from with the VS 2008 IDE.
Private Sub rptSingleWorkOrder()
Try
strSQL = "Select A.productName, " & _
"A.productDesc, " & _
[code]....
By the way, this code runs cleanly completely thru from the time the procedure is called until it exits.
how to make a crystal report in Vb.net using ms access as your back.end The purpose for this is about my project i think it's better to use a crystal report rather than to command another application for viewing your file right? ^_^
View 1 Repliesi have done my application that uses crystal report and access database. I try to publish the application but when install on client machine, it wont work. the access database wont load and so the reports. What should i do?
View 9 RepliesI created a report by using crystal report. I used ado.net connection for this. I created a dataset and joined report.[code]This is OK in first load time. And when I clicks print button in report view, the report view ask logon information.
View 1 RepliesI am using VB.Net and crystal Report in VS2008. On Crystal Report I have a database(SQL20005) Column "Address".
I have used "Can Grow" option for that Column to change. But it resizes Vertically. I want to change its Width as Address have different data.
trying to simply change the Server Name for a Crystal Report at runtime and it will not let me. Herthe code below. The database is identical to my development server database. I use SQL Server 2005(SPK 2) and Visual Basic 2008. I use Crystal Reports 2008. When I run the code it accepts changes to the user name and password but igmores any change to the ServerName or DatabaseName
View 5 RepliesI am having problem with the connection between an access database and crystal report. I created a crystal report by using wizard, all working go, but when I run the program in another computer am getting some error on path..wrong path for the database. So I need to find a way to connect database with the crystal report using a relative path...
View 1 Repliesi am using Access 2003 and vs2005,i am trying to add data to my crystal report from my access database,ok. So to do this i followed these steps: Now after all these steps,how to add the column names of the table "Table1" in my crystal report?
View 11 RepliesI am trying to build a setup file which will install my vb.net application with database and crystal report files to the client.
1.) I created my vb.net application in release mode.
2.) I created new setup project and added my vb.net application project in that solution.
3.) Also added the primary output in application folder
4.) [dun know how to add database so] created app_data folder inside the application folder and added the database file manually from add->file
5.) [dun know how to add crystal reports so] created reports folder inside the application folder and added the reports manually from add->file
6.) Build solution.
7.) Tried deploying in client machine.
8.) Application runs fine and works great. But crystal report files doesn't. When i try to open crystal report some long error messages comes in my way.
So I would like to know is the way i am doing to add the database file and crystal report files correct? how can i make crystal reports work in client machine?
My IDE is MS Visual Studio 2008.I just want to ask how can I get the result of a store procedure from MS Access using VB.Net and use the result in a Crystal Report.
I have a Windows Application Project that requires this function.
i am having a Visual Studio 2008 but it not install with crystal report when i open add new item-> its didnot contain Crystal Report how can i add crystal report and make crystal reports in visual studio 2008 how i install crystal report with visual studio 2008 only crystal reports 2008 install and its open with visual studio 2008 when we click Project->Add New Item-> and crystal reports shows in thiis file
View 1 RepliesI want to change "Prompting Text" of a crystal report parameter in VB6.0. When report is connected to View, it is able to change the "Prompting Text" of parameter. But when it is connected to Procedure, it is throwing "Not a Report Parameter".
I found one reason behind this. When we use view, we create parameters explicitly in the report. But for procedure, report will get parameters from procedure. As there are no parameters in report, it throws "Not a Report Parameter".
So how to add prompting text to the "crystal report parameter" from vb6 when the report uses stored procedure?
Technogies using: VB6.0,Crystal Reports 8.5, Oracle/Sql Server
Code snippet:
Dim CrApp As CRAXDRT.Application
Dim CrRep As CRAXDRT.Report
Set CrApp = CreateObject("CrystalRuntime.Application")
[Code]....
I plan on designing a Crystal Report, and then calling it through VB.NET code. Will the end-user need a Crystal license in order to use the crystal report part of the program?
View 1 RepliesI would like to use VBA to change the caption of a report when it opens based on parameters set in the code. For example[code]...
View 1 RepliesWhen i pass the parameter and run the report it works fine as i close the form it closes the form is there any way so that i should be able to close the crystal report viewer and pass the parameter again and should be able to view report again.
View 1 RepliesI got a problem I want to print a report which is receipt having size 3 x 4 cm. i am unable to resize crystal report. i am using crystal report coming with visual studio.net 2008.
View 1 Replies