Business Objects And Microsoft Reporting Services
Jul 20, 2005
Hi,
I am evaluating Microsoft Reporting Services against Business Objects
as a reporting tool against SQL Server. I am primarily a BOBJ
developer and am finding RS not easy to use. Can anyone provide any
feedback to the overall comparison between these 2 products as I am
finding RS frustrating and am wondering if it is just a matter of
re-adjusting and spending more time on it or if anyone else is finding
RS more trickey to use than BOBJ as well
I would be extremely grateful for any feedback.
Many thanks in advance
LA
View 1 Replies
ADVERTISEMENT
Apr 29, 2007
Setup gives me the option, I choose these services, it tells me they are already installed, but they are not?
View 2 Replies
View Related
Mar 24, 2007
I'm on Windows XP and recently downloaded Sql Server Express Advanced edition from http://msdn.microsoft.com/vstudio/express/sql/download/
I also downloaded the Toolkit but it won't install--says the services are already installed. However, I can't find the Business Intelligence link and don't see any Reporting buttons or menu items in Sql Server Express. I'm trying to learn T-SQL and Reporting Services but am frustrated. I've uninstalled, rebooted and reinstalled and still nothing. I'm even listening to the MS videos on SQL Server Express--Reporting Services but what they tell to download and install is what I've done--but no luck. Help!!!
View 11 Replies
View Related
Dec 14, 2007
Everybody says that sql reporting supports using business objects but I am running into a situation where I have a custom business object which has bunch of objects bundled inside and if I try to show those objects in a list or table, all I get is an error without any description.
Can we report on business objects which have some depth build into them, like a customer -> address -> shipping -> Although my custom object has 4 level deep objects which I would like to group on and report on.
If yes then how do we achieve this?
Or what kind of interface do those object need to use like IEnumerator or what?
Is there any example out there which reflects this?
Atul
View 4 Replies
View Related
Jun 17, 2015
I am making a report using RDLC. I have made the connection with Sybase database (using ODBC) and when I add a new DataSet in report then it says:
The database is new or does not contain any objects...Connection to database is successful and it contain many tables and views but they are not being displayed.
Tried again with Sybase OLEDB provider but same issue.Even the Server Explorer where you can see database servers added is not showing any tables and views. I read somewhere it is because there may be no primary keys defined in any table so I created a new table with primary key but issue remains the same.
View 2 Replies
View Related
Jan 23, 2007
I have SQL 2005 reporting services installed and running, however I do not have the BI dev studio installed and cannot figure out how to get it installed.
The report server is operating correctly since I have developed reports on another pc using VS 2005 and uploaded them to the server.
How do I get the BI dev studio installed on the server?
View 1 Replies
View Related
Apr 29, 2008
Is there a way in Reporting Services to filter based on a parameter, but get it to use distinct values?
Currently I have a dataset that is grouped on a Branch value and a Team value.
The end-user wants to be able to filter out data based on the branch values, however when I set it up to that field it comes back with:
Branch 1
Branch 1
Branch 1
Branch 2
Branch 2
Branch 3
Branch 3
and the same goes with Team, which is a sub-group of branch. Is there any way I could set this up so that the parameter drop-down will only display distinct values? Also, is it possible to do the same with another parameter based upon the branch parameter.
Ex.
Branch 1 contains Team 01, Team 02, and Team 03
Branch 2 contains Team 04, Team 05
User selects to filter by Branch 1, the Team dropdown should only contain options for further filtering on Team 01, Team 02, and Team 03 not all of them.
Any help is much appreciated.
View 3 Replies
View Related
Nov 15, 2006
How to Add Reporting Services in Microsoft Dynamics CRM 3.0
View 8 Replies
View Related
Feb 28, 2008
Ok, probibly an easy question but I haven't been able to find what I am looking for.
If I have a simple class (see below), how would I make the People List avalible to build a report off of?
Thanks
asdf46
Code Snippetpublic class Person
{
public string FirstName { get; set;}
public string LastName { get; set;}
}
// and put them into a list
List <Person> People = new List<Person>();
People.Add(new Person () { FirstName = "Joe", LastName = "User"});
People.Add(new Person () { FirstName = "Jane", LastName = "Smith"});
View 3 Replies
View Related
Jan 19, 2007
Hi all.
I have a Application developed on VB2005 with the reports (processed local) from Microsoft Reporting Services 2005.
I would like to know how can i use the value of a variable to be displayed on a textbox on my report.
Thanks for the help.
Best regards.
dp
View 7 Replies
View Related
Dec 1, 2015
I have a dataset with rows that I normally would display in a  table control. I have too many columns and I would like each data row to be display on many lines. How is that possible?
View 4 Replies
View Related
Aug 3, 2015
I can't print reports using Microsoft Edge from Windows 10 With IE 11 Works fine.I've tried regsvr32 with rsclientprint64.dll but it's not working.
View 8 Replies
View Related
Jun 10, 2015
I am working on complex invoice document that handles various types of invoicing, credit, and progress bill customer facing documents. Â I am faced with same problem I see many SSRS devs posting on. Â And that is extra blank pages, being generated because the report width exceeds the width of the page.
My problem is I cannot shrink the horizontal width of the tablix and therefore the report width either...
While I would have done things differently if developing from scratch, the tablix in question has only one column and objects contained in rectangles are placed in the row/column cell.....The link to the image below shows the row I am currently working on. Â Essentially all the client wants a columnar report with column lines, closed footers, etc... Â so rather redoing the whole tablix, which I still might do, I am using rectangles with the column then lining them up. Â Anyway, that is a whole 'nuther post. Â My specific questions are: Â
Invoice in Report Builder
1. In the image I have selected the parent rectangle. Â The children are other rectangles and the data is with grandchildren textboxes that exist within those rectangles. Â I clearly have a bit of right side white space in the main parent rectangle, but there is no sizing tool on a hover... just move tool. Â And if I change the rectangle size in the prop form it just snaps back to the cell width. Â How do I size the parent rectangle and keep if from expanding.
Here I am guessing that to actually reduce the horizontal width of tablix and then the report, I have to first decrease the parent width of the rectangles that occur in each row?
View 2 Replies
View Related
Feb 28, 2006
I am trying to install Microsoft SQL Server 2005 Reporting Services, Receiving the following error
Microsoft SQL Server 2005 Reporting Services -- Error 1303. The installer has insufficient privileges to access this directory: C:Config.Msi. The installation cannot continue. Log on as administrator or contact your system administrator.
I am already logged in as Administrator and should have all the necessary permissions to install software
Please help me.
View 3 Replies
View Related
Sep 15, 2006
When I try to connect to the Reporting Services using Microsoft SQL Server Management Studio, the following error message propmpts up:
_____________________________________________________________
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
_____________________________________________________________
Is there any settings that I need to do in the "Reporting Services Configuration Manager" ?
Thanks.
Best regards,
Michael Wu
View 1 Replies
View Related
Mar 23, 2000
We have a user who uses Business Objects to run queries on the database. They are reporting that the query can lock the database up and that they were told at a conference that there is a setting which can aleviate this problem, but they are not sure if it is in SQL Server or Business Objects.
Anyone got any idea what they are talking about?
Colin.
View 1 Replies
View Related
Jun 12, 2006
Have to build DR solution and subj is a part of it.
Maybe some one has done it already€¦ share the experience please.
Dr in my case will between 2 different data centers, replication is san 2 san so on other side I have a warm standby that does not see san disks and will become active if and only if the primary data center is down, windows domain is the same, ip addresses, names of the servers are different. How a cluster will behave is interesting as well (I mean CE is on cluster, not geo distributed cluster).
I have CE90. I€™m talking to their tech support that seems to be outsourced, they didn€™t really produce in 5 days anything more then a part of their own documentation in pdf format for CE version I do not use J€¦
So I€™m wondering maybe somebody had to walk similar path already€¦
View 1 Replies
View Related
Apr 3, 2007
We have decided to use business objects in our new application, which seems to be working well, since they can be used as a binding source for grids, etc.
I am trying to evaluate whether SSIS is a practical solution for our ETL requirements. The problem is, I can't find any examples or references, or even the slightest hint that anyone is using them with business objects. Any attempts to search yield a ton of results which are based on a commercial product called "Business Objects" rather than the design pattern.
It is currently a requirement of our development team that all data access must be done via business objects, rather than communicating directly with the database.
Can anyone provide some more information (besides just suggesting I write a custom connection manager)? Is there anyone who has actually made SSIS work with business objects?
Thanks, Richard
View 9 Replies
View Related
Apr 2, 2008
I was wondering if it is possible to use a generic list object to use as the datasource/data for a report? Right now we use these business objects to display information on our website and would be great it we could re-use those objects and create reports based on them. We are doing some calculations etc in the business layer to build these objects, so if we could re-use, that would be best.
Thanks!
View 2 Replies
View Related
Dec 11, 2007
Hi,
I have a hardware configuration Question on microsoft BI components.
We have a BI solution which is END to END on Microsoft . It has:
1)SQL Server 2005 SP2 Database
2)SSIS
3)SSAS
4)SSRS
5)Excel 2007
6)WSS 3.0 (portal).
Can anyone tell me how to split the hardware for alll the components above. I mean which components can/should be kept together and what other should be residing on other widows servers so that the performance is imporved.
As of now i was thinking of having Database and SSIS on one server box and the SSRS and WSS on another box.
Please Suggest.
Thankyou
View 1 Replies
View Related
Oct 3, 2001
Hello,
"Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server "
I keep getting this when trying to copy stored procs from one db to another on the same server. I am using the DTS wizard. I have been able to copy the tables but I need the sp's too, and there are too many to copy one at a time.
Help!
TIA,
Bruce
View 1 Replies
View Related
Aug 24, 2006
Hello,
I am using the Microsoft .NET Data Provider v1.0 for SAP NetWeaver® Business Intelligence to connect to SAP BW queries. I have tried looking for documentation on the connection string arguments but have not had much success. My question is this: How do you specify the connection timeout in the connection string:
Connection string example: DataSource=http://mySAPNetweaverBIServer:8000/sap/bw/xml/soap/xmla?sap-client=020
Cheers
View 2 Replies
View Related
Apr 20, 2007
Is this product SAP Certified?
I have read somewhere that any integration technology wrt SAP has to be SAP certified.
If no, what are the implications of using this in a project? will SAP refuse to support the customer because they are using a non-SAP certified product?
regards,
Abhishek.
View 3 Replies
View Related
Jan 18, 2007
Hi everybody,
Does anyone know if there is a x64 version of the Microsoft .NET Data Provider for mySAP Business Suite for use with SSIS? On the SAP site, I found a librfc32.dll which works under x64, but the x86 SAP Connector can't use it.
Thanks
Hans
View 3 Replies
View Related
Apr 18, 2006
This is available at http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
Currently this is tagged as pre-release software. A preview version. When will a fully licensed version be available?
Also, has anyone used it? Any experiences to share???
Thanks
-Jamie
View 11 Replies
View Related
Jul 25, 2007
Hello Everyone,
Does anyone know if there are any licence implications (SAP side) against Microsoft .NET Data Provider for mySAP Business Suite?
I heard from a colleague that if my SQL Server has (for example) 5 users, if SQL does connect to SAP, it would require the user license of 5 more users?
If there any implications similar to this one with SAP?
Regards,
Joseph
View 1 Replies
View Related
Mar 31, 2008
There are a few features in the new SQL Server - Reporting Services that I really need in production. I have tested everything and it works great. I am running the CTP version since Microsoft is saying they aren't releasing the release version until 3rd quarter 2008.
Since Microsoft won't sell SQL 2008 until 3rd quarter, can I run the CTP in production until the release and then purchase SQL 2008?
Jim
View 1 Replies
View Related
Jan 25, 2007
Currently a server running 2003 small business operating system has MSDE 2000 and Microsoft##SSEE.
A memory problem exists with SQL consuming over 50% of RAM. Total RAM is 4GB.
There is a SQL 2000 patch for this type of problem. However, it calls for SQL to be upgraded to SP4.
Problem:
Can this MSDE 2000 be upgraded with SP4 and have memory patch applied with Microsoft##SSEE also on this box?
Please let me know. Thank you.
View 3 Replies
View Related
Feb 11, 2008
I watched and followed the Intro to VB 2008 Express, but in the final part of the video, when you add a database, i did everything as the video says, still i get:
An error occurred creating the form. See Exception.InnerException for details. The error is: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Ive tried the fix stated in another forum, the one about changing the "Target CPU" but the option doesn appear, what does appear its the "Platfrom" dropdown list, but its fixed to "Any CPU" and dont have any more options.
Ive also downloaded Microsoft SQL Server Compact 3.5 ENU and "re-installed" and selected repair, followed the steps, rebooted and still nothing.
The problem persists, any ideas, please?
View 6 Replies
View Related
Apr 17, 2007
Hi,all BI experts here,
Thank you very much for your kind attention.
I am having a problem with connecting to SQL Server 2005 database from Office Business Scorecard Manager 2005 (the connection string i am using is: provider=SQLOLEDB;Data source=server_name; Initial catalog=database_name). But the connection failed. Would please any experts here shed me any light on what is the problem and how to fix it then? As there is no any forum for Office Business Scrorecard manager 2005. Therefore I post my thread here as it is related to the connection to SQL Server 2005 database engine, thought here is the best place for this question.
Thank you very in advance for your kind advices and help. And I am looking forward to hearing from you soon.
With best regards,
Yours sincerely,
View 6 Replies
View Related
