|
i have designed crystal reports in my project in VISUAL STUDIO.net 2005 in ASP.net, C#. i have designed database in SQL Server 2005.in crystal report i have used the SQL Query which takes records from two tables, but in output the record against the column of one table re repeating.i am also displaying my code behind crystalReportViewer1_Load as i am struggling for many days but couldnt find error, please help me find any solution.i have generated reports through crystal report wizard
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
//string strcon = "Provider=SQLOLEDB;Server=./SQLEXPRESS;DataSource=rescue15; User Instance=false; Integrated Security=true;";
string strcon = "Provider=SQLOLEDB;Server=(local);Database=rescue15;uid=sa;pwd=SASA;";
OleDbConnection conn = new OleDbConnection(strcon);
//string q = "SELECT DISTINCT crime_mgmt.cr_location,crime_mgmt.cr_date,offensive_issue.c_desc FROM crime_mgmt,offensive_issue WHERE crime_mgmt.fir_num = offensive_issue.fir_num AND crime_mgmt.cr_date BETWEEN '" + crimewithdate.text + "' AND '" + crimewithdate.text1 + "'";
string q = "SELECT c.cr_date, c.cr_location, o.c_desc FROM crime_mgmt AS c INNER JOIN offensive_issue AS o ON c.fir_num = o.fir_num WHERE c.cr_date BETWEEN '" + crimewithdate.text.ToString() + "' AND '" + crimewithdate.text1.ToString() + "'";
OleDbCommand cmd = new OleDbCommand(q, conn);
conn.Open();
ReportDocument rep = new ReportDocument();
string exename = Application.ExecutablePath;
FileInfo exefile = new FileInfo(exename);
string directory = exefile.DirectoryName;
string str = HostingEnvironment.ApplicationPhysicalPath + directory + "\\CrystalReport2.rpt";
rep.Load(str);
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
//da.Fill(ds);
da.Fill(ds, "crime_mgmt");
da.Fill(ds, "offensive_issue");
//ds.WriteXml(directory + "\\AuthoritesWise.xml");
//ds.ReadXml(directory + "\\AuthoritesWise.xml");
rep.SetDataSource(ds);
crystalReportViewer1.ReportSource = rep;
conn.Close();
}
|
|
|
|
|
Hi mavii,
I too worked on Crystal Reports where I didnot do the Procedure as given by you. I used Stored Procedures which is very simple and easy to use. If you require this I will help regarding this.
|
|
|
|
|
i have not worked with stored procedure, please guide me, can u tell me the whole procedure to design crystal reports in windows application (not the web-based application)
|
|
|
|
|
Hi,
I worked in Web application but I think both are the same. The procedure which I did in Web Applications is:
1) First in the ASPX Page gave the required Text boxes which will give input to Stored Porcs. Upon submitting the Page I will redirect to new ASPX Page which will Display only Crystal Reports. This is because if we keep any other fields like Textboxes there will be a problem which I don't know exactly.
2) In the Second Page I will just have Crystal Reports Viewer(CRViewerPortfolioReports) and Crystal Reports Source(CRSourcePortfolioReports .
On Page Load the below code has to be written
int Portfolio_ID = int.Parse(Request.QueryString.Get("Portfolio_ID"));
//Portfolio_ID Input Parameter for Stored Procedure.
string ReportName = "CRPortfolioReports.rpt";
string ReportPath;
ReportPath = Server.MapPath("../CrystalReportFiles/") + ReportName;
//ReportPath Location of the CRYSTAL REPORT
CRSourcePortfolioReports.ReportDocument.Load(ReportPath);
CRSourcePortfolioReports.ReportDocument.SetDatabaseLogon(USERNAME, PASSWORD);
CRSourcePortfolioReports.ReportDocument.SetParameterValue("@IMRsPerPortfolio_PortfolioID", Portfolio_ID);
//@IMRsPerPortfolio_PortfolioID STORED PROCEDURE INPUT PARAMETER
//IF you want to add another Input Parameter DATE...
//CRSourcePortfolioReports.ReportDocument.SetParameterValue("@IMRsPerPortfolio_DATE", //DATE);
CRViewerPortfolioReports.ReportSource = CRSourcePortfolioReports;
CRViewerPortfolioReports.DataBind();
3) Building the CRYSTAL REPORT .rtp FILE
Add New Crystal Report File and create a new Database connection and add the Stored Procedure developed. You will automatically get the Input Parameters and Output Parameters which you could automatically map to X or Y Cordinates. Like if @IMRsPerPortfolio_PortfolioID id INPUT Parameter it will be coming in Parameters Field of Field Explorer Tab.
|
|
|
|
|
I hosted my web Page in a Local System which has IIS 5.0, .Net Framework 1.1 and .Net framework 2.0 along with VS 2003 installed in that system. There are no problems with Web pages working in .Net Framework 1.1. For the pages developed in Framework 2.0 i.e VS 2005 the web page is NOT getting loaded at all its taking VERY HIGH Response time and not loading finally.
When I restart IIS in this system the Web Pages belonging to 2.0 Framework are getting loaded and after some time the Same Problem is repeating. Could you Please help me to resolve this Issue.
Thanks in advance.
|
|
|
|
|
I thought you had to configure IIS to use one version of the framework, or the other ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi Christian,
The IIS was configured correctly for .Net Framework 2.0 sites or 1.1. Since the Web page is loading fine after restarting IIS. I think this won't be the Problem.
|
|
|
|
|
Downloaded wrox chat from the net won't work on my machine but works great on dad's
Both have xp pro
both have ms vwd express 2005 downloaded from the same cd
Can anyone help me??? Anxious to get back to building my site
|
|
|
|
|
Do you have a firewall ? What does 'won't work' mean ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
the chat window does not show up on the site just the enter text box and the insert button
|
|
|
|
|
Im thinking it is a problem with the apps iFrame and my browser but im not sure how to check this route I have dell unit with internet express
|
|
|
|
|
learningman wrote: internet express
Internet Express?
|
|
|
|
|
HI i have to use custom paging in gridview in asp.net 2.0 ,
the format i need is : Displayting 1 to pagesize of totalrecords and
<- -="">
Previous Next
Please suggest how can I implement it , i am new to .net 2.0 ,I did not find this format in paging styles availabel in 2.0
|
|
|
|
|
dotnet.coder wrote: the format i need is : Displayting 1 to pagesize of totalrecords and
<- -="">
Previous Next
Can you explain in details, if you talking about button you can change and customize it . but i did not got your point 
|
|
|
|
|
Hi,Am not sure whether this is the right place to post this question,pardon me .
i am devoloping a website.Am papplying CSS.I ahev a hyper link.When i move mouse over teh hyper link i want the link displayed as "google" to change the color and enlarge.i tried hover;
a.nav:hover {color: orange;
text-decoration: underline;
}
A:hover
{
color: #09529E;
font-size :larger;
}
But this is not helping me.
My entire code lookds like this;
BODY
{
}
.intro{
FONT-WEIGHT: bold;
FONT-SIZE: 14pt;
font-family: arial;
color:green;
}
.cashback{
FONT-SIZE: 14pt;
COLOR: lime;
FONT-STYLE: italic;
FONT-FAMILY: Arial;
}
.heading{
font-weight:lighter;
FONT-SIZE: 18pt;
COLOR: #09529E;
FONT-FAMILY: Arial;
}
.notavailable{
FONT-SIZE: 9pt;
COLOR: green;
FONT-FAMILY: Arial;
}
.tabs {
PADDING-RIGHT: 5px; PADDING-LEFT: 5px; FONT-WEIGHT: bold; COLOR: #09529E; TEXT-ALIGN: center
}
A:link {
COLOR: #09529E;
TEXT-DECORATION: none;
}
A:visited {
COLOR: #FFFFFF;
TEXT-DECORATION: none;
outline:none;
}
a.nav:hover {color: orange;
text-decoration: underline;
}
A:hover
{
color: #09529E;
font-size :larger;
}
How can i modify this tto so that when my mouse moves over the google hyprelink in my webpage it will enlarge and chage the color.
Thanking You;
|
|
|
|
|
change "A" to "a". Similarly, all of the CSS element names are all supposed to be lower-case (for instance, "PADDING" should be "padding").
Also, CSS ID names and class names are also case-sensitive. If you declared "myClass" in your style sheet, you MUST use it as "myClass" in your html. Any variation in case from the declared name will be ignored.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Hi,
Thanks,but still the issue persists;
My source:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<link rel="Stylesheet" href="customer.css" />
</head>
<body>
<form id="form1" runat="server"><br />
<br/>
<br/>
<div class="cashback" > <asp:HyperLink ID="HyperLink1" CssClass="tabs" runat="server" NavigateUrl="http://www.google.co.in" BackColor="Transparent" BorderColor="#FFC0C0">Google</asp:HyperLink></div><br/>
<br/>
<div class="intro">
Program </div>
<div class="cashback">
Get Cash back </div>
<br/>
<div class="notavailable">
Please inquire with your local
company .</div>
<br/>
<div class="heading">
Mission Statement
</div>
<br/>
Our mission has been simply stated and vigorously followed.
<br/>
<br/>
<div class="heading">Brief History</div>
<br/>
We xxxxxxxxx
</form>
</body>
</html>
My CSS:
BODY
{
}
.intro{
font-weight: bold;
font-size: 14pt;
font-family: arial;
color:green;
}
.cashback{
font-size: 14pt;
color: lime;
font-style: italic;
font-family: Arial;
}
.heading{
font-weight:lighter;
font-size: 18pt;
color: #09529E;
font-family: Arial;
}
.notavailable{
font-size: 9pt;
color: green;
font-family: Arial;
}
.tabs {
padding-right: 5px; padding-left: 5px; font-weight: bold; color: #09529E; text-align: center
}
A.tabs:link {
color: #09529E;
text-decoration: none;
}
A.tabs:visited {
color: #FFFFFF;
text-decoration: none;
outline:none;
}
a.tabs:hover {color: orange;
text-decoration: underline;
}
A.tabs:active
{
color: lime
}
May be this will help
Thanking you,
|
|
|
|
|
Change "A" to "a". You still have "A.tabs"
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Please be courteous to your reader and correct typos!
"So what's the future like? Are there flying cars and everything's clean?"
"No, the cars are still on the ground and it's even dirtier, but we're working on it."
From: Quantum Leap (not verbatim)
{o,o}.oO( Want a great RSS reader? Try FeedBeast! )
|)””’) ( Check out my profile for a special CodeProject deal! )
-”-”-
|
|
|
|
|
Hi,
Thanks now it works.
Thanks for the help.
I changed it like this
BODY
{
}
.intro{
font-weight: bold;
font-size: 14pt;
font-family: arial;
color:green;
}
.cashback{
font-size: 14pt;
color: lime;
font-style: italic;
font-family: Arial;
}
.heading{
font-weight:lighter;
font-size: 18pt;
color: #09529E;
font-family: Arial;
}
.notavailable{
font-size: 9pt;
color: green;
font-family: Arial;
}
.tabs {
padding-right: 5px; padding-left: 5px;
font-weight: bold; color: #09529E; text-align: center;
text-decoration: none;line-height:24px;
}
a.tabs:link {
color: #09529E;
text-decoration: none;
}
a.tabs:visited {
color: #000000;
text-decoration: none;
outline:none;
}
a.tabs:hover {color: orange;
text-decoration: none;font-size: 24pt;
}
a.tabs:active
{
color: lime;
}
Thanks again
|
|
|
|
|
Using .Net 2.0...
I'm currently using my own user management stuff, but I've come to realize that I need part of the Membership functionality of .Net. Here's my setup:
1) I'm using MySql for the database. This fact is not open for discussion beyond answering my question, don't waste your time trying to convince me to use Sql Server. The provider I'm using supports the .Net Membership/roles stuff.
2) Registration includes a number of fields as well as a captcha system.
3) When the user registers, an email is sent to his/her email address with an activation code.
4) When the user activates the account (by clicking on the url in the email he was sent), he is then permitted to log in to the site.
When I'm done converting to the M.Net membership stuff, I want all of the above to work as before.
Currently, all pages of the site are in the site's root folder. I want to move all of the members-only pages to a sub-folder. I DO NOT want to use the .Net membership registration or login controls. Again, please don't ask why, just make the mental leap.
Can someone guide me as to what I need to do to effect this change?
I'm using a massaged version of this Codeproject article[^] for my provider code.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
modified on Saturday, January 19, 2008 10:37:22 AM
|
|
|
|
|
|
Do not repost the same question if no one answers the first time. This is the same thing you just asked. Reposting same question is also considered rude.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
I have a form with some read-only TextBox controls on it.
<asp:TextBox ID="Total1" ReadOnly="true" maxlength="2" columns="1" runat="server" />
These controls are being populated by a javascript function as the user enters data elsewhere on the form. When I try to read these values after the user clicks the submit button with this code:
int x = Convert.ToInt32(this.Total1.Text);
the Text property shows "0", despite showing another value on the screen. If the javascript can set the text on the screen, why doesn't the .Net code read the correct value from the control?
What am I doing wrong?
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
use
ContentEditable="false"
insted of Readonly property, if you use ReadOnly="true" it lost data when postback.
I have faced same problem and i have that solluation 
let me know when done 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
