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

Top 5 Contributors of the Month
Post New Web Links

Edit Sql Query for building reports

Posted By:      Posted Date: August 24, 2010    Points: 0   Category :ASP.Net


          I have one SQL Query and it is working fine. Now, I want to access another table using One of the columns in this table.

How can I access that value and How to put that in the existing SQL Query


View Complete Post

More Related Resource Links

Building Reports in SharePoint Integration Mode

 I configured and connected SSRS to my SharePoint farm, but how do I go about creating reports?  The usual <my server>/reports url is disabled in SharePoint integrated mode.  Can someone point me in the right direction? Thanks, Eric

Building SSRS reports based on SharePoint 2007 lists

Hi,   I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list. The difficulty I'm facing is the following: The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication. Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?   Kind Regards,  AVermaas    

Adding a table or view multiple times when building a query with BI Report Designer and Report Build

How can I add a table/view multiple times to a single query by using BI Report Designer or Report Builder 3.0? In Report Designer I managed (workaround) to add one table multiple times by creating multiple Named Queries and having the same SELECT. Still I don't know how to add one table multiple times in Report Builder 3.0.

Content Query Webpart to show edit item link field in SPS2010


I have a Content Query Webpart in SharePoint 2010 that I would like to surface Documents grouped by content type. I wish to show the edit form or view Properties link as part of the fields shown in the results. When the User clicks on this link, it should take him to the edit form or view Properties page for the document.

Any ideas?

Unable to edit master page - message "building report"


I am able to open the site (SPS 2010) using Sharepoint Designer 2010. When I browse to the master page, I can check it out and when I try to edit, it gives me a message saying that it is trying to build the report. But nothing happens even if I wait for hours.

I am trying to edit the master page so that I can change the top banner and to provide mouse-over text for the sites. I would really appreciate if anyone could provide any advice to get around this.

I am also curios about one thing. For some reason, I am unable to open the site using sharepoint designer if I try to open the site via http. But I am able to open the https site. Does it have to do anything with alternate access mappings?

Please advise.

Building a query into a SSIS package


I have a simple package that imports data from an excel file to a 2008 R2 database.

here is a sample of the excel file

54            Siobhan Kennedy               Health

22            Peter OChahan                  Education

31            Ryan Harkins                     Finance


My table in the database looks like this:


CREATE TABLE [dbo].[Employee](

[EmployeeID] [int] NULL,

[FirstName] [nchar](50) NULL,

[LastName] [nchar](50) NULL,

[Department] [nchar](50) NULL)


I want to import the data into the database, splitting the name column into firstname and lastname using the SSIS package.

So far (on the data control tab) I have an 'Excel Source' Box and an 'OLE destination' Box.

I think i need to pick an option from the 'Data Flow Transformations' menu in the toolbox. Is this correct?




Error when Content Query Web Part in Edit Mode


Hi friends!,

I am using content query web part for displaying data from list. when i export these webpart in notepad. and add some column name and type in CommonViewField parameter. it gives error while editing the content query web part. it was working fine in MOSS2007. please let me know correct format if it changed.

Error when Content Query Web Part in Edit Mode


Hi Friends,

I am using content query web part in sharepoint 2010 for displaying data from list. i exported it. and open in notepad edit mode and made, add some column name and type. i uploaded this web part. this is added . when i edit this web part in site. it gives error


Error when Content Query Web Part in Edit Mode


Hi Friends,

I am using content query web part in sharepoint 2010 for displaying data from list. i exported it. and open in notepad edit mode and made, add some column name and type. i uploaded this web part. this is added . when i edit this web part in site. it gives error

What grid control is used to edit a Query in TFS?


I am currently designing a .Net 3.5 Windows Forms application and I would like to use a grid control similar to the one found when editing a Query in TFS : example here

Does anyone know what control this is and whether it's a standard tool available in Visual Studio? Basically I need a grid control which can host dropdowns and allows you to group rows together.

Any advice much appreciated

How to undo an edit mistake in Query Editor?


How to undo an edit mistake in SQL Server Management Studio Query Editor?

When edit a code in Query Editor, because of mistake, I lose part of  the code. Now I want to undo the previous action. How to deal with it?

Inplace Edit in GridView

In this article I am presenting a different way to look at EditItemTemplate, using which user navigation for editing is reduced and . it looks very different (see screeen shots) then regular implementation of GridView.

Building a Searchable Phone Directory with Windows SharePoint Services

I want to continue to build out the intranet site we've started in our previous articles. A standard item in every intranet is a staff/employee list. Most companies implementing Windows SharePoint Services (WSS) are large enough to have a database that contains all employees. We will use the aggregation features of SharePoint to include data from this database into our intranet.

Edit GridView Individual Cells in ASP.NET

The ASP.NET GridView allows for a row of data to be edited by setting the EditIndex property of the GridView, placing the entire row in edit mode.

You may not want the entire row in edit mode if you are using DropDownList controls for several columns in the EditItemTemplate. If each DropDownList has many options then loading them all at once may result in a sluggish page. Also, if your data structure is more like a 2 dimensional array rather than a set of rows, you may want to edit each cell individually.

Here I will demonstrate how to achieve this and also how to deal with event validation without disabling it.

Building a grouping Grid with GridView and ASP.NET AJAX toolkit CollapsiblePanel

I've posted an update to this post to apply on demand loading of Details data using ASP.NET AJAX PageMethods. I'm demonstrating the usage if CollapsiblePanelExtender client events on the new post. Check it out.

I admit, Matt Berseth is really inspiring me! Few days ago I pass through 2 of his great posts:

.Surrounding your Data Table and Dialog Controls with ComponentArt Styled Panels
.Building a Grouping Grid with the ASP.NET 3.5 LinqDataSource and ListView Controls
The first one is pure design tips one which I used for making good presentation of my demo here. The 2nd post is actually the idea.

ASP.Net Gridview Edit Update Cancel Commands

In ASP.Net 2.0, GridView Control also provides the functionality to edit and update the data retrieved from the database using CommandField template. You can cancel the action using Cancel Command of the CommandField. GridView consists of events that can be used to perform the actions like edit, update and cancel upon the Data items displayed in the ASP.Net GridView Data Control.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.
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