Check if cube exists

How can I check whether a cube exists and make the control flow dependend on that?
Thanks for help!!

By using AMO in a script task

HTH
Ovidiu

|||Could you give me a small example?
There is only little information available in the SQL Server help.
The help for AMO shows me, there should be aMicrosoft.AnalysisServices Namespace. However, when I open the Script designer, it know nothing about this namespace. I can't even find this namespace on msn.
|||Note: I found the Microsoft.AnalysisServices.dll, but how can I reference this assembly in SSIS?
|||I finally found the "References" node in the object explorer (seems kind of stupid I didn't saw it..)

Check if cube exists

How can I check whether a cube exists and make the control flow dependend on that?
Thanks for help!!

By using AMO in a script task

HTH
Ovidiu

|||Could you give me a small example?
There is only little information available in the SQL Server help.
The help for AMO shows me, there should be aMicrosoft.AnalysisServices Namespace. However, when I open the Script designer, it know nothing about this namespace. I can't even find this namespace on msn.
|||Note: I found the Microsoft.AnalysisServices.dll, but how can I reference this assembly in SSIS?
|||I finally found the "References" node in the object explorer (seems kind of stupid I didn't saw it..)

check constraint or rule for control characters

I'm trying to control the accidental entry of special characters (carriage
return) from getting into my data. I thought I could write a check
constraint like what follows
[name] <> '%' + char(13) + '%'
but this doesn't work. Tried several permutations but the carriage return
is always accepted when I enter the data through an access database table
view (control + enter).
If I can get the expression working I think the best way to implement would
be either a user defined datatype or a rule bound to the column.
Has anyone done this sort of thing, or know how?
Thanks
David LHow about
CharIndex(Char(13), [Name], 1) = 0
Or
[Name] Not Like '%' + Char(13) + '%'
Thomas
"DavinciCoder" <dal@.rlpi.com> wrote in message
news:uqpvUvuaFHA.2664@.TK2MSFTNGP15.phx.gbl...
> I'm trying to control the accidental entry of special characters (carriage
> return) from getting into my data. I thought I could write a check constr
aint
> like what follows
> [name] <> '%' + char(13) + '%'
> but this doesn't work. Tried several permutations but the carriage return
is
> always accepted when I enter the data through an access database table vie
w
> (control + enter).
> If I can get the expression working I think the best way to implement woul
d be
> either a user defined datatype or a rule bound to the column.
> Has anyone done this sort of thing, or know how?
> Thanks
>
> --
> David L
>|||Ok, the second works great thanks
"Thomas Coleman" <replyingroup@.anywhere.com> wrote in message
news:eh1KX0uaFHA.1152@.tk2msftngp13.phx.gbl...
> How about
> CharIndex(Char(13), [Name], 1) = 0
> Or
> [Name] Not Like '%' + Char(13) + '%'
>
> Thomas
>
> "DavinciCoder" <dal@.rlpi.com> wrote in message
> news:uqpvUvuaFHA.2664@.TK2MSFTNGP15.phx.gbl...
>|||David
You may want to check CHAR(10) as well.
"DavinciCoder" <dal@.rlpi.com> wrote in message
news:%23X6if6uaFHA.2884@.tk2msftngp13.phx.gbl...
> Ok, the second works great thanks
>
> "Thomas Coleman" <replyingroup@.anywhere.com> wrote in message
> news:eh1KX0uaFHA.1152@.tk2msftngp13.phx.gbl...
>

Charts displayed in tables

Is it possible to have a Chart control within a table. I am trying to create
a report which displays some information about a School and has a bar chart
to display the pupil age ranges for each school.Add a grouping to the table, where you group e.g. by Fields!SchoolName.Value
Then, enlarge the table group header and drop a chart in the table group
header (!). You can then design the chart.
At runtime, you will get one table group per school name with one chart per
table group header which should give you exactly what you want.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MicroMoth" <stephen.adams@.forvus.co.uk> wrote in message
news:D562F265-AC31-4935-A217-628819F863C6@.microsoft.com...
> Is it possible to have a Chart control within a table. I am trying to
create
> a report which displays some information about a School and has a bar
chart
> to display the pupil age ranges for each school.|||It is possible to have a table where a row "expands" to reveal a table.
Add a second detail row to the table, and a second grouping with the same
grouping expreassion as the main table grouping. Place a rectangle in the
second detail row. The rectangle automatically takes up the whole row, and
you are now free to place your chart (plus any other controls) anywhere in
the rectangle. Set the initial visibility of the second grouping to False,
and toggle it according to one of the fields in the first detail row. Works a
treat.
"MicroMoth" wrote:
> Is it possible to have a Chart control within a table. I am trying to create
> a report which displays some information about a School and has a bar chart
> to display the pupil age ranges for each school.

Charts and colour control

Hello,
I wonder if it is possible to have better control over the colours than just
selecting the palette?
My problem is that I have several charts showing the same data series in
different time periods. But for some reason the same series get different
colours in the different charts. The report would look much more appealing
if the colours were consistent.
Many thanks in advance.
Best regards,
Vemund HagaHi Venmund,
Thanks for your post.
From your descriptions, I understood that you would like to set the colors
in the report manually when those series to be the same. Have I understood
you? Correct me if I was wrong.
Based on my scope, unfortunately, I am afraid SQL Server 2000 Reporting
Services only supports palette color selection. Additional functionality in
this area is still under consideration
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||"Vemund Haga" wrote:
> Hello,
> I wonder if it is possible to have better control over the colours than just
> selecting the palette?
You can manually set the colour of each series in the graph properties. See
http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||Hi Glenn
I'm having this same problem and after reading some other related posts I
came to the following conclusion:
Although one can write an expression to control the colors in the Fill
property of the Series Style but this expression will have to be based on the
fixed number of possible values in the Series Groups. The expression can end
with "Transparent" value if non of the conditions in the expression are
satisfied but that is about it.
Is this correct?
Thanks
Shawn
"Glenn F. Henriksen" wrote:
> "Vemund Haga" wrote:
> > Hello,
> > I wonder if it is possible to have better control over the colours than just
> > selecting the palette?
> You can manually set the colour of each series in the graph properties. See
> http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||"Shawn Kralj" wrote:
> Although one can write an expression to control the colors in the Fill
> property of the Series Style but this expression will have to be based on the
> fixed number of possible values in the Series Groups. The expression can end
> with "Transparent" value if non of the conditions in the expression are
> satisfied but that is about it.
> Is this correct?
I'm sorry, but I'm not quite understanding what you are trying to do here.
Why don't you explain what you want to obtain instead, the desired effect.
--
Glenn F. Henriksen
http://www.henriksen.no/|||Hi Venmund,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. Have you read
the blog Glenn provided? We appreciate your patience and look forward to
hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Glenn
I have a Series Group in my report based on Sales Category field values.
There are 5 sales categories, and if I want to assign custom color to chart
bars for each category my expression will have to include a logical test and
assignment of custom color for each category.
I did get it to work but I want to make sure I'm doing it in the most
efficient way. I assigned a number to each category in my query (from 1 to 5)
and I can now use a Choose method to assign colors easily.
My expression is as follows:
=choose(First(Fields!SalesCategoryCode.Value, "chart1_SeriesGroup1"),
"Navy", "White", "Blue", "Yellow", "Black")
Is this the best way of doing it?
Thanks
Shawn
"Glenn F. Henriksen" wrote:
> "Shawn Kralj" wrote:
> > Although one can write an expression to control the colors in the Fill
> > property of the Series Style but this expression will have to be based on the
> > fixed number of possible values in the Series Groups. The expression can end
> > with "Transparent" value if non of the conditions in the expression are
> > satisfied but that is about it.
> >
> > Is this correct?
> I'm sorry, but I'm not quite understanding what you are trying to do here.
> Why don't you explain what you want to obtain instead, the desired effect.
> --
> Glenn F. Henriksen
> http://www.henriksen.no/|||Hi Genn
I have a series group in the report. I customized the color of each bar,
and it looks exactly like what i need in VS.net. After I depolyed to the
report server, however, it ignored the customized color and used default
color instead. Is there any way to solve the problem'
Thanks a lot.
Sean
"Glenn F. Henriksen" wrote:
> "Vemund Haga" wrote:
> > Hello,
> > I wonder if it is possible to have better control over the colours than just
> > selecting the palette?
> You can manually set the colour of each series in the graph properties. See
> http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||Are you sure you have SP1 installed on the report server (not only on the
report designer machine)?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:2DB7DF0D-419D-424C-A924-B61786518442@.microsoft.com...
> Hi Genn
> I have a series group in the report. I customized the color of each bar,
> and it looks exactly like what i need in VS.net. After I depolyed to the
> report server, however, it ignored the customized color and used default
> color instead. Is there any way to solve the problem'
> Thanks a lot.
> Sean
> "Glenn F. Henriksen" wrote:
> > "Vemund Haga" wrote:
> > > Hello,
> > > I wonder if it is possible to have better control over the colours
than just
> > > selecting the palette?
> >
> > You can manually set the colour of each series in the graph properties.
See
> >
http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.

Charts - width of columns

Is there a way to control the width of the columns that are produced when
using a column chart?Yes there is a way to control the width of columns and bars. The property is
called "PointWidth". However, the property is only supported on the report
server (and designer preview).
What you need to do is:
* open your RDL file in a text / xml-editor or in "code view" of designer
* search for the chart (<chart name="...">)
* add a PointWidth value between 0 and 100 (by default it is 55)
Example:
<Chart Name="Sales">
<PointWidth>30</PointWidth>
...
</Chart>
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsrdl/htm/rsp_ref_rdl_elements_fp_87lg.asp
Note: PointWidth is a constant value, so if you have an unknown number of
categories at runtime you might want to use two identical charts (one with
regular PointWidth, the other with a small PointWidth) and based on a
condition (number of categories) always hide one chart.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"PD" <PD@.discussions.microsoft.com> wrote in message
news:5C4C2447-15F9-4A7B-B4BE-2823EE08D73D@.microsoft.com...
> Is there a way to control the width of the columns that are produced when
> using a column chart?

chart control

I would like to set some of the properties in the chart control at run time
from the database. Is there a way to set the properties at execution time?Some of the chart properties are expressions (and therefore can be set
dynamically), while other properties are static and have to be defined at
design time.
Which properties do you want to control dynamically?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:6A3A681A-F516-48B7-BEF6-7F77F1C332EC@.microsoft.com...
>I would like to set some of the properties in the chart control at run time
> from the database. Is there a way to set the properties at execution
> time?|||I would like to set the Title and the type of chart.
"Robert Bruckner [MSFT]" wrote:
> Some of the chart properties are expressions (and therefore can be set
> dynamically), while other properties are static and have to be defined at
> design time.
> Which properties do you want to control dynamically?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bill" <Bill@.discussions.microsoft.com> wrote in message
> news:6A3A681A-F516-48B7-BEF6-7F77F1C332EC@.microsoft.com...
> >I would like to set some of the properties in the chart control at run time
> > from the database. Is there a way to set the properties at execution
> > time?
>
>|||The chart title can be an expression (although the dialog does not have an
explicit expression button).
The chart type has to be determined at design time.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:D79FC3FF-C13F-4001-A242-C19C440436F3@.microsoft.com...
>I would like to set the Title and the type of chart.
> "Robert Bruckner [MSFT]" wrote:
>> Some of the chart properties are expressions (and therefore can be set
>> dynamically), while other properties are static and have to be defined at
>> design time.
>> Which properties do you want to control dynamically?
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bill" <Bill@.discussions.microsoft.com> wrote in message
>> news:6A3A681A-F516-48B7-BEF6-7F77F1C332EC@.microsoft.com...
>> >I would like to set some of the properties in the chart control at run
>> >time
>> > from the database. Is there a way to set the properties at execution
>> > time?
>>|||> Regarding: The chart type has to be determined at design time.
BTW: You could have multiple charts defined in your report with different
chart types and dynamically hide all of them based on a report parameter
value (i.e. the select chart type) except for the one you want show. You
would set the Visibility.Hidden property on the charts based on the
parameter values.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23DkiTFk3FHA.700@.TK2MSFTNGP15.phx.gbl...
> The chart title can be an expression (although the dialog does not have an
> explicit expression button).
> The chart type has to be determined at design time.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Bill" <Bill@.discussions.microsoft.com> wrote in message
> news:D79FC3FF-C13F-4001-A242-C19C440436F3@.microsoft.com...
>>I would like to set the Title and the type of chart.
>> "Robert Bruckner [MSFT]" wrote:
>> Some of the chart properties are expressions (and therefore can be set
>> dynamically), while other properties are static and have to be defined
>> at
>> design time.
>> Which properties do you want to control dynamically?
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bill" <Bill@.discussions.microsoft.com> wrote in message
>> news:6A3A681A-F516-48B7-BEF6-7F77F1C332EC@.microsoft.com...
>> >I would like to set some of the properties in the chart control at run
>> >time
>> > from the database. Is there a way to set the properties at execution
>> > time?
>>
>

Chart color palate

Does anyone know a way to gain control of the color palate to the point of
picking your own colors and/or patterns? Also even using data driven colors?
ThanksLook at this link:
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
"mrmac" wrote:
> Does anyone know a way to gain control of the color palate to the point of
> picking your own colors and/or patterns? Also even using data driven colors?
> Thanks|||Thank you alot.

chart axis

Does anyone know how one can control/modify/overwrite standard X and Y axis
in chart control? I am even reconsidering rewriting the whole char component
since it is far from what is must look like.
Thanks,
--
Martin Kulov
http://www.codeattest.com/blogs/martin
MCAD Charter Member
MCSD.NET Early Achiever
MCSD> Does anyone know how one can control/modify/overwrite standard X and Y
> axis in chart control?
My problem is that when I have two data series the X axis is grouped with
values from both series and makes it unreadable. How can I create two
separate X axis that can read easily?
Thanks,
--
Martin Kulov
http://www.codeattest.com/blogs/martin
MCAD Charter Member
MCSD.NET Early Achiever
MCSD
"Martin Kulov" <kulov@.bezbokluk.abv.bg> wrote in message
news:e$K3zardFHA.1036@.tk2msftngp13.phx.gbl...
> Does anyone know how one can control/modify/overwrite standard X and Y
> axis in chart control? I am even reconsidering rewriting the whole char
> component since it is far from what is must look like.
> Thanks,
> --
> Martin Kulov
> http://www.codeattest.com/blogs/martin
> MCAD Charter Member
> MCSD.NET Early Achiever
> MCSD
>

char(13) function is not working

Hello everyone,
In SQL Server books online there is this following example:
B. Use CHAR to insert a control character
This example uses CHAR(13) to print name, address, and city information
on separate lines, when the results are returned in text.
USE Northwind
SELECT FirstName + ' ' + LastName, + CHAR(13) + Address,
+ CHAR(13) + City, + Region
FROM Employees
WHERE EmployeeID = 1
Here is the result set:
Nancy Davolio
507 - 20th Ave. E.
Apt. 2A
Seattle WA
But when you run the select statement above in query analyzer the output
does not match the output shown above. The char(13) does not work as a
carriage return. Any thoughts as to why? I am working on SQL 2000 sp3
on Windows 2000.
Thanks,
Raziq.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:eOg32A0lEHA.324@.TK2MSFTNGP11.phx.gbl...
> But when you run the select statement above in query analyzer the output
> does not match the output shown above. The char(13) does not work as a
> carriage return. Any thoughts as to why? I am working on SQL 2000 sp3
> on Windows 2000.
Do you have results set to text mode or grid mode? You need to use text
mode to see line breaks. Also, Windows uses CR-LF, which is CHAR(13) +
CHAR(10), some other systems use only CR or LF.

char(13) function is not working

Hello everyone,
In SQL Server books online there is this following example:
B. Use CHAR to insert a control character
This example uses CHAR(13) to print name, address, and city information
on separate lines, when the results are returned in text.
USE Northwind
SELECT FirstName + ' ' + LastName, + CHAR(13) + Address,
+ CHAR(13) + City, + Region
FROM Employees
WHERE EmployeeID = 1
Here is the result set:
Nancy Davolio
507 - 20th Ave. E.
Apt. 2A
Seattle WA
But when you run the select statement above in query analyzer the output
does not match the output shown above. The char(13) does not work as a
carriage return. Any thoughts as to why? I am working on SQL 2000 sp3
on Windows 2000.
Thanks,
Raziq.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:eOg32A0lEHA.324@.TK2MSFTNGP11.phx.gbl...
> But when you run the select statement above in query analyzer the output
> does not match the output shown above. The char(13) does not work as a
> carriage return. Any thoughts as to why? I am working on SQL 2000 sp3
> on Windows 2000.
Do you have results set to text mode or grid mode? You need to use text
mode to see line breaks. Also, Windows uses CR-LF, which is CHAR(13) +
CHAR(10), some other systems use only CR or LF.