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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Interactive sort - keep toggled data open

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :Sql Server
 
I have created a matrix with a toggle option on one of the rows (when the report is initially run this row is hidden).  This row, when toggled produces 10 or more rows with data.  In the column headings I have given the user the option to interactively sort through the data that is stored in this row.  The problem that I am having is that when I choose to sort the data after I have toggled to see the data, the report re-renders and the goes back to the un-toggled view.  So I have to re-toggle to see what my sorted data. I want to be able to view my sorted data without having to toggle back out. I believe the solution lies in Row visibility "show or hide based on expression".  I just don’t know what expression to use... or if the solution is more complex. is this possible??


View Complete Post


More Related Resource Links

Merge SQL to Excel--Need .Net button to open on fly and have current SQL data!

  

           Hello all,
I do not know if this is the proper place to ask this, but my question is...
I have a SQL DB and I want to convert it to Excel Sheet (I did this using the wizard)!
In my aspx page I have a button.  So when I press this button I want the Excel sheet to open!  But I need the Excel sheet to show me the up to date information that is in the SQL DB.  

Practical OData: Building Rich Internet Apps with the Open Data Protocol

  

See how you can build Rich Internet Applications that take advantage of the OData protocol to creatively interact with Silverlight, PowerPivot, SQL Server, SharePoint, the Windows Azure platform, "Dallas" and more.

Shayne Burgess

MSDN Magazine June 2010


Cannot open data library in SPD2007

  

Help: For some reason, I'm unable to one of my data source library - sharepoint list i SPD.

 I can see the sharepoint list but when I select the list "show data" I get an error on the "Data Source Details" tab.

"The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again. If the problem persists, contact the server administrator."

When I open the list directly in IE it sees to work just fine, I see not problems there. When I open a customized view form (aspx) it fails.

If I try to create an new apsx and insert data source control for the sharepoint list, then I can see the fields in the list when I open properties on the data source.

If I insert a sharepoint control "custom list form" then I can see "preview" data from the list.

Does anyone have a clue why not I or anybody else can't open that list/form and data library?

Using SPD2007 and WSS 3.0, the SQL server is sqlexpress 2005 and is installed on the SP server


Henry

How to specifically sort the data in a database using c#?

  
<!-- [if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"

Interactive Sort - problem when toggling

  
I have created a matrix with a toggle option on one of the rows (when the report is initially run this row is hidden).  This row when toggled produces 10 or more rows with data.  In the column headings I have given the user the option to interactively sort through the data that is stored in this row.  The problem that I am having is that when I choose to sort the data after I have toggled to see the data, the report re-renders and the goes back to the un-toggled view.  So I have to re-toggle to see what my sorted data. I want to be able to view my sorted data without having to toggle back out. I believe the solution lies in Row visibility "show or hide based on expression".  I just don’t know what expression to use... or if the solution is more complex. Help please.

Dynamic Data Entity Framework: Initial Sort Order for Views

  
Hello Steve,I'm trying to set an initial sort order for my View (not table) in Dynamic Data using Entity Framework 2. I have updated my Model and Imported the View. Now I'm trying to use the DisplayColumn attibutebut it's not working.[DisplayColumn("Product", "ParsingOrder", true)]Fabio

Removing Extra Padding Around Interactive Sort Arrows

  
I have a report (using SSRS 2005) which uses Interactive Sorting for all the headings in the table. There appears to be padding around the sort glyphs (arrows) on both the left and the right.  It looks like it is padding about 10px on the left and 10px on the right.  I don't have any setting in my report to explain this.  This means I have to size the text boxes to be a lot larger than they need to be otherwise the heading label wraps to another line. Here's what the text box looks like: ---------------------- | Review Date     ?     | ---------------------- As you can see in my representation there is a lot of padding to the left and right of the sort image. Is there anyway to get rid of this extra padding around the sort glyphs?  I've tried everything I can think of.  If not, can I keep the heading labels from wrapping?  I've tried non-breaking spaces but they still wrap to the next line. Thanks in advance, -- John...

Cant open dtsx project when the data source is Excel

  
hi All, i have problem opening my dtsx file. it returns error like: TITLE: SQL Server Import and Export Wizard ------------------------------ An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. ------------------------------ ADDITIONAL INFORMATION: Exception has been thrown by the target of an invocation. (mscorlib) ------------------------------ The connection type "EXCEL" specified for connection manager "{AD831AF9-657F-4509-981E-EE593FDFA421}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.  ({004CD349-A469-43E7-AE5E-CDA5629AEBFB}) ------------------------------ The connection type "EXCEL" specified for connection manager "{AD831AF9-657F-4509-981E-EE593FDFA421}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.  ({004CD349-A469-43E7-AE5E-CDA5629AEBFB}) everything was working fine a week ago, when i try to open it again this mornging for modification, everything isnt good. any idea what should i do? thanks!!!AddinGanteng

how to open a subform model Form,Sub Window form using jquery that save the data ajex

  
how to open a subform model Form,Sub Window  form using jquery that save the data ajex

Creating a Form say grid sort of a interface where in data values will be extracted from the table 4

  

how dis can be done help please with simple button click and changing the values it can be done but how to move columns with data in graceful manner the way we have in calendar control... 


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

  

Hi..

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

This are the url comes from database and binded in gridview

www.xxxxxx.com/A/Default.aspx

www.xxxxxx.com/B/Default.aspx

www.zzzzz.com/C/Default.aspx

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...





Data Source Library won't open / grayed out

  
Hello!

I saw a similar question but the answers didn't solve my problem so here it goes.  I have a site, and many subsites underneath.  For all of them it says I'm owner/full control.  They even gave me control of the site above mine so I could have permission to do a lot of things on my sites.  Ok well every site works the same.  I open them in SharePoint Designer and can insert data view and see the data sources under the "current site".

However, this one site i have says "current site" in the data source library tab, but it is grayed out and I can't expand it.  My IT contact has no idea what's wrong since I have full permission to all these sites.  I can add webparts through sharepoint designer to this site, I just can't add data views (and I really need data views for what I'm doing).

This is a site that's been around for a bit but this is the first time I started using it to insert data views.  Unfortunately it's a live site so I can't just delete/recreate as other things on the site are currently in use and going through workflows.  

Any suggestions are appreciated!  Where can I look?  What should I check? 

Thanks so much!

Change Default Sort for Dynamic Data Web Application

  

Hi,

 

I just created a dynamic data web application and setup a simple .EDMX file. Next, I created meta-data / partial classes to ensure that my integer identifiers wouldn't show up:

 
// ...

[ScaffoldColumn(false)]

public object TableId { get; set; }

 // ...
 

I wanted to now set the up the list pages so they sort using a different attribute ("Name" in this case). Anyone know if this is possible / how to do it?

 

Thanks!

 

Kevin

 


Data view - Sort with comma

  

Hi

I have implemented a data view web part with SharePoint Designer on a site with Locale Finnish/Swedish. The data view aggregates data from several lists within the site. My first problem was that numbers with commas wasn't displayed in my data sheet. I found a workaround where I added the following lines to the XSLT:

<xsl:decimal-format decimal-separator="," grouping-separator="." name="lcid1060" />

 <xsl:value-of select="format-number(translate(@MyColumn,',','.'), '#,0','lcid1060')"/>

By doing this I can get the values formatted as numbers with commas as separator.

My problem is however that the sort function in the data sheet view web part sorts the column as text. So my question is how to get the data view to sort the column as a number instead of text?

Best regards,
Niclas 
   


Niclas Carlsson

Trying to enumerate the contents of folder ''. Can't open data connection (425).

  

Hello Guys,

I know there were posts before about this issue but contacting the web hoster did not help me.
The oddity is, that the same website files, copied and pasted, connection string altered to point to the
production/live db, published to the httpdocs folder works fine BUT the same web files, copied and
pasted, connection string altered to poin to the dev db, published to the subdomains/dev fodler causes the error below:

 ------ Build started: Project: AHN, Configuration: Debug Any CPU ------
   AHN -> P:\Web_Development\xxx\DEV\bin\xxx.dll
------ Publish started: Project: xxx, Configuration: Debug Any CPU ------
Connecting to ftp://xxx.co.uk/subdomains/dev/httpdocs...
Transformed Web.config using Web.Debug.config into
obj\Debug\TransformWebConfig\transformed\Web.config.
Copying all files to temporary location below for package/publish:
obj\Debug\Package\PackageTmp.
Deleting existing files...
An error occured trying to enumerate the contents of folder ''. Can't
open data connection (425).
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Publish: 0 succeeded, 1 failed, 0 skipped ==========


When I asked the hoster whats going on, he obsiously that its not his fold because the publishing is

Matrix column Interactive sort

  

Hi,

 

In one of my reports, there is a requirement to provide interactive sort functionality on all the columns of the matrix report.

(Reporting Services 2005).

 

I was successful in implementing the interactive sort on the row groupings, but was unable to do the same on the column groupings.

 

For example , I have the following :

Categories: 
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