.......I need to know how to have that displayed before the reports are ran. I'd like to have in the Report Parameters area so users can see this information when making choices for the reports.
View 1 RepliesView 6 Replies View Related
Hello,
I've seen this question floating around, but I have not been able to find a definitive answer.
Can this be done, and if so, what do I need to install into Visual Studio 2003?
Thank you.
-Gumbatman
Well the boss suddenly decided to slap me with one mean!!! (when you have never worked with SQL/MSDE) project, any help or guidance will be gretly appreciated :)
Q: Also understand how MSDE works. Find out if an MSDE database can be used independently of SQL Server. i.e. figure out how an MSDE database gets used as an "off-line" version of SQL Server. I.e. so you can carry a portion of a SQL Server database away with you on a notebook and synchronise back when you re-connect
..... the question is a little broken but i'm sure one of you wiz's will understand,
BTW. I have a little knowledge of Enterprise manager, SQL DB's, Backing up/Restoring, basics in other words, so I might seem a little slow ;) if you bombard me with complicated replies.
Thanks once again.
If I am using Ado.Net from a .Net Class library hosted outside SqlServer to do Sends and Receives do I have to use anything else other than queues? The reason I am asking is because I already have an abstraction layer for a couple of our queueing systems and I was hoping to put SSB in there as well but the abstraction layers' primitive is the Queue not Conversation/Dialog/Service, etc.
Thanks
Costas
im trying to gain some experience using mssql. in my system tray there is a sql server service manager. my question is this...what do i use to interface with sql server? ive seen messages referencing 'enterprise manager', but i cant find it or this thing called 'query analyzer'.
im running windows 2000 professional. i downloaded and installed a program called 'database fishing tool' which seems to do what i need but, im asked for a username and password. since ive never connected to the sql server i dont know this info.
ive scoured the web for anything to help me with this, but cant find any info for what seems would be the most fundamental...
please help. thank you.
Hi,very new to SQL queries, and strugling with join conceptI had to do a join based on a single field:select*fromtableA, tableBwheretableA.value = tableB.value(+);this works finebut how can i do the same thing while comparing multiple columns ... iwas thinking something like this: (obviously doesn't work)select*fromtableA, tableBwhere[tableA.value1, tableA.value2] = [tableB.value1,tableB.value2](+);Is there some sort of "tuple" comparison I can do?Thank you.
View 2 Replies View RelatedI am currently using enterprise manager to run multiple queries on asingle table in a DB. I refresh these queries every few minutes. Dueto the huge number of them I was looking for a better way (or should Ijust say "a way") to manage/save these queries so I can recall themeasier/faster for monitoring purposes. Suggestions?TIA.
View 4 Replies View RelatedHi,After a power outage (and UPS failure), my boss's SQL Server 2000 won'tstart (or crashes quickly or something). We don't have any backups, as it'sa test server. Is there a way to import the database files into a new SQLinstallation? By "installation," I mean either a re-installed SS, a secondinstallation on the same PC, or maybe even on another PC. In another words,given only the files sitting on the harddrive, is there a way to "import"the DBs in those files into SS?Sp_attach_db would probably be the answer, except it seems to requirerunning sp_detach_db...which I cannot do, as SS is not working.Thanks in advance,Jay
View 2 Replies View Related
I have a chart and i am populating it from a sproc.
In the Legend i am getting InvestmentPercent.Value- InvestmentName.Value - InvestmentPercent.Value
How can I just display InvestmentPercent.Value - InvestmentName.value
In the graph it looks
3- cash -3
38 - FixedIncome -38
how can I set this thing right...
Regards
Karen
I have added a pie chart to my report but the legend is not wide enough. Is there a way of altering the width of the legend?
View 1 Replies View RelatedI have few chart based reports where I am showing different costs in series. I want to fix the colour of each type of cost so that I can maintain the same colour for each cost in different reports.
Is it possible?? If yes, then please let me know.
Thanks in advance!!!
Hi All,
what I want is a custom Legend for the Pie Chart.
I have followed this article and have done what was written under
Custom Chart Color Palettes and Legends
http://msdn2.microsoft.com/en-us/library/aa964128.aspx#moressrscharts_topic4
But still the color of the legend is not uniform.
Basically I am using a stored procedure which returns two values : Circle, Total based on a parameter called Customer.
1. I have pasted the code asked in the Code Section of the report.
2. Have Disabled the 'Show Legend' box in Chart Properties.
3. Have included the following code in the Values->Appearance->Series Styel->Fill
=Code.GetColor(Fields!Circle.Value)
4. In the Category groups ->Group on-> this is my expression =Fields!Circle.Value (Basically I am not sure where
should I include Circle Field. I have tried this both by putting it in Category Groups and Series Groups.)
5. Dragged and dropped new table and have done the following
a.table1->Properties->Groups->Add->General->Group on Expression Fields!Circle.Value
b.Deleted Detail row.
c.Dragged and dropped rectangle in the column value and set the background value to =Code.GetColor(Fields!Circle.Value)
When I run the report for different customers the colors are not remaining constant. I have 17 values for Circles. So included three more colors in the "colorPalette " variable..
After doing all this still I am not able to get the same colors. Could someone tell me where I am going wrong?
trying to get a new database created then running a script to created the tables, relationships, indexes and insert default data. All this I'm making happen during the installation of my Windows application. I'm installing SQL 2012 Express as a prerequisite of my application and then opening a connection to that installed SQL Server using Windows Authentication.Â
E.g.: Data Source=ComputerNameSQLEXPRESS;Initial Catalog=master;Integrated Security=SSPI; Then I run a query from my code to create the database eg: "CREATE DATABASE [MyDatabaseName]".
From this point I run a script using a Batch file containing "SQLCMD....... Myscriptname.sql". In my script I have my tables being created using "Use [MyDatabaseName]   Go  CREATE TABLE [dbo].[MyTableName] .....". So question is, should I have [dbo]. as part of my Create Table T-SQL commands? Can I remove "[dbo]."? Who would be the owner of the database? If I can remove the [dbo]., should I also remove dbo. from any query string from within my code?
Hi,
I am having trouble really understanding what makes a model accurate and effective at predicting some attribute. I can't seem to find any clear documentation about the mining legend of the lift chart on the Mining Accuracy Chart tab when working with the Data Mining Structure designer in VS 2005. Specifically, I would like to know more about what numbers in the Score, Population Correct and Predict Probability columns mean, and why they change when you move the vertical gray bar on the Lift Chart. Also, what is generally a good score to be aiming for, provided that it is highly difficult to get 100% accuracy with the kind of data that I am using.
Any more information on this subject is much appreciated. Thank you for your time,
Chris Burns
I am trying to develop a report that will show a 100% stacked bar graph for many teachers. Each teacher will have there own graph. The series in the report are the percent of scores given on a test, with each test in a group. Scores are given on a scale of 1-4. Most of the time a teacher will have all fours scores in there data; however it is possible to only have 2 or 3 of the scores. How can I set the legend up so that all scores across all the graphs show the same color for the same data series? Right now I get something like this.
First Graph
4: Lime
3: Purple
2: Blue
1: Green
Second Graph (no values for 1 or 2)
4: Blue
3: Green
I need the second graph to be
4: Lime
3: Purple
I have a Pie Chart report that works well until Users discovered that when values are 0% or less across the chart, the Legend returns NaN. How do I format the Legend to return 0% instead of the NaN that Users do not want to see. Below is my express for the Legend Property="#AXISLABEL" & " - " & "#PERCENT{P0}".
View 5 Replies View RelatedAfter days of trying to deploy my web application along with the ASPNETDB database I am convinced this is actually just an attempt on the part of the MSFT developers to drive us nuts.
It simply will not work. As reported by everyone in all of the forums, it works fine in development but does not work when deployed. If I move my data to a full SQL Server instance and modify all of my connection strings accordingly, it works fine, as well. It just does not work when I publish the app and try to run it using the AttachDBFilename methodology. I am convinced that only Santa Claus or an honest lawyer can make it work.
Let's recap the steps: first, I create the folder that I want to use for production and give Modify permissions on that folder to <machine>ASPNET and NETWORK SERVICE. Then I open up IIS Administrator and create a new virtual directory that points to that folder and set its permissions to include Write. I check the ASP.NET tab and it's set for 2.0. Now I switch back to VS2005 and publish my web application directly to the target folder.
Feeling optimistic, I go right to IE and bring up the site. Looks good until I attempt to login. That's when I get the first error - Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.
From there I start through the forums and try every one of the solutions proposed, even though none of them specifically identify this error wording. I know I should have used the wording from the Exception "Details" - except they state exactly the same thing - what was I thinking? I thought the .NET developers did away with the error message authors from the old days but it looks like they're back with a vengence.
Somewhere along the way I am able to get past that first error. Unfortunately, I've made so many changes I don't know which combination actually worked. But it doesn't matter because now the database is refusing to let <machine>ASPNET login! Okay, so I use SSME and create a login attach the database and create a user (none of which is supposed to be required for UserInstance=true). Detach the database and try IE again. You guessed it - still won't work. Now it can't generate the user instance because a database by that name already exists, or the user doesn't have permissions, or it's Friday and the machine wants to leave early - I give up.
So, at this point, I'm pretty much finished with SQLExpress for anything other than my development environment.
Is there anyway in SSRS 2008 to sort the Legend on a chart? Right now I am unsure as to how it is currently sorting. I see a property to Reverse the order, but I don't see anything to alphabetize it.
View 8 Replies View RelatedI was trying to write a custom legend text for a chart that I have in SSRS. In the chart I have a Bar chart and a Line chart. I have two values coming from a dataset. One is a running value. All the series values are from year dataset.
I need to get a custom legend text for the three data series looking like this. "2013- Mth", "2014-Mth". Year should be dynamic and coming from the dataset.
I tried writing an expression in the series legend option as shown below.
But I don't get the required text for the chart. I only get the default series text for the legend. If I only write a text without the dynamic year taken from the dataset columns I get the custom text. But not when I concatenate the dynamic year series with the static text. Any property to enable/disable?
Is it possible to remove the tick marks that I have circled in red?The chart has data Week by week over a year, and the T1, T2 etc are equivalent to Quarter1, Quarter 2 etcI've got a 3 level grouping, with the top level being Year, then Quarter, then Week. The label for the "Week" grouping is set to blank, and that's why you don't see it here.Removing the Tick marks would make the chart legend more readable in my opinion.
View 2 Replies View RelatedHi,
I have just run a simple data set through a model to predict a simple true or false value (i.e. binary output)
The Lift Chart/Mining Legend in Analysis Services shows three results €“ Score, Population Correct (%), and Predict Probability (%)
Population Correct I beleive is the percentage of predictions it got right out of the total number of predictions it tried to make. Is this correct?
However, I can€™t work out how the other two are derived in particular the 'SCORE'. To give a live example the scores were as follows:
Model Score Pop Correct Pred Probability
Decision Trees 0.83 76.59% 54.28%
Neural Network 0.75 67.63% 50.05%
Ideal Model 100.00%
Can anyone help with this and give a detailed explanation?
Many thanks,
S Rajput
Hello 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
I 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
I 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
Hi 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
Hi 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
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
Is 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.
Hi folks.
Here i have small problem in transactions.I don't know how it is happaning.
Up to my knowldge if you start a transaction in side the transaction if you have DML statements
Those statements only will be effected by rollback or commit but in MS SQL SERVER 7.0 and 6.5
It is rolling back all the commands including DDL witch it shouldn't please let me know on that
If any one can help this please tell me ...........Please............
For Example
begin transaction t1
create table t1
drop table t2
then execute bellow statements
select * from t1
this query gives you table with out data
select * from t2
you will recieve an error that there is no object
but if you rollback
T1 willn't be there in the database
droped table t2 will come back please explain how it can happand.....................
Email Address:
myself@ramkistuff.8m.com
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
Hi,
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
I've created a job using SQL DMO (in VB6) but it fails to run. When try to manual start the job from the Enterprise Manager, it gives error "cannot start job because it does not have any job server(s) defined."
Here is the code :
Dim oSQLServer As New SQLDMO.SQLServer
Dim oJobServer As New SQLDMO.JobServer
Dim oJob As New SQLDMO.Job
Dim oJobSch As New SQLDMO.JobSchedule
Dim oJobStep As SQLDMO.JobStep
oSQLServer.Connect "mc", "sa", ""
oJob.Name = "JOB_Backup"
oSQLServer.JobServer.Jobs.Add oJob
Set oJobStep = New SQLDMO.JobStep
With oJobStep
.Name = "Step 1"
.StepID = 1
.DatabaseName = "master"
.SubSystem = "TSQL"
.Command = "BACKUP DATABASE [medco] TO DISK = 'E:Projectmedco.BAK' With INIT"
.OnFailAction = SQLDMOJobStepAction_QuitWithFailure
.OnSuccessAction = SQLDMOJobStepAction_QuitWithSuccess
End With
oJob.JobSteps.Add oJobStep
oJob.StartStepID = 1
'Set the schedule.
With oJobSch
.Name = "Schedule 1"
.Schedule.FrequencyType = SQLDMOFreq_Daily
.Schedule.FrequencyInterval = 1
.Schedule.ActiveStartDate = "20010315"
.Schedule.ActiveStartTimeOfDay = "150800"
.Schedule.ActiveEndDate = SQLDMO_NOENDDATE
.Schedule.ActiveEndTimeOfDay = SQLDMO_NOENDTIME
End With
oJob.JobSchedules.Add oJobSch
oSQLServer.DisConnect
Set oJobStep = Nothing
Set oJobSch = Nothing
Set oJob = Nothing
Set oSQLServer = Nothing
Something is missing but ?
Thanks for all your helps in advance,
Ben