Can Rs.exe Also Un Publish Reports?
Jan 7, 2008there's lots of info on the web about rs.exe adding objects to RS, but what about rs.exe deleting them, for cleaning house, without "breaking" anything?
View 4 Replies
ADVERTISEMENT
Reporting Services :: Publish MDW Reports On SSRS
Jun 1, 2015Is there a way to publish the MDW (Data Collection) reports (Disk Usage history, Query Statistic history, and Server Activity history ) on SSRS server?!Â
It is not logical for all who wants to view the mentioned reports to open the SSMS ! Â
I've already check [URL] .... there, the writer is suggesting to recreate the reports from scratch on SSRS, that if I could figure their queries, which I don't think the only way that we have!
ASPNETDB With Publish Provider
Aug 22, 2007Hi!
I have created a sql script with publish provider and the file has all information about ASPNETDB and now i want to drive the sql script into my databas on my webbhosting.
How do i? i have SQL Server Management Studio Express to admin my databas.
any?
How To Publish OLAP Cube
May 6, 2003Hi,
I am new to SQLServer 2000.I have built a cube.I was wondering how to acess this from a client(say via excel or a browser).
Thanks,
copericus
Low Latency Publish-Subscribe
May 4, 2007
Hi,
I have a couple of questions to make.
How can i trigger notifications to my application ( C#)
without hanging in WaitFor Operation??
It's possible for broker service to call some remote
object that my application provide ???
Can Publish/Subscribe using Broker Service be used
for a low latency notifications (150ms ) max with milions of
messages published per second??
Thanks in advance
Sérgio
How Do I Publish Sql Express Database In Internet?
May 29, 2007Hi all,
There is a sql express database .mdf file which I can access locally through local web pages using windows authentication and integrated security = true.
Now I want to publish this db and the web pages to my hoster's server so as to access the db from internet.
The connection string currently is in the web config as below:<add name="NORTHWNDConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|NORTHWND.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> The database is currently located in the App_Data folder.
Please give me some step by step solution to configure the db to access from internet. Thanks a lot in advance.
Transient Deadlock During SSDT Publish
Jul 10, 2015I have a SSDT project that intermittently fails with the following error when I try to publish via Visual Studio by double-clicking the publish.xml file...
(330,1): SQL72014: .Net SqlClient Data Provider: Msg 1205, Level 13, State 68, Line 5
Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
(326,0): SQL72045: Script execution error. Â The executed script:
IF EXISTS (SELECT 1
      FROM  [master].[dbo].[sysdatabases]
      WHERE  [name] = N'$(DatabaseName)')
  BEGIN
    ALTER DATABASE [$(DatabaseName)]
      SET READ_COMMITTED_SNAPSHOT OFFÂ
      WITH ROLLBACK IMMEDIATE;
  END
This is a hyperV client running on my laptop. I'm connecting to the client's VPN inside the hyperV client and using the "runas" method to open Visual Studio to spoof the domain credentials i use on the clients network. This allows me to connect to servers on the client's domain via apps as if I was logged in with appropriate credentials (not sure how to phrase that better). I can elaborate if deemed necessary, but even the client's FTEs are having same problem and they're sitting in the building.
Windows Server 2012 R2 StandardSQL Server 2014 CU6 (12.0.2480)Visual Studio Premium 2013 (12.0.31101.00) Update 4Â
Windows Server 2012 R2 (VMWare)SQL Server 2012 SP2 (11.0.5058).Here are some observations...
Happens about 60% of the time during the day (I just keep re-running until it deploys successfully)...late at night and on weekends, it doesn't seem to happen with anywhere near as high a frequency.Only seems to happen when I use "Always re-create database" option (don't recall incrementals having this problem...but admittedly I'm not doing many of those as we're still in the full-speed-ahead-development phase)This does NOT happen when I publish to my local SQL Server instance..Deadlock xEvent trace on target instance. Unfortunately it didn't seem to be able to capture all the info and the deadlock graph doesn't render (error below) checking the Single User Mode during the publish. This seems to increase the frequency with which this issue occurs.
Replication :: Publish Database On Subscriber
Aug 13, 2015I have database (DB) on the server SQL1. This database (DB) is published on SQL1 server for SQL2 server. So, SQL1 is publisher and SQL2 is subscriber for (DB). Can I publish database (DB) on the server SQL2 for the server SQL3? I would like to implement this scheme of Publication/Subscription:
<o:p></o:p>
SQL1 -> SQL2 ->SQL3..
I know, that it is simpler just to publish DB for SQL2 and SQL3 from SQL1, but, because of network connectivity, I can't do that...
Publish C# Project Connected To Database?
Aug 10, 2015i want ti publish a c# project connected to sql database, i introduced the database into my project, i use the connection string:Â
 SqlConnection cn = new SqlConnection(@"Data Source=CONTA-LAPTOP;Initial Catalog=RaducuIonel;Integrated
Security=True"); Â if right click on the database-> properties iti show me next connection string: Data Source=CONTA-LAPTOP;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATARaducuIonel.mdf";Initial
Catalog=RaducuIonel;Integrated Security=True  Â
...when i connect to server in sql i use windows autentification. And the last thing: when i publish the project it ask me: application will check for updates from [URL] or application will not check for updates. I select first option: to check for updates from here:Â [URL] .to another computer my application cannot connect to database (login error)Â .what i am doing wrong?Â
After Publish From VS2005 To IIS 5.1, SQLExpress Doesn't Work
Jan 30, 2007I created an app in vs2005 and everything works perfectly in the development environment. I've published the site to my local IIS, but when I try to log in, it doesn't allow me. I'm assuming that it has something to do with the db not working correctly. Unfortunately I don't know how to debug to see where the problem is coming from now that it's running on my 'live' IIS. Does anyone have any ideas on what could be the problem. I have some settings in the web.config, which have been working perfectly.
<appSettings><add key="UserName" value=""/><add key="Password" value=""/><add key="Server" value="xxxxxxsqlexpress"/><add key="Database" value="xxxxx_xxx_users"/><add key="UseTrusted" value="True"/></appSettings>
I had a local guy at the office here saying that the ASP.NET user needs to be granted access to sqlexpress2005, but I wasn't sure on how to do that.
So all in all, My app works in Visual Studio 2005, and not in IIS. There are no errors when loading various pages. They all load correctly and without error. It seems that it's just when I try to do anything with the DB.
Thanks for the help. I appreciate it!
Publish A Report From A Local Database To The Server
Nov 10, 2007
Hello,
I recently read the following book:
http://www.amazon.com/Microsoft-Server-2005-Reporting-Services/dp/0072262397/ref=pd_bbs_sr_1/104-5275187-2065567?ie=UTF8&s=books&qid=1194662002&sr=8-1
It was excellent.
I was hoping to find an example of the following:
My company has a desktop application with a local database (sql server 2k express) I would like to be able to have local reports and if the user likes the report they are viewing, the user could "publish" that report to the server. Since the database is local, the report data source cannot point to that database. So, it would publish the report AND the data in it.
For this use case, what is the recommended strategy of moving the data with the report? Would i create a small xml file and then dynamically build a datasource that points to that xml? Any best practices advice?
If i could find an example would be fantastic.
Thanks for your help,
Dan
Publish Window Application With Sql Server Express SP2
Feb 4, 2008How do I get SQL Server 2005 Express Edition Service Pack 2 to show up in the prerequisites list when publishing the application?
Thanks
How Cany I Publish 1 Table From An Attached Database?
Oct 24, 2006Hello,
In my vb.net application, I have an attached database called dbMaster with the following tables:
tblCustomer, tblProducts, tblUsers
In visual studio 2005, is it possible to publish only one table? My problem is, is that I want to send my end users updated data from my tblCustomer, and am finding that on my test laptop, if I publish dbMaster, it sends all tables when I just want one to be sent.
Thanks in advance.
Failure To Publish An Indexed View Logbased Publication
Jun 14, 2007i am trying to publish an indexed view logbased publication but I'm getting "must be a schema-bound view with at least a clustered index to be published as a log-based indexed view article."
The table has clustered index and the view is schema-bound.
this is the script for schemabinding
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [nth].[musictracks1] with schemabinding
AS
SELECT autoid,idtrack,songname,singer,writer,composer,center
FROM nth.musictracks
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
and this is for making the publication an indexed view logbased publication
exec sp_addarticle
@publication = N'lb_publication',
@article = N'musictracks1',
@source_owner = N'nth',
@source_object = N'musictracks1',
@type = N'indexed view logbased',
@description = null,
@creation_script = null,
@pre_creation_cmd = N'none',
@schema_option = 0x0000000008000001,
/* table name doesn€™t have to be the same as view name */
@destination_table = N'musictracks1',
@destination_owner = N'nth'
GO
Any idea what is wrong?
Thanks,
Salah
How To Publish Tables Without Primary Keys In Transactional Replication
May 16, 2007Hi All
I am a newbie to replication. I just want to know Is there any way to publish tables (articles) without primary keys in transactional replication.
Early Thanks,
Salman Shehbaz.
Reporting Services Error When Preview/publish A Report Containing SAP BI Hierarchy
Jan 28, 2008Hi SSRS Experts
I'm trying to create a report using a SAP BI InfoCube as my datasource.
One of the fields in the InfoCube (GL Account) consist of a 3 level hierarchy, which need to be reported on.
The query that I built using QueryBuilder executes fine and displays the hierarchies correctly, but when I preview the report, i get the following error:
An error occurred during local report processing
An error has occurred during report processing
Query execution failed for data set "SAPBWD"
The "0GL_ACCOUNT 1000IE" Object was not found.
0GL_ACCOUNT is the GL account field to report on
1000IE is the selected GL Account Hierarchy to be displayed
Here's the query that was generated using query builder:
SELECT NON EMPTY { [Measures].[D2A3Y7ANS9YOF2FONXMUS9RAI] } ON COLUMNS, NON EMPTY {[0GL_ACCOUNT 1000IE].[LEVEL03].ALLMEMBERS * [ZF_MC].[LEVEL01].ALLMEMBERS } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [ZFGL_M03/ZREP_BOR001] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING SAP VARIABLES [ZFV_FY] INCLUDING [0FISCYEAR].[Z12007] [ZFV_PC] INCLUDING [0PROFIT_CTR 1000FS].[10000001000033] [ZFV_RM] INCLUDING [0FISCPER3].[005] [ZFV_PV] INCLUDING [0VERSION].[003]
I hope you would be able to assist.
Kind Regards
Utian Goliath
I Have A Web Site Where I Input Stories And Set The Publish Date To Some Time In Future And Set An Hour From 1-24....
Sep 20, 2007i need to be able to do an sql call whereby i can check the day and hour for publishing.eg select story where day = ?? AND hour = ?? any one know the best way to do this.
i need to call out date as a day number or someting and the getdate as just the hour??? anyone know how??
Step By Step To Publish/deploy The Report Project To The User Pc ?
Oct 3, 2007hye everyone,
after finished do the report and deploy at IIS/report manager in local pc..
i want to know , what is the step /how to deploy the report project at the user's pc/ client pc /other server..
thanks in advance
thank you very much
Comparison Of SQL Server Reporting Services To Access Reports, Crystal Reports, Cognos Or Other Options
Nov 5, 2007Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
Hal1490
Hal9000
Reports Usage Frequency For All The Existing Reports On SSRS 2000
Mar 18, 2008I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
Reports Usage Frequency For All The Existing Reports On SSRS 2000
Mar 18, 2008I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
Remove All Reports ( Not Data Sources) From Reports Server
Jan 23, 2007Hi does anyone know how to do the above with out going through reportserver url?
Preferably by using a cmd tool ? such rs.exe
or through the backend in the reportserver DB?
Thanks
Dave
Publish A Report Services Report To SharePoint
Feb 8, 2007OK... I'm running out of things to try.
I have SQL Server 2005 SP2 installed and Reporting Services Addin configured. I am trying to publish a report from BIDS to SharePoint... but a box continues to pop up asking me for credencials.
What am I doing wrong? I have reviewed all the web.config files as per an earlier post referenced, but I only see one entry in the config file for the location tag. However, I did see this tag in two config files... not certain if that is something I should be concerned with?
I'd really like to just get a sample report up on the Sharepoint Server so I can move forward.
Can anyone help?
Migration Of SQL Reports 2000 To SQL Reports 2005
Feb 13, 2008Hi Friends,
Could I migrate the reports which are developed on SQL 2000 to SQL 2005. If Yes then How ...
Could anyone explain me. How it works.
Thanks
sqlferns
Converting Crystal Reports To SSRS Reports
Mar 27, 2008
My issue is with converting multi-value parameters:
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
As an example:
I have a database table with a column called ID.
I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data:
1 - 50
60 - 80
150 - 127
This will only return results within those ranges.
Does anyone know if SSRS provides this kind of functionality?
Thanks,
Patrick Conway
Copy Reports From Other Users My Reports Folder
Aug 7, 2007Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.
The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.
Is there a way to do this?
Thanks for your help.
How To Show ChartFX Reports In ReportServer And How To Show Tooltips For Reports Using Chart Properties
Dec 31, 2007
Hi all,
I have two problems.
1. I downloaded ChartFXRSTrial and created one chart, and able to deploy it in ReportServer, but the problem is the reports are not showing there, i checked the configuration of .dll files in the help provided by chartFX, but couldn't get anything, so could help me on this.
2. How to give Tooltip for the X- axis or Y- axis values in the ReportServer , i tried using chartproperties of .rdl file, but didnt understand it. can help me on this, and one more i tried with Dundas too, If im giving tooltip as #valy then, it is showing samething in reportserver instead the values of 'Y-axis'.
Thanks,
Mahesh Manthena
Reports About The Reports Usage
Apr 18, 2007Hi,
We just deployed a report solution and I would like to know when and how much each report is used. Is there a report for it ?
With regards,
Constantijn Enders
Reports
Oct 24, 2006Hi all, how can we get running totals for particular column in sqlserver crystal reports
View 1 Replies View RelatedReports
Oct 24, 2006how to get running totals for a particular field in sqlserver reports
View 2 Replies View RelatedReally Need HELP With REPORTS
Nov 8, 2007Hi,
I have all stored procedures for report for this month and previous month. Now my task is to generate report to find out the difference for all coulms those are same for both month reports.
EX of final report
Month1|Month2|Difference|
sales |Sales | % |
| | |
| | |
| | |
There are other colums in those rows too..
So could any one help me out.
I want my out put in Excel sheet
And its a recuant report ..so i have to use stored procedure.
LOOKING FOR HELP ASAP
How To Know Which Reports Are Being Run
Feb 20, 2008How to know which reports are being run/accessed ? Do i have to query some tables for that.
View 1 Replies View RelatedSQL Reports.
Jul 20, 2005Hi,I have some queries regarding SQL Reports.1. What is SQL Reporting Services?2. What is it's Architechture?3. When it gonna release?It is urgent.If somebody can give me answers quickly.....Thanks in advance,Pratik
View 1 Replies View Related