|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
Hi,
Refer to http://www.connectionstring.com/
Ramesh Sambari
|
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
You're absolutely correct. I'm currently converting our CR reports to 08 version.
Thanks!
|
|
|
|
|
|
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!
|
|
|
|
|
|
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.
|
|
|
|
|
how do i determine whether im exceeding the bottom margin?
Thanx
|
|
|
|
|
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.
|
|
|
|
|
Can you pls fix that in my code of me?
Thanx
|
|
|
|
|
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...
|
|
|
|
|
I dont get paid, is a project im com'n up with. Help me out Bro.
|
|
|
|
|
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?
|
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|