Changing Chart Types With Parameters
Jan 11, 2005Can I change the chart type with the value supplied in the Report Parameters ? Other than chart types everything else have expression field attached to them.
Please Help !
Viraj
Can I change the chart type with the value supplied in the Report Parameters ? Other than chart types everything else have expression field attached to them.
Please Help !
Viraj
Hi,
I have seen on the internet that there are more chart types availlable then used by reporting services.
I have seen some pretty charts in exel 2007.
Are there possibilities to use such charts in RS.
I have also seen that you can purchase charts from special dev houses (like dundas).
So i think i must be able to create my own library with charts.
Any idea how i can do this ?
Vincent
Hi,
I am trying to create a graph that consists of a bar chart and line graph - both to appear on the same graph.
They will show different information, but will essentially come from the same dataset.
So far I have not been able to achieve this and it would seem that you cannot mix chart types. This is very disappointing given the plaudits associated with this product.
Can anyone restore my faith in this product by telling me that the above is possible and, if so, how do I go about it.
Thanks very much.
Lee.
How do I go from a text data type to a numeric data type without having to delete the column and put it back out there. I tried to changed the data type but it gave me a error saying that I couldn't go from text to int data type. Help.
View 4 Replies View RelatedHi All,I have a varchar(255) column for storing text in english and inhebrew.It was a stupid mistake to set the data type to be varchar, becausenow I need to store text in german and francais too.Question: Is it safe to change the data type from varchar to nvarchar,without damaging the data that's already present?(I have more than 1000000 records stored...)Thanks,Danny
View 4 Replies View Relatedhi all
i am using bar chart in my reports , i want to show the intervel on my y axis like
0k,2k,4k,6k,.......
but it is showing like 0,2000,4000,6000 .... by default . i dont know hoe to achieve this please help.
How can I change a field type whilst it is populated?
I have tried :
insert new_table
select *
from old_table
but I get :
Disallowed implicit conversion from datatype 'text' to datatype 'varchar'
Table: 'davy.dbo.new_table', Column: 'de_area'
Use the CONVERT function to run this query.
My table formats are as follows :
TABLE dbo.new_table (
de_pk int NOT NULL ,
de_name char (25) NOT NULL ,
de_area char(255) NULL
)
TABLE dbo.new_table (
de_pk int NOT NULL ,
de_name char (25) NOT NULL ,
de_area text(16) NULL
)
i changed a float data type to a decimal and have lost accurate details, is there a way of rolling back to what it was before
View 1 Replies View RelatedIs there a way to change the physical mapping of a user defined data type to the physical SQL Server datatype. It seems that once you create them, it is just about impossible to change it.
Thanks,
Andrew Abrams
Greetings once again SQL friends,
Sorry to bug you with my silly questions but this little problem has been driving me crazy for the last hour or so!
I am attempting to change the data type of a variable in an expression but I keep getting an error saying that the expression can not be evaluated.
The syntax I am using is as follows :
(dt_str) @[User::MAX_OFFER_PRICE_ID]
My variable MAX_OFFER_PRICE_ID is type int32 and I am attempting to cast it as a string.
What am I doing wrong?!
Thanks for your help in advance.
Hi there.
"This is a simple problem, so do not be discouraged by the amount of text ahead. I wrote so much because I thought this needed to be explained as well as possible, even though it's simple."
I have two (almost) same sets of tables on two servers, call them Source and Destination.
What needs to be done is that the data in the tables on Source has to be transferred to the same (corresponding) tables on Destination. The unfortunate thing is that in some of the tables on Source some columns are Unicode and in the corresponding tables on Destination the same columns are non-Unicode. Since the data kept in the tables is always ASCII there is no need to have a distinction.
Remark: No, I can't delete the Destination tables and recreate them with the Unicode settings.
Now, I know there is a task that can convert between encodings. But 1. there are MANY tables, 2. there are MANY columns in them and 3. I do not know which columns are Unicode and which are not. I would have to examine all the tables which would take A LOT OF time.
A question arises: Is it possible to write a script component that would take a row, examine the columns for SSIS data types (not VB.NET types) and change the piece of data's type in the colum from Unicode to non-Unicode? I am not sure I've stated this properly but hopefully you get the idea.
If you think this is impossible, please give me an alternative solution (if able), excluding - of course - the conversion task.
Thank you very much.
Darek
I have a chart that presently has two groupings on the x-axis: Year & Qtr. I'd like the Year labels to be one color, and the Qtr labels to be a different color. (All year labels should be Black, all Qtr labels should be Blue). I can see that an expression can be written to handle this dynamically, but I'm banging my head trying to figure it out...
Any help?
Thanks in advance,
Pete
We have a database that originally had all objects owned by a vendor id. We are in the process of changing the ownership to 'dbo' and wish to remove the vendor id but have found there are a few user defined datatypes that are also owned by this vendor id. How can I change the ownership of them to 'dbo'? They are currently being used in some of the tables. I tried the sp_changeobjectowner but that doesn't work for these.
thanks for any advice!
Hi
I created a report based on category,time and stores as report parameters.The datasets are created by using mdx queries and the provider I selected is olap services.I would like to add a bar chart in the layout and the resultant chart should be based on the selected parameters.I am not able to get this.First of all is it possible? If so, what should I do in the chart properties?
Regards
Ranjit
I have one report "Incident Summary" which has a Report Parameter called DimPoolPool using ParameterValue for Value Field and ParameterCaptionIndented for Label field. The default value is [Dim Pool].[Pool].[All]
From another chart report I want to be able to click on a column to make open the Incident Summary report parameterized by "Pool". So I got to properties of the chart > Data > Values > Edit > Action > Jump to report > Parameter, and here I enter DimPoolPool = Fields!Pool.Value.
It seems to me that this should be picking up [Dim Pool].[Pool].&[poolname] and entering that into the parameters of Incident Summary report. However instead the Incident Summary opens with blank parameter waiting for user to enter.
How do you format parameters correctly between reports?
I'm a relative newcomer to Power View. I've been playing with charts and have been struggling to combine both line and bar on the same chart. It would appear this functionality is not available. Considering this is basic functionality when it comes to charting, how to achieve this....
View 3 Replies View Related
Hi, all experts here,
Thank you very much for your kind attention.
I am having a question about how can I put a chart and a table in a same page of my report? And let the same parameters passed between them? Is it possible in SQL server 2005 Reporting Services? Please would any experts here shed me any light on it?
Thank you very much in advance and I am looking forward to hearing from you.
With best regards,
Yours sincerely,
I am producing a report in Report Builder 2 containing a chart and table. Â The user is able to select single or multiple choices on a parameter called Specialty. Â My present chart is only suitable when one Specialty is selected. Â Therefore I only want this to be visible when the user has selected one Specialty. Â I am planning to create a second chart which is suitable for than more than one selection. So if the user selects more than one Specialty the existing chart will not be visible and instead will be replaced by the second.I think this should be done using Chart Properties>Visibility but cannot develop the logic of the expression.
View 5 Replies View RelatedHey Guys,
I have two parameters on a report, which are independent of one another, yet when I change one, the current report refreshes, and I'm left with a blank screen. What is causing the refresh behavior on this report? It appears as though it is treating them as cascading parameters, but I don€™t use one to filter the other. Since the report has default values, when first navigating to the report, it displays just fine. I would like the user to be able to change the first parameter without the report refreshing to a blank screen. Once it refreshes, they can click on the €œView Report€? button and see the report, but I would like for the current report to stay there, which is the case on my other reports, until they click the button. Any ideas?
Thanks - Dan
I'm new to SQL Server....running SQL Server 2000. Had to move the system database logs to a different drive. Used EM, Server properties, Startup parameters. Changed the transaction log designation. Closed that window. Stopped the server.
Server won't start as I messed up and did not include the file name in the new designated path....just down to directory level.
From what I've seen, I have to be able to start the server service to change the parameters and the server won't start.
Is there a file that contains these parameters I may edit or should I try using the command line options.
Many thanks in advance.
Hi All
Can I change the name of a report depends on the parameters selected by end user?
Can you give me a similar expression?
Thanks
I have an source file and i have to load it into the data base by changing datatype of the columns in ssis
View 1 Replies View RelatedI have a stored proc which will be fed a value that is compared to a char value for a selection. One of the choices might be 'all' for which I want to return all records. Something like this
create procedure name @location char(40)
as select ----------------
where locname like @location
I tried using LIKE COALESCE but no luck. Any ideas
Thanks
I think it has been discussed previously that having default parameter values based on expressions, e.g. a default parameter value of =Split("Bug",",") in multiple parameters will cause a postbacl whenever a user selects different values from the list.
Is this by design? Its a bit of an annoying thing. The refreshpostback doesnt happen if you have basic defaults like ="All" but only when an expression of some sort is used in more than 1 parameter. Does RS think they are linked or something, why does it need to psotback
efresh?
I'm looking for ways to enable business users to change algorithm parameters in a "high-level way" with the UI presenting some domain-specific blurb and sliders. Is it possible to create a Visual Studio package or add-in for Business Intelligence Development Studio that can change algorithm parameters? Can the Visual Studio SDK or Shell be used for that? Is documentation available?
Also, is the Business Intelligence Development Studio changing with SQL Server 2008 and Visual Studio 2008?
Okay, this one might stump you guys.
View 3 Replies View RelatedI have a report I want to modify and when I go to deploy it I get:
Changing the report parameters or data sources to the values you specified is not allowed. The report is configured to run unattended. Using the specified values would prevent the unattended processing of this report
Now I understand the error, it is because on the report server's web management interface I entered credentials for the report to run that point to a custom datasource and supplied the appropriate credentials to run the report.
However, I don't want to have to reconfigure that just to deploy a slightly modified version of the report.
How can I get around this? Or what is the proper work around? I just want to change the background color from dark gray to light gray on a header column....
Thanks!
Hello All,
I have a reporting services report in the form of a chart. I have two datafields on the chart.
I need to be able to dynamically hide one datafield and view the chart for the other one and vice versa.
How do I do this ?
Any help would be appreciated..
Thanks!
When I export the report in excel format the chart is displayed as picture. I want it to be displayed as editable chart.Does Office Writer work in this situation and did anyone use Office Writer to accomplish same type of problem.Is there any other method or product we can use instead of the office writer.
View 2 Replies View RelatedI have a report designed in SSRS 2008 R2.My issue is that the data labels do not stay outside the bars for high values.
View 4 Replies View RelatedSQL Server 2000, ASP.Net 1.1
I've been writing this stuff for a while, and can't seem to come to the
conclusion of how I should be retrieving data and assigning this data
to variables.
Since i'm using SQL Server, I'm convinced that I should be using the
datareaders GetSqlDouble (or whatever) function, but this would mean i
need my local variables to be one of the SQL types. The problem
with that is, that there will have to be lots of conversions done by me
to be able to use a SQL type in my application.
For instance, I have a class where i'm retrieving dates. In order
to retrieve them correctly (Null values included), I need to retrieve
them with GetSqlDateTime(), then when it comes time to display the date
in a table, i must first check for nulls, then convert to a
string. This seems to be very cumbersome. Would I be better
off just using GetDateTime(), and the .ToString method, and ignoring
Sql Types all together?
so, basically, how are you guys using your sql server data? with
the supplied sql types, and doing all of the post-processing work
manually? I feel like i'm having trouble conveying my
issue...hopefully someone knows what i mean....i'd just like some
direction to save trouble in the long run, since i feel like there's
got to be a better way...
Confused!
Thanks,
JJ
I need to create a chart with the following features
1) Bar chart that has data for 3 years (3 series)
2) Line chart that has the same data as per the above points on the bar chart but this is a running total. (3 series)
3) These data points are for the 12 months
4) there should be a secondary axis for the cumulative one
Can I create this using the same data set?
Hi Guys..
i don't know weather is it possible or not..but Can any One tell's me How can i refresh the Chart Values.. acutally what's happening..
i have two Chart in a reprot .. One is Main Category and other one is SubCategory... acutally what i want.. in Main Category chart sum of Quantities of Subcategory values comes in bar or any other format.. and when i click on Main chart any bar it's refresh the other chart and return the result of subcategory under that main category in details...
i don't know is this possible .. acutally i m very new in reproting.. infact that's my first report.. so i want to do this.. if any article or any help anyone can provide me..
Thanks