Gauge Controls for Reporting Services 2005

Dear Anyone,

Does anyone know where I can get gauge controls ans sorts that can be used in RS2005?

Thanks,

Joseph

See Dundas Software or Panorama

http://www.dundas.com/home/index.aspx
http://www.panorama.com|||Actually, Dundas Gauge is not available yet for Reporting Services. The only Custom Report Items I know of are chart and barcode. I expect that Dundas will release gauge for SSRS sometime in 2006.|||

DUNDAS Gauge for Reporting Services with RS2005. The product is almost complete and is schedule for Beta in 2 weeks and ready for official release in the beginning of March

is hte news I got from them

|||

Joseph,

Dundas Gauge for Reporting Services is now in beta.

To signup, go to http://www.dundas.com/betas or visit http://www.dundasreporting.com for more info.

Cheers

Ed Worsfold
Dundas
edw@.dundas.com

Gauge Controls for Reporting Services 2005

Dear Anyone,

Does anyone know where I can get gauge controls ans sorts that can be used in RS2005?

Thanks,

Joseph

See Dundas Software or Panorama

http://www.dundas.com/home/index.aspx
http://www.panorama.com|||Actually, Dundas Gauge is not available yet for Reporting Services. The only Custom Report Items I know of are chart and barcode. I expect that Dundas will release gauge for SSRS sometime in 2006.|||

DUNDAS Gauge for Reporting Services with RS2005. The product is almost complete and is schedule for Beta in 2 weeks and ready for official release in the beginning of March

is hte news I got from them

|||

Joseph,

Dundas Gauge for Reporting Services is now in beta.

To signup, go to http://www.dundas.com/betas or visit http://www.dundasreporting.com for more info.

Cheers

Ed Worsfold
Dundas
edw@.dundas.com

Gauge Controls for Reporting Services 2005

Dear Anyone,

Does anyone know where I can get gauge controls ans sorts that can be used in RS2005?

Thanks,

Joseph

See Dundas Software or Panorama

http://www.dundas.com/home/index.aspx
http://www.panorama.com|||Actually, Dundas Gauge is not available yet for Reporting Services. The only Custom Report Items I know of are chart and barcode. I expect that Dundas will release gauge for SSRS sometime in 2006.|||

DUNDAS Gauge for Reporting Services with RS2005. The product is almost complete and is schedule for Beta in 2 weeks and ready for official release in the beginning of March

is hte news I got from them

|||

Joseph,

Dundas Gauge for Reporting Services is now in beta.

To signup, go to http://www.dundas.com/betas or visit http://www.dundasreporting.com for more info.

Cheers

Ed Worsfold
Dundas
edw@.dundas.com

Gauge Controls for Reporting Services 2005

Dear Anyone,

Does anyone know where I can get gauge controls ans sorts that can be used in RS2005?

Thanks,

Joseph

See Dundas Software or Panorama

http://www.dundas.com/home/index.aspx
http://www.panorama.com|||Actually, Dundas Gauge is not available yet for Reporting Services. The only Custom Report Items I know of are chart and barcode. I expect that Dundas will release gauge for SSRS sometime in 2006.|||

DUNDAS Gauge for Reporting Services with RS2005. The product is almost complete and is schedule for Beta in 2 weeks and ready for official release in the beginning of March

is hte news I got from them

|||

Joseph,

Dundas Gauge for Reporting Services is now in beta.

To signup, go to http://www.dundas.com/betas or visit http://www.dundasreporting.com for more info.

Cheers

Ed Worsfold
Dundas
edw@.dundas.com

sql

Gathering requirements for SQL Reporting Services

Hello,
I am assigned the task of gathering requirements from business users
for implementing reports using SQL Server Reporting Services. Some of
the questions I have in mind are:
1. What is the purpose of the report?
2. How many users would be using it?
3. Where is the data coming from?
4. What delivery method is required?
5. What is the layout of the report?
What other information would I need before jumping into setting up the
framework and developing the reports?In addition to your list. you can find out.
1. Complexity (like calculated fileds, charts etc) of the reports
2. Whether the reports are to be shown seperate or should be a part of the
program (This question is for Report viewer)
3. The setup of the hardware servers ( this question is for checking the
performance)
4. Licensing issue should be in your checklist as well.
Amarnath
"sandeshmeda@.gmail.com" wrote:
> Hello,
> I am assigned the task of gathering requirements from business users
> for implementing reports using SQL Server Reporting Services. Some of
> the questions I have in mind are:
> 1. What is the purpose of the report?
> 2. How many users would be using it?
> 3. Where is the data coming from?
> 4. What delivery method is required?
> 5. What is the layout of the report?
> What other information would I need before jumping into setting up the
> framework and developing the reports?
>sql

Garbage appearing when displaying Oracle character fields

Hi,
I am having troubles with character fields being displayed as garbage characters in Reporting Services. I have a shared data source defined as "Oracle" not "OLE DB" going against an Oracle 9i database. When I run a query in the Wizard Query Builder (which I hear uses the OLE DB connection to Oracle) the characters display correctly without any garbage characters. When I run the query in the Generic Query Builder (which I hear uses the Oracle data processing extension) the character fields display with garbage in them. Also, when I view the data in the data layout under the Preview tab, I get the garbage characters. The garbage characters appear on the second or following rows, in which the prior row had the same value in that field. The fields can either be defined as varchar2 or char in Oracle of more than 1 character in length. varchar2(1) and char(1) data types seem to display correctly without the garbage. The problem also shows up when I deploy the report to the ReportServer and view it in the ReportManager.
Does anyone have any ideas?
Thanks!
MelindaI found out that our issue was that we were using the Oracle 8.1.5 client to connect to an Oracle 9i database. This was causing garbage characters to appear in our reports. Once I upgraded to use the Oracle 9.1 client, it worked as expected. I did some digging and found a small line in the documentation that suggests the minimum client is Oracle 8.1.7 or later.
"Melinda" wrote:
> Hi,
> I am having troubles with character fields being displayed as garbage characters in Reporting Services. I have a shared data source defined as "Oracle" not "OLE DB" going against an Oracle 9i database. When I run a query in the Wizard Query Builder (which I hear uses the OLE DB connection to Oracle) the characters display correctly without any garbage characters. When I run the query in the Generic Query Builder (which I hear uses the Oracle data processing extension) the character fields display with garbage in them. Also, when I view the data in the data layout under the Preview tab, I get the garbage characters. The garbage characters appear on the second or following rows, in which the prior row had the same value in that field. The fields can either be defined as varchar2 or char in Oracle of more than 1 character in length. varchar2(1) and char(1) data types seem to display correctly without the garbage. The problem also shows up when I deploy the report to the ReportServer and view it in the ReportManager.
> Does anyone have any ideas?
> Thanks!
> Melinda

Gantt chart in SQL reporting service

Hi all,

I need creat a gannt chart for project server report in SQL reporting service. Is somebody know some good third party tool can help to implement or how to creat by hand?

Thanks in advance!

I use Dundas Chart for Reporting Services and can thoroughly recommend it and it supports Gannt Charts

|||Thanks Jasper! But Dundas chart is a little bit expensive solution for us. It supports SQL 2000 reporting service?|||I downloaded the Dundas Chart for Reporting Services and try to create a Gantt chart. I found it's very difficult to do, as there're many settings on it. Is there any tutorial provided? Thanks!

Gantt chart in SQL reporting service

Hi all,

I need creat a gannt chart for project server report in SQL reporting service. Is somebody know some good third party tool can help to implement or how to creat by hand?

Thanks in advance!

I use Dundas Chart for Reporting Services and can thoroughly recommend it and it supports Gannt Charts

|||Thanks Jasper! But Dundas chart is a little bit expensive solution for us. It supports SQL 2000 reporting service?|||I downloaded the Dundas Chart for Reporting Services and try to create a Gantt chart. I found it's very difficult to do, as there're many settings on it. Is there any tutorial provided? Thanks!

Gant with reporting services

Hi all,
I need to display a Gant with phases and their starting and ending
data...how can I do it? Is it possible?
Thank you.very difficult but possible.
Amarnath
"Tatopitta" wrote:
> Hi all,
> I need to display a Gant with phases and their starting and ending
> data...how can I do it? Is it possible?
> Thank you.|||Can you give me more detail? Should I rapresent my dates like datetime or
with numbers? If datetime, I cannot manage date inferior to the minimum...if
number I cannot show on the axis the date values...
"Amarnath" wrote:
> very difficult but possible.
> Amarnath
> "Tatopitta" wrote:
> > Hi all,
> > I need to display a Gant with phases and their starting and ending
> > data...how can I do it? Is it possible?
> >
> > Thank you.

Galactic Data Model

I am trying to do the examples using SQL Server 2005 Reporting Services (2006) by Brian Larson.

The example says to use GDS as the data source yet all I see is Adventure Works.

The tables for AW are not the same as the tables for GDS.

Is there something I need to do or does the DBA need to install something else.

Have you installed the Galactic database yet from the downloaded source code for the book? If not, run the 'Create Galactic Database.sql' script in the 'Galactic Database Install' folder. At the bottom of the script is the userid and password:

exec sp_addlogin N'GalacticReporting', N'gds', @.logindb, @.loginlang

In order to set up the data source, you must use this userid and password (unless you change it to something more convenient). See if that works for you and hollar if it doesn't.

FYI: SQL Reporting Services download is available!

http://www.microsoft.com/sql/reporting/productinfo/trial.asp
If you have a SQL 2000 license, you can use the software. I don't work for
Microsoft, but I am excited enough to see this that I wanted to send out the
link. I have been waiting a long time to move beyond the limits of
Infomaker or crystal reports to something that is more integrated with SQL.
It has pdf output capabilities btw. I am going to start trying this out
immediately, I suggest DBAs check this out.
--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
*******************************************************************Just wanted to pass this along from my first attempt.
Note from the Readme file, I found you need VB .NET 2003 for the Report
designer.
Before you install the product, check for a file called authz.dll in
c:\winnt\system32. It'll hold up the install for the Reporting Services
server part if it is missing. It is a file that comes either from
contacting MS support for the file in Q320211 or from another Win 2k machine
that was upgraded from a previous service pack to SP 4 instead of SP 4
directly.
You know there always has to be prerequisites <g>
--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
*******************************************************************

FYI: SQL Reporting Services download is available!

http://www.microsoft.com/sql/report...tinfo/trial.asp
If you have a SQL 2000 license, you can use the software. I don't work for
Microsoft, but I am excited enough to see this that I wanted to send out the
link. I have been waiting a long time to move beyond the limits of
Infomaker or crystal reports to something that is more integrated with SQL.
It has pdf output capabilities btw. I am going to start trying this out
immediately, I suggest DBAs check this out.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************Just wanted to pass this along from my first attempt.
Note from the Readme file, I found you need VB .NET 2003 for the Report
designer.
Before you install the product, check for a file called authz.dll in
c:\winnt\system32. It'll hold up the install for the Reporting Services
server part if it is missing. It is a file that comes either from
contacting MS support for the file in Q320211 or from another Win 2k machine
that was upgraded from a previous service pack to SP 4 instead of SP 4
directly.
You know there always has to be prerequisites <g>
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************

Funny Results from using Surface Area Configuration for Features

Hi,
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
Chris
Worse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>
|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>

Funny Results from using Surface Area Configuration for Features

Hi,
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
ChrisWorse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>sql

Funny Results from using Surface Area Configuration for Features

Hi,
I am using a Windows account that is a local admin on the server yet when I
use Surface Area Configuration for features I only see Reporting Services
and Integration Services. I understand that this feature is using WMI but
what would stop me from seeing the actual Database Engine components?
Thanks
ChrisWorse still I can only see those 2 services when I use the Configuration
Manager/SQL Server 2005 Services. Some how I have lost the ability to see
all the services. I would have to believe that this is a permissions
problem?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I am using a Windows account that is a local admin on the server yet when
> I use Surface Area Configuration for features I only see Reporting
> Services and Integration Services. I understand that this feature is using
> WMI but what would stop me from seeing the actual Database Engine
> components?
> Thanks
> Chris
>|||Could this have happened because a different person, using a different
Windows Account, used Microsoft Update to update the server? Has some
permissions been changed to the other account?
Thanks
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OG618d2iHHA.1884@.TK2MSFTNGP06.phx.gbl...
> Worse still I can only see those 2 services when I use the Configuration
> Manager/SQL Server 2005 Services. Some how I have lost the ability to see
> all the services. I would have to believe that this is a permissions
> problem?
> Thanks
> Chris
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:uKkwuy1iHHA.3452@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I am using a Windows account that is a local admin on the server yet when
>> I use Surface Area Configuration for features I only see Reporting
>> Services and Integration Services. I understand that this feature is
>> using WMI but what would stop me from seeing the actual Database Engine
>> components?
>> Thanks
>> Chris
>

Funky Problem with Invisible Chart

So, I'm pretty new to Reporting Services and this is my first post in this forum. So basically I was creating a report which contains a chart. I configure the dataset, chart values, etc and the chart shows up blank. The title of the chart shows, but nothing else shows. The way I created the report in the designer is no different that another report that actually works.

I've searched google with every word I could think of and I haven't been able to find this issue anywhere. Is this some crazy Microsoft hiccup?

Here is the Stored Procedure that I am using as my dataset:

CREATE PROCEDURE YearlyTotalsInPercentages(@.Yearint) ASBEGINDECLARE @.TotalSumintSELECT SUM(dbo.Main.Hours) AS CBDCYearlyTotals, dbo.Project.ProductLine AS ProductLineINTO #tempTotalsFROM dbo.Main INNER JOIN dbo.Department ON dbo.Main.DeptNo = dbo.Department.DeptNo INNER JOIN dbo.Project ON dbo.Main.ProjectNo = dbo.Project.ProjectNoWHERE dbo.Main.UserID LIKE'CI%' AND dbo.Project.ControlLocation ='IND' AND DATEPART(yyyy, dbo.Main.DataDate) = @.Year AND dbo.Main.Active = 1GROUP BY dbo.Project.ProductLine SET @.TotalSum = (SELECT SUM(dbo.Main.Hours)FROM dbo.Main INNER JOIN dbo.Department ON dbo.Main.DeptNo = dbo.Department.DeptNo INNER JOIN dbo.Project ON dbo.Main.ProjectNo = dbo.Project.ProjectNoWHERE dbo.Main.UserID LIKE'CI%' AND dbo.Project.ControlLocation ='IND' AND DATEPART(yyyy, dbo.Main.DataDate) = @.Year AND dbo.Main.Active = 1) SELECT t.CBDCYearlyTotals AS CBDCYearlyTotals, t.ProductLine AS ProductLine, ROUND((t.CBDCYearlyTotals/@.TotalSum) * 100, 1) AS Percentage FROM #tempTotals tENDGO

I can present the rdl if necessary.

Muchos Gracias

So, in doing deeper searching I found another forum that said temp tables may not be supported and that table variables should be used instead. So, I'm attempting that route, but running into problems with the query when it comes to dividing by @.TotalSum. It returns 0 now and not the number that I had gotten previously.

Just one road block after the other. Ah, the joys of programming.

Anybody got any clues as to why this would happen?

Function like canGrow() in Crystal Reports for Columns

Hai All,
I have to know is there any Function in SQL Reporting Services ascanGrow() Funciton in Crystal Reports for Columns.
If my data is exceeding the Column Width.how can i accomadate in the Column without go the next line in the columns.
Please enlighten me.
Thanx,
Karthik.AIf you right click on the field you'll see some options at the bottom of the pop-up window that will enable the data to either increase and/or decrease contents.
Hope that helps.|||

ya correct,
But it makes either increase or decrease the Height of the Column.
What i need ,is to increase the Width.

Thanx,
Karthik.A

Function for "yesterday"

Can anyone help with the function for reporting the day before current date? I'm using Crystal 10. Being new to Crystal I can't seem to get the formula to work that I have. I want the report that I have built to display the day before's data. Thanks very much in advance!!DateAdd ('d',-1 ,CurrentDate )|||The database field that I pull the date from is the {Trips.tdate}, therefor it would be this?

{Trips.tdate} dateadd('d',-1 ,CurrentDate )|||Just go to REPORT -> SELECT EXPERT and in that write:

{Trips.tdate} = dateadd('d',-1 ,CurrentDate )|||I am getting an error stating "a string is required". It follows the =|||in trips, tdate is string|||This is what I have
{Trips.tdate} = dateadd('d',-1 ,CurrentDate )

I get a "number amount, currency amount, boolean or sting is expected here" Here being between the = and dateadd

I know now why I became a paramedic!|||You are comparing a string (which happens to look like a date to you) with a date.
In the field explorer, right click, show field type to check - should say string.
Convert your trips.tdate string to a date.
Alternatively, make sure you store dates as dates, not strings :)

So something like:
CDate({trip.tdate}) = dateadd('d',-1 ,CurrentDate )

To avoid having to do this throughout a report (if you use trip.tdate a lot) you can create a formula to return the string as a date and use the formula instead of the database field.
Still better to store it properly in the first place though!|||You are correct in the fact it is a string. I have no way of changing how the software captures the date. I pasted the following

CDate({trip.tdate}) = dateadd('d',-1 ,CurrentDate )

It now tells me that trip.tdate is an unknown field.|||You weren't supposed to blindly copy my typo! It's Trips (with an 'S') not trip.|||I got it, I got it!!!! Thanks everyone!!!!!!|||Thanks JaganEllis!