I am using a Visual Studio 2005 for web application development, for Reporting service
I am using Sql Server Reporting Service and Report Builder 9.0.1399.0.
Is it possible to use the Report builder tools (Explorer, Fields and Design Report) in
an ASPX pages?.
Is it Possible to create the Reports dynamically in a Web Application using Report
Builder?
Thanks in Advance
Thanigaivel
Hi !
I'm trying to figure out how can i get a list of the reports made with reportbuilder. I have create a folder in ReportManger and all my report are in this folder.
When i create report with ReportDesigner i get a .RDL file, but when i create a report using reportBuilder i can't file the file created. What i want to do is to create in our web application a Web page with a list of report that our client has create using ReportBuilder. I was thinking about doing a loop on the folder for each report File but i can't find those files.
Any idea ?
Thanks!
(I wish I was able to attach pictures....anyhow I'll try my best without them)
The customer's goal is to via ReportBuilder to select fields from multiple
many-to-many relationships. They are able to see the fields that exists
within the various many-to-many relationships but IS ONLY able to select
fields from ONE many-to-many relationship. Example using AdventureWorks:
DataSourceView (relationships automatically generated by wizard)
Contact ---< VendorContact >--- Vendor
Contact ---< StoreContact >--- Store
Contact ---< ContactCreditCard >--- CreditCard
So the goal in the ReportBuilder is to be able select fields from
Contact/Vendor/Store/ and CreditCard.
PROBLEM is that the ReportBuilder ONLY allows user to select fields from
Contact/Vendor OR Contact/Store OR Contact/CreditCard (exclusively)
The only workaround I've found is to reverse the relationships in the
DataSourceView to the following
Contact >--- VendorContact ---< Vendor
Contact >--- StoreContact ---< Store
Contact >--- ContactCreditCard ---< CreditCard
This works however we need an explanation as to why it only works this way?
Thanks in advance
Hi,
I have a need to display on screen AND email a pdf report to email addresses specified at run time, executing the report with a parameter specified by the user. I have looked into data driven subscriptions, but it seems this is based on scheduling. Unfortunately for the majority of the project I will only have access to SQL 2005 Standard Edition (Production system is Enterprise), so I cannot investigate thoroughly.
So, is this possible using data driven subscriptions? Scenario is:
1. User enters parameter used for query, as well as email addresses.
2. Report is generated and displayed on screen.
3. Report is emailed to addresses specified by user.
Any tips on how to get this working?
Thanks
Mark Smith
Is there a way to subscribe SSRS report using dynamic parameters for email and trigger the report from autosys job so that report should generate the exact time the job is triggered.Let me describe, my SSRS report should be triggered on success of one autosys job. i need to send email parameter and time of report schedule from this autosys job.
View 3 Replies View RelatedI have three types of specific reports that i have to create with the input parameters (range) either
1: By date (rdl 1)
2.By Month (rdl 2)
3.By Year (rdl 3)
Is it possible ( or how do I ) to create just one report template ( one rdl) with the three sets of parameters ( hiding/invisible which ever two sets base on user selection) and the output of the report will display the desired type( either by year, month or date).
I ask this because its possible to create a drill down report from year down to date etc in report designer (vs 2005). Not sure if I can create one instead of three rdls and with the 'logic' built within that template.
Thanks
Regards
Alu
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.
All,
I have a report that grows horizontally as it contains a matrix. In the header section of the report, I have items such as Title and time stamp in text boxes. How can I make these items align in the center if the report grows horizontally, it looks kinda odd with report title not being in the center? Any input will be appreciated.
Thanks.
I was the happy admin of some reportservers (build 3175) until someone asked me to get the ReportBuilder to work. I've read through the documentation and configured the SSRS site security so that the icon is visible. However when I click on it nothing happens. If I try to launch it by right clicking and then save as -- open I receive the following error:
- Downloading file:///C:/UserTemp/_temp/ReportBuilder.exe.manifest 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.DownloadApplicationManifest(AssemblyManifest deploymentManifest, String targetDir, Uri deploymentUri, IDownloadNotification notification, DownloadOptions options, Uri& appSourceUri, String& appManifestPath)
at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)
at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState subState, ActivationDescription actDesc)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.FileWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
at System.Net.FileWebRequest.WrappedGetResponseCallback(Object state)
--- Inner Exception ---
System.IO.FileNotFoundException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: mscorlib
- Stack trace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.
Here are the things I have checked/tried:
Ensured the .NET Framework Reliant components are enabled in the browser
Running the browser with a user account that is local admin on the workstation
MIME settings on IIS server look ok
I am not seeing any access denieds on my workstation (checked with file and regmon)
I am not seeing any failures in the security event log
For the test that I am doing, both the user account, workstation and server are in the same domain
Don't see any errors in the SSRS logs
Can anyone think of anything else that would lead me to resolving this problem?
Thanks
How to integrate reportbuilder with a .Net web application?
View 1 Replies View RelatedWe created a custom security extension for RS using Forms Authentication. The issue I am having is in ReportBuilder when the forms authentication ticket expires. Forms auth will attempt to redirect (send a HTTP 302) and the report builder will show the error message "Object moved to here" instead of prompt for credentials. I have been watching the IIS logs and I see the first time report builder start it attempt to connect using default windows credentials and after the FormsAuthenticationRequired exception it will prompt for credentials and invoke LogonUser method, but this only happens the first time or if change the server in the url. I was expecting ReportBuilder to consider the Forms Authentication expiration at any time.
Do you have any idea how to work around this?
Any help is really appreciated.
Thanks
I have a question about table layout report. I want to do that:
I have a table report and on that report i have a Total field of money. And i want to do that if condition on that field, so if the prize is less then 150, the color of the text it should be red otherwise it should be other color. So how can i achieve that. I know that this is possible in Reporting services in Report Designer is like =IIF(field.???.Value<150;"red";"gree")
But if i make that same in report builder, the what it does, it displays not the value in color, but it displays the text "red" od "green".
I will be very happy and gratefull if somebody can help me.
thank you in advance.
Hi,
Is there a way to change the size of the fields (in this case a drop down list) on the filter page of ReportBuilder? I have an attribute I want to filter by, but the contents are too wide so the full thing can't be read if I set up an 'equals to' filter in ReportBuilder.
Thanks.....
I am trying to open the reportbuilder from within a web application so that I can pass the credentials. I would like to be able to have the reportbuilder open within the app. Is this possible.
I'm trying to avoid keeping the report builder credentials and the app's credentials both up to date.
Thanks.
This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:
PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (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 : https://reports.mysite.com/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 https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/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: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-------------------------------
Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:
Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework
Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework
Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework
Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!
Hi !
We have made a lot of reports using Visual Studio. Now some of our client would like to customize those reports. We have install ReportBuilder on their server to allow them to create their own reports. Everything is working fine when they are trying to create new reports. The problem is when they are trying to customize reports that we have made using Visual Studio.
When they are trying to open those reports in ReportBuilder they get this Error:
One or more unexpected Report Definition Language (RDL) elements of the following type have been removed: DataSetMicrosoft.ReportingServices.ReportBuilder.ReportModel.Report: System.Web.Services.Protocols.SoapException: The operation you are attempting on item "/Data Sources/DataSource1" is not allowed for this item type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "/Data Sources/DataSource1" is not allowed for this item type. at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.GetModelItemIDAndItemSecurity(ModelCatalogItem model) at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.LoadModel(ModelCatalogItem model, Boolean getModelDefinition) at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, Boolean getModelDefinition) at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadUserModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, String perspectiveID) at Microsoft.ReportingServices.Library.GetUserModelAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition)
We get this error for each report that we have create under Visual Studio (All those report use parameters). Is there a way to allow our client to customize those reports ?
Thanks !!
PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (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://webdev.ci.lubbock.tx.us/ReportServer$SQL05/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://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [4/10/2006 11:34:29 AM] : Activation of http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [4/10/2006 11:34:29 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/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: (401) Unauthorized.
- 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.
Does anyone know how that I can get the reportbuilder.application to run on a client on the network. It seems that if I have to remote into the actual server to get the report builder to work would be pointless for users on the network. I get the 401 Unauthorized all the time. Any comments would help.
Jordanb412
We have installed SQL Server 2005 reporting services and reportbuilder.
On the local machine and local network we can start and use reportbuilder perfectly.
We are using ISA server for security. When we get around ISA it works fine, but when we have to get access via ISA, we get the error 'unauthorised', when starting the reportbuilder application.
The virtual folder 'reportbuilder' is configured in IIS for Anonymous access, the report en reportserver virtual folder, we need basis authentication.
Can someone help?
I am creating a dynamic DSN in a report to pick which database to run a query against. I have a fairly simple expression,
="Data Source=MYSQLSERVER;Initial Catalog=ADV_" & Parameters!DBNum.Value
When I try to preview the report, I get the following error
An unexpected error occured while compling expressions. Native complier return value: '[BC32017] Comma, ')', or a valid expression continuation expected.'.
I have also tried it without the parameter,
="Data Source=MYSQLSERVER;Initial Catalog=ADV_1"
with the same result. When I use the exact same static DSN it works fine. Anyone have any idea what I might try to get it to work next?
R
Hi,
I'm trying to create a report with dynamic columns. I mean that the user is able to select if he wants to see a double drill report with client group and product group, or agents with clients, or everything else he needs. I tried to insert some variables in the query that extracts data from report, and using that variables like parameters, but Reporting Services always get the parameter default value and not the correct value i give him.
How can I solve my problem? There is another way to obtain dynamic reports?
hi,
i have a dataset which returns me a dynamic set of data ie. number of columns can be different....say 14 columns for some dates...and just 12 for some other...(pivot table is being used in the backend)...how can i present this in the table...also my column names are best suited to be the column headers in the table.....is it possible to create a table at runtime...??
Hello,
I am currently working with SQL 2005 Reporting Services and MS Visual studio 2005.
In my SQL server I have data about organizations, so that each organization's data is stored in an individual database.
In addition, the number of organizations/databases is variable. I know the number of organizations and the name of each one (that it agrees with the name of its database)
because there is a database (organizationsDB) with a table (organizationsTB) containing the list of the organizations.
So, It would be possible to create a report containing a summary of each organization? .... for example a table in which each row contains data of each organization.
Could you give me any ideas?
Thanks in advance!
Hi:
I have a question of create a dynamic the report.
For example: At the beginning I have 3 columns in the report, build by VS. After couple weeks, the same report needs to have more columns. And i don't want to use the VS to modify the layout manually, instead, when adding new columns, I can call a function to modify the rdl file add attributes into the xml file automatically. But after that which way I can go to publish the modified report into the report server, then when user clicks on that report again, there will be more columns show up.
thanks
Hello,
is it possible to have a kind of dynamic subreport in a main report.
Let me illustrate this with an example:
Next to my table i would like to have a window (subreport) that changes content whenever i click on a different value
inside my table. In the subreport i would like to display detail information on specific cells in my table.
Is this possible in SSRS 2005?
Greetings
V.
Hello Sir,
I m working in Microsoft SQL Server Analysis Services Designer
Version 9.00.1399.00 for creating reports .
Now, I m facing a problem to view a run time dialog box at time of my report.
Means ,
In my report procedure , i have fired 2 delete queries after firing of these queries i wanna show a message box with Message "Some Records are Deleted". and one Ok Button !!
and after showing this dialog box i wanna view my report output !!
The procedure of my report is :
-----------------------------------------------------------------------------------------
create procedure MyTemp
as
-- Query1
delete from myTempTable1 where Id = 5
-- Query2
delete from myTempTable2 where Id = 10
-- After exectuing above two queries Query1 and Query2.
-- here i want to view amessage dialog box with message "Some Records are Deleted"
select Id, name from myTempTable1,myTempTable2
-----------------------------------------------------------------------------------------
So, how can i do this !!
I will change in my proceudre or report !!
Please suggest me about solution of this problem .
If u dont have any solution regaring this then please suggest me where i will get
the solution of this problem .
Hi Friends,
Is it possible to give a name at run time to a report when we try to download it in any format.
Do we have any control over the report name for e.g. the report name can be passed at parameter value.
Thanks,
Novin
But If I change default parameter with everyone I need it always run correctly! The real problem is in execution mode, it not takes the parameter i give it danamically. I can see only the default columns I set by default. The thing I need to kwnow is: is this method correct or this problem can be solved in any other manner?
View 2 Replies View RelatedI've got this working -- I allow users to have 2 groups, and choose what they want to group by. I'd like to add one extra bit of functionality -- for the inner grouping, I would like my users to have the option "None" -- i.e. don't have an inner group.
I've tried setting the group expression of the second (inner) group to "" when the user chooses the "None" option but the report errors out. Any suggestions as to how to dynamically get rid of the inner group?
Thx
Helen
Hi,
I have report that needs to be scheduled hourly and the output is in excel. I want this to have a dynamic filename (Filename + datetime.xls).
How do i do that?
cherriesh
I have a requirement to add the ability to filter a report by partial last name, at the report level (i.e. not at the database server). In case someone else needs to work out how to do this, here is what I did.
Add a Parameter to the report. In my case it is named LastName, is non-queried, allows Null or Blank, and has a default of null.
Add a filter to the dataset that contains the field to be searched. Set its Expression to:
=IIF(Parameters!LastName.Value = System.DBNull.Value OR Parameters!LastName.Value = "",
Fields!LastName.Value, Nothing) ,
its operator to "="
and its value to =IIF(Parameters!LastName.Value = Nothing OR Parameters!LastName.Value = "", Nothing, Parameters!LastName.Value & "*")
voila!
Helen
Hi, I have a SRS report that I would like to a add an PDF file to be visibleprintable on the report. The data stored is the file location of the file.
I tried using an image; however it does not recognize the PDF files.
Please advise.
View 1 Replies View Related
Hi all,
Is it possible to create a report with dynamic parameters or parameters dependant on other ones? I have the following scenario -
Parameter 1 - 'Select an Application' - List of applications that are available
Parameter 2 - 'Select a module' - This is a list of modules that needs to depend on Parameter 1. As a user selects different applications, the appropriate module list will be loaded.
Is this possible to do in SSRS?
Thanks,
Brian