How Do 'you' Organize Reporting

Jan 9, 2007

Hello,

This is more a informational question. Until now we had over 50 reports ready in our system, we are almost ready to go into production and are starting to link all reports with eachohter. The first problem was that we had them all nicely grouped in different projects so that we could publish in a logical folder-tree. Problem is that we can't jump to reports that are nog in the same folder. Going by url changes the layout and parts of the report manager are gone.

We then started to have a look at Sharepoint but i can't find books on the topic SharePoint & SSRS that describes the possible options. I've seen quite some documents and ways to publish reports but until now we prefer to mail the periodical reports to the users with data-driven subscriptions.

So at this moment we don't know quite wha direction to take. Putting all reports in one folder would solve many linking problems but makes it quite messy for the users.... And the linking issue is a must. As we now will start to create our dashboards with SSRS too.

So, any suggestions on what road to take or what publications to read are welcome.



Kind Regards

Harry

View 1 Replies


ADVERTISEMENT

Organize Data

Feb 12, 2008



Hi,
I have data like this in Excel table:
ID GameScore1 GameScore2 GameScore3 ClassScore1 ClassScore2 Classscore3

10 10 20 27 5 35 23

I have to arrange like this in SQLServer table:
ID TestRecord GameScore ClassScore

10 1 10 5
10 2 20 35

10 3 27 23


Test Record 1 for score1, 2 for score2, 3 for Score3.
Which way to organize this data in SSIS?

Thanks in advance

View 10 Replies View Related

Organize Into Tables

Feb 6, 2008

Hi,
I have information like this:
Apllicant information: Firstname, Lastname, Address, Phone, SSN, county, workphone..
Each applican can earn 3 certificates:






1st Certificate

2nd certificate

3rd certificate


Status of certification

Status of certification

Status of certification


Status of dues

Status of dues

Status of dues









Certification#

Certification#

Certification#


Validation date

Validation date

Validation date


Renewal date

Renewal date

Renewal date


Effective date

Effective date

Effective date


Date of cert # changed > means earned the next(second or third certificate).

These don€™t have this column information

These don€™t have this column information
Some common information for all 3 certificates like NOTE,€¦

How to organize the above information in SQLServer tables. how to apply the normalization . I can store all the contact information in one table and put the SSN as primary key. How to organize the certificates into tables? I have to made 3 tables for 3 certificates and linked to contact information table?

Thanks in advance

View 13 Replies View Related

Best Way To Organize Multiple Databases?

Jan 21, 2008

I'm very new to SQL, so you'll have to excuse the nubishness of this question. I've got my trusty O'Reilly book here!

We're using Microsoft SQL Server 2005 on our web server. I'm currently working on a project to get a few MS Access Databases available on the web page.

The web part is actually working fine, with the DBs exported into SQL for performance reasons. (From what I've read pulling data from the .mdb file could cause me problems in the future, so I'm tossing it all onto the SQL server from the start.)

Before I get into the project full-tilt, though, I'm curious about how best to organize all the data?



I'm using the Upsizing Wizard in Access for the conversions, and every new DB gets added under Databases. If this gets approved I may be looking at well over a hundred DBs which will eventually be converted and made web accessible.

I can keep everything neat and tidy on the web server by just tossing things in a few directories, but the menu on the SQL Server Management Studio is going to become a mess really quickly if I let it just keep adding to +Databases.

Is there a way to sort everything into a series of folder/groups, like how System Databases has it?

Thanks in advance,

-Lamune

View 2 Replies View Related

Organize DFT Components In Designer

Jul 4, 2007

Hello,

I have DFTs with around 50 components and future ETLs will have 100+ components in DFTs.
I was wondering that is there anyway to group components like we have #region in C#.

Thanks,

Kapil

View 4 Replies View Related

Organize Big Solution Tree

Jul 17, 2007

Hello,

I need some advice regarding organizing packages.

I am in starting phase of a data conversion project. As my ETL target, I have to produce around 70 flat files. I am creating one package for each target file. Some target files may be a result of 2-3 packages.
I have some common packages that get called from many other packages.


Before my solution tree grows into unmanageable state, I would like packages to get organized based on their target and purpose of the package.
The ideal solution to this problem would be to organize packages in a folder structure but I couldn€™t see any option to create folders in a solution.
I also noticed that we can€™t easily put package files next to each other even after renaming packages.



I was wondering is there a better or any way to organize packages in solution tree?


Kapil

View 1 Replies View Related

Articles In More Than One Category - How To Organize Tables?

Jun 10, 2005

Greetings,I have one table, named Article, and one table name Category.The problem is, one Article could be in just one or in several categories.What is the best way to connect data between Article and Category according to fast search performance?I have several ideas:1. To have third cross table Article_Category with fields Article_ID and Category_ID, and search Article_Category table 2. To have several INTEGER columns in Article table (like Category_ID1, Category_ID2,..) and search those columns3. Add one VARCHAR field in Article table where I could write Category ID's delimited by some character (e.g. by comma), and do text search in only that column.What is recommended for solving problems like this?

View 7 Replies View Related

Organize And View Datasets Using Toad

Jul 23, 2005

Hello,i want to use toad to work with sql-Server for my business. But i cantget rid of it, after extracting the packets i find the toad ss.exe.I dont know how to connect to my database, as i never worked beforewith the odbc-database driver. I think it must be about the manager"start -> controls -> odbc...".All i want is to view the datasets in my db, but i dont want to writethe nesassery querys, like in mysql-admin for mysql databases.Is toad the right applikation or should i use an other manager?plz help me, thanks - xunling

View 1 Replies View Related

SQL Security :: How To Organize And Secure Database Users

Apr 21, 2015

Is there any way in which I could distinguish a group of Database users from the other users. Say for e.g. store the Database users hierarchically, etc. Adding a Prefix/Suffix to the user name as a distinguish-er will not work in my case. I want to restrict the deletion of these Database users. Even the login with sysadmin or serveradmin rights should not be able to DROP those Database users.

View 11 Replies View Related

SQL Server 2012 :: Dynamic Pivot Statement To Calculate And Organize Columns

Mar 11, 2015

How to write a Dynamic Pivot Statement to Calculate and Organize Columns like:

CREATE TABLE #mytable
(
Name varchar(50),
GA int,
GB int,
startdate DATETIME,
enddate DATETIME

[Code] ...

Below is Our Sample Table Data.

Name GAGBstartdateenddate
Pavan 261/1/20151/1/2015
Hema 561/1/20151/1/2015
Surya 501/1/20151/1/2015
Pavan 811/2/20151/8/2015
Hema 311/2/20151/8/2015
Surya 121/2/20151/8/2015
Pavan 1041/9/20151/15/2015
Hema 301/9/20151/15/2015
Surya 6131/9/20151/15/2015

How to write Pivot Satement to get Oupt like below:

1/1/2015 Pavan Hema Surya SumTotal
Total 8 11 5 24
GA 2 5 5 12
GB 6 6 0 12

1/8/2015 Pavan Hema Surya SumTotal
Total 9 4 3 16
GA 8 3 1 12
GB 1 1 2 4

1/15/2015 Pavan Hema Surya SumTotal
Total 14 3 19 36
GA 10 3 6 19
GB 4 0 13 17

View 5 Replies View Related

To Access Reporting Sevices (Report Manager, Reporting Web Services), Does One Has To Be An Admin On The Machine

Mar 12, 2007

Hi There,

Our DBA has installed reporting services on a server and now in order to access the report manager, one has to be an Admin on that Server. I am guessing that there is a mistake in the configuration of Reporting Services. Usually it should allow anybody who was added to the roles in the properties section of the Report Manager, right? I have also added the users to the DB..

Also I am using Windows Authentication to access Report Catalog items (Reporting Services is installed on Server2) from a web Application(deployed on Server1) and displaying the report using report viewer. For some reason, server1 has to be in an Admin role on Server2 to access the report catalog/report. This is kinda strange for me as I don't want everybody to be an Admin on Server2. Can anybody please point in the right direction?

Thanks.

View 3 Replies View Related

Reporting Services :: JIT Debugging Error When Reporting Configuration Manager Is Opened

Sep 11, 2015

We have installed SQL Server 2005 with reporting services.When tried to open getting errors as below: how to avoid such errors See the end of this message for details on invoking  just-in-time (JIT) debugging instead of this dialog box.

ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMException (0x8000000A)
  at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
 
[code]...

View 4 Replies View Related

Reporting Services Menu Does Not Appear When Install Reporting Service Add-in For SharePoint

May 14, 2008

Hi all,

I have some problem about reporting service add-in.

After I install reporting service add-in for SharePoint, reporting service menu does not appear in Application Management Tab in SharePoint Central Administration.

I try to uninstall and re-install again, it remain not work.

How can I solve this problem?

Thank you very much.

View 4 Replies View Related

Reporting Services :: Get Report Toolbar Using SOAP API In SSRS Reporting?

Nov 3, 2015

Is there any way to get the report toolbar using SOAP Api  in SSRS reporting.

View 6 Replies View Related

Reporting Services :: Real Time Reporting In SSRS?

Jun 19, 2015

We've got a requirement to build the real time report. user can browse report at any point of time and need to see the latest data(stock market) in the report.

I've few options down...

1. Directly point to OLTP database as source and write stored procedure to show result set.

2. Replicate the database and write the SP's to reports. To avoid pointing directly to OLTP db.

3. To build the datawarehouse with dim & facts to show it in reports. I prefer this as a standard method, but this would have some latency depending on trasaction load which will differ from the requirement.

View 3 Replies View Related

Reporting Services ReportServer DB Reporting - 3rd Party Tool ?

Jan 15, 2007

HI There

We are required to gather certain information regarding reporting services.

Which reports were requested, by whom , how long did they run for, what parameters were passed etc etc.

I see that the system tables do provide some of this information, is there a 3rd party tool or something we can use to gather all this type of information for us?

This is for reporting services 2000 and 2005.

Thanx

View 1 Replies View Related

Configure IIS For Reporting Manager And Reporting Server Site

Oct 4, 2006

Dear All:

My reporting manager and reporting server were working fine in IIS. But when I booted the system one day, one error message came "Unexpected error" for the IIS. So I removed the IIS and reinstalled he same.

But after that, I tried to give virtual directories to reporting manager and reporting server sites. But it ain't working. Could you please help me?

My IIS 5.1
Reporting service 2005 Express with SQL Server Express
ASP.NET 2.0 Express.

Please help.

Thanks in Advance

Emmanuel Mathew

View 5 Replies View Related

SQL Server Reporting Service -Reporting Parameter

Sep 4, 2007

Hi,

Can we pass the Database name/Catalog name for the datasouce that will be used for report,
as a report parameter . Is yes can any one help me on how to achieve that .

Thanks in Advance

View 1 Replies View Related

Reporting Services :: Can't Access Reporting Server

May 8, 2015

I started my Reporting Server and if I use the Internet Explorer as a Administrator everything works fine.But if I don't open it as an admin it calls "rsAccess Denied The user [...] does not have the permission...".Problem is that I want to run it in an SAP Program with an HTML Viewer. how I can get those Permissions ?By the way somehow I'm not able to create or change roles in the Microsoft SQL Server Management Studio.

View 5 Replies View Related

Reporting Services - Batch Reporting

Dec 30, 2007

Hello, I understand that SQL Express Advanced Edition does not support report subscriptions. However, I have two questions:



Is there a way to run a report in a batch mode where the web ui would not show and perhaps the result of the report could be automated to export to .pdf format?

Does anyone know if SQL Express 2008 with Advanced Services will support report subscriptions, or any sort of a batch reporting capability?

Thanks in advance!

Tim

View 3 Replies View Related

Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services

Mar 22, 2008



Hello,

I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?

Any help is appreciated

View 1 Replies View Related

How To Avoid Space Of Text Box In Reporting Service If It Is Null Reporting Service

May 16, 2008



i have a list report
some values of this are blank or null
i want to avoid that spacing if it is null
like
name:jjj
lastname kkk
firstname
address uuuu

i want it should be
name jjj
lastname kkk
address uuuu

View 3 Replies View Related

Reporting Services :: 2012 SSRS Reporting Configuration (SCCM 2012)

May 26, 2015

We have SCCM 2012 primary site and Remote SQL 2012 server. Due to hardening and password reset we are facing reporting issue.

while we Open the SRS report in SQL server and try to edit the Report (Report Builder) we are getting following error due to which we are unable to configure Reporting Service point in the SCCM 2012 server. We created the New Reporting server database still we are getting the below error.

View 14 Replies View Related

Reporting Problems W/ MS SQL Server 2005 Reporting Services Step By Step To MS

Apr 26, 2007

I am trying to learn Reporting Services using the title "MS SQL Server 2005 Reporting Services Step by Step" by Stacia Misner and Hitachi Consulting, published in 2006. I am experiencing problems with some of the exercises. I got as far as Chapter 4 when I followed directions to create a SQL statement to define a query string for a dataset. Pg 80:



select * from vProductProfitability

where year = 2003 and

MonthNumberOfYear = 1



The view vProductProfitability does not exist in the tutorial database that came with the book, rs2005sbsDW. The result of this query is the basis for the entire chapter on developing basic reports and I'm being denied a learning opportunity because the view does not exist. In short, I'm stuck.



I have tried to find somewhere at Microsoft to place this question and get some answers so I can continue thru the tutorial. To no avail. Does anyone have any suggestions?



BTW, the solution that came in the CD is also wrong because the query noted above is also in the solution.



This humble grasshopper seeks wisdom.



Respectfully Submitted,



Dave Matthews

Atlanta, GA

aka FlooseMan Dave

View 17 Replies View Related

Compatibility Of SQL Express Reporting Services With SQL 2000 Reporting Services

Dec 6, 2006

I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.

One option possibly is the SQL Express with Advanced Services download, which has Reporting Services. My questions are as follows:

Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets?
Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?

Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.

Thanks to anyone who can help.

-- Mark

View 1 Replies View Related

Reporting On A DTS Performance Reporting

Jul 20, 2005

Hi all. I have a dts package called package1 that I run once a weekthat does some imports/queries against about the same amount of dataeach run. I am wondering (hoping!) if I can run a query that will showits performance over the past 6 months in terms of how long theexecution for each run took.I think SQL server saves this dts package run history somewhere and ifso how can I do this? Am I totally off base?

View 1 Replies View Related

Reporting Services :: Localization Data In Reporting Services?

Jul 27, 2015

I work in a big project and we will begin in using reporting services as the base technique for reports and I will be responsible for this part. but I have a problem I will discuss in the following:

Currently: We use currently devexpress reports and we have 2 languages(Arabic and English). the data in tables saved in two ways (Arabic and English). when the end user change the language of the web site the report data language changed when run it.

Example:

we have table with (ID, NAME_AR, NAME_EN, JobTitle_AR, JobTitle_EN). designed report will display(ID, NAME_EN, JobTitle_EN) . but the end user change the language of the system the report will

dispaly(ID, NAME_AR, JobTitle_AR) 

Hint:this done pragmatically

how to do this in reporting services.

View 7 Replies View Related

Reporting

May 11, 2008

Hi there, i have been asked to build some reports to extend an app that i wrote. I have written the basics but i am stuck on a few things
 In SQL (or maybe C#) how can i break down my outstanding costs from orders into 1 - 3 days 3 - 7, 7 - 14, 14 - 21 - 21 - 30, 60, 90+
I have a basic idea, e.g. SELECT * FROM tbl_orders WHERE status = outstanding AND (date_ordered >= txtFromDate AND date_ordered <= txtToDate), i have used the between function, however because my DB is in american date, and my web.config formats it into UK date/time it throws an error

View 2 Replies View Related

Reporting

Feb 12, 2002

Can anyone tell me how I can create a simple job or package to run a COmmand such as dbcc sqlperf(logspace) and have the results sent to a text file?

THanks
David

View 1 Replies View Related

Reporting

Jun 16, 2004

I have 50 rows in my sumary table.I wantted to show them in the front end with pagination,means i wanted to show those 50 rows in 5 different pages with 10 rows per page.
How can i do that using sql stored procedure.

View 3 Replies View Related

SqL Reporting

Feb 16, 2005

Anyone know anything about SQL reporting service I went to Microsofts site to check it out. How much is it anyone know??

View 1 Replies View Related

Reporting

Apr 4, 2006

I'm finding it difficult to find any posts/articles on reporting in SQL Server 2005. I have a report that requires the name of the person using the machine. I have a table that contains their name with the user name, and I can pull the username out by setting a variable to Environ("username"), however, I either need to create a sub-report or find a way to query the database with the username via the code.

What would be the best way to do this, and if I have to do a sub-report, how do I pass parameters to the query?

Your help is much appreciated.

Thanks.

View 6 Replies View Related

Reporting

Jun 7, 2006

i need to generate a report on the foll tables
here is the sample data for the report output..hope it makes it more clear now...

table 1
Companyname id year volume_for_jan vol_for_feb.....vol_dec
abc 1 2000 34 333 ......555
2 2000 33 22 666

table 2
Companyname id year volume_for_jan vol_for_feb.....vol_dec
rrr 44 2001 55 66.............888
24 2001 22 35 454

each table has almost 800000 rows

I need to generate a report out of these tables which should be as follows

Company name Id Year Vol_for_jan Vol_for_feb.........
abc 1 2000 34 33
2 2000 33 22
rrr 44 2001 55 66
..................................................

when i try to run the report in business intelligence ,it takes forever to run and doesnt even produce the report at the end...

i dont have any primary key or indexes on these tables
because when i try to insert an auto no field into the table, sql does not let me do that

what shall i do????

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved