Min Requirement To Run Report Builder Without SQL Server Installed

Feb 13, 2008

Do i have to install ms sql server on ever machine to work Report Builder?

View 5 Replies


ADVERTISEMENT

IIS Feature Requirement - All Components Are Installed!

Apr 10, 2008

I'm trying to install SQL Server 2005 Express with Advanced Features (SP2), ideally with Reporting Services. However, every time I try to install it, setup fails the IIS Feature Requirement.

This is starting to get annoying, as every single component for IIS 7.0 is installed.

Strangely, if I go into the Programs and Features thing (I'm on Vista HP), select SQL Server 2005, and click Change, the setup here passes the IIS test.

Could it be that because SQL Server is already installed (just the database engine), it is affecting an 'upgrade' to the Advanced Features pack? Will I have to uninstall SQL Server completely, then reinstall it (no biggy) ?

View 6 Replies View Related

Report Builder: How Can I Append Two Table Fields To Report In Report Builder

Feb 6, 2008


Hi,



When i select datasource in Report Builder, i am able to see all the available DataSources.

Eg: I have selected one datasource from the list and which has 3 tables(table1, table2, table3) associated to that datasource.



when i drag and drop table1 fields to report, i am not able to see the other 2 tables(table2 & table3)

Is there any property or relationship do i need to maintain?



Thanks,
SR.

View 5 Replies View Related

Report Builder Using Report Model Based On Linked Server (Excel) - Primary Key?

Sep 6, 2007

I've created a linked server with a pretty basic Excel spreadsheet, and used this command to create a linked server to it:


sp_addlinkedserver ''XL_SPS_1', 'Excel', 'Microsoft.Jet.OLEDB.4.0', 'c:MyExcel.xls', null, 'Excel 8.0'



I want to use this as the data from which to build a report model. As linked servers don't show up in the Data Source View wizard, I created a view in SQL Server:


create view MyExcel
as
select * from XL_SPS_1...Sheet1$


Okay, great, now the view shows up in the DSV wizard and I can create the data source view. However, when I create a new report model based on this data source view, the Report Model Wizard tells me at "Create entities for all tables" that I've got an error when it processes dbo_MyExcel that "Table does not have a primary key."

I assume this is where the identifying attributes for the entities in the report model are taken from, so I really can't go further. Does anyone have an idea as to how to add a primary key to a linked server (Excel) in SQL 2005? Can this be done? Other than importing spreadsheet data to a SQL table, how can I get around this?

Thanks,
--Stan

View 3 Replies View Related

Possiblity / Instructions On How To Install Report Builder Locally Without Hitting Report Server

Feb 16, 2007

We have a remote business client who has a proxy server setup and this translates into receiving a 407 proxy authentication blocking error when attempting to download the report builder application for deployment off the report server which is housed locally with us. The proxy server does not allow them to download application type files off another site. At the moment, they would not like to disable the proxy for these users to allow them to deploy the application on their client or add the report server as a trusted site. Is there a method by which Report Builder can be locally installed on the client pc instead of online only with it knowing the correct report server to access and then still launch correctly when the report builder button is pressed through report manager?

I am not a web application guru by any means and we have tried to replicate the oneclick deployment and what occurs in the local settings/apps/2.0 subdirectories, but the application still attempts to download/install again. If we attempt to just launch the local executable on the client, report builder assumes the client pc (localhost) is the report server to access. Is there a method which will succeed?

View 1 Replies View Related

Report Builder Not Appearing In Report Server 2005 Web Page

Sep 17, 2007

I have provided required permissions, still user not able to view report builder option in his console.

what could be wrong? what needs to be done to provide report builder to users.

Deleep P

View 5 Replies View Related

Report Builder And Report Server Cross Domain Communication

Dec 19, 2006



I have client machine in one domain, say A domain , on which I have installed .net 2.0 without any problem. I have report server running in other domain (B domain) where I have deployed few models which will be used from domain A to create ad hoc reports by launching Report Builder. I can access other reports in domain B from A

But when I click on Report Builder ..it tries to connect to server in domain B but fails to connect and shows following log in a text pop up

I know, problem is because of cross domain communication but question is then how to fix it ? what changes I need to do for that in firewall, domain etc etc settings?

Here is the error, I have highlighted lines which might give some clue:

------------------------------------------------------------------------------------------

PLATFORM VERSION INFO
Windows : 5.2.3790.65536 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : http://192.168.1.197/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://192.168.1.197/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://192.168.1.197/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (500) Internal Server Error.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [12/19/2006 6:49:58 AM] : Activation of http://192.168.1.197/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [12/19/2006 6:50:14 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://192.168.1.197/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- The remote server returned an error: (500) Internal Server Error.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.

View 1 Replies View Related

Installed Sql Server 2005, But Report Error

Feb 26, 2008

I installed sql server 2005, but the installed program report error.
I copy it at the line below.
And I have use strong password, and I have installed the .net framework 2.0 before I installed sql server 2005.
But the error is the same.



title: Microsoft SQL Server Setup
------------------------------

SQL Server Setup failed to obtain system account information for the ASPNET account. To proceed, reinstall the .NET Framework, and then run SQL Server Setup again.

help info: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28126

View 3 Replies View Related

Sql Server Report Service Samples Not Installed ?

Jan 25, 2007

Hi,I have installed the Sql server 2005 standerd edition to my computer

but i cant find this folder to view report service authentication samples ?

C:Program FilesMicrosoft SQL Server90Samples ?

but i can see C:Program FilesMicrosoft SQL Server90 folder !



any idea ?

sujithf

View 1 Replies View Related

Report Builder Using SQL SERVER 2005

May 6, 2006



Hi All!!

Can any body help me out in how to build reports using SQL SERVER 2005.
I will be very thankfull for that



Thanks
Biresh Singh



View 4 Replies View Related

Connect To Server From Report Builder

Sep 17, 2007

I am able to start Report Builder from the Reports site.

Report Builder opens but then it asks to "Select site or server", I don't see any data sources or anything, I can only enter a site or server. I tried http://crossdatabase/Reports and http://crossdatabase/ReportServer and http://crossdatabase nothing works. What's more, when I cancel and then click on the open button I get an exception:




Code Snippet
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.ReportBuilder.CatalogItemDialog.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ReportBuilder
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Documents%20and%20Settings/Administrator.VDBRANDE/Local%20Settings/Apps/2.0/97YHGD67.7XE/97YX7M5J.5E2/repo..tion_c3bce3770c238a49_0009.0000_827b297b08a11874/ReportBuilder.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Deployment
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
System.Web.Services
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
yicgob7u
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
g5yh0wut
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
a0wegfwe
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.








I run the Report Builder on the server so there should be no connection problems.

Thanks for any tips.

View 4 Replies View Related

VPN Between Report Builder And Reporting Server

Dec 20, 2006

Hi,

I have my client in one domain and RS running server in another, both r connected through VPN. Now if I try to launch report builder on client machine by clicking link in browser (clickonce)...it tries to connect to server but fails and shows some error, saying 'Internal Server Error (500)', complete error is here :

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1034868&SiteID=1

I can access models on server from other machines in the same domain succesfully..but not from this client domain.

How can we make report builder connect to server acros VPN ?

Thanks,

prashant

View 1 Replies View Related

Moving Report Builder Reports To New Server

Jun 22, 2007

I have a development server setup with Report Builder that our users have been testing out. They have a number of reports that they have created on this dev server.



We now have our live environment all setup and I'd like to move their Report Builder reports to the new server for them so they don't have to recreate them.



Is this possible? If so, how?



Thanks.

View 1 Replies View Related

Problem For Starting Report Builder Using URL In SQL Server SP2

Aug 8, 2007

According to this article ( http://msdn2.microsoft.com/en-us/library/ms345245.aspx ), a report "/My Reports/AdventureReport1" can be opend using a URL like following:
http://<ServerName>/reportserver/ReportBuilder/ReportBuilder.application?/My+Reports/AdventureReport1

This works correctly in SQL SERVER SP1.

In SP2, Report Builder is still able to open the specified report. However, when you try to click €œSave As€? for the opened report in Report Builder, Report Builder will always give you a dialog without any folders, and you have no way to type in anything in the textbox/dropdown in the dialog.

Any suggestion is appreciated.

Thanks,

Roger

View 1 Replies View Related

Report Builder Behind The Proxy Server Issue

Mar 13, 2008

We implemented Custom authentication with reporting services, everything works fine. At our client's site from one of there computer we did the following :

1- open internet explorer and access http://myserver.com/reportserver/reportbuilder/reportbuilder.application
2- the Report Builder Click once application was successfully downloaded onto the clients computer.
3- client was prompted to enter username and password. Client was able to see the report model and create,save reports to the reportserver.
4- close the report builder and try to access report via http://myserver.com/reportserver/reportbuilder/reportbuilder.application, this time the report builder launches but there is no prompt for username and password, instead it's asking to select a reportserver.
5 - tried selecting http://myserver.com/reportserver, there is not popup to enter username and password and we get the error message "unable to connect to server at http://myserver.com/reportserver , enter a different URL and Try again.

.NET framework 2.0 is installed on the client's machine. Our client can access http://myserver.com/reportserver/ from internet explorer.

Our client machine is behind a proxy server . Could this be caused by the proxy server. Why is report builder not prompting for credentials when launched. It only prompts for credentials the first time (installation). Any idea or anyone encountered this issue. we need a fix, because our client cannot access the report builder...

Chi.

View 5 Replies View Related

Report Builder Included In SQL Server 2005 Standard?

Mar 17, 2008



Can someone verify that Report Builder is included in SQL Server 2005 Standard edition?

I have a book that says it's only included in Enterprise edition, but the following chart says it is included in Standard:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

View 1 Replies View Related

How Does The Report Builder Application Communicates With The Reporting Server

Apr 17, 2007

Can any body please explain that "how does the Report Builder application communicates with the reporting server".
Does it use web service for that, or does it connect to it directly ?
If it use webservice then where is it situated and what is it's name.
Please explain a bit ?

View 1 Replies View Related

Reporting Services :: Add Sub-report To Main Report Using Report Builder?

Sep 9, 2015

I just created a report builder. I have a main report and i wanted to create a sub report. why i cant or i cant view the path or the folder of my  .rdl file to be use as my sub report.

View 5 Replies View Related

Modifying A Report Created In Report Builder In The Report Designer.

Jun 30, 2006

After I use the report builder to create a generic report, how do I actually get that report into the report designer so that I can modify it more effectivly?



The issue that I have now is that the file on the report server is not a .rdl file and if I simply save it as one and then bring it into VS to modify it the code file is a html structure rater than a XML file type.



Any suggestions would be appreciated. Thanks

View 3 Replies View Related

SQL Server 2008 :: Calling Stored Procedure Into Report Builder

Oct 23, 2015

I am trying to call a stored procedure into report builder. The stored procedure has 2 parameters. When I run the report with allowing nulls and blank value in the parameters it works fine, but when I enter a value in a parameter it ignores the where clause I had in the original query(stored procedure) and displays everything.

View 3 Replies View Related

Reporting Services :: Date Format In Report Builder When Using UTC Server

Oct 14, 2015

I am building reports based on Report Builder and SQL server 2014.

Our report data are hosted on azure sql database.

Date time on azure are stored as UTC.

When I run my report locally, how can I format correctly the date/time format on my report in order that if I am in French, I should have the date/time set to UTC + French offset. How can I do this ?

View 3 Replies View Related

Working Of MS SQL Server Report Builder With Faircom SQL Server

Mar 13, 2007

 Hi, I am able to create reports(.rdl) using Faircom c-treeSQL Server ODBC driver which in turn connects to the Faircom SQL Server.

However I'm facing issues while creating the Report model for the report builder. I would like to know if it is possible to create report models with Faircom SQL Server?

Thanks,
Satish

View 1 Replies View Related

Reporting Services :: Cannot Find Report Builder Download Link For Server

Nov 23, 2015

I have SQL Server 2012 SP2 x64 Express Advanced Services installed on Windows 10 Pro 64 bit.

I cannot find the Report Builder download link for SQL Server 2012 SP2 x64 Express Advanced Services on Windows 10 Pro.

Shouldn't the Report Builder link be for SQL Server 2012 SP2 and x64 bit in order to work with SQL Server 2012 SP2 x64 Express Advanced Services on Windows 10 Pro 64 bit?The only Report Builder 3.0 links I have found have been x86 (32 bit) and SP1.

View 3 Replies View Related

Unable To Launch Report Builder From Report Manager( But Works From Localhost !!!)

Jul 17, 2007



Hi,



I am unable to launch report builder from the report manager from a client machine. But I am able to launch from the localhost.



Even I am able to launch report builder by clicking reportbuilder.exe on the local machine.



Please help !!



OS - Windows XP professional

SQL Reporting Services 2005.

View 1 Replies View Related

Installing Report Service In Window XP - Report Builder And Other Option Are Not Displaying

Dec 15, 2006

hi

I have installed SQL Server Reporting Service on window xp. everything working fine except one thing.

I have installed sql server with my a/c. my a/c have admin rights. when i giving http://dineshpatel/reports it is displaying page but Report Builder and other option are not displaying. I hope i don't have admin rights.

I have checked with local administrator login also but same problem.

what additional setting are require for admin rights?

Dinesh Patel

View 10 Replies View Related

Reporting Services :: Row Group Totals On A Drill Down Report Builder Report

Oct 28, 2015

I have a report builder drill down report. I have row groups with totals.    It looks like the attached.   The problem is when the report is not expanded the Grand Totals column is not accurate... it is displaying the totals of one of the rows when expanded.The expression in the Total Show text box is

= Switch (                                                                      
MID(Fields!protocol_id.Value,1,7)="THERAPY",                    
                                         Sum(IIF(Fields!status.Value = "CO", CDbl(Fields!TX_CO.Value),           Nothing)),
  MID(Fields!protocol_id.Value,1,7) = "GENERAL" and                                                  MID(Fields!program_id.Value,1,6)
= "INTAKE",                                                        Sum(IIF(Fields!status.Value = "CO",

[code]...

Is there any way to not display the expression in the Total columns unless the report is expanded?

View 2 Replies View Related

Report Builder Icon Is Not Showing Up On The Report Manager Home Page

Feb 1, 2007

HI, there,

I added a new windows user "ReportUser" which is a local user (not in administrator group). When I connect to the report manage's web page, I use reportuser to log in (when the anonymous access is disabled it will ask a log in). Report builder icon is not showing up on the report manager home page.

If I log in as a user in administrator group, the reportr builder icon shows up so I can download it and build report.

I have assigned reportuser "Content manager" and "repoter builder" access to the home folder. Is there anything else I have to do to make the report build icon show up on the home page?



Thanks



Jack

View 5 Replies View Related

Reporting Services :: Report Builder - Add Report Processing Time?

Feb 26, 2015

I was wondering if there was any way to add a value field to a report, with the time it took for the report to Process.

It would probably be a text field with an Expression, but don't know how that would go.

I know that in Expression there is a value for ExecutionTime (when report began to run), but nothing about when it ends.Can this be done? and if yes, how?

View 3 Replies View Related

Reporting Services :: See Report-Level Variables In Report Builder 3.0

Mar 22, 2011

Is there a way to see Report-Level variables in Report Builder 3.0?  Also, just as a feedback, it would be really nice if there were a way to see and easily access all of the variables used in a report from one location instead of going to the dataset, the report, and then to the individual groups (if needed) to see the variables.  Also, it would be very useful if Group-level variables can show up in the Expression Builder as well.

View 2 Replies View Related

Reporting Services :: Go To Report Function Works In Report Builder But Not In Web?

Jul 6, 2015

I've gotten to the point of publishing the new reports on the SSRS server and have run into the following problem.

I use a field in the primary report with the "Go to report" action to open up another report (also published) for more details. It works properly from within ReportBuilder (2.0) using the report server and I can go to and from the secondary report as I expect. Its passing the correct parameters to the second report and its runs.

But when I use the reports from the SSRS web, the Go To link no longer works. Mouse hover shows its still a link but clicking goes no where. I can run both reports independently from SSRS and they still work.  

I've tried this in IE and Chrome with no luck in either. I also poked around at Compatability view and popup blocker but nothing made any difference.

View 2 Replies View Related

Restrict Report Builder Access To Report Execution Timeout

Nov 22, 2006

I am setting up the SQL2005 reporting service to let users build their own reports on the web. I'll provide them with pre-built report models. We have concern with SQL database performance by allowing users to execute huge reports. The problem that I have is: If I give the users permissions to build report they'll have access to the report's Properties | Execution page, which allows them to disable the report execution timeout. Is there a way for me to allow them build reports while restrict them to access the report execution timeout settings?

Please advise. Many thanks.

View 1 Replies View Related

Report Model: Drill On Calculated Field In Report Builder

Feb 11, 2007

Hi,

I've created dsv that contain all fields from table database. in the smdl I've remove some fileds due to security. All fields in the smdl do not contain drill.

Issue: When I created calculated field in the report builder the field has a link. When I clicked the drill I saw all the record data including field that not in the smdl.

Questions:

1) Can I remove the link from the calculated fields?

2) Can I prevent from users drill to fields that not in the smdl?

Thanks,

Assaf

View 1 Replies View Related

User Unable To Save/Open Report In Report Builder

Feb 21, 2007

Hi,

I have environment that use SSRS 2005 ad hoc reporting.

One of the users (out of 200) is unable to open or save reports in the report builder.

the user succeed to open the report builder, when he try to save report that he build from shema he get error. as well when he try to open an existing report that build in the report builder he also get an error,

On open the error is:

The numeric portion of 2pt cannot be parsed as a unit of the type point.

The Initilizer for 'Microsoft.ReportingServices.Design.Constants' threw an exception

On Save the error is:

System.IO.StreamReader: Deserialization failed: The type initializer for 'Microsoft.ReportingServices.Design.Constants' threw an exception. Line 2, position 2

Please note that I succeed with second user to create ad hoc report on the first user

computer. I also failed to with the first user to create ad hoc on another computer.

It seems like permissions issue

Thanks,

Assaf

View 3 Replies View Related







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