I have a simple web form with a dropdownlist and a ReportViewer. I would like to dynamically change the report within the viewer when the user makes a selection in the dropdownlist. I think I need to alter the ObjectDataSource that the ReportViewer is using. I've tried a few things without success.
View 2 RepliesI have a reportViewer control and I dynamically setting the report path and dataset in the page load event if it is not a post back. This first report displays without issue. However, when I attempt to change the report path / dataset via the onChange event from a dropdown list I get the following error:
A data source instance has not been supplied for the data source "Summary_DataTable1".
This code works fine and the summary report is displayed the first time the page is loaded.
[code]....
I have a data object where one of the properties is a collection of another data object. I never really figured out how to map this to a GridView, but I came up with a workaround. Now I am stuck and cannot figure out any way to do this in a ReportViewer.
Here is how I solved the GridView issue:
Say we have these objects:
public class BoysWithToys : List<BoyWithToy>
{
}
public class BoyWithToy
{
string FirstName { get; set; }
string LastName { get; set; }
int BoyNumber { get; set; }
List<Toy> FavoriteToys { get; set; }
}
public class Toy
{
int BoyNumber { get; set; }
string Toy { get; set; }
}
What I wanted to do was to map BoysWithToys to the GridView and present one GridView row per BoyWithToy record. Where there was more than one FavoriteToys record I wanted to list them in a bulleted list in the FavoriteToys column. I accomplished this by calling RowDataBound() for the GridView, casting the e.Row.DataItem to BoyWithToy, then looping through all of the FavoriteToys and adding each Toy to a bulleted list, then setting the column's text to that list.
I have no idea how to accomplish anything similar in ReportViewer. If I simply drag the BoysWithToys DataSource to the designer and run it, the FavoriteToys column shows '#Error'.
i am building my objectdatasource dynmically when certain buttons are clicked on the page.. and with that the gridview is being displayed with the results of the objectdatasource that was built.
So my gridview code looks like this:
[Code]....
How can i enable sorting and paging if the datasource is being built on button click event?
I have a grid view that I want to dynamically change based on data in my page. Specifically I want to change one of the title items and I want to hide a column based on a certain condition.
View 3 RepliesHow do i dynamically change the value of dataitem in repeater control(.net 2.0,VS 2005)..i have repeater something like this :
<asp:Repeater ID="rptGameInfo" runat=server OnItemDataBound="itemDataBound_rptGameInfo" >
<HeaderTemplate >
</HeaderTemplate>
<ItemTemplate >
<asp:Label ID="lblLoc" runat=server Text="Location:" ></asp:Label><%# Eval("GAME_LOCATION")%><br />
</ItemTemplate >
</asp:Repeater>
and it shows the result like this:
location:"Select"
If location is "Select" i want to change it to "n/a". So i am trying to capture it in itemDataBound even something like this
if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{
DataRowView row = e.Item.DataItem as DataRowView;
string location = row["GAME_LOCATION"].ToString();
if (location == "Select")
{
// e.Item.Text = "n/a";>>
}
Does e.Item some 'text' sort of property ,i can set the value to?
I have a aspx where i have thumbails of pictures in listview, once i click on a picture, picture shows up as big next to list view. Now what i want to do is, have a red color border around the thumbail of picture which is show big at the center. check the Picture I just want to change the CSS class of the image selected in the listview. I get to know which image id is selected through query string PageNO or if <%#Eval("PageNo") %> is =2 then second image css class should be redBorder else imgBorder1 ASPX Page
[Code]....
Code Behind:
[Code]....
How to change the skin ID of the dynamic controls
View 2 RepliesI have an ASP.NET Web Forms app using Entity Framework in the data layer. I've recently changed the app over to use one Object Context per request as per this post. It works great for the entire application except for any page which uses a ReportViewer to display something.
I've noticed that it fails when trying to get an instance of the [Code].... from the [Code].... collection because [Code]....
is null.
Microsoft.ReportViewer.WebForms.dll and Microsoft.ReportViewer.Common.dll can also be seen in the call stack each time it fails. The reports each use one or more ObjectDataSources to retreive data.
Based on this I'm assuming that the ReportViewer is somehow to blame, but i have no idea why. I would need some way to dispose the ObjectContext after it had been used by the report at the very least.
Is it possible to change back ground image of a datalist at run time??
View 2 RepliesI'm trying to change the text of a GridView label in an ItemTemplate and I am having some issues. I searched all over and can't find a solution. This is what I am trying to do...
I have a GridView that has a comment field. Normally when the page is rendered the comment field is truncated using a truncate class that limits field length. The full contents can be displayed in a tooltip when the comment field is hovered over. That part works fine.
I also have an export to Excel class that will take the Gridview and export it to Excel and that part works fine as well...
Now the issue... Because of the truncated field, when I do an export it will export exactly what is in that field, the truncated version of a comment. When the export button is clicked I need to change the .text value of the label that is in the GridView ItemTemplate
From this truncated version...
[Code]....
And then back again after the export routine is complete.
I have accessed the contents of a label before using FindControl but never set a value, is this possible? Also, I have captured what is in the comment field on RowDataBound but by that time, it is already truncated.
I would change the filterexpression depending to the choice of some DropDownList but, i've tryed with ObjectDataSource_Filtering event but it seems that non reevaluate the filter.is it the right event?i've to do any other operations after changing the filterexpression?
View 1 RepliesI have an SSRS report that has a Comments field where there's enough text to span multiple rows per record. It renders fine in the ASP.Net ReportViewer control, but when it's exported the formatting can be different. Exporting to Word it looks fantastic. But exporting to Excel and PDF, the row height for each record is never increased beyond the default, so the text just gets truncated. In Excel I can go in and double-click on individual or multiple row heights to fix them, but this is an extra step we don't want.
View 2 RepliesI have the following on my aspx page
[Code]....
Then in my code behind i have the following set up in 4+ button events, since each button serves a different purpose.. Prior to this past week, i was only working with 2 gridviews on the page.. that were linked to this datasource.. so everything was fine.. but recently had to add a Datalist to display the results a certain way.. I got it all working, but now that more records are in the table the datalist is growing in length on the page and cant figure out how to modify the current code to enable paging without having to redesign the logic all together to get it enabled.
Based on what i have below and above, is there a solution i can implement to implement paging ONLY for the Datalist? Or if it cant be specific, if enabled, will it affect the gridview that is already configured to enable paging, which already works?
[Code]....
EDIT: Purpose of this Website: Its called Utopiapimp.com. It is a third party utility for a game called utopia-game.com. The site currently has over 12k users to it an I run the site. The game is fully text based and will always remain that. Users copy and paste full pages of text from the game and paste the copied information into my site. I run a series of regular expressions against the pasted data and break it down. I then insert anywhere from 5 values to over 30 values into the DB based on that one paste. I then take those values and run queries against them to display the information back in a VERY simple and easy to understand way. The game is team based and each team has 25 users to it. So each team is a group and each row is ONE users information. The users can update all 25 rows or just one row at a time. I require storing things into cache because the site is very slow doing over 1,000 queries almost every minute.
So here is the deal. Imagine I have an excel EDIT(Excel is just an example of how to imagine it, I don't actually use excel) spreadsheet with 100 columns and 5000 rows. Each row has two unique identifiers. One for the row it self and one to group together 25 rows a piece. There are about 10 columns in the row that will almost never change and the other 90 columns will always be changing. We can say some will even change in a matter of seconds depending on how fast the row is updated. Rows can also be added and deleted from the group, but not from the database. The rows are taken from about 4 queries from the database to show the most recent and updated data from the database. So every time something in the database is updated, I would also like the row to be updated. If a row or a group has not been updated in 12 or so hours, it will be taken out of Cache. Once the user calls the group again via the DB queries. They will be placed into Cache.
The above is what I would like. That is the wish.In Reality, I still have all the rows, but the way I store them in Cache is currently broken. I store each row in a class and the class is stored in the Server Cache via a HUGE list. When I go to update/Delete/Insert items in the list or rows, most the time it works, but sometimes it throws errors because the cache has changed. I want to be able to lock down the cache like the database throws a lock on a row more or less. I have DateTime stamps to remove things after 12 hours, but this almost always breaks because other users are updating the same 25 rows in the group or just the cache has changed.This is an example of how I add items to Cache, this one shows I only pull the 10 or so columns that very rarely change. This example all removes rows not updated after 12 hours:
DateTime dt = DateTime.UtcNow;
if (HttpContext.Current.Cache["GetRows"] != null)
{
[code]...
I have to be able to dynamically change the sproc name that is used in a Linq to SQL query. I see in the dbml designer this:
[Function(Name="dbo.InsertUnknownMessage")]
In an asp.net 3.5 web app, I have a page with the following markup/code (this is the brief version, but I believe I got all the relevant info).
[Code]....
The form contains 2 different record types, accessed using the paging controls, depending on the ParentSR field; a parent SR will be something like '1234' while its sub-record will be something like '1234.1'. There are only a few differences in the fields used between the 2 different record types and that is why they are stored in the same table. However, the activity depends on the record type. When browsing from the parent record to the sub-record, the itemtemplate loads fine (notice in the formview's datasource
query, that the sractivity_id field is being pulled along with the subquery value). But when going to edit the record, the page throws an error:
System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentOutOfRangeException: 'ddlActivity' has a SelectedValue which is invalid because it does not exist in the list of items.
If i click 'back' and retry, it may take 3 attempts, but then the edittemplate will load just fine. I should also point out that this error does not always occur. I've been trying to figure this out for a couple months and it is driving me nuts, mainly due to the fact that I can't reproduce the error in development--it seems to only occurr in production. Anyone with any thoughts on what is going on?
I have a vb.net web site. Currently it is generating reports via ReportViewer. The datasouce for the all reports is set at the deploying of the report.
ReportViewer is configured in the aspx page
<rsweb:ReportViewer ID="myReportViewer" runat="server" ShowParameterPrompts="true"
ZoomMode="Percent" Height="1100px" Width="1000px" BorderWidth="1">
</rsweb:ReportViewer>
I am setting up the ReportViewer using the following code.
Dim _cred As New ReportServerCredentials(Session("_ApplUser"), Session("_ApplPswd"), Session("_ApplDom"))
'Set the processing mode for the ReportViewer to Remote
myReportViewer.ZoomPercent = 100
myReportViewer.Width = Unit.Percentage(100)
myReportViewer.Height = Unit.Percentage(100)
myReportViewer.ProcessingMode = ProcessingMode.Remote
Dim _SrvRpt As ServerReport
_SrvRpt = myReportViewer.ServerReport
_SrvRpt.ReportServerCredentials = _cred
'Set the report server URL and report path
_SrvRpt.ReportServerUrl = New Uri(Session("_RSConn"))
_SrvRpt.ReportPath = Session("_RSFold") + _rr.Report_Path
myReportViewer.ServerReport.Refresh()
lblTitle.Text = _rr.Report_Title
myReportViewer.ServerReport.Refresh()
myReportViewer.Visible = True
What I want to do is dynamically set the datasource for a report at runtime. That is, I have 2 datasources already configured in my Report Manager. I want to have the vb.net pick which datasource based on a enviornment variable. So, if Env 1, then use Datasource 1 in the Report Manager. Of Env 2 then use Datasource 2 in the Report Manager. I have seen what looks like software for doing this Locally but no for Remote.
We have a database with around 5000 records in it. We also have a web page that displays many of the fields. One field is an nText field and displays up to several paragraphs. My customer wants me to add those A+ and A- buttons for increasing and decreasing the font size for this field. My problem is that many of the older records have quite a bit of formatting in the field. Most of the rest contain styles dictating a font size of 12 px. Is there a way to increase and decrease the font soze of the text without modifying all the records?
Here's an example:
[code].....
I'm working on a project that have 3 diffrent type of users with 3 diffrent master pages. I can verfiy there access level and let them view pages but after googling I came accross a tutorial form asp.net but it wasn't very helpfull the code I got listed below works only if the session is at null, It dosen't seem to pull the session value.
[Code]....
there is a class page attached to it but nothing seems to work. I've downloaded the tutorial but it wasn't any clearer than what I read.
I 'm just trying not to have to code over the joint pages.
I'm running CR XI, and accessing .RPT files through a ReportViewer in my ASP.NET pages. I've already got the following code, which is supposed to set the Report Datasource dynamically.
rptSP = New ReportDocument
Dim rptPath As String = Request.QueryString("report")
rptSP.Load(rptPath.ToString, 0)
Dim SConn As New System.Data.SqlClient.SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString)
rptSP.DataSourceConnections(SConn.DataSource, SConn.InitialCatalog).SetConnection(SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password)
Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo
myConnectionInfo.ServerName = SConn.DataSource
myConnectionInfo.DatabaseName = SConn.InitialCatalog
myConnectionInfo.UserID = SConn.UserID
myConnectionInfo.Password = SConn.Password
'Two new methods to loop through all objects and tables contained in the requested report and set
'login credentials for each object and table.
SetDBLogonForReport(myConnectionInfo, rptSP)
SetDBLogonForSubreports(myConnectionInfo, rptSP)
Me.CrystalReportViewer1.ReportSource = rptSP
But when I go into each .RPT file, and open up the Database Expert section, there is obviously still servernames hardcoded in there, and the code listed above doesn't seem to be able to change the servernames that are hardcoded there.
I say this because I have training and production environments. When the .RPT file is hardcoded with my production server, and I open it on my training server with the code above (and the web.config has the training server in the connection string), I get the ol:
Object reference not set to an instance of an object.
And then if I go into the .RPT file, and change over the datasource to the training server, and try to open it again, it works fine. Why doesn't the code above overwrite the .RPT files datasource?
How can I avoid having to open up each .RPT and change the datasource when migrating reports from server to server? Is there a setting in the .RPT file I'm missing or something?
I have some javascript to iterate the divs in my web page. There is also a ReportViewer control. If I look at the HTML in FireBug in FireFox I can drill down to a div with an id of "oReportDiv". However, my javascript does not pick this up and if I view Source I cannot find it there either. It is the same story in Internet Explorer - I can find the div in the developer tools but not in the source.
The div is buried in nested iFrames and Framesets and all sorts of nasty looking stuff.
I have a datagrid called studentAddList which is combined by 2 tables. Now I have a reportviewer called ReportViewer1. They are both placed on the same page. Now I would like to bind the datagrid studentAddList to the reportviewer ReportViewer1. The reason why I bind the datagrid to it is because I have some filtration on the data.
View 5 RepliesI would be more than happy if someone with creating a dataset programmatically then connect it to my reportviewer programmatically. If you have vb.net examples
View 3 RepliesI'm writing a script and need with being able to modify the ImageUrl property in a HyperLink control from the code behind page. It is meant to dynamically show an image.
I just need to know the correct format of the code behind to get this to work.