.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

How to test reports generated using web intelligence and sql server?

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

Hi all,

How to test reports generated using web intelligence and sql server?

One way of validating the data is to write sql query based on the report requirement and match the resultset with the data of the report. Then for testing the front end, based on the report requirement,validate the filters or prompts, formatting , printing and exporting feature of the report.

what else can be tested? is it necessary to test the Universe as well? like integrity checking, closed loops, joins etc..?or just run the sql query against the database from which the universe is created and match with the data in the report??

Could anyone Please advice me asap.

Thank You


Eveta


View Complete Post


More Related Resource Links

how to test reports generated using web intelligence and sql server

  

Hi all,

How to test reports generated using web intelligence and sql server?

One way of validating the data is to write sql query based on the report requirement and match the resultset with the data of the report. Then for testing the front end, based on the report requirement,validate the filters or prompts, formatting , printing and exporting feature of the report.

what else can be tested? is it necessary to test the Universe as well? like integrity checking, closed loops, joins etc..?or just run the sql query against the database from which the universe is created and match with the data in the report??

Please advice me asap.

Thank You


Convert Text to Numeric in reports generated by Microsoft SQL Server 2000

  
Our programming team is producing Excel reports using Microsoft SQL Server 2000 and cannot seem to find a way to produce numeric data as numeric.  It is being produced in the spread sheet as text (with the green triangle in the corner of the cell).  If the user viewing the report has an older version of Excel they cannot even convert it to numeric manually. 

Is there a way to produce numeric data as numeric in the Excel report?

ssrs 2008 reports Datasource error in Test server..

  

Hi ,

 i Have upgraded my Reports from Report server  VS 2005 to  VS 2008 .

My reports works fine in local, development & test server.

After Ugrading to 2008 it works fine in local server & devlopement serverr.

 When i deployed to Test server i am trying to access my reports i am getting below errors,

 An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..

i checked the Datasource conncetion properties..its pointing to correct Test database only..

My reports are windows integrated...

Now it works in srs 2005 developement & test server. For same properties it works in dev server,  it  doesn't works in srs 2008 test server.

 

Why? Can anyone give me some idea...?

 


Test your skill in SQL Server

  
You will be given a series of 10 SQL Server related questions that are randomly selected. Since the questions are randomly selected, you will receive a different set of questions each time you start a test. At the end of the last question, you will be given your score. You can then start a new test session if you like.

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


Test Run: Configuration Testing With Virtual Server, Part 2

  

Because Virtual Server is built upon a set of COM modules, you can automate the creation and testing of virtual machines. Here we use Windows PowerShell to run the tests.

Dr. James McCaffrey and Paul Despe

MSDN Magazine December 2008


Test Run: Configuration Testing With Virtual Server, Part 1

  

This time James McCaffrey sets up a virtual environment to use for configuration testing to introduce you to software configuration testing with Microsoft Virtual Server

Dr. James McCaffrey

MSDN Magazine September 2008


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


Errors when interacting with WorkFlow generated tasks through ISA Server

  

I have a MOSs environment that I have published through ISA Server 2006 and i am getting really strange behavior whentrying to interact with WorkLFow generated tasks when I have connected through ISA. This also seems to affect InfoPath Forms Services. I was wondering if anyone out there is seeing any problems when using ISA Server to interact wih Forms or WorkFlows?

 

The error I get simply states:

the form cannot be submitted to the web server either because your computer is offline or because the host server is currently unavailable.

 

Any help would be appreciated.

 

-joe

 

 


Crystal Reports Server

  
Hi We recently purchased a crystal reports server 2008 V1 License for Concurrent Users and 0 Named Users. What does this CAL mean? Does this mean that only 5 users can login at a time and view the reports? We tried initially but was not able to view since they got an error. How can i have more people log in at a time and view reports with the license we bought. Another problem is we are facing some deployment issues while deploying the reports from Crystal Rports on our client machines to this server? Some times we are able to do, but some times it will get stuck and throws upan error   Can somebody tell me about this CR Server 2008 and provide me any nice documents for setting up the users and how to use Crystal Report Server 2008?  

SQL Server 2005 Performance Dashboard Reports user context

  
HI, We are planning on installing the Dashboard reports. But we'd like to know if the Dashboard is run under admin user or the login user who runs the Dashboard reports? Thanks! Kong

Programmatically Generated Reports (RDLC) ASP.NET C#

  
Good Day,   I been looking for a day now and I couldn't find a good source of information. I have a one of a kind report wherein the RDLC file including all controls are programmatically generated (system generated)  by one of my asp.net page. All fields and its values to be displayed on the RDLC file are coming a stored procedure. On my stored procedure I'm using a temp table for example #MyTable and its columns can adjust programmatically/automatically base on date range. BTW I'm using C# code to generate the RDLC file and preview it on the report viewer of a page. Sample: Date Range: 01/01/2008  to 12/31/2009  My temp table may look like below AssetCode, Description, Class,  Jan2008, Feb2008, Mar2008 --> until column reach Dec2009 AAAA00001, AAAAAAA,FF, 0.00, 0.00,1,00.00 --> some month#### column may not or may contain value base on my formula. AAAA00002, BBBBBBB,FF, 0.00, 1.00,1,00.00 --> some month#### column may not or may contain value base on my formula. AAAA00003, CCCCCCC,CE, 1.00, 1.00,1,00.00 --> some month#### column may not or may contain value base on my formula. I have no problem in retrieving all data on SQL Server using temp table and showing it on a system generated rdlc file even if I'm using

Sharepoint 2010 Business Intelligence integration with datasources other than MS SQL Server

  
I want to Implement Business Intelligence by SharePoint 2010 on top of data sources other than MS SQL Server or MS Analytics Services ( cubes ), for example Oracle RDBMS and Oracle OLAP ( cube ) or Teradata. Quesiton : Is there any way to do this, if the is, how do I bring metadata to sharepoint BI or how do I make SharePoint BI to see other data source. I've looked at Busines Data Connectivity in Visual Studio, but that is more for two way integration and didn't seem like a good or easy way just to bring new data sources to SharePoint BI I found some tool from third party company "BDC Meta Man" which created metadata layer for Oracle RDBMS in SharePoint, but I thought there must be a way to do it by using Microsoft tools

Health Analyzer reports "Product / patch installation or server upgrade required." and I can't seem

  
The text of the error is: On server SHAREPOINTSERVER, once all required products and/or patches are installed, perform an upgrade by either running PSConfigUI.exe or by executing the command "PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures". If a former upgrade attempt has failed, you may need to resolve upgrade specific issues before attempting upgrade again. Refer to the upgrade status page (http://sharepointserver:XXXX/_admin/UpgradeStatus.aspx) for information about current and prior upgrade attempts, and to determine issues that may be preventing upgrade from succeeding. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=142700". So I went to the server in question and ran the command line quoted in the error message and then I get this error back: Configuration of SharePoint Products failed. Configuration must be performed before you use SharePoint Products. For further details, see the diagnostic log located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\1 4\LOGS\PSCDiagnostics_....log and the application event log. So fine, I look into the event log and get this: Failed to initiate the upgrade sequence. An exception of type System.IO.IOException was thrown. Additional exception information: Access to the path 'C:\ProgramData\Microsoft\SharePoi
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