Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Line Numbers In Report Builder


I have a report in which the user community would like line numbers associated with each row.  Has anyone done this or have any ideas how to accomplish this?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Report Builder: How To Provide Parameter In The Report Generated Report Builder
Hi All,

I have used Report Builder in one of the project for client. Is it possible to provide parameter in the report that is generated by Report Builder? It's quite the same with the parameter in usual Report/RDL (by Visual Studio).

 

And is it possible to pass the UserID that is running the report to the Data Source View or directly to the query? Currently, I need to get the UserID of the user that runs the report to do some filtering of the data (in SQL Query). I can do this easily in the RDL file developed by Visual Studio, which I can use global parameter User!UserID and pass to query. I find difficulty to use SQL Execution Context (select USER_NAME(),SUSER_NAME()), because report needs to be run as certain account, so that the report can be subscribed by user (e.g. email subscription). How to pass this UserID to the query/data without end-user intervention in Report Builder?

 

Thanks.

View Replies !   View Related
Report Builder: How Can I Append Two Table Fields To Report In Report Builder
 
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 Replies !   View Related
Line Numbers.
How to enable “line numberâ€? display in query editor (SSMS)?


------------------------
I think, therefore I am - Rene Descartes

View Replies !   View Related
Adding Line Sequence Numbers
hi all

I am stuck with something that seems easy but im obviously clueless as how to execute the idea.

I have a custom table that houses invoices on the details level. So for example i have:

InvcNo
00000001
00000001
00000001
00000002
00000002
00000003

and so forth

What I am wanting to do in another column is keep track of the sequence number for each distinct invoice like:

SeqNo
1
2
3
1
2
1

I am working in a stored proc and i cant get past adding the numbers up at each line as a whole and not reseting when the next invoice number is present. Any help would be so greatly appreciated.

Thanks

View Replies !   View Related
Generating Sequenced Line Numbers For Each Invoice Number
Can you help me with SQL issue I€™m stuck on? 
I wish to take source data that looks like this:





Invoic_num

Line_num

 

 

 


6658

0

 

 

 


6658

2

 

 

 


6658

8

 

 

 


7721

2

 

 

 


7721

3

 

 

 
 
And rebuild the line numbers like this:





Invoic_num

Line_num

 

 

 


6658

1

 

 

 


6658

2

 

 

 


6658

3

 

 

 


7721

1

 

 

 


7721

2

 

 

 
 
This seems completely impossible to me. So I was thinking that maybe a second procedure using update could be run against the table after the initial build.

View Replies !   View Related
CLR Stored Procedure And Stack Trace Line Numbers
Hello you all CLR stored procedure experts,
 
When a self-developed CLR stored procedure throws an Exception and the Exception is caught in the code and for example logged, there only are class and method names in the stack trace lines, but not the line numbers. Can the line numbers somehow be included in the stack trace?
 
I'm not familiar with .NET framework stack traces, but when I tried to find out more information I hit concepts like PDB files, are such things somehow needed to enable line numbers in stack traces?
 
Big thanks already in advance,
J

 

View Replies !   View Related
The Zero Line Seperating Postive And Negative Numbers Should Be Darker
 

Hi,
I am having chart which has positive and negative numbers.I need dark line(gridline) at 0.00th location.So that it differentiates between positive and negative levels.So please help me out in solving this asap.
 
Thanks in Advance
Shri

View Replies !   View Related
SQL 2005 Management Studio: Line Numbers In Query Window.
Can anyone tell me if you can display line numbers in the query windowof SQL 2005 Management Studio and if so how do I go about doing it?Thanks a bunch. TFD

View Replies !   View Related
Modifying A Report Created In Report Builder In The Report Designer.
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 Replies !   View Related
Software / Other Requirements For Executing Report Manager And Report Builder On A Client Machine
Hi,

 

I created an adhoc model using MSSQL Server 2005 and also created a report (based on that model using

the Report Builder application on my machine which has both, VS 2005 (along with .Net Framework 2.0) as

well as MSSQL 2005 Reporting Services installed.

 

However, when I try to access my localhost from somebody else's machine, I am not able to do so. The

machine from where I am carrying out this activity has the following credentials: 

The user is not an admin user
No .Net Framework installed. (Hence when I click on Report Builder it asks me to install .Net F/w 2.0)
No VS2005 installed
No MSSQL 2005 Reporting Services installed.

So can anybody please help me with the solution for the following queries??

Do I need to log in as the admin user, if I wish to view Reports from the Report Server?
Is .Net F/w required on the client machine??

Please help

 

Thanking you in advance

 

Kind Regards

 

Pratik

View Replies !   View Related
Possiblity / Instructions On How To Install Report Builder Locally Without Hitting Report Server
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 Replies !   View Related
Report Builder Using Report Model Based On Linked Server (Excel) - Primary Key?
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 Replies !   View Related
Unable To Launch Report Builder From Report Manager( But Works From Localhost !!!)
 

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 Replies !   View Related
Problem When Starting Report Builder With Report Path Launch Parameter
Hi,

 

I'm having a problem with the Report Builder application; when I open Report Builder without parameters the application is working fine - I can create reports and save them in a folder I have access to on the Report Server.

 

However, if I open Report Builder with the report path as a launch parameter to edit an existing report I run into some problems. I can still change and execute the report and save it (if I have publish-permissions to the folder/report), but if I try to use Save As to save the report somewhere else it does not work.

 

The Save As dialog appears, but the "Look in" dropdownlist is empty, and the box below says "Loading...". If I try to press the "Folder up" button next to the dropdownlist an exception is thrown. It seems the Report Builder suddenly does not know which Report Server it is connected to..

 

I use e.g. https://<servername>/reportserver/reportbuilder/ReportBuilder.application?/BUs/Standard/testke as url to open Report Builder. BUs/Standard/testke is the report's path.

 

Am I doing something wrong here?

 

Thanks,

 

- Kjetil

View Replies !   View Related
Report Builder Icon Is Not Showing Up On The Report Manager Home Page
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 Replies !   View Related
Installing Report Service In Window XP - Report Builder And Other Option Are Not Displaying
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 Replies !   View Related
Report Builder Not Appearing In Report Server 2005 Web Page
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 Replies !   View Related
Report Builder Report - Formatting The Alternate Rows In Different Colours
 

Hi All,
        I want to format the alternate rows in different colours of Tabular Report (Done using the Report Builder), as we do in Sql Server Reporting Services .Is this possible in the Report Builder ?.
-Mahendra

View Replies !   View Related
Report Model: Drill On Calculated Field In Report Builder
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 Replies !   View Related
Report Builder And Report Server Cross Domain Communication
 

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 Replies !   View Related
Restrict Report Builder Access To Report Execution Timeout
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 Replies !   View Related
Hidden Attrib From Report Model Can Still Be Viewed In Report Builder
Hello, I use MS Visual studio 2005
 
 

When I add a new Report Server Project: Project1
This project contains:
 

-JH.ds (Data Source)
-JH.dsv (Data Source View: contains 1 table ('JH_Table1') with 3 attribs (a, b, c)
-JH.smdl (the property hidden of a,b and c are set to TRUE)
 
Then the project is deployed.
Report builder is started from internet explorer.
 
When the project is openen JH_table1 is in the entity list.
When JH_table1 is seleced in the entity list no fields are visible. (so far so good)
 
But when I double click on JH_table1 in the entity list a table is added with 3 columns a, b, c?
 
Is this a bug?
 
Is it possible to make sure column C is not visible/addable in report builder?
 
Kind regards
 
Jeroen 

 

View Replies !   View Related
Multiple 1:N Tables In Single Report Builder Report
The version of Report Builder I have will only let me choose from a very limited range of layouts. For example, the tabular layout displays a single table on a page.

 

Is there a way to produce a report containing two tables and other fields?

 

For example, I would like to create a very simple customer report with customer name and address at the top, then a table containing all contacts I have for the the customer (a 1:N sub-table of customer) and then a second table containing all the orders from the customer (a 1:N sub-table of customer).

 

Is this possible in the current version of Report Builder or is it planned in a future relase?

 

P.S. I know this is easy in VS Report Designer but I specifically want to do this in Report Builder. The Report Designer client is simply too complex for my non-technical user base. Report Builder would be ideal.

View Replies !   View Related
Dynamic Refresh Of Report Model In The Report Builder
Is it possible to dynamically refresh the report model of the report builder?

could it even be using code with any of the interfaces?

When we add a table or add a column to the table in database , will the report model get refreshed automatically or do we need to do it externally. If so, can we use any of the objects and write a custom code in VB.

View Replies !   View Related
Error Viewing Report Created In Report Builder
Cuandro estoy creando un reporte con report builder y le doy ejecutar sin guardarlo me manda el siguiente error:
 
Sintaxis incorrecta cerca de '<'.
La etiqueta 'xmlns' ya se ha declarado. Los nombres de etiqueta deben ser Ășnicos en cada lote de consultas o procedimiento almacenado.
La etiqueta 'xmlns' ya se ha declarado. Los nombres de etiqueta deben ser Ășnicos en cada lote de consultas o procedimiento almacenado.
La etiqueta 'xmlns' ya se ha declarado. Los nombres de etiqueta deben ser Ășnicos en cada lote de consultas o procedimiento almacenado.
----------------------------
Query execution failed for data set 'dataSet'.
----------------------------
An error has occurred during report processing.
 
Pero si lo guardo y lo ejecuto desde el servidor de reportes si se ejecuta, alguien tiene idea de por qué no puede ver los reportes a medida que los voy desarrollando?

View Replies !   View Related
Cannot Drill Down On Drillable Column From Report Builder Report
I deployed the same report model to 2 different SSRS servers.  The report only has 1 field with count of records from 1 table.  I can drill down on this column on 1 server, but not on the other server.  This column is set to drillabe on the report model. 
 
Is there any SSRS configuration that is stopping me drilling down on it?

View Replies !   View Related
Error Viewing Report Created In Report Builder
Using the report builder, I created a simple report based on a report model. This report runs ok in the report builder.

I proceeded to save the report to the report server, but when I want to view this report in Report Manager, I get the following error:

An error has occurred during report processing.

Query execution failed for data set 'dataSet'.

Incorrect syntax near '<'. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xsi' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xsi' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xsi' has already been declared. Label names must be unique within a query batch or stored procedure.

View Replies !   View Related
Problems In Report Builder With Multi-Dimensions Report
Hi,
 
I have made a build a Report Model Project on Analysis Service Database.
Project is build successfully.
 
But problem is that, while I generate Ad Hoc Reports on multi-dimensions then it gives blank data.
Is Report Model does not works with multi dimensions selections in Ad Hoc reports.
 
I was thinking it will behave just like Pivots, while access Cube in Excel.
 
Please give lights in this area I€™m in need for this functionality.
 
Thanks & with Best Regards
Bhudev
 

View Replies !   View Related
Cannot Set The Subscription For Any Report Created By AS 2005 Through Report Builder.
I have created couple report through report builder which using AS cube as the data source. Every time when I try to access the New Subscription from the web UI. It complains about "Subscriptions cannot be created because the cedentals used to run the report are not stored, or if a linked report, the link is no longer valid.".
 
So I went into "Properties" -> "Data Source" and use the custom data source. I've selected "Microsoft SQL Server Analysis Services" and put in the following Data Source=SQLTEST;Initial Catalog="Data Warehouse AS". I've select "Crednetials stored securely in the report server", using my Windows login and password.. and I've got the following error.
 
"
An error has occurred during report processing.



Query execution failed for data set 'dataSet'.






The SemanticQuery element at line 7, column 351 (namespace http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling) cannot appear under Envelope/Body/Execute/Command. "




Please help!!!

View Replies !   View Related
Report Builder Report Models On Top Of Analysis Services
Hi,

 

Is anyone using Report Builder via a Report Model generated from Analysis Services in production?

 

From what I have seen on the Forum people have done this from books, but it is not clear as to whether they have used it at work, in production. There do appear to be reports of some problems with the integration between the two, and with performance.

 

The attraction of Report Builder on top of Analysis Services is that we should only need to define measures, security, etc, once in the Cube, not twice, as we would if we had to use Report Builder on top of a relational source, alongside Cubes on Analysis Services.

 

What I would like to find out is:

 

1) If there is someone who has deployed Report Builder on top of both a relational data source and Analysis Services. If so, which has been taken up best by the users?

 

2) How does the navigation in Report Builder work with Cubes. It seems a little bizarre in that you can only drill down, never up. Is there any way around this. Do you need to design the Cube specifically to support the Report Model? If so how?

 

3) The generation of the report model is easy. However, is there any way to control this, or to edit it later?

 

4) We have had problems with Report Models on relational sources where changes have invalidated the Report Model and all reports built on it. Can similar problems arise, for example, if you change the Cube and then Re-Generate the Report Model?

 

5) Are there any other issues around Report Builder. The two I have found so far seem to be Hidden Dimensions showing up, and Report Builder not working if measures are defined as non-aggregatable.

 

6) Are there any other end-user adhoc reporting products which work better with Analysis Services?

 

Regards

 

 

Paul

 

View Replies !   View Related
Can't Create A Report That Uses Related Tables On Report Builder
I'm using Reporting Services integrated with SharePoint Server 2007, but when I tried to use Report Builder to create my report that uses data from two or more tables, it just surprised me with the limit of just one entity (table) for each report, so I can't use such a INNER JOIN or any other way to create a relationship between the entities.
 
How can I achieve this goal and add this report to a SharePoint Page?
 
PS: If this is not the right forum, please move this post to the right one.

View Replies !   View Related
Report Builder Displays All Folders When Saving Report
 
When saving a report in Report Builder the default users folder is displayed when save is first clicked.  However the user can navigate to any folder from the root on down.
Is there anyway to only allow the user to access their "My Report" folder and not navigate to other folders?
 
Users are currently placed in a Windows Group.  The windoes group is given System User and My Reports roles.
 

View Replies !   View Related
Converting Report Desinger Files To Report Builder
Hi

 

I am working on Report builder project and was wondering if somone can help me with below questions

 



Is it possible to convert RDL files built in report designer to Report Builde RDL file? if yes then is there any tool or we will have to do it manually. I have also seen that there is no SQL in RDL files created in Report Builder.
If above is not possible then my second question is if we can only copy the layout but as we have got 1000 RDL files in built by report desinger how can we automatically convert this into layout in Report Builder.
Does Microsoft has any specific tools for this?
Will highly appreciate for any help on above.

 

Thanks

M

View Replies !   View Related
[Report Builder] Use More Entities In Report Build
Hi, i wanna make a report and use data from diffrent entities, the problem i can't. When im clicking on an entitie i cannot go back to the 'main' screen where all the entities are.

Im using AdventureWorks db now, can i for example get from the entitie 'contact' Store contacts and from 'Culture' the Culture ID's

is their a way to do this, or is the report builder made to only generate reports from ONE entitie.

Kind regards from Holland!

-Arjan

View Replies !   View Related
Inserting Picture In Report Builder Report
Hi everyone,

I want my users to be able to insert the logo when they create reports using report builder. Documentation tells that under Insert tab you can click on "Picture" and then browse to the location of the file and insert a picture. But I dont see "Picture" option under Insert menu. I only see 3 options "text box","Filter Description" and "Total Row Count".

 

Any Idea???

 

Thanks

Ashwini

View Replies !   View Related
Is Such A Report Possible Using SSRS 2005 Report Builder?
I have RS 2005 SP1. I have a report model developed and deployed.

 

I have a scenario and I am not sure if it is possible to create a report for this scenario using the report builder. Let's say I have a customers entity and address entity that is related to the customer's entity as a 1-many relationship. I have the effective date on the address that specifies the date from which the address is effective. A customer will have multiple records in address with the latest effective date as the latest address of the customer.

 

Suppose, I need to create a report using the report builder to get the list of latest address for customers, how can I do it? I know it can be done using the report designer using a query that uses the group by clause. But can it be done using report builder?

 

Thanks in advance.

View Replies !   View Related
How Do I Build An Ad-hoc Report To Show Top 50 Using Only Report Builder?
Hi all,

 

I'm very new to report builder and I don't even know if this is possible. Some of my users have asked if they can build an ad-hoc report to show say top 50 annual salaries. This has to be done soley with whatever report builder has for building ad-hoc reports as that's all the users have access to.

Any help would be most appreciated. Thanks.

View Replies !   View Related
Using .rdl Created With Report Design In Report Builder
Hi,

I have a couple of reports that I created within the SQL Report Designer, I
would like to give the ability to the end user of C# Winform application  to
be able to make modification to this .rdl file using the Report Builder,
however when I try and launch the report that I created within the Report
Designer using the Report builder I get the following error..

Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: The report
'http://localhost/ReportServer/MyReport)' cannot be opened because no data
source is associated with it. Associate a model data source with this report
and try again.

How can I resolve this situation.

I'm not sure if my approach is the best or if I'm I should be looking at the solution from another approach

Thanks

View Replies !   View Related
Exporting Report Builder Tabular Report To CSV
 

A simple tabular Report Builder report was written to feed another system that requires quoted CSV. I have two issues when exported:

1) I can't get control over the exported column names. Currently, they are exported as "FIELDNAME_Value".

When I try to change the column headings in the designer, it has no effect on the exported column names

When I create a New Field and specify my desired column name (e.g., COMPANY), the export appears as COMPANY_Value.

How do I control these names for the CSV export?

2) The spec calls for quoted text. In my export, only values with special characters are quoted.

Thanks in advance.

-DRB

View Replies !   View Related
Report Builder Error When Running Report
Hello everyone,

I've come across an unusual error on some of our machines.  I'm trying to track down why only certain ones will give an error.  I thought it might have something to do with .NET 2.0 not being installed, but I assume that they wouldn't even be able to launch Report Builder if this is the case.  I'm at the point now where I've been told these machines have .NET 2.0.  I plan on trying to verify soon, but I thought I'd get everyone's opinion on what it could be.

With even the simplist report (just 1 field dragged onto the report) the following error appears: "Report execution error  The report might not be valid or the server could not process the data."  When I clicked on the details, the following appears: "The numeric portion of 0pt cannot be parsed as a unit of type Point.  -----  The type initializer for 'Microsoft.ReportingServices.Design.Constants' threw an exception."

This model was created with Business Intelligence Development Studio and we're using SQL 2005 Enterprise.

Anyone have any thoughts on what this could be or how I can better troubleshoot it?


Thanks,

Dan

 

View Replies !   View Related
Automatically Save Report In Report Builder
Hi,
 
In Report Builder(SSRS 2005 sp2), is there a way to automatically save a report the user is working on?  The problem is that somtimes a user would be spending a long time working on a new report and the connection would timeout and the user has to start all over again.
 
-waslam

View Replies !   View Related
Formatting Numbers In A Mixed Column (numbers In Some Cells Strings In Other Cells) In Excel As Numbers
I have a report with a column which contains either a string such as "N/A" or a number such as 12. A user exports the report to Excel. In Excel the numbers are formatted as text.

I already tried to set the value as CDbl which returns error for the cells containing a string.

The requirement is to export the column to Excel with the numbers formatted as numbers and the strings such as "N/A' in the same column as string.

Any suggestions?

 

 

View Replies !   View Related
Cannot See Report Builder In Report Manager
Hi Everyone,

 

I recently updated my instance of SQL Server 2005 express to install reporting services.  I am able to navigate to the report manager url but the report builder button is missing.  Also, when I go to the report manager url, It prompts me for the server's username and password.  Does anyone know how I can fix this?

 

 

View Replies !   View Related
Saving A Report In Report Builder
I used Report Builder to create a report then I saved it.  The report does NOT appear in my Shared Reports folder in Report Manager.  However, if I go back into Report Builder and hit "open" the report defintion is saved and I can open and run it in Report Builder. 

 

Why can't I run it from Report Manager?

 

Thanks.

View Replies !   View Related
Report Builder And Report Models
Hi,

 

the database my app is using contains information from multiple user organisations, a sort of multi organisation database. I intend using the reprot builder to provide access to a user ine ach organisation. However the issue of who sees what info has popped up and i'm trying to think of a way to restict the user of report builder to only be able to see their own organisations information. This is a social services type application which is used by mutlitple service providers so organisations get twitchy about other organisations being able to see detailed client info. on the application the security stops this but at am a t a loss as to how to best restirct access to an organisation won client data.

 

any thoughts? is this somehting that can be configured through the reprt model and the report builder user account?

 

few ideas or advise would eb v helpful,

 

trhanks

View Replies !   View Related
Report Builder Report Possibility?
This may not be possible, but I wanted to see what some of the experts' opinions are here.

One of our users has created a report in Report Builder.  I want to take this report, post it to a folder and allow her employees to run the report.

I've put it in a folder called "Reference Line Reports" and gave browser permission to a list of users.  These users are able to run the report (without having access to Report Builder or the report model).

When they try to utilize the "infinite clickthrough" functionality, I get the following error.

The permissions granted to user '<domain><username>' are insufficient for performing this operation. (rsAccessDenied)





If I give one of these users access to the "report builder" they no longer get the error.  The problem is that we don't want them to run the report builder (giving unrestricted access).  I just want to be able to give them a report builder report with the clickthrough ability.

I would like to disclaim that we have not upgraded to SP1 (or CTP SP2 yet).  Has anyone seen a similar problem or know if this was something fixed in sp1?

Thank you,


Dan

View Replies !   View Related
How To Open A RDL Report In Report Builder ?
I have 2 files for a report (rdl and data). If I am trying to open the report using the File->Open->File->*.RDL , the VS will open the XML report definition.

How can I see the design of the report ?

Thanks.

View Replies !   View Related
Summary Only Report With Report Builder
Hello,

I have been trying to figure out how to develop a summary only report with no luck.  I have tried several groupings but still cannot suppress the detail.  Has anyone been successful in creating this type of report?

Thanks in advance.

Dean.

 

View Replies !   View Related
Duplicates Report In Report Builder
I have a need to allow the users to create what we call "Duplicate Reports" using Report Builder.  It's the classic select to get duplicates:
 
select columnA, count(*)
from tableA
group by ColumnA
Having count(*) > 1
 
I cannot seem to get this to translate into a query in Report builder.  I've tried adding columnA to the table on the report canvas, grouping on columnA and creating a field called RecCount, that consists of count(columnA) and placing that in the table on the report canvas then adding a filter that says where RecCount > 1.  When I generate the report it says no data meets the criteria, when I know we have data that meets the criteria.
 
The reason we are doing this in Report Builder is that the column that contains duplicates can vary, one day it can be columnA, the next day it can be columnB.  We are just trying to give the users the power to create the reports so they don't have to wait on the DBA staff to do it for them.


This is such a simple thing, there must be a way to do it, but I haven't found the magic combination yet.  Any help would be appreciated.
 -A.

View Replies !   View Related
Cannot Delete Report From Report Builder
We have successfully implemented Forms Authentication with Reporting Services.  While users can create new reports and modify existing reports in Report Builder without a problem, the "Delete" option is grayed out. 
The "Delete" option is even grayed out for the all-powerful "admin" user defined in the RS configuration files.
There is no problem deleting reports using Report Manager.
 
What security setting is Report Builder checking when it determines whether the delete option should be available or not?
 

View Replies !   View Related
Report Manager And Report Builder
Hi All,

Just wanted to know if this is normal. Here's my situation.

I'm using the SQL Server Express 2005 with Advanced Services.

When I go to my Report Manager page, http://localhost/reports$sqlexpress, I don't see any link for report builder. I've read some articles that I should be able to run the Report Builder from here. Maybe I read it wrong or something?

Also, since I don't have the link, I would have to type the complete URL for the report builder, http://localhost/reportserver$sqlexpress/reportbuilder/reportbuilder.application
. It runs the application fine. Then when I try to enter the Site or Link, which is http://localhost/reportserver$sqlexpress/, I get an error on the Get Started Panel saying "Report Builder and Report Models" is not supported in this edition of reporting services."

Does it really not support Report Builder and Report Model if I'm using SQL Server Express 2005 with Advanced Services?

Thanks.

View Replies !   View Related
New Report In Report Builder Issue
Hi,
 
When I download the report builder by clickonce and select the new option in File menu it doesn't work!, nothing appears,
 
Why is happening this?
 
Thanks

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved