I am using Visual Studio 2010 and I want to make some reports dynamically. I want to display in the reports viewer my own created dataSet and table adapter. Is this possible? Or it is possible to change the connection string from the dataset at runtime? I have different connections strings which are defined in the settings.xml file and i want to use this strings at connection.
View 1 RepliesWe're testing the native Visual Studio reporting technologies for ASP.NET (RDLC file + ReportViewer) to see if it meets our needs. One flaw we have detected that makes it unfeasable to use is that, for some reason, when connected to our IDataSource, the ReportViewer does not ask for paginated data. It gets the DataSourceView and calls its ExecuteSelectMethod passing an DataSourceSelectArguments that does not ask for paginated data. The CanPage property of the DataSourceView returns true. It doesn't even ask for count.
On the other hand, the pagination on top of the control shows an uncertain number of pages, what makes us believe that there might be a way to work with paginated data. Is there a way to make it to work with paginated data? Is it a good reporting tool? If not, what are the options that meet this need?
I have SSRS (discountasp.net) and I currently display reports on my web page using Reportviewer and use .net code to authenticate them (username/password). Recently I have bought VPS (Windows Server 2008 Web Edition + .net 4.0) and would like to use SSRS the same way as above. I have never done this before so need some guidance on that just to ensure the server is still "safe". Below are some questions that I think are related but feel free to add other comments that I didn't think about.
1) Set up new user? What permissions are required?
2) Configure SSRS to for external connections?
3) Firewall?
I have a question about whether it's possible to make the ReportViewer's toolbar static while scrolling the report content. I have a ASP.NET web app and I use a ReportViewer control in a page to display the report, when a report is displayed in the ReportViewer oftern the user wants to scroll down to the bottom of the report, but then they have to scroll back to the top to use the toolbar to print or export. Is there a way to make the toolbar always static and only the report content scroll?
View 2 Replieshow to dynamically change the Report design InteractiveSize property? I want to use a radiobutton list which has two options (complete list, paginated list) which changes the height of the Report display. I wonder if I need to use the Report Parameters but how do I change and refresh to display the selected option.
View 2 RepliesI am trying to display a rdl file multiple times on a single reportviewer control in asp.net.Actually I have an rdl stub which displays monthly data and I want to repeat same rdl for each selected month. Suppose If I select month January to March then I want to display 3 reports for each month on same reportviewer asp.net control.I need this solution urgently.
View 6 Repliesi have successfully deploy my reports to our SQL reportserver and i was able to display it in a reportviewer in my site. but my problem is my reports is requiring a parameter to display the report, at first the parameterPrompt is were i manually
encode the parameter value, but i need to dynamically pass the parameter value without manually encoding it in the parameterPrompt.
I'm venturing into the world of Microsoft Reporting Services for the first time. So far it's gone pretty well, but I do have a couple of questions. The biggest one is, can I get the ReportViewer to use a relative path to my .rdlc file instead of the full path name that it seems insistent on using? When I'm developing locally oh my desktop, my filepath is c:inetputwwwrootcascadewritingwritingresults.rdlc; however, when I move this to production the filepath will become :websitecascadewritingwritingresults.rdlc. The .aspx page that my ReportViewer is embedded in resides in the same directory as the .rdlc file itself, so I was hoping I could just simply chop off the path altogether and reference the file name, but when I do ReportViewer fusses at me and says it can't find the file.
An error occurred during local report processing.
The report definition for report 'c:inetpubwwwrootCascadeWritingResults.rdlc' has not been specified
Could not find file 'c:inetpubwwwrootCascadeWritingResults.rdlc'.
In case you need/want to see it, my code for the ReportViewer is below:
[Code]....
how to download excel file containing formula like sum and cell protection from a reportviewer?
I had tried to render the end result from the reportviewer to edit it result before exporting it out but reportviewer is only able to render out as byte format.
I got struck while trying to convert the bytes to a table format where i could add the formula in but to not vaild.
I am getting this error that is related to ReportsViewer. I need to eliminate all references to this library. So where do I need to start deleting the references?
Description: An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
<add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
I just migrated myDocuments folder to a new laptop (windows 7, 64 bit). The visual studio project WAS working on my desktop computer (windows XP pro).
Runtime error is:
ASP.NET runtime error: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f
It references the config file, so I am looking to see if I need to add something in there or what?
i want to make XML file for RSS news. Can anyone tell me How to create XML file?
View 1 RepliesI stacked with making xsl file, for attaching it to the treeview.
This is my XML File:
<?xml version="1.0" encoding="utf-8" ?>
<div id="menu">
<ul class="folder"><a href="Default.aspx?PageName=default">Category</a>
<li class="doc"><a href="Default.aspx?PageName=a">menu item 1</a></li>
<li class="doc"><a href="Default.aspx?PageName=a">menu item 2</a></li>
<li class="doc"><a href="Default.aspx?PageName=a">menu item 3</a></li>
</ul>
<ul class="folder"><a href="Default.aspx?PageName=default">Category2</a>
<li class="doc"><a href="Default.aspx?PageName=a">menu item1</a></li>
<li class="doc"><a href="Default.aspx?PageName=a">menu item 2</a>
</li>
</ul>
<ul class="folder"><a href="Default.aspx?PageName=a">Category3</a>
<li class="doc"><a href="Default.aspx?PageName=a">menu item 1</a></li>
<li class="doc"><a href="Default.aspx?PageName=a">menu item 2</a></li>
</ul>
<ul class="folder"><a href="Default.aspx?PageName=a">Category4</a>
<li class="doc"><a href="Default.aspx?PageName=a">menu item 1</a></li>
<li class="doc"><a href="Default.aspx?PageName=a">menu item 2</a></li>
<li class="doc"><a href="Default.aspx?PageName=a">menu item 3</a></li>
<li class="doc"><a href="Default.aspx?PageName=a">menu item 4</a></li>
</ul>
</div>
[Code]....
and here is a code in aspx page:
<asp:TreeView ID="TreeView1" runat="server" DataSourceID="XmlDataSourceTreeview">
<Databindings>
<asp:TreeNodeBinding DataMember="folder" TextField="title"/>
Here should be additiona datamembers....
</Databindings>
</asp:TreeView> <asp:XmlDataSource ID="XmlDataSourceTreeview" runat="server" DataFile="~/Menu.xml" XPath="div" TransformFile="~/Menu.xsl"></asp:XmlDataSource>
I am generating a text file on server. I want this file to be able to get downloaded by clients accessing the site. Like, when the file is generated a link should appear on the page that says,"Download the File". Clicking that will run a code that will download te file and save it on client's PC. How to do this?
View 3 Repliesi am new to wcf and below is what the WCF WSDL returns, my question is, how to call a WCF service from html page?
[Code]....
I try to use internationalization in MVC but I can not make the resource strings public to my application.If I follow Steve Sanderson then I have to create a resource file and enter my strings. But in the window to enter the strings I can not choose the drop down to change the modifier because it is inactive (grey).
View 2 RepliesHow to make exported .XLS file Editable Thid code makes .XLS File Read Only
:(
using System;
using System.Data;
using System.Configuration;
using System.IO;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public class GridViewExportUtil
{
/// <param name="fileName"></param>
/// <param name="gv"></param>
public static void Export(string fileName, GridView gv)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("content-disposition", "attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.Charset = System.Text.Encoding.Unicode.EncodingName;
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Unicode;
HttpContext.Current.Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble());
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
// Create a form to contain the grid
Table table = new Table();
// add the header row to the table
if (gv.HeaderRow != null)
{
GridViewExportUtil.PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}
// add each of the data rows to the table
foreach (GridViewRow row in gv.Rows)
{
GridViewExportUtil.PrepareControlForExport(row);
table.Rows.Add(row);
}
// add the footer row to the table
if (gv.FooterRow != null)
{
GridViewExportUtil.PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
/// <summary>
/// Replace any of the contained controls with literals
/// </summary>
/// <param name="control"></param>
private static void PrepareControlForExport(Control control)
{
for (int i = 0; i < control.Controls.Count; i++)
{
Control current = control.Controls[i];
if (current is LinkButton)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as LinkButton).Text));
}
else if (current is ImageButton)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as ImageButton).AlternateText));
}
else if (current is HyperLink)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as HyperLink).Text));
}
else if (current is DropDownList)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as DropDownList).SelectedItem.Text));
}
else if (current is CheckBox)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as CheckBox).Checked ? "True" : "False"));
}
if (current.HasControls())
{
GridViewExportUtil.PrepareControlForExport(current);
}
}
}
}
I have an asp.net mvc project, its build just from views, controllers, models, and other files. I have any codebehind file in my views. Does it makes sense to create them for using sometime? Is it some situation when they giving more abilities and advantage for developer?
View 3 RepliesHow can i Make A Text File In Memory(Ram -> Save NoWhere) And Write Something On It And Open NotePad on top of Client browser And Open That Text File In It And Let the user save it by him/her self? -> in code behind
View 1 RepliesI have a hquery plugin that consists of jquery itself, 2 .js files and some script to configure the plug-in which resides on the page. I noticed that in .net you can create a .js file.What I would like to do is put the configuration inside a .js file created in .net, but how do I then reference this in the header of the page
View 1 RepliesI need to make a backup file(.bak) of a database(.mdf)
I learned I need to use MS SQL Server management studio Express to do so, but I can't figure it out how.
I don't know how to connect to the database using this program. In the "Connect to Server" dialogue window, I am supposed to choose a server name from the dropdown list, but nothing comes up. What am i doing wrong?
I need to make a back up file(.bak) from my database (.mdf)
I learned that i need to use Ms SQL Server management studio express. I can't figure out how to connect to the database. looks like I need to select a server type, but nothing comes up for me to select. The databse was made using visual developer 2008 ms sql server, so i thought something like "SQl Server 2005 or 2008" comes up, but it didn't.
how to make a copy of a report! I have a report completed - i wanted to make a copy of this report and change a few things to make a new report. (Rather than starting from scratch.) Within VS 2008, if i right-click on the report and hit copy, then right-click on the folder to paste a copy, paste is not an available option.
View 2 RepliesI've been trying to get my Web Service in my wcf project to be able to reference the resource objects in my resource file but to no avali.Please kindly advice and assist on what went wrong.
View 1 RepliesI'm trying to let the user download different documents where the data is stored in an SQL DB. In firefox, the filetype is correctly read, but not in IE. I'm trying to do this without having to set the ".pdf" or whatever extension the document has, because I haven't got that information. I only have the filetype.
[Code]....