IN CRYSTAL REPORT OUTPUT EACH RECORD APPEARS 3 0r 4 TIMES REPEATING - ASP.NET Discussion Boards

smashguitars wrote:
how do i link asp.net and silverlight

You can use "Add Silverlight Link" in VS 2008 if you have Silverlight Tool for VS 2008 installed.

smashguitars wrote:
how do i link asp.net and silverlight so that i can set properties or values on asp.net page and be able to access those values with a silverlight client?

No. You won't be able to get the properties of ASP.NET page from Silverlight project. The main reason why we should use "Add Silverlight link" is that ~

1. To prevent the cross-domain error. For example, you won't be able to access the database from Silverlight directly. So, you have to create the webservice for that. then you have to invoke that service to get the data from database. If you are using two different projects for web service and silverlight project, you will get the cross-thread.. So, what we used to do is that we put the webservice in ASP.NET project and add the silverlight link to ASP.NET project.

Let me know if you need more help on Silverlight 1.1 with ASP.NET. I'm willing to help you..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Hi all....

i have an excel sheet with images, now i want to read the images from excel sheet and save in to a folder using c#...

please help me....it is urgent....

thanks
Pradeep K.

Pradeep Reddy

pradeep kumarappagari wrote:
please help me....it is urgent....

That is considered impolite on this site.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Hi

Try the Below code

you have to add one DLL or COM Obeject I dont remember exactly Named Microsoft Excel 11.0 Object
//INCLUDE
using Excel; //For Excel LOCATION DLL Microsoft Excel 11.0 Object Library
using System.Reflection; //For Missing
using System.Runtime.InteropServices; //For Marshall

//CODE:::::

Excel.Application oXL;
_Workbook oWB;
_Worksheet oSheet;
object oMissing = Missing.Value;

Range oRng;

oXL = new Excel.Application();

oWB = oXL.Workbooks.Open("EXCEL LOCATION", oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
int TotalSheetsinExcel = 0;
TotalSheetsinExcel = oWB.Sheets.Count - 1;
oSheet = (_Worksheet)oWB.Sheets[1];
Picture pic = (Picture)oSheet.Pictures(1);

//pic object will have PICTURE

//Close Objects
oWB.Save();
oWB.Close(null, null, null);
oXL.Workbooks.Close();
oXL.Quit();
Marshal.ReleaseComObject(oXL);
Marshal.ReleaseComObject(oSheet);
Marshal.ReleaseComObject(oWB);
GC.Collect();

hi thank for the reply...

how to save the picture at particular location which is in pic object....

Pradeep Reddy

Hi

I exactly don't know the procedure. The previous one which i sent also was wrong I think as pic.Copy() is returning "true".

thank u.... Blush | :O

Pradeep Reddy

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 Wink | ;)

.
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?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

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 Confused | :confused:

Best Regards
-----------------
Abhijit Jana
View My Latest Article :- SpyNet : Your Network Spy

"Success is Journey it's not a destination"

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