.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Make entire sparkline chart a drillthrough link

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server
Using SSRS 2008 (not R2) I have a sparkline chart that I want to turn into a link to a subreport.  I've been able to make the series be a link, but I want the entire chart to be a link.  Does anyone know how to do this?

View Complete Post

More Related Resource Links

SSRS 2005 Drillthrough chart Passing Wrong parameter value

Hi I have a drillthrough report that in Report A I have a week of data, showing Sunday through Saturday on the X-axis. When a data point is clicked on this chart, it shpuld pass the date of the weekday for that data point to Report B. But sometimes, it passes the prior weekday date, eg click on the Monday date data point, but Sunday's date is passed to the next report. Has anyone observed this type of behavior? I should mention that it is intermittent.   Thanks all.   Bobrpress

WpfDataGrid make cell background fill entire cell

Hi!  I'm setting DataGridColumn.CellStyle to a background color and to a horizontal alignment. If I do not set the horizontal alignment the whole cell is filled with the background color but if i set the horizontal alignment the background color only is shown behind the text in the cell. I've seen some workarounds to this problem (http://stackoverflow.com/questions/1379902/setting-column-background-in-wpf-listview-gridview, setting the Margins on the DataGrid and the Cell margin) but it does not work for me. The background is still only shown behind the text   private void ApplyCellStyle(Style defaultColumnStyle, DataGridColumn dataGridColumn, Color backgroundColor, HorizontalAlignment horizontalAlignment) { var style = new Style(typeof(DataGridCell), defaultColumnStyle); var backgroundPropertySetter = new Setter { Property = Control.BackgroundProperty, Value = new SolidColorBrush(backgroundColor) }; var horizontalAlignmentPropertySetter = new Setter { Property = FrameworkElement.HorizontalAlignmentProperty, Value = horizontalAlignment }; style.Setters.Add(horizontalAlignmentPropertySetter); style.Setters.Add(backgroundPropertySetter); dataGridColumn.CellStyle = style; }   Does anyone know a solution to this problem?    Regards, Lina

Is it possible to make Reporting Services use a different chart rendering engine instead of the buil

Is it possible to make Reporting Services use a different chart rendering engine instead of the built-in one? E.g. to generate a datafile (e.g. CSV) and then use e.g. http://www.highcharts.com/demo to display the chart, rather than the built-in chart in reporting services?

make Gridview data as hyper link with alias open in new window



I have one asp.net C# page in which i have gridview..

This are the url comes from database and binded in gridview




what i need is i need to show this url has like this

www.xxxxxx.com/A/Default.aspx is like Test1

www.xxxxxx.com/B/Default.aspx is like Test2

www.zzzzz.com/C/Default.aspx is like Test3

if user click Test1 it will open a new browser window with www.xxxxxx.com/A/Default.aspx

if user click Test3 it will open a new browser window with www.zzzzz.com/C/Default.aspx 

how to make this in gridview please help me in this...

How to make sure that the entire table tag won't change ?


Hi everyone,

I know this sounds a bit noob but I still don't know if there's a way to do this or not. Let's say we have 3 columns. 2nd column (the middle one) is populated with a detailview when the user click something on the first column, then it shows in the middle column detailview. So, it's like

column1        column2(middle)        column3
Something    DetailView                  Something more

But the point is, if the detailview is a bit longer, then the entire table size change. column2 becomes very long and column1 and column2 also changed their style by shrinking the same size as in column2. I have no idea if there's such way to make those layout flexible. I don't seriously wanna limit the height of the column2 from CSS though. Thanks all.

How to make many-to-many field to link of List page in details page,please?



How to make many-to-many field to a link of List page in details page template,please?

Because my another end of many-to-many field include too many data.

MSDN Abstract Classes Link

MSDN Reference For Abstract Clases

Chart Tutorial

The AxisTitle class declares properties that define the common appearance settings of a title which is displayed by a particular axis.

Properties exposed via the AxisTitle class allow you to customize common title attributes, such as:

* the axis title's text (Title.Text),
* the color and font settings of the title's text (TitleBase.TextColor and TitleBase.Font),
* apply antialising (smoothing) to the title's text (TitleBase.Antialiasing),
* the alignment of the axis title (Alignment),
* the visibility of the axis title (TitleBase.Visible).


Unique ID throughout entire request



I am hoping somene here could advise me on a better solution to my present problem.  First a little background information on the application. 

I have a web application using the 3.5 framework.  The structure of this application is as follows: UI -> WebService   -> Business Layer -> DataAccess Layer.   What I want to accomplish is for every request (click on a link or button) have a unique identifer that follows this request through its entire lifecycle.  This unique identifer can be accessible anywhere within this request.  We use Response.Redirects which could easily be changed to Server.Transfers (although I do not want to do that) but  the problem lies with the web service calls.  Currently, a GUID is set in the ApplicationRequest.  This GUID checks for a guid value in the RawURL and if so, assigns this value to a HttpContext Item.  If not, HttpContext.Items gets a new one created.  However, this idea is wrong and will need to be revisisted.  The bigger problem is with the web service calls.  Without changing every web service method signature, and every call for that matter, is there a way of getting this GUID there.  I created a web method in every web service so that each time I instantiate a web service object in the UI, before calling any

How to let user edit selected gridview columns, not entire row



I've got a gridview I would like to let the user edit a couple of columns.  Seems like everything I'm coming across so far makes the entire row editable.  

Hopefully the solution isn't too complicated.  Can someone point me in the right direction?


Beginner: this doesn't make sense to me


Do you need and "empty" script tag in the head to run scripts that are in the body?  Also, can you run JQuery scripts if they're in the <head> tag?  The first sample only works if the JQuery script is in the form (and body) tag, not in the head - even if I add $(document).ready(function() { });

This works

<head runat="server">
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" />
<script type="text/javascript">
<form id="form1" runat="server">
<a href="">Here is a link</a>
<script type="text/javascript">
$('a').click(function () {
alert("you clicked me!");


This doesn't work.  Notice I removed the second <script> tag from the head

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="serve

how to make a dropdownlist looks like google search box


dear all...

any idea how to do that ?

Thnx in advance

How can I be sure that my entire project is up-to-date and free of errors in VS2010?


Seems like a stupid question, but I will go to Build > Build Solution many many times and the build will succeed many many times, then I will put in a minor syntax error and the build will fail, BUT the build will not fail because of the minor syntax error; it will fail because of an unresolved type that I put in about twenty compiles ago. And then I will fix the minor syntax eror, and the compiler will still complain about the unresolved type. Here is my code:

<%@ Register TagPrefix="FTB" Namespace="FreeTextBoxControls" Assembly="FreeTextBox" %>
  <form runat="server">
  Hello World!!  

Pretty simple, really. I go to Buld > Build WebApplication1 and it runs OK. Now, if I put in a minor syntax error, such as substitute "forrrrrrrm" for "form" and then try to Build Solution, it complains not about the misspelled word, but about the FreeTextBox. And then if I correct the misspelled wird, it still complains about the FreeTextBox. Which leads me to believe that Building the Solution does not check absolutely 100% everything that needs to be checked. Is there a more thorough way of compiling a program that I need to use?

Need Syntax To Make Results of LINQ Union Return Non-Generic Type



I have the below SQL which works just fine:

SELECT     Message, CreateDate, AccountId, AlertTypeId
FROM       dbo.Alerts
SELECT     TOP (100) PERCENT Status, CreateDate, AccountId,
                          (SELECT     10 AS Expr1) AS AlertTypeId
FROM         dbo.StatusUpdates
WHERE AccountId = PassedInParameter

I have been going about trying to convert the above into a LINQ method and am having problems with return types.
As the above SQL illustrates, I am querying two distinct LINQ tables - Alerts and StatusUpdates -
and then attempting to perform a Union on them. In order to do the union in LINQ, I have to have agreeing types. So, I
am using "var" to make the results of "alerts" and "updates" generic before the union.  

public IList GetStatusUpdatesAsAlertsByAccountId<T>(Int32 accountId)
            using (WorkbookDataContext dc = _conn.GetCont

Unable to make connection to database?


Hy guys. I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.

I have database called PhoneDirectory.

It have only one table named Residents.

I have button wiht ID="Button1".

I want when i click this button to see all of my residents. 

I want to see the result in DetailsView and to be able to edin, delete and add new resident.

First try with SqlDataSource so i wrote this:

<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>" 
              SelectCommand = "SELECT * FROM Resident "

video tutorial link for composite and rendered custom server control


hii all

i am new to technology so go easy on this post

according to what i read from web there are 3 type of custom server controls

1 superclass

2 composite

3 rendered

i found video tutorial for superclass custom server control but couldnt find video tutials for other 2.

please forward me link for composite and rendered custom server controls video tutorial  

Html Link Button


Hi All,

I would like to create a html link button(in aspx page) so that the page could not post back and some controls to display on clicking link button.

Can any one of you help me regarding this issue?

Let me know if you have any queries.



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend