Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi

### help need in calculating %'s in matrix reports.

Hi all, I have created report. And i have a problem in writing an expression in calculating the percentages.in column B, D, F I know that we can do this using Inscope function. But iam not able to get the solution. Is there any other way, or if its only thr inscope function could someone plz help me in writing to calculate the percentage   Matrix Report SNO A B C D E F 1 count % count % TOTAL Count TOTAL % 2 3 (3 / tot count) * 100 4 (4 / tot count) * 100     3 5 (5 / tot count) * 100 3 (3 / tot count) * 100 SUM(A2,A3,A4,C2,C3,C4) SUM(D2,D3,D4,B2,B3,B4) 4 8 (8 / tot count) * 100 6 (6 / tot count) * 100     TOTAL SUM(3,5,8)   SUM(4,3,6)         Thank you, -- Suman Gupta

### How to merge two matrix rows in rdl reports

Hi,

Could any body help my problem. I have design two matrix  in single  .rdl  .

I want merger two matrix rows together  in output when i export excel .

Could you give any better idea .

Thanks,

Murali

### Report Builder 3.0 renders empty page for Reports with Matrix (column group) in Landscape orientatio

I need some help.

If I create a Report with a Matrix Tablix (with row Groups and column groups) in landscape layout and preview it in print layout, the report generates me some extra empty page every 2nd page.

I don't understand the rule, why it's doing that.

My Report settings are:

• PageSize: width: 29.7 cm, height: 21 cm
• InteractiveSize: width: 29.7cm, height: 21 cm
• Margins : 0cm,0cm,0cm,0cm
• Report Body : widht: 25cm, height: 10cm

According my Report settings this shouldn't happen, should it. The width of my Tablix is max 22cm.

What I noticed is, that when I shrink the width of my Report Body to 21 cm (to the width of the portrait layout) or less, the emtpy pages disappear.

Or when I delete the column group, it also renders the report without some empty pages.

I think this problem has something to do with column groups.

Is this a bug or am I missing a setting?

### Viewing Reports with SharePoint 2.0 Web Parts

Reporting Services provides several Web Parts that work with specific versions of a report server and in particular deployment modes. If you want to access report server content on a SharePoint site from a native mode report server, use the SharePoint 2.0 Web Parts that are included with Reporting Services. Instructions for installing and using the 2.0 Web Parts are provided in this topic.

### crystal reports on mvc 2 vs2008

hi, i'm a new user of mvc 2, so, i need to use crystal reports on mvc 2, actually, i'm developing on visual studio 2008, but i canÃÂ´t run my reports. it's posible run my reports???

thank you very much.

### Web Matrix + Windows Authentication

I'm curious if its possible to get windows auth working with asp.net webpages/webmatrix.

I've got it published to IIS with windows auth turned on and anonymous/forms/basic turned off.

I'm guessing the WebSecurity Helper probably won't work here but can you access User.Identity.Name etc?

Sorry for the newbie questions, I've only just started working with asp.net ^^,

### Session with Crystal Reports on IE 8

All,

Having a very wierd problem.  I have an application that uses Crystal Reports and it uses what I have found to be a common scenario (I am not a CR expert in any way).  I have an ASPX page that gathers options for the report, and then it goes and gets the data and if there is some, a button appears for them to launch the report.  On clicking that button, the code sets some values in the HttpResponse.Context area, then performs a Server.Transfer to another ASPX page that is our Report Template.  This page contains the CR stuff and it generates a PDF version of the report.  It then does the following code:

With HttpContext.Current.Response
.ClearContent()
.ContentType = "application/pdf"
.BinaryWrite(s.ToArray)
.End()
E

### Business Intelligence Reports Project in Visual studio 2008 ?

Hi,

I wonder how to add a project template called  Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?

Thank you..

### Reports Editing

Hello,

I opened my reports in Business Intelligent Development Studio 2005. I want to edit reports.

I m newbie to these reports. Is it the right way to Open in Business Intelligent Development Studio 2005.

How can I edit the reports after that.? Can anyone help me from beginning.

TIA

### displaying dynamic added value in reports

Hi,

I my application i have generated dynamic rows that contains some textbox values, i need to take those values and display in

### dynamically change column names in Crystal reports

I need to develop 3 pages.

On the first page user defines atmost 7 column names to be displayed on the report. I'm saving these names in a Sql DB table 'Columns' with Column_Nm and Column_ID as Table columns.

On the second page I'm retrieving column_Nm from the table and displaying them on the page so that the user enters the data. This data is saved in another table 'Summary' with the Columns column1 through column7.

on the 3rd page I need to show a report of 'Summary' table.

How do I dynamically replace column1 through column7 names with that of 'Column_Nm' on the report?

Any help/suggestions would be appreciated.

### Desperately need help with crystal reports

Hi All,

I am new to .Net and And I have absoutely no idea about crystal reports. Can anyone please let me know a step by step process of how to design and generate a crystal report in vs2005

I need to ask for start date and endate.. when selected .. i should genarte a report using the existing stiored procedure and the connection string in my web config file..

Your help willbe very much appreciated..

### Data Points: Designing Reports with SQL Server Reporting Services 2005

Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both WindowsÃÂ® Forms and Web-based applications.

John Papa

MSDN Magazine June 2006

### Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration

The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.

Ed Hild

MSDN Magazine March 2006

### Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services

SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.

John C. Hancock

MSDN Magazine August 2004

### Scripting SQL: VBScript Interfaces in SQL Server 2000 Let You Transform Data and Provide Reports to

Application service providers often must send information to clients automatically rather than on-demand. For example, a manufacturer may want to know each day how many of their products were sold by a retail chain. While SQL Server is ideal for maintaining this type of database, you have to write scripts to get the data out in a client-friendly format. Here you will see how you can use Data Transformation Services (DTS), a powerful tool in SQL Server, to automate the retrieval and formatting of data from SQL Server 2000 and make the process of pushing data to your users a lot easier.

Alok Mehta and Daniel Williams

MSDN Magazine August 2002

### Crystal Reports: Add Professional Quality Reports to Your Application with Visual Studio .NET

Crystal Reports for Visual Studio .NET provides a comprehensive reporting solution for .NET developers that is thoroughly integrated with both the Visual Studio .NET IDE and the .NET Framework. Crystal Reports supports ADO.NET, XML Web Services, and ASP.NET server controls and caching. It also integrates seamlessly with the Visual Studio .NET Server Explorer, toolbox, and design environment. It has a rich programming model and flexible options for customizing and deploying reports. These major features and others covered here take the drudge work out of data representation in your own applications.

Andrew Brust

MSDN Magazine May 2002

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