.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

How to add multiple reports in single parent pane with each report had its own pane and dropdown to

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

We had a report to create which should show multiple reports with each of them had there own pane and each of them had drop down to select the parameters to run this report. We had to create this report using SSRS, any ideas???



View Complete Post

More Related Resource Links

One report >> Multiple Linked Reports in different folders?

I love Linked Reports in SSRS because of my ability to change one report in one project and post changes to one location on my SSRS server and then have those changes take effect in my linked report.  Today however I was asked to make one of those reports which is already liniked elsewhere to be linked to two locations and I was dismayed to find out that there is a chance that its limited to one linked report for any source report. Can someone tell me this isn't so and show me a way around this?  I don't want to have to post my RDL to multiple locations unless its absolutely necessary. I'm using SQL Server 2008, SSRS2008, Standard Edition. Thanks, Keith

Two crystal reports in a single report viewer

hi...to alli want to generate the two crystal reports one is employee and another is project.now i want to display the two reorts in a single crystal report viewer. i've tried using sub-reports but the page header is not avaliable in a sub reports.. so i want to display two separate crystalreports in a single viewer..can anybody help me.. plz

REndering large single reports into Multiple reports



I am using ssrs 2008.  My Report can genarate  5000 Record count , 10000 Records count or more than 10000 records count.

When i am rendering large reoport above 10, 000 record count i am getting timeout Exception error.

how can i avoid that exception..?

 i read through some forum can genarate one report into mulitiple reports by dividing the record count.

can nay one explain in detail..how best i can work on Rendering Large reports.


thanks in Advance.


TreeView with parent to single child relation from multiple children c#



how to populate treeview  with a child node and with all its parent nodes





       -----a11 // if selected i want to draw treeview with its all parents






Using ReportViewer.LocalReport.Render() method to export single report multiple times


I'm using the ReportViewer control on my .aspx page which displays a single report based on various user parameter selections.  Dropdown2 is dependent on the DropDown1 selection (i.e. the user selects Unit A from DropDown1 and that results in 10 selections under Dropdown2, or the user selects Unit B from DropDown1 and that results in 15 selections under DropDown2, and so on).  The user makes the selections, clicks the "Run Report" button, and the report displays as expected.  The user then can export to Excel or PDF

I've received a request to allow users to run the report for all possible selections and export to their desired format rather than having to run the report for each separate DropDown1 and DropDown2 selection.  So in other words, they don't even want to see the report on the screen, they just want to be able to click a button that runs the report for all possible parameter selections and export it to a single Excel or PDF document.

Does anyone have thoughts on how to best approach this?  Or is it even possible?  I know how to render a single report with parameters directly to PDF or Excel using the ReportViewer.LocalReport.Render() method, but I don't know how to render the same report multiple times to a single destination.

Why does modifying a Query causes all fields in the dataset to disappear in the Report Data pane


We routinely import reports from Microsoft CRM and amend them in Visual Studio 2008 eg to add column totals, change layouts etc

If the report needs more fields from CRM, I amend the SQL query in the CRM Dataset, adding the new field references (rather than recreate the report in CRM with new fields, import into  VS2008 and redo all  the formatting etc).

This worked fine until this week.

Whenever I modify the SQL query in the CRM Dataset, all the fields in the Dataset disappear in the Report Data pane.

Even changing a character in a field name which isn't used in the report - which should have absolutely no impact on the report - causes the fields to disappear.

As far as I'm aware, nothing has changed on our systems.

We use SQL 2008 reporting services and Microsoft Visual Studio 2008.

Any suggestions greatly appreciated!

how to create multiple dimensions on single parent column


How i cant create multiple dimensions on single parent column? 

This is the senario


Workflow fact table

Wf_id (int)






Department Dimension Table




Now if i create dimension from dimdept , it have only one department name column, how i can use this same lookup to represent the service and source department names? Same senario pops up in sales fact tables as well , like manage_id and salesman_id both looks up to same parent table "Emp_id"

How to display reports from multiple lists in SQL Server Reporting Services Report Viewer


Hi All,

  I want to generate report through SSRS from more than one sharepoint lists. To generate report from one list i am using below query:

   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
         <Parameter Name="listName">
   <ElementPath IgnoreNamespaces="True">*</ElementPath>

Please suggest me a query to get results from more than one list like we use joins for SQL tables.

Thanks in advance,

Saurabh Kumar Singh

Mail: saurabhsinghmca@gmail.com

merging multiple tables in a single dataset to single table


 i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset 

like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid  as a compact data and combination of 3 tables from d single dataset.....

can some1 help me please.....

how to set multiple button in single image


Hi friends,

I need to make multiple button in a single image in asp.net.

and need coding also for vb.net.

thanx in advance

single form multiple buttons in MVC


In a single page  has two buttons , ddown and tempname.

I wrote two actionresult separetly each one for ddown and tempname.

I need one is post and another one is get method. so i gave like

1. Get Method


        [AcceptParameter(Name = "button", Value = "tempname")]
        public ActionResult ddown_tempname(string statusName, NewsLetterAdminViewModel viewModel)

return View();



2.Post Method


        [AcceptParameter(Name = "button", Value = "ddown")]
        public ActionResult ddown(string statusName, string button, NewsLetterAdminViewModel viewModel, FormCollection collection)

return View();



if i call the post method its worked well. but if i call the get method, the code does not execute. the brea

using single function to open multiple colorbox


Hi I have li like this

<li class="game">
                                    <div class="game-thumb">
                                        <a href="include/games/words.swf" class="gamelink">
                                            <img src="include/games/words.jpg" /></a></div>
                                    <div class="thumb-desc">
                                <li class="game">
                                    <div class="game-thumb">
                                        <a href="include/games/cat.swf" class="game2">
                                            <img src="include/games/dots.jpg" /></a></div>
                                    <div class="thumb-desc">
                                        Trap the CAT</div>
                                <li class="game">
                                    <div class="game-thumb">
                                        <a href="include/games/gravitymaster.swf" class=&qu

How to store and retrieve multiple values in a single session variable .


I want to store employee name,designation and department in session variable and
retrieve in another page how to do this.

how to write a stored proc to prevent multiple users in uploading the reports at a time? plsss help



I wanted to know how to prevent more than one user from uploading the report at a time .I am new to .net ,plss help with the code that would be great.Details are below:

This is a Windos based app written in c# . When User A  clicks Upload option on  one server  from the menu  to upload the files  and at the same time when User B clicks Upload option on different server , User B should be alerted a message saying "User A's uploading is in progress,pls wait" . How to achieve this, plsss help with the code.. I am thinking this logic should be kept in a stored proc, How do I write that proc? plss help


Thanks in advance!

SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft



Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.




Multiple domains in single asp.net mvc application




I want to use my asp.net mvc application with multiple domains (maybe of hundreds),

so I have created custom Route class that matches requests including domain.

Each domain could has different routes, so the number of routes in RouteTable can be huge

(eg 500 domains, each 20 routes = 10000 routes in RouteTable).

I am considering how it will be efficient?


I have an idea to replace RouteTable.Routes (of type RouteCollection)

with custom one (of type Dictionary<string, RouteCollection>).

But how I can override default route matching mechanism with my custom mechanism which will be two step:

1) retrieve RouteCollection from dictionary based on domain name

2) retrieve specyfic Route object (standard route matching mechanism)

How can I do this?


Maybe someone has better idea for solving this problem?


Thanks in advance


Using the single *.rpt file with multiple data sources


I've created a set of CrystalReports (*.rpt files) for an ASP.NET web app on a development server. I call each report using the following code:

protected void BTN_RunReport_Click(object sender, ImageClickEventArgs e)
CrystalReportViewer_ClientLetter.Visible = true;

ConnectionInfo con = new ConnectionInfo();
con.ServerName = Constants.ServerIP;
con.DatabaseName = Constants.DatabaseName;
con.UserID = Constants.UserID;
con.Password = Constants.Password;

CrystalReportViewer_ClientLetter.ReportSource = Server.MapPath(Constants.ClientLetters);
ParameterFields parameter = CrystalReportViewer_ClientLetter.ParameterFieldInfo;
ParameterField batchdate = new ParameterField();
batchdate.Name = "@BatchDate";
ParameterDiscreteValue batchdate_value = new ParameterDiscreteValue();
batchdate_value.Value = Convert.ToDateTime(txtBatchDate.Text);

foreach (TableLogOnInfo tlf in CrystalReportViewer_ClientLetter.LogOnInfo)
tlf.ConnectionInfo = con;
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