|
Hi,
I have a number of reports, one for each question on a questionnaire. They're all supposed to be pie charts and show the results as a "Yes"/"No" split.
Rather than write a separate report for each question, I'd like to create one report called (for example), "generic.rdlc". I would then load this report and dynamically set a data-source to it. All I'd then have to do is change or set the column name to report on.
Can anyone suggest a way of doing this?
The report .rdlc format appears to be a basic XML file and I can find where to set the column, so I guess I could write the column name to the file before I load it. Is that really the best way to do it though? Is there not an API method I can use to "poke" a value into the report?
Incidentally, I'd also like to set the name of the report so I can title it appropriately - again, surely I shouldn't have to write this value to the report file directly?
Thanks for any help offered 
|
|
|
|
|
Hi there guys.
Background:
Im currently developing a website that displays data retrieved from MS SQL Server on a chart with MS Charts. The data stored in MS SQL Server table is a temperature measurement taken every second. Every thing works fine. As long as i dont exceed 1 hour of data points. Well up to 4 hours sometimes work as well. But as sson as I increase the range of datapoints to display on the chart(using fastline series) it takes forever and even sometimes times out.(Im using Microsoft Visual Basic 2008(C#) ASP.NET and MS Charts)
Question:
1.Is there another chart application that handles large amounts of data beter.
There is several available but I cant say which will handle large data quantities beter.
(and this is for a University final year project so the budget is very tight)
2.Is there a way to maybe speed up MS charts.
3.And finally I even tried to filter my SQL query to return only every 60th row which I dont mind on say a 12 hour chart. But I cant seem to find any solution to return every nth row that works.
Thanks in advance.
Any help will be much appreciated.
Cobus
|
|
|
|
|
you need to optimize your sql queries.
Everything Is Possible!
|
|
|
|
|
Suresh Dayma wrote: you need to optimize your sql queries.
Thanx. I figured that would be the best. Building a custom query to select only every 60th row. Could just not find a good solution to such a query.
Current solution that ive got that is working is creating an empty data table and then using a for statement to select a specific row and appending it to the datatable with the row identifier as the for counter multiplied by 60 or whatever the case may be until the spesified date or time is reached. Thus creating a table with the relevant time span but only selected values.(thus painting the chart is much faster due to less values)
This works fine just feels cumbersome and sloppy. Well thanks so far.
|
|
|
|
|
I have a master page and set it's back ground color in the body tag . Now that is fine for the Master page. How do I set the back ground color of the content page to a different color?
Thanks,
Steve Holdorf
|
|
|
|
|
Hi,
You cannot set the background color of a content page since it does not have a body tag.
The work around is to create a inside the ContentPlaceHolder and change its color.
Here is the code
<div style="background-color: #FFFF00; width: 100%; height: 100%">
</div>
Hope this helps.
Sujoy Upadhyay
|
|
|
|
|
You are not right. You can do the change. See my post below.
|
|
|
|
|
Add runat="server" and ID attribute of body tag in Master Page.
<body style="background-color:Gray" id="masterBody" runat="server">
Add a new PageBackground property in master page code behind and in page load assign the property value in body style.
public String PageBackgound { get; set; }
protected void Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(PageBackgound))
{
masterBody.Style.Add(HtmlTextWriterStyle.BackgroundColor, PageBackgound);
}
}
In your content page get the master page reference and assign PageBackground property value
MasterPage myMaster = (MasterPage)Page.Master;
myMaster.PageBackgound = "#ccff99";
Hope this will solve your problem.
|
|
|
|
|
Thanks for providing the code.
I am trying to compile the code you have provided.
It is giving me error
'MasterPageCP.PageBackgound.get' must declare a body because it is not marked abstract or extern
Please help
Sujoy Upadhyay
|
|
|
|
|
Code is valid - it should work fine. Go in to the property pages of your project and make sure that the "Target Framework" is .NET 3.0 or 3.5.
|
|
|
|
|
This wont work for .Net 2.0?
Sujoy Upadhyay
|
|
|
|
|
In 2.0 , you need some changes in property declaration
private string _background;
public String PageBackgound {
get { return _background; }
set { _background = value; }
}
|
|
|
|
|
Steve Holdorf wrote: set it's back ground color in the body tag . Now that is fine for the Master page
change style tag with class, because it to difficult to override style tag from content page
for example in masterpage
<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" Inherits="MasterPage" %>
<!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></title>
<asp:ContentPlaceHolder id="head" runat="server">
</asp:ContentPlaceHolder>
<style>
.bodyClass
{background-color:Red;}
.conetntpage
{background-color:White;}
</style>
</head>
<body class="bodyClass";>
<form id="form1" runat="server">
<div>
<asp:ContentPlaceHolder id="ContentPlaceHolder1" runat="server">
</asp:ContentPlaceHolder>
</div>
</form>
</body>
</html>
now in content Page PageLoad
public partial class contentpage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("<script language=\"javascript\">");
sb.Append("document.body.className=\"conetntpage\";");
sb.Append("</script>");
ClientScript.RegisterStartupScript(this.GetType(), "MyScript", sb.ToString());
}
}
Hop this will help you
Raju.M
|
|
|
|
|
Everything above looks great; however, someone indicated that all I have to do is set a style background-color in the content page to a different color. If this is true in which content page tag do I set the background-color style?
Thanks,
Steve Holdorf
|
|
|
|
|
Got it working. Just did this:
Add this in the master page head
<asp:contentplaceholder id="head" runat="server">
<asp:contentplaceholder id="head" runat="server">
Set some background color to whatever control you want, either div or table etc in the master page.
Then in content page, you can set the style in its head,
If you do not have any head section in the master page and insert style in content page, you will get an error
content page will look like this:
view plaincopy to clipboardprint?
<asp:content id="Content1" contentplaceholderid="head" runat="server">
body,html
{
background-color: White;
}
Thanks for all of you guys helping me.
Steve Holdorf
|
|
|
|
|
I am loading dropdown list using c#. I need to load data from dropdown into Listbox using javascript.
|
|
|
|
|
var obj = document.getElementById('<%=YourDropDown.ClientID %>');
var obj2 = document.getElementById('<%=YourListBox.ClientID %>');
for (i=0;i<obj.options.length;i++)
{
obj2.options[i] = new Option(obj[i].text, obj[i].value);
}
|
|
|
|
|
Thanks Gray, I too came to know about this. only thing bothers me is if drop down contains more than 100 records how is the performance?
|
|
|
|
|
The solution is quite good. I dont think performance will be a issue since all operations are on client side.
What say Gray?
Sujoy Upadhyay
|
|
|
|
|
It will definitely affect performance. See this [Faster DHTML in 12 Steps]
Taken from MSDN
Tip: Use innerHTML to add a large number of options to a SELECT element.
Use string concatenation to build up the SELECT element HTML text, then use this to set the innerHTML property. For very large numbers of options, string concatenation can also affect performance. In this situation, build an array and call the Microsoft JScript join method to perform a final concatenation of the OPTION element HTML text.
|
|
|
|
|
I say you shouldn't do it client side at all. You should do it on the server side. I say there are very few reason why you should ever need to UI elements with the exact same data in them. I also say that a dropdown with 100 items in it is not good interface design. You need to figure out some way to break it down or a different UI element to use. But I don't have enough info to give solutions to those issues.
|
|
|
|
|
Hello all,
I have to make a project to keep track of the systems currently in the Network in asp.net.
In other words, I want to have an application in which there must be a check about how many connections are currently in use and which are those connections ( e.g. using their IDs)...
And apart from this, If anyone gets Offline, then his/her status must be triggered as mail to me...so in this way, I can manage the computer Network Connections..
Anyone knows where can I get the sample project for this ...or get simple idea ...?
Thanks in advance..
|
|
|
|
|
I think you must be assigned in college or school to do such exercise.
But my dear friend, this is not code providing forum.
We are here to help you, if you were stuck at some point whether in logic
or technically.
See what I have found by little googling[^].
Also, please go through the forum guidelines[^] before you post anything.
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
|
thanks for sending..
but How could u say like that...?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
