ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 All rights reserved.Wrap Text in Crystal Report in ASP.Net<p>How to split a product name and display&nbsp; in two rows&nbsp; if the product name grows in crysrtal report (</p>, 22 Oct 2018 03:31:19 GMTWrap long text in GridView and report viewer in ASP.Net<p><em>What i want, if the text is too long to fit as per the defined width, the text should be wrapped in next row. I don&rsquo;t want to expand the column width to accommodate this text in one row. In other words, I want to wrap the text in next row if the text inside this columns exceeded the width of the column defined i<img src="Untitled.png" alt="" />n&nbsp;gridview and reportviewer</em></p>, 19 Nov 2017 06:55:00 GMTwhat is Fiddler and how its helpfull in wcf service<p>"HTTP data inspector Fiddler." what is the use of this and give me any article &nbsp;for&nbsp;how to use fiddler to monitor wcf service in detail</p>, 24 Jul 2014 02:30:40 GMTVisual Studio localhost Port casuing problems for Crystal Reports in ASP.Net<p>Hi, I have created a dataset with 3 tables and trying to fill this dataset using dataadapter(By executing stored procedure). The data is getting filled into the dataset but it is not getting displayed in the crystal report(Getting blank report). Pls refer by code below :<br /><br /></p> <pre class="brush: csharp">using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Configuration; using System.Data.SqlClient; using CrystalDecisions.CrystalReports.Engine; namespace CrystalEx { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { string sqlCon = &#34;Server=ServerName;Database=DBName;uid=sa;pwd=sa;connection timeout=3600;&#34;; SqlConnection sqlConn = new SqlConnection(sqlCon); SqlDataAdapter sqlAdap = new SqlDataAdapter(); //TQReportCM is a stored procedure , i am selecting a record by passing one parameter sqlAdap.SelectCommand = new SqlCommand(&#34;TQReportCM&#34;, sqlConn); sqlConn.Open(); DataSet1 ds = new DataSet1(); sqlAdap.SelectCommand.CommandType = CommandType.StoredProcedure; sqlAdap.SelectCommand.Connection = sqlConn; sqlAdap.SelectCommand.Parameters.Add(&#34;@CmNo&#34;, SqlDbType.NVarChar, 400).Value = &#34;1&#34;; sqlAdap.Fill(ds, ds.CM.TableName); //TQReportCRPOCis a stored procedure , i am selecting a record by passing one parameter sqlAdap.SelectCommand = new SqlCommand(&#34;TQReportCRPOC&#34;, sqlConn); sqlAdap.SelectCommand.CommandType = CommandType.StoredProcedure; sqlAdap.SelectCommand.Connection = sqlConn; sqlAdap.SelectCommand.Parameters.Add(&#34;@Name&#34;, SqlDbType.NVarChar, 400).Value = &#34;hello&#34;; sqlAdap.Fill(ds, ds.CRPOC.TableName); //TQReportSelectHS is a stored procedure , i am selecting a record by passing one parameter sqlAdap.SelectCommand = new SqlCommand(&#34;TQReportSelectHS&#34;, sqlConn); sqlAdap.SelectCommand.CommandType = CommandType.StoredProcedure; sqlAdap.SelectCommand.Connection = sqlConn; sqlAdap.SelectCommand.Parameters.Add(&#34;@FirstName&#34;, SqlDbType.NVarChar, 400).Value = &#34;abcd&#34;; sqlAdap.Fill(ds, ds.Customer.TableName); ReportDocument rptDoc = new ReportDocument(); rptDoc.Load(Server.MapPath(&#34;CrystalReport1.rpt&#34;)); rptDoc.SetDataSource(ds); CrystalReportViewer1.DataBind(); CrystalReportViewer1.ReportSource = rptDoc; } } }</pre> <p>Any help would be appreciated.<br />Thanks in advance</p>, 08 Aug 2013 09:10:49 GMTVisual Studio Crystal Report does not work in IE 10 browser<p>How to make <strong>Crystal Report</strong> using inbuilt sql express <strong>in VisualStudio2012</strong>??</p>, 10 Oct 2013 01:54:15 GMTVisual Studio crashing as soon as i try to add crystal Report<p>using VS2005 web application</p> <p>when i even try to add crystal report rpt to the application visual studio shutsdown</p> <p>i tried repairing VS &amp; even checked if ccrystal report is checked while installation</p> <p>&nbsp;</p> <p>but still the same issue</p> <p>so wanted to check log files if i can get any info</p> <p>where can i find the log files for the same</p> <p>&nbsp;</p>, 26 May 2012 01:05:24 GMTVersion of Crystal Report runtime that would work with website built using visual studio 2010 and hosted with IIS7<p>which version of crystal report would be install with visual studio 2010 ultimate which can be work perfectly with IIS7.</p>, 05 Jan 2013 03:02:58 GMTUsing Hindi or Marathi fonts in Crystal Reports in ASP.Net<p>HI Mudassar,</p> <p>I am Exporting Crystal Report to pdf in hindi font it displaying &nbsp;as boxes&nbsp;i have installed adobe reader 11.0 with asian extended language pack in my local system bit still i am facing issue please help in solving this issue thanks in advance.(English is working fine problem is with only with hindi font)</p>, 08 Apr 2014 23:27:29 GMTUsing Crystal Reports PrintToPrinter command with ASP.Net<p>i am using this code for printing when i try printing from client system its printing on server printer . &nbsp;Helpp</p> <p>&nbsp;</p> <pre class="brush: csharp"> DateTime curdate = Convert.ToDateTime(TextBox1.Text); SqlDataAdapter da = null; DataTable dt = new DataTable(); DataTable dt1 = new DataTable(); con.Open(); SqlCommand cmd = new SqlCommand(&#34;SELECT * FROM Transactions where report_type = @report_type AND dateadd(dd, datediff(dd,0, [R_date]), 0) = @R_date&#34;); cmd.Connection = con; cmd.Parameters.Add(&#34;@report_type&#34;, SqlDbType.NVarChar).Value = DropDownList1.SelectedValue; cmd.Parameters.Add(&#34;@R_date&#34;, SqlDbType.DateTime).Value = curdate.Date; da = new SqlDataAdapter(cmd); dt.Clear(); da.Fill(dt); if (dt.Rows.Count &gt; 0) { ReportDocument Report = new ReportDocument(); Report.Load(Server.MapPath(&#34;~/Report.rpt&#34;)); Report.SetDataSource(dt); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; Report.SetDatabaseLogon(&#34;sa&#34;, &#34;123456789&#34;, @&#34;TRAINING-ROOM-8&#34;, &#34;newMreport&#34;); CrystalReportViewer1.ReportSource = Report; CrystalReportViewer1.ReportSource = Report; CrystalReportViewer1.DataBind(); CrTables = Report.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } Report.Refresh(); Report.PrintToPrinter(1, true, 1, 1); con.Close(); } }</pre> <p>&nbsp;</p>, 02 Dec 2012 22:45:02 GMTUsing Crystal Reports in ASP.Net Example<p>how to make crystal report from project?</p>, 01 Nov 2012 22:49:33 GMTUse Crystal report made uisng vs 2008(crystal report 10) in crystal report viewer 13 in ASP.Net<p>what happens if i build web app (.net 3.5, vs 2008) with crystal report basic for vs 2008 (cr basic 10) and i publish it in server which using crystal report viewer 13?</p> <p>can it runs smoothly? if error what can i do?must i upgrade my crystal report?</p>, 08 Jun 2016 07:08:06 GMTUpload Download Files using Web Service in ASP.Net<p>hi<br />My web service Return Files bytes Correctly .<br /><strong>service Code is as Follows...</strong></p> <p>&nbsp;</p> <pre class="brush: csharp">[WebMethod()] public byte[] Download_Files_From_Database1(string File_ID) { try { byte[] buffer = null; using (SqlConnection con = new SqlConnection(&#34;ConnString&#34;)) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = &#34;select ID,File_Name,File_Extension,File_Content_types,File_Size,File_Uploaded_Date,File_Data from dbo.File_Information (nolock) where Id=@Id&#34;; cmd.Parameters.AddWithValue(&#34;@id&#34;, File_ID); cmd.Connection = con; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { buffer = new byte[Convert.ToInt32(dr[&#34;File_Size&#34;])]; buffer = (byte[])dr[&#34;File_Data&#34;]; } } } return buffer; } catch (Exception ex) { throw ex; } } </pre> <p><strong>and Client Side Code is</strong></p> <pre class="brush: csharp">protected void lnkDownload1_Click(object sender, EventArgs e) { Stream download = null; try { LinkButton lnkbtn = sender as LinkButton; GridViewRow gvrow = lnkbtn.NamingContainer as GridViewRow; int fileid = Convert.ToInt32(GridView1.DataKeys[gvrow.RowIndex].Values[&#34;ID&#34;].ToString()); string File_Name = GridView1.DataKeys[gvrow.RowIndex].Values[&#34;File_Name&#34;].ToString(); string File_Content_types = GridView1.DataKeys[gvrow.RowIndex].Values[&#34;File_Content_types&#34;].ToString(); string Ext = GridView1.DataKeys[gvrow.RowIndex].Values[&#34;File_Extension&#34;].ToString(); //// Url Working Perfect string url = &#34;http://localhost:13817/Web_Service_File_Download_Service_Side_Example2/WebService.asmx/Download_Files_From_Database1?File_ID=&#34; + fileid; HttpWebRequest Request_From_Client = WebRequest.Create(url) as HttpWebRequest; Request_From_Client.Method = &#34;GET&#34;; HttpWebResponse response_From_Server = Request_From_Client.GetResponse() as HttpWebResponse; Stream stream = response_From_Server.GetResponseStream(); Response.ContentType = &#34;application/octet-stream&#34;; Response.AppendHeader(&#34;Content-Disposition&#34;, &#34;attachment; filename=&#34; + File_Name); const int bufferLength = 10000; byte[] buffer = new Byte[bufferLength]; int length = 0; download = stream; do { if (Response.IsClientConnected) { length = download.Read(buffer, 0, bufferLength); Response.OutputStream.Write(buffer, 0, length); buffer = new Byte[bufferLength]; } else { length = -1; } } while (length &gt; 0); Response.Flush(); Response.End(); } catch (Exception ex) { System.Web.HttpContext.Current.Response.Write(&#34;Error : &#34; + ex.Message); } finally { if (download != null) download.Close(); } } </pre> <p>can any body help me.<br />when i hit url it gives required Output.<br />but not using in above code</p>, 14 Jul 2014 18:47:52 GMTShow multiple Crystal Reports on single webpage in ASP.Net<p>Hello,</p> <p>I want to show two small reports on one web page.</p> <p>How to Show Two Crystal Reports on single webpage or suggest any other option for my requirement.</p> <p>Thanks</p> <p>&nbsp;</p>, 01 Jul 2018 23:57:44 GMTShow hide TextBox in RDLC report based on page count in ASP.Net<p>I want to write a expression for a textbox that it will only show if the page count is greater than one then it will be only showed otherwise we will not show.So if the report is one page that textbox will not show but if the report is generated by many pages then it will be showed</p> <pre class="brush: vb">=IIf((Globals!TotalPages &gt; 1),True,False) i tried this way but not working </pre> <p>&nbsp;</p>, 07 Aug 2018 06:18:02 GMTShow hide columns in RDLC report at Runtime in ASP.Net<p>Hide /Unhide RDLC Columns on Runtime</p> <p>to collapase the columns having no data list excel hide columns but on runtime..</p> <p>&nbsp;</p>, 29 Jul 2016 03:01:23 GMTTo Display the data crystal Report<p><strong>Hai Techie</strong></p> <p><br />I have created a following crystal report to show the details of a table.<br />Crystal report runs perfectly but does not show data</p> <p><br />The code is</p> <p><br />SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Iwens_Database; Trusted_Connection=yes");<br />SqlCommand cnd = new SqlCommand("SELECT E_id, E_Name, E_Address, E_Contact_No, E_Email, DOEn, E_noi, E_coursename, E_year, E_companyname, E_design, E_others, E_Selected, E_Followup FROM Enquiry_table", con);<br /><br /><br />SqlDataAdapter sda = new SqlDataAdapter();<br /><br />DataSet eds = new Enquids();<br /><br /><br />ReportDocument rdoc = new ReportDocument();<br />sda.SelectCommand = cnd;<br />DataTable dt = eds.Tables[0];<br />sda.Fill(eds, "enquirypartfollowp");<br />rdoc.Load(Server.MapPath("Enquirybydate.rpt"));<br />rdoc.SetDataSource(eds.Tables ["Enquiry_table"]);<br />eds.Tables[0].TableName = "Enquiry_table";<br />CrystalReportViewer1.ReportSource = rdoc;<br />CrystalReportViewer1.RefreshReport();<br /><br /></p>, 21 Feb 2013 05:05:04 GMTThe type or namespace name ASPSnippets could not be found Error<p>i have used an ASP.Net C# web application to post image on facebook.for that i have used "aspsnippets.facebookapi.dll"</p> <p>everything is working fine while execute from local server.but when i upload my code in server and run</p> <p>it says error like "The type or namespace name 'ASPSnippets' could not be found (are you missing a using directive or an assembly reference?)"</p> <p>but i have added Dll reference in my page like&nbsp;</p> <pre>&nbsp;</pre> <pre class="brush: csharp">using ASPSnippets.FaceBookAPI;</pre> <p>how to solve this issue.</p>, 18 Aug 2014 05:51:33 GMTtext out from textbox crystall report<p>Hi! I have text more than 1000 character in table. But I want show text from table in crystal report. When I show text in textbox crystal report text out from textbox and can&rsquo;t seen all text.</p> <p>For example:</p> <table> <tbody> <tr> <td width="115"> <p>Text out from t</p> </td> </tr> </tbody> </table> <p>extbox.</p> <p>For me need like this:</p> <table> <tbody> <tr> <td width="115"> <p>Text out from textbox . it&rsquo;s need me</p> </td> </tr> </tbody> </table> <p>How I can solve this?</p>, 17 Nov 2015 02:41:25 GMTSum Column Values in Crystal Report<p>am generating crystal report and in this am using product name&nbsp; and its price, i want to display the total price of the product in footer section ,</p> <p>what i do,?</p> <p>thank you...</p>, 11 Oct 2013 23:04:57 GMTSubreport in RDLC report using C# and VB.Net in ASP.Net<p>i have 3 dataset i want to display with Rdlc Report view</p> <p>i want to display per a page studnent Name, all subjects under assessments1 and assements2 for a sudent.</p> <p>any help or link to help me in</p>, 14 Jan 2018 23:18:06 GMT