Check remotely if Reporting Services exist

is there a way to check the reporting services remotely.. using the reporting services url?

What do you actually Mean by checking reporting Services remotely? What is your requirement?|||

i want to check if a remote server has an existing reporting service or runs a reporting service...

|||You can check using

http://servername/reportserver

or

http://servername/reports

|||

yeah... but how can i check it programatically?|||Can you specify the scenario where you need this checking.May be I can help you|||

im trying to make an application that can connect to multiple report server... i need to get all the available report server within the network then connect to that report service...

|||

hii

Is this the thing you mean to say i mean you want to see your reporting serverices ?

if this the thing u wanted then you can go for the following path.

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServe

cheers

regards

Mahasweta

|||May be this will help you

Check the link

http://msdn2.microsoft.com/en-us/library/aa226200(SQL.80).aspx

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Management;

using System.IO;

[assembly: CLSCompliant(true)]

namespace TGest

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

const string WmiNamespace = @."\\localhost\root\Microsoft\SqlServer\ReportServer\v9\Admin";

const string WmiRSClass =

@."\\localhost\root\Microsoft\SqlServer\ReportServer\v9\admin:MSReportServer_ConfigurationSetting";

ManagementClass serverClass;

ManagementScope scope;

scope = new ManagementScope(WmiNamespace);

// Connect to the Reporting Services namespace.

scope.Connect();

// Create the server class.

serverClass = new ManagementClass(WmiRSClass);

// Connect to the management object.

serverClass.Get();

if (serverClass == null)

throw new Exception("No class found");

// Loop through the instances of the server class.

ManagementObjectCollection instances = serverClass.GetInstances();

foreach (ManagementObject instance in instances)

{

MessageBox.Show("Instance Detected");

}

}

}

}

|||

thanks man! i got all the reporting services instance in my local my machine... but im trying to access a remote workstation and get all the report server instance in there... but im getting an error "{"Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))"}". i've already use a default authentication level(Windows authentication). here's my code..

Code Snippet

try

{

const string WmiNamespace = @."\\bserver\root\Microsoft\SqlServer\ReportServer\v9\Admin";

const string WmiRSClass =

@."\\bserver\root\Microsoft\SqlServer\ReportServer\v9\admin:MSReportServer_ConfigurationSetting";

ManagementClass serverClass;

ManagementScope scope;

ConnectionOptions options;

options = new ConnectionOptions();

options.Authentication = AuthenticationLevel.Default;

scope = new ManagementScope(WmiNamespace,options);

// Connect to the Reporting Services namespace.

scope.Connect();

// Create the server class.

serverClass = new ManagementClass(WmiRSClass);

// Connect to the management object.

serverClass.Get();

if (serverClass == null)

throw new Exception("No class found");

// Loop through the instances of the server class.

ManagementObjectCollection instances = serverClass.GetInstances();

foreach (ManagementObject instance in instances)

{

Console.Out.WriteLine("Instance Detected");

PropertyDataCollection instProps = instance.Properties;

foreach (PropertyData prop in instProps)

{

string name = prop.Name;

object val = prop.Value;

Console.Out.Write("Property Name: " + name);

if (val != null)

Console.Out.WriteLine(" Value: " + val.ToString());

else

Console.Out.WriteLine(" Value: <null>");

}

}

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

thanks!!

Check Box in reprting services

Hi!
I don't know how to have check box in reporting services.Hi Shima,
This is the round about solution that we had worked on.
First, your query should return the following values for True as 'x' and for
false as 'o' (for ex., i have an gender field in my db wherein I have set
that field as bit. Now in my query, I have it
case when gender=1 then 'x' else 'o' end) as Gender
Now in your report, after you pull this field onto the report layout, change
the font to "wingdings" and this should solve your problem.
Regards,
Sudhakara.T.P.
"shima.seifolahi@.gmail.com" wrote:
> Hi!
> I don't know how to have check box in reporting services.
>|||On Oct 18, 2:49 pm, Sudhakara.T.P.
<Sudhakar...@.discussions.microsoft.com> wrote:
> Hi Shima,
> This is the round about solution that we had worked on.
> First, your query should return the following values for True as 'x' and for
> false as 'o' (for ex., i have an gender field in my db wherein I have set
> that field as bit. Now in my query, I have it
> case when gender=1 then 'x' else 'o' end) as Gender
> Now in your report, after you pull this field onto the report layout, change
> the font to "wingdings" and this should solve your problem.
> Regards,
> Sudhakara.T.P.
>
> "shima.seifol...@.gmail.com" wrote:
> > Hi!
> > I don't know how to have check box in reporting services.- Hide quoted text -
> - Show quoted text -
Hi!
my problem isn't it,becuse i want to have check box in run time ,for
example i want to select two or three names of employers in first
report then i want to show names of their emploeeys in the second
report (i want to show these informations of these employers together,
not one by one ) and i need to have check box in first report ,thses
two reports have relation via navigation , till now i haven't have
any solution for it .
But I hope!

Cheapest way to purchase SQL Reporting Services

Within my department we have 1 copy of of vb studio.net standard and 2 copies
of vb studio.net enterprise and run sql server 2000.
One of the guys is writing a system which I have to report on using SQL
Reporting Services. As I don't have any .net product, do I have to purchase a
.net product to then get a development edition of SQL Reporting Services to
write any reports etc.
Looking for the cheapest way to be able to use SQL Reporting Services as I
work in the NHS (lucky me).
Any help will be much appreciated.
Thanks, MarkYour SQL license gives you RS. All you need to develop report is a copy of
VS. The cheapest way to aquire it is VB.net standard.
=?Utf-8?B?bWFya19tZW56aWVz?= <mark_menzies@.discussions.microsoft.com>
wrote in news:DC6ABF54-CFC9-417F-A898-1DB7FCB21549@.microsoft.com:
> Within my department we have 1 copy of of vb studio.net standard and 2
> copies of vb studio.net enterprise and run sql server 2000.
> One of the guys is writing a system which I have to report on using
> SQL Reporting Services. As I don't have any .net product, do I have to
> purchase a .net product to then get a development edition of SQL
> Reporting Services to write any reports etc.
> Looking for the cheapest way to be able to use SQL Reporting Services
> as I work in the NHS (lucky me).
> Any help will be much appreciated.
> Thanks, Mark
>|||Also, RS 2005 comes with a version of VS so no extra purchase is required.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Asher_N" <compguy666@.hotmail.com> wrote in message
news:Xns970F5808B7AFDcompguy666hotmailcom@.207.46.248.16...
> Your SQL license gives you RS. All you need to develop report is a copy of
> VS. The cheapest way to aquire it is VB.net standard.
> =?Utf-8?B?bWFya19tZW56aWVz?= <mark_menzies@.discussions.microsoft.com>
> wrote in news:DC6ABF54-CFC9-417F-A898-1DB7FCB21549@.microsoft.com:
>> Within my department we have 1 copy of of vb studio.net standard and 2
>> copies of vb studio.net enterprise and run sql server 2000.
>> One of the guys is writing a system which I have to report on using
>> SQL Reporting Services. As I don't have any .net product, do I have to
>> purchase a .net product to then get a development edition of SQL
>> Reporting Services to write any reports etc.
>> Looking for the cheapest way to be able to use SQL Reporting Services
>> as I work in the NHS (lucky me).
>> Any help will be much appreciated.
>> Thanks, Mark
>>
>

charts in Reporting Services

hey there

Happy New Year to you all.

in RS 2005

in layout tab

I have four columns in my table

col 1 (group on Company)

col 2 (group on application)

col 3 (count on id no) // total field (count/idno) // max/idno)

col 4 (graph) as I want this to show line by line (visual statement)

I read you need to put that max field in to help with graph. in the Y axis Max field

Unfortunately I either didn't read it properly or I am doing something really wrong.

My graph is not showing correctly - eg one line has 2 in it and is showing more than a line that has 227.

call id is in data of the graph

company name is in series of the graph

can someone explain what I am doing wrong please

thanks

jewel

Anyone able to help here would like to see examples of people using these graphs!

Can someone help with some examples they are using?

Is someone using these without writing extra code etc?

cheers

Charts in Reporting Services

Hi,
I have a report with a chart. The chart is a simple line
chart. Each line in the chart is represented as a
different color. In the absence of a color printer, I
need to change lines to be represented differently. In
other words, one line as a dashed, one as a solid, one as
a dot-dash.
Is this possible to make it do this?
Thanks,
DonUsing the Chart Properties dialog navigate to the Data tab.
From there you can set the Appearance for each Value.
In particular you will want to set the Border and Line properties using the
Series Style options
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Don R." <reinhard@.stjosephs-marshfield.org> wrote in message
news:9fa401c486f8$3741ff60$a501280a@.phx.gbl...
> Hi,
> I have a report with a chart. The chart is a simple line
> chart. Each line in the chart is represented as a
> different color. In the absence of a color printer, I
> need to change lines to be represented differently. In
> other words, one line as a dashed, one as a solid, one as
> a dot-dash.
> Is this possible to make it do this?
> Thanks,
> Don|||Bruce,
Thanks.
I tried this and the property settings were applied to
all "Series". How do I make each "Series" have a
different line type (one solid, one dashed one dots )?
Don
>--Original Message--
>Using the Chart Properties dialog navigate to the Data
tab.
>From there you can set the Appearance for each Value.
>In particular you will want to set the Border and Line
properties using the
>Series Style options
>--
>Bruce Johnson [MSFT]
>Microsoft SQL Server Reporting Services
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"Don R." <reinhard@.stjosephs-marshfield.org> wrote in
message
>news:9fa401c486f8$3741ff60$a501280a@.phx.gbl...
>> Hi,
>> I have a report with a chart. The chart is a simple
line
>> chart. Each line in the chart is represented as a
>> different color. In the absence of a color printer, I
>> need to change lines to be represented differently. In
>> other words, one line as a dashed, one as a solid, one
as
>> a dot-dash.
>> Is this possible to make it do this?
>> Thanks,
>> Don
>
>.
>

Charts for Reporting Services

I'm having problem with Charts
any good website or books i can read up on
just can't anything good on charts
I need to use 2 pie chart and 1 bar chart but i can't get it to work like i wanted to

I'm not sure what Series and Category is used and how to stack the fields in the Charts

For a standard bar chart, the Category is what goes on the X axis (i.e. might be the month, or product, or whatever). Using the Series will group the bars, a typical grouping might be by year.

These three links (especially the last one) may be of some assistance:

http://msdn2.microsoft.com/en-us/library/ms156306.aspx

http://msdn2.microsoft.com/en-us/library/ms155847.aspx

http://msdn2.microsoft.com/en-us/library/aa964128.aspx

Charts - too much data - possible to break up into 2 charts

If the user is reporting on a lot of information then the line chart/graph
in the report contains too much data and the X-Axis labels just look like
one big blob because all of the item labels are squeezed together too
tightly.
Has anyone found a way to say for example... If there are more than X number
of items on the X Axis in the chart then to split the chart into 2 charts.
The second chart would appear directly beneath the 1st chart. This way the
user would be able to telll what the data is they are looking at.
This seems to be a common problem in all charting situations and the
solution usually is just filtering on less data. I don't see why we have to
tell the user to filter on less data and run multiple reports. It seems
possible that en enterprise reporting application like RS should have this
capability... or... the capability to code it in the report.
Any ideas?There is no perfect solution for this. Some ideas:
* You could use filters and multiple charts and use conditional visibility
to hide unneeded charts
* Group the data and use drillthrough reports with charts showing the
details per group
* If you use a bar chart visualization instead of line chart, you could use
a table with groupings. In the group header you would add a chart. The more
data you have in the dataset, the more groups you get and the more chart
bars are drawn. A sample for this approach is copied to the bottom of this
posting.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"D Witherspoon" <dwitherspoon@.noway.org> wrote in message
news:elaCN4ivFHA.2008@.TK2MSFTNGP10.phx.gbl...
> If the user is reporting on a lot of information then the line chart/graph
> in the report contains too much data and the X-Axis labels just look like
> one big blob because all of the item labels are squeezed together too
> tightly.
> Has anyone found a way to say for example... If there are more than X
> number of items on the X Axis in the chart then to split the chart into 2
> charts. The second chart would appear directly beneath the 1st chart.
> This way the user would be able to telll what the data is they are looking
> at.
> This seems to be a common problem in all charting situations and the
> solution usually is just filtering on less data. I don't see why we have
> to tell the user to filter on less data and run multiple reports. It
> seems possible that en enterprise reporting application like RS should
> have this capability... or... the capability to code it in the report.
>
> Any ideas?
====
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table2">
<Height>0.75in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Product Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>0-200</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<DataSetName>Northwind</DataSetName>
<Top>0.125in</Top>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.5in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="ProductName_2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>ProductName_2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!ProductName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Chart Name="chart1">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitsInStock.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Marker />
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitsOnOrder.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Marker />
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title />
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<Min>0</Min>
</Axis>
</CategoryAxis>
<DataSetName>Northwind</DataSetName>
<PointWidth>0</PointWidth>
<Type>Bar</Type>
<Title />
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>Units In Stock</Label>
</StaticMember>
<StaticMember>
<Label>Units On Order</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<Subtype>Stacked</Subtype>
<PlotArea>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Max>200</Max>
<Margin>true</Margin>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table2_Group1">
<GroupExpressions>
<GroupExpression>=Fields!ProductName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<TableColumns>
<TableColumn>
<Width>1.33333in</Width>
</TableColumn>
<TableColumn>
<Width>3.5in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>1.25in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>99dae70f-00e4-4971-a2f6-486f3896814a</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=(local);initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>4.83333in</Width>
<DataSets>
<DataSet Name="Northwind">
<Fields>
<Field Name="ProductID">
<DataField>ProductID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ProductName">
<DataField>ProductName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="SupplierID">
<DataField>SupplierID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="CategoryID">
<DataField>CategoryID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="QuantityPerUnit">
<DataField>QuantityPerUnit</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="UnitPrice">
<DataField>UnitPrice</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="UnitsInStock">
<DataField>UnitsInStock</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="UnitsOnOrder">
<DataField>UnitsOnOrder</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="ReorderLevel">
<DataField>ReorderLevel</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="Discontinued">
<DataField>Discontinued</DataField>
<rd:TypeName>System.Boolean</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>select * from products</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<PageHeight>100in</PageHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>9ecf615a-64ce-4ec1-98bf-05333c406eb6</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>

Charts

Hi, I have a quick question about charts in SQL reporting services...

Is it possible to have a page through chart, meaning that an user can page through multiple pages of the same chart?

No, this is not built in to RS. You may be able to simulate this functionality using drill-throughs, where the user clicks on a link that opens the same report with a different set parameters that result in a new chart.

For more information:
Working with Parameters in Reporting Services

Charts

Hi, I have a quick question about charts in SQL reporting services...

Is it possible to have a page through chart, meaning that an user can page through multiple pages of the same chart?

No, this is not built in to RS. You may be able to simulate this functionality using drill-throughs, where the user clicks on a link that opens the same report with a different set parameters that result in a new chart.

For more information:
Working with Parameters in Reporting Services

charts

I've created a stacked bar chart using reporting services. I'm
building the chart from 20 records that include amounts, years, ect.
The problem is whenever there are two amounts that are the same the
chart only shows one of the amounts. I tried to find out if there was
a property that was hiding duplicates with no luck.
thanksYou need to create a group for the chart that will identify the unique
records.
Andy Potter

Charts

Is it possible to have charting in SQL Server REporting services, where when
a mouse points to a point on the graph, it displays the value of the point?Sorry, this is not supported. The closest you can get is to either use data
point labels which are always visible, or use drillthrough actions on chart
datapoints.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"TerminatorIII" <TerminatorIII@.discussions.microsoft.com> wrote in message
news:6015BBDE-C7F5-4A04-8F3D-F65B417F932C@.microsoft.com...
> Is it possible to have charting in SQL Server REporting services, where
> when
> a mouse points to a point on the graph, it displays the value of the
> point?

chart x-axis y-axis

I'm trying to convert an old chart to Reporting Services.
We have used the same dataset for years, it is very very simple. But it seems to me that Reporting Services can't deal with this simple dataset.

My question is: How can I get create a line chart using this dataset.

The data set consists of 1 row with 96 columns (a day divided into 96 sets of 15 minutes). Each column records how many events occurs within the 15 minutes. Along the x axis I would like to display a vertical line every 4 hours. The y axis should be numbered 0 to the highest value in the results.

I could not make this dataset any more simple than it is. But Reporting Services just chokes on this.

Here is a sample of the dataset :
1 2 0 4 5 6 7 8 9 10... 96It looks as thought what I may need is to reset the dataset to look like this:
time events
00-14 1
15-29 2
30-44 0
...

The only way I could do that with the existing tables would be 96 unions.

96 Unions!
Microsoft I must say that I am not so impressed with reporting services. Dragging fields to a myesterous chart "category" or "series" was dumb to begin with.

Chart Types

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

Depending on the effort you will have to put in such a component to create your own charts, I would recommend using charts such as those from Dundas for Reporting Services, because they are very experienced in building those components (even the basic ones that ship with RS are made by Dundas)

Jens K. Suessmeyer

http://www.sqlserver2005.de

Chart Question...

Hi,
I'm trying to create a line graph/chart in reporting services. I have 2
stored procedures that outputs the count of 2 tables that created 2
datasets.
Both these procedures use a field called acctdates. I'm trying to use
the acctdates as the catagory field and the 2 counts in the data field. But
I keep receiving an error saying I can't use a field from another dataset
for the current dataset. Is there a way around this problem? or is there a
different way I should approach it?
Please help....
Thank you,
RickyYou may want to consider joining the two datasets inside a stored procedure.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ricky" <kmeas1@.gmail.com> wrote in message
news:Ow0xdjVNFHA.2372@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm trying to create a line graph/chart in reporting services. I have
> 2 stored procedures that outputs the count of 2 tables that created 2
> datasets.
> Both these procedures use a field called acctdates. I'm trying to
> use the acctdates as the catagory field and the 2 counts in the data
> field. But I keep receiving an error saying I can't use a field from
> another dataset for the current dataset. Is there a way around this
> problem? or is there a different way I should approach it?
> Please help....
>
> Thank you,
> Ricky
>

Chart in Reporting Services

hey all

I am using RS 2005

I have a report with chart

parameters = value1, value2, value3, all

How can I make the chart only show when all is selected?

cheers

jewel

Hi,

The chart component has a Visibility property.

In this property you can use an expression which checks the value of the parameter.
For example: when setting the Visibility.Hidden property to

=IIF(Parameters!MyParameter.Value = "All", false, true)

The chart will only be displayed when the value of the MyParameter is All.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

thanks for your answer Geert but

when I add that line I get this error

[rsParameterReference] The Hidden expression for the 'chart1' refers to a non-existing report parameter 'MyParameter'.

I also tried with 'Select All' which is the actual wording of my parameter but still get the same message.

These values are specified in the available values - non queried part of the report parameters.

not sure what I am missing here?

thanks

jewel

|||

The MyParameter refers to a report parameter. This was just an example. You need to change the name of to one of your report parameters.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

sorry about that Geert

Must be a slow reaction to being back at work after a break. Absolutely right!

cheers for this

jewel

Chart i blurring in IE

Hi,
I created a chart through the reporting services. The chart is very clear if
I preview it throguh the Report Designer. However, it is very blurring when I
view the report through the Report Manager or Internet Explorer.
Any ideas about this problem?
Thanks,
DavidAre just the fonts in the chart "blurring" when shown in IE? If that is the
case, then most likely, the report server machine has "ClearType" turned on
(Control Panel - Display - Appearance - Effects). Does turning ClearType off
improve it?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"David" <wei.liu@.powerinfonet.com> wrote in message
news:CB3F80F8-1630-4C36-8C67-1745E888B51A@.microsoft.com...
> Hi,
> I created a chart through the reporting services. The chart is very clear
> if
> I preview it throguh the Report Designer. However, it is very blurring
> when I
> view the report through the Report Manager or Internet Explorer.
> Any ideas about this problem?
> Thanks,
> David|||Hi, Robert:
Thank you very much for your information. I tried ClearType and it does not
work in my case. I am using URL to access the report. If I set the
HTMLFragment to true, I get a much better quality chart report.
I have another question. Right now I have multiple reports in one HTML page.
Therefore, each report has its own horizontal frame. Is it possible to set
all reports have one horizontal frame?
Thank you for your kind help,
Best regards,
Favid
"Robert Bruckner [MSFT]" wrote:
> Are just the fonts in the chart "blurring" when shown in IE? If that is the
> case, then most likely, the report server machine has "ClearType" turned on
> (Control Panel - Display - Appearance - Effects). Does turning ClearType off
> improve it?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "David" <wei.liu@.powerinfonet.com> wrote in message
> news:CB3F80F8-1630-4C36-8C67-1745E888B51A@.microsoft.com...
> > Hi,
> >
> > I created a chart through the reporting services. The chart is very clear
> > if
> > I preview it throguh the Report Designer. However, it is very blurring
> > when I
> > view the report through the Report Manager or Internet Explorer.
> >
> > Any ideas about this problem?
> >
> > Thanks,
> >
> > David
>
>

Chart FX for reporting services

Just saw this:
http://www.softwarefx.com/sfxSqlProducts/cfxReportingServices/
anyone try it yet?
Can you use the maps on Chart FX for this?No, but I've used Dundas, I'd be interested in comparing notes. My
understanding is the third party charts implement a different set of
interfaces than the default chart. A couple drawbacks, the dundas chart
wasn't easy to swap, the xml was a completely different structure. The
image quality of the text isn't that great, and a few other items that I
think would be specific to Dundas.
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:OlcdpoVSGHA.4300@.TK2MSFTNGP14.phx.gbl...
> Just saw this:
> http://www.softwarefx.com/sfxSqlProducts/cfxReportingServices/
> anyone try it yet?
> Can you use the maps on Chart FX for this?
>|||There is definately a difference in quality from the native chart to
those based on the custom report item interfaces due to rendering
limitations of the interface. This is will remain common amongst any
Reporting Services control vendor until Microsoft provides a rendering
context to the controls and allows a render to a format other than an
image.
Microsoft has based their native chart on our core chart code but the
difference between their implementation and ours (aside from our
features are much more deep) is that they render with context and do
processing at different times of execution. When our RS chart renders,
we have to do it all in one shot.
When the native chart renders they adjust according to where they are
rendering. For example, when they render to the printer, they will
generate a chart image as an emf file and scale to the device later in
execution. If pdf, they render to a image that is actually resized to
a huge image, they then scale the fonts, and adjust other chart
elements through a complex transformation (this is how they do it in
SQL2005 as they did it differently in SQL2000).
Today, we have released Dundas Chart for Reporting Services v1.5 and
Dundas Gauge for Reporting Services v1.0. In this release of our
chart, aside from bug fixes and new features, we have made significant
changes in our rendering to improve the quality of the text. These
changes provide you much improved printing / pdf rendering, however,
they are not a full solution and unfortunately one will not be
available the next SQL Server release in 2007. In the meantime, Dundas
Software will continue to work closely with the SQL Server team to
ensure the quality improves to what you would demand.
Andrew Bryan
Dundas Software

Chart error: Parameter is not valid

Hi,
I'm using Reporting Services 2005, trying to design a report in Visual
Studio 2005.
I have a chart in the report that seems to work just fine when I test it
with Preview.
However, every now and then, if I change some trivial detail in the chart
properties, such as the title font, the chart suddenly won't render in design
mode, instead displaying the following error: "Parameter is not valid."
Does anyone have any idea what might be causing this?I sometimes get the same error in charts but they are still working in
preview.
It´s really strange...
"Rolf Smeds" <Rolf Smeds@.discussions.microsoft.com> escribió en el mensaje
news:8BE6B851-1C4A-4CEC-8943-28F1F703F362@.microsoft.com...
> Hi,
> I'm using Reporting Services 2005, trying to design a report in Visual
> Studio 2005.
> I have a chart in the report that seems to work just fine when I test it
> with Preview.
> However, every now and then, if I change some trivial detail in the chart
> properties, such as the title font, the chart suddenly won't render in
> design
> mode, instead displaying the following error: "Parameter is not valid."
> Does anyone have any idea what might be causing this?

Chart does not show up untill cookies allowed

We have web server with web application on one server and SQL Server with
Reporting Services on another. We try to implement reporting on internet, but
for some reason charts in reports not displayed untill cookies from Reporting
Services server (not web server) on client side are not enabled.
Does anubody has solution or ideas?
ThanksI found the solution. The value for UseSessionCookies was "true", I changed
it to "false" (in Configuration table).

Chart data from custom assembly method?

Hi!
I'm new to reporting services and have a question for you.
I've managed to get a single value from a custom assembly method and publish
it on a report,
what I want to do now is to fill a chart with data from my custom assembly
method, the data
is returned like a dataset.
Displaying a single value was no big deal, found a lot of examples on the
net and in this forum, but
setting the custom dataset as source is very hard to find.
Regards,
Peter Larsson!Isn't this possible, anyone?
/P
"Peter Larsson" <peterskola@.frillesas.nospam> wrote in message
news:eAHDhuahHHA.1624@.TK2MSFTNGP06.phx.gbl...
> Hi!
> I'm new to reporting services and have a question for you.
> I've managed to get a single value from a custom assembly method and
> publish it on a report,
> what I want to do now is to fill a chart with data from my custom assembly
> method, the data
> is returned like a dataset.
> Displaying a single value was no big deal, found a lot of examples on the
> net and in this forum, but
> setting the custom dataset as source is very hard to find.
> Regards,
> Peter Larsson!
>
>