.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

Dynamicaly Repeating Report-content

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server


I'm having a problem here, I'll try to explain it as clear as possible.
I'm writing a report which have to show the recepie of a menu in all the available languages.
So I'm passing a parameter recepieId.
Now I'd like to see the report-content 3 times as English, French and Dutch are available as language.
Should I work with subreports, but then how can I pass 1 value to one report, and the other ones to the next ones (as the number of languages may increase)
Or Is there a way to put all this inside a table and repeat it like that?
The query's for for the details of the recepies deliver the recepieId, languagueId and the description. So I can filter those on the languageId

Thanks already!

View Complete Post

More Related Resource Links

Content and Structure Report not showing all items

I have an environment where the Site Owner is not seeing all items pending approval when they access that view from the root node in the Content And Structure section.

We can see pending items in this view if they access some of the lower level nodes in the tree structure, just not from the top node.

I've noticed that the second level nodes are not inheriting permissions from the root node, but I'm not sure if that is relevant. I've also checked the CAML for the Pending Approval view and it has not been altered in any way.

Any ideas?

Repeating table not showing content following a rule refresh

Background info: I have a form where I populate employee info from the GetUserProfileByName ws. From there I populate its manager info from another web service call (seperate data connections).  Once the manager is populated, through rules, I'm populating the first approver. All this is done at form load through rules. The approvers node is defined as follows and is displayed on the form as a repeating table:  participants (group)    approver (repeating group)       ApproverName       ApproverLogin       ApproverEmail Problem: The repeating table is not showing any content even though I'm using an alert to show that I do in fact have one row in there. As a side note, I know the table is working because if the user elects to delegate approval to another user (through the people picker), the table shows these approvers correctly.  Anyone as any clue what I'm doing wrong? Thanks!    

Convert Xml content from a Dataset to another Dataset for SSRS report?

Hi All Does anybody know how to convert xml field from SQL Query to Dataset? For example I have a table T with Fields A(VARCHAR), B(INT), & C(XML). Field C has <test><row>ROW 1</row><row>ROW 2</row></test> I make a query to get this data and call this Dataset1 Now I want the Column C content to be converted into a dataset  call it Dataset2 so that I can drag and drop tables from there to make my reports. Is it possible to do it without using webservice?Another limitation I have, I should not have to connect to DB again, so this boils down to use the already data contained in Dataset1. I was trying to somehow embed this XML content in the query at runtime dynamically? I am currently looking for a way to use the Dataset1 as the datasource and and parse the XML content of Dataset1 to Dataset2. Also, is it that XML content needs to hardcoded in the query, can't we do it dynamically and run the query?

How to show the content of two tables in one report?


Hi there,

I am working with reporting services for the first time and I have a very basic question, but can't find a solution for it anywhere. I use Visual Studio 2008 and SQL Server 2005.

Here is the problem:

I have two SQL data tables, one consisting of general data about a person (name, age,..) and one containing their employment data (joining date, salary, ...). I now want to show both tables for one particular person in one report such that the general data as well as the employment data each have their own section, such as


Name: Thomas Mueller

Age: 27

How can I have a page width re-size dynamicaly depending on its content


I am using the AJAX re-sizing control and the control I am wanting to resize is on the right side of the page, so when I resize it, most of the image isn't visible.  If I could get the page width to change as I resize the image it would be great.

How do I do that?


Group headers of the main report are not repeating when used with subreports


Hi all,

  I have a SQL server 2008 report which has a main report and 2 subreports embedded. Each of the subreports are placed under a main group and the group headers of the main header are made to repeat with RONP property and Keep together properties set to true. If the subreport's data fits in one page the group headers are repeated. But when the subreport's data spans to more than one page the group headrs of the main report are not repeated. Please let me know if there is a workaround to achieve the same. I have tried putting the group headers in the page header, but this approach does not work fine. Please let me know if this can be achieved using coding.



Content not displayed in Report Manager 2008



I have created some reports in SSRS 2008 and after that deployed it successfully to RM. But when I log in through Repor manager URL, no content is displayed over there on Home page even if it showed report deployed successfully from VS.

To me it seems dont have sufficient privileges even if i am admin on my machine. Any idea?



Report Library metadata lost during content database migration


We upgraded content databases from SharePoint 2007 Enterprise to SharePoint 2010 Enterprise.  A few of our users were using a Report Library (not related to SSRS).

During the upgrade, it stripped out the "History" column.  We went through the audit log (using Axceler ControlPoint) and it showed the user who performed the upgrade deleted the "Reporting Metadata/2_.000", for example.  The delete was done by the actual upgrade process, though, not the user.

It seems that this was a global action carried across all sites in the farm during the upgrade.


SharePoint Tutorial - Content Types

SharePoint content types provide users with a way to manage and organize content in a more meaningful way. It's a reusable of settings you want to apply to a particular type of document in a library or item in a list.

Enabling Users to Maintain SharePoint Content

When SharePoint is installed as a corporate intranet, there is a considerable amount of effort involved in maintaining the content to keep the site relevant. As we discussed in the first few parts of this series, SharePoint has many built-in features to reduce the burden on the site administrator.

Some areas of the site usually contain less-dynamic information. Internal memos and corporate policies are common examples of this information. One option for this information is to post these documents in a document library. Documents in a library are often stored in a few different formats: Word, Acrobat (PDF), or HTML. Each of these formats has its drawbacks.

Application Vs. Content Pages in SharePoint

SharePoint has two types of ASPX pages. One type is the application page, also known as a _layout page. The other type of ASPX page is a content page, also known as a site page. Each of these page types is stored in a different location in SharePoint. When developers create custom ASPX pages, they must decide on the page type.

Enabling Users to Maintain SharePoint Content

When SharePoint is installed as a corporate intranet, there is a considerable amount of effort involved in maintaining the content to keep the site relevant. As we discussed in the first few parts of this series, SharePoint has many built-in features to reduce the burden on the site administrator.

Content Types in MOSS 2007

In this article I will try to describe the one of the best feature in Microsoft office Share Point 2007 called Content Types.

Content types are simply collection of contents.Each content in a Content type can have different settings.Basically it is a reusable collection of settings which you want to apply to a particular category of contents.

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

Alternating row background for first column of a report


is there a way to make the first column of a report use the an alternating background color? 

I have the background color set for the entire row however it does not work for the first column if the color is set to an expression.  If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).

In the file below only the textbox for part number does not show an alternating background.  All others work correctly.

                    <Textbox Name="PartNumber">

Unique content within master page based on conditions met


 Hi all-

I would like to present users with unique content based on certain conditions being met as they land on the home page (default.aspx).  The condition logic will be in the VB code behind Page Load event. The content will go in a content placeholder as specificed from the master page. 

However, the content change wouldn't be something small (ie making a panel or label visible or not) but rather it will be different HTML,  Divs and databound gridview content.  The HTML content will be stored in the database.

Can someone point me in the right direction for best practices on how to accomplish this?


Passing Linq Statement between master and content page


I usually work with windows forms, and am just starting to work with ASP.Net, so appologies if this is a dumb question!

I have a master page which has a search button on it. The results of this are built up using a Linq statement and if there are any results, I want to display the results in a contents page.

On the masterpage, I have the following code:

Private _res

    Public Overridable ReadOnly Property SearchRes()
            Return _res
        End Get
    End Property

 Private Sub DoSearch()
   'some code to get a linq result

    If res.Any Then
            _res = res
            Server.Transfer("SearchResults.aspx", True)
            'no results
            LabelNoRes.Visible = True
        End If
 End Sub

On the SearchResults.aspx page I have this code.

Dim m As pxSite = CType(Page.Master, MasterPage)
        If m.SearchRes IsNot Nothing Then
            Label1.Text = "Results found = " & m.SearchRes.Count
        End If

m.searchRes is always nothing. 

What am I doing wrong here?


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