Visual Basic

FirstPrevNext

crystal report + vb.net2005 hrishiS11-May-09 20:26 hrishiS 11-May-09 20:26  Hi to all, I have vb.net2005 project with crystal report, I am getting an error (for one report )while opening the report after I deployed the project in some other system. In the error, It is showing the same path as my local computer(where i have created the project)where initially the crystal report was there. And asking to specify a new path with a dialog box opened. While creating the setup I have added all the reports and changed the report path as application.startup.... All reports works fine accept one. Why is that particular report is showing the early path?Please help me out. Thnaks in advance ----------------------------- I am a beginner Re: crystal report + vb.net2005 Tiyani Miyambo11-May-09 20:49 Tiyani Miyambo 11-May-09 20:49  This depends on what type of database you using. For instance the Report can work on the Machine you created the report and stop working when you go to other machine. so you have to rebuild the path on the report for it to work on the other machine Re: crystal report + vb.net2005 hrishiS11-May-09 20:57 hrishiS 11-May-09 20:57  thanks Tiyani... But it works fine for other report. I have done the same procedure for all the reports. Since i have given the application path for the report,.on the button click, why is it saying so?....the path exist ----------------------------- I am a beginner Crystal Report Error when called from VB 2008 Ener Leumas11-May-09 20:09 Ener Leumas 11-May-09 20:09  Whenever I call a report, an error occur. The Table "stored procedure name" could not be found. I'm trying to call a Crystal Report with a stored procedure as its table source. Anybody experienced the same problem and solved it? connection string hrishiS11-May-09 19:52 hrishiS 11-May-09 19:52  Hi to all, I am using Vb.net 2005 with ms access(2007) as back end For security reason I have put password for the access database. Could anyone please tell me "the connection string to connect to the database." Thnaks in advance ----------------------------- I am a beginner Re: connection string specialdreamsin11-May-09 20:11 specialdreamsin 11-May-09 20:11  Hi, Refer to http://www.connectionstring.com/ Ramesh Sambari Re: connection string EliottA12-May-09 2:44 EliottA 12-May-09 2:44  I think you meant this?[^] Check out the CodeProject forum Guidelines[^] Calling Crystal Report 7 from Visual Basic 2008 Ener Leumas11-May-09 17:23 Ener Leumas 11-May-09 17:23  I'm trying to call a Crystal Report 7 from my Visual Basic 2008 project. I have used the following codes on my form: ConInfo.ConnectionInfo.UserID = <user name=""> ConInfo.ConnectionInfo.Password = <password> ConInfo.ConnectionInfo.ServerName = <server name=""> ConInfo.ConnectionInfo.DatabaseName = <database name=""> For intCounter = 0 To objReport.Database.Tables.Count - 1 objReport.Database.Tables(intCounter).ApplyLogOnInfo(ConInfo) Next However, whenever I call it using the code below, I'm still being asked for the login details. Dim objForm As New frmViewReport objForm.ViewReport("C:\MyREPORT.RPT", , "@pParam=MyParam") objForm.Show() I supply the correct login information (server name, user id, password, database) but I'm still getting error message "Login Failed. Please try again." Help anyone? It will be highly appreciated. BTW, I got the codes also from this site. Maybe I'm just lacking something to make it run. Re: Calling Crystal Report 7 from Visual Basic 2008 Mycroft Holmes11-May-09 18:06 Mycroft Holmes 11-May-09 18:06  At a guess you should be passing objReport to the reportviewer. I think, CR is opening MyReport without creds. Isn't 7 rather old, I thought CR was up to 11 or 12 by now. Never underestimate the power of human stupidity RAH Re: Calling Crystal Report 7 from Visual Basic 2008 Ener Leumas11-May-09 18:29 Ener Leumas 11-May-09 18:29  Actually I am passing it to a reportviewer, but still with logon error. Yup, CR 7 is really old. I'm upgrading to CR 2008 (for the new reports) and I'm just trying to call the old reports done thru CR 7 so as not to do it all over again on 2008. Re: Calling Crystal Report 7 from Visual Basic 2008 DJ Matthews12-May-09 5:14 DJ Matthews 12-May-09 5:14  You can not call ANY version of Crystal report under 9 i think from .Net. Depending on how many reports you have, you can open them all up in CR 08 and save them as the 08 version. I'm about to go through this with about 200 CR 7&8 reports we have from a legacy VB6 app we have. Re: Calling Crystal Report 7 from Visual Basic 2008 Ener Leumas12-May-09 21:03 Ener Leumas 12-May-09 21:03  You're absolutely correct. I'm currently converting our CR reports to 08 version. Thanks! [Message Deleted] Silva_A11-May-09 12:20 Silva_A 11-May-09 12:20  [Message Deleted] Re: PRINT FROM DATA READER ON MULTIPLE PAGES Dave Kreskowiak11-May-09 15:32 Dave Kreskowiak 11-May-09 15:32  And the problem would be .....?? You should not be doing any database operations inside this method. Setup and execute the database operations outside of this, then maintain the datareader only to read the data and parse it for print. When the printing is done, then you can close the reader. Oh, and posting IN ALL UPPER CASE IS THE SAME AS YELLING AT THE TOP OF YOUR LUNGS! A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 [Message Deleted] Silva_A12-May-09 3:50 Silva_A 12-May-09 3:50  [Message Deleted] Re: PRINT FROM DATA READER ON MULTIPLE PAGES Dave Kreskowiak12-May-09 4:23 Dave Kreskowiak 12-May-09 4:23  You're already doing it. You render just the current page, and if you have more pages to render, you set the e.HasMorePages = True and drop out of the event handler. The PrintPage event will fire again so you can render the next page. WHen you don't have any more pages to print, you just set e.HasMorePages to False. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 Re: PRINT FROM DATA READER ON MULTIPLE PAGES Silva_A12-May-09 12:47 Silva_A 12-May-09 12:47  how do i determine whether im exceeding the bottom margin? Thanx Re: PRINT FROM DATA READER ON MULTIPLE PAGES Dave Kreskowiak12-May-09 13:31 Dave Kreskowiak 12-May-09 13:31  That's where you have to keep track of where your drawing your strings and how big they are. Look into Graphics.MeasureString. The margins are given to you in the event args you get from the system in the "e" variable. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 Re: PRINT FROM DATA READER ON MULTIPLE PAGES Silva_A13-May-09 1:40 Silva_A 13-May-09 1:40  Can you pls fix that in my code of me? Thanx Re: PRINT FROM DATA READER ON MULTIPLE PAGES Dave Kreskowiak13-May-09 2:02 Dave Kreskowiak 13-May-09 2:02  Isn't that what YOU get paid to do?? Besides, from what I'm seeing in your code, it would take a complete rewrite of your printing method, and breaking it down into smaller methods that do very specific things... A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 Re: PRINT FROM DATA READER ON MULTIPLE PAGES Silva_A13-May-09 5:40 Silva_A 13-May-09 5:40  I dont get paid, is a project im com'n up with. Help me out Bro. Re: PRINT FROM DATA READER ON MULTIPLE PAGES Dave Kreskowiak13-May-09 14:18 Dave Kreskowiak 13-May-09 14:18  Since I work a fulltime job with overtime, and have 1 year old running around my house afterwards, when am I supposed to do this? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 Re: PRINT FROM DATA READER ON MULTIPLE PAGES Silva_A14-May-09 8:45 Silva_A 14-May-09 8:45  Pls help me out. Help - Finding 3rd Point on Circle cyndy_northrup11-May-09 9:53 cyndy_northrup 11-May-09 9:53  Do you know, if we had two points in degrees on a circle and we wanted to derive an unknown 3rd point in degrees could we do it if we knew that the third point had a known angle to the other two points? So the three points together make a triangle, as an example ; Point (1) is on the circle at 30 degrees Point (2) is on the circle at 90 degrees Point (3) exists somewhere on the circle and we know that it has a 75 degree internal angle to Point (1) and (2), how can we determine at what degree on the circle point (3) is situated at? Re: Help - Finding 3rd Point on Circle Luc Pattyn11-May-09 10:43 Luc Pattyn 11-May-09 10:43  Hi Cyndy, once the circle (center O) and two points (A and B) are fixed, you can no longer chose the interior angle at a third point C; that angle is constant, it does not depend on the position of C on the circle at all (assuming you mean the circumference). Here is a well known example: have A and B at opposite locations (say 0 and 180 degrees), then no matter where C lies, angle ACB will always be 90 degrees. General proof: 1. the sum of the interior angles of quadrilaterals is always 360 2. in quadrilateral OACB angle ACB (the one you want) equals OAC plus OBC (because the triangles OAC and OBC are isosceles) 3. angle AOB is fixed 4. from 1+2+3 it follows angle ACB is also fixed (and equal to 180 minus half of AOB) Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Last Visit: 31-Dec-99 18:00     Last Update: 7-May-24 9:55 Refresh ᐊ Prev1...1107110811091110111111121113111411151116 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.