Reporting Services

MSDNSYS.COM

Tag: SQL Server Reporting Services, SQL Server / Home

Reporting Services RSS

NAVIGATION

Zero values on a line chart

am using a line chart to display series of results over time - data is got from and AnalysisServices cube.problem is that sometimes there is no value for the result - and the chart doesnt display that as zeroe.g. with the following dataweek 1 10 itemsweek 2 12 itemsweek 3 14 items week 4 8 ...

1 answers | 597 bytes |

YTD Calculation when using SSAS as data source

I have a cube that tracks sales by sales rep. In this cube, I have dimensions for SalesRep, Product, and Region hierarchies. I also have a Time dimension that provides Fiscal Year, Fiscal Quarter, Fiscal Month, and Calendar Date; the Time dimension also has an attribute showing the first day of ...

1 answers | 864 bytes |

YTD again

I have a YTD calculated member that works fine in the AS2005 browser. However, when I try to used YTD along with a Month parameter in my report, the YTD picks up the month YTD not the total YTD for all months.How do I display both monthly and YTD sales?TIA....

2 answers | 278 bytes |

You are not authorized to view this page

I cannot access the SRSserver/reports page and get a 401 error, no matter what credentials I supply when prompted.This is a 2005 SRS install, with a distributed model - the database is located on a separate server. The account I am using is an admin on both servers (and in SQL).I've tried ...

1 answers | 781 bytes |

You are not authorized to view this page

Our Reporting Services was working finei think maybe the secuity update messed our server now we can't see out reporting default websitewe messed around with the IIS and we were able toget to show the home pages of the reporting serviceswhen we click on the report it gets "not authorized ...

7 answers | 956 bytes |

You are not authorized to view this page

Our Reporting Services was working finei think maybe the secuity update messed our servernow we can't see out reporting default websitewe messed around with the IIS and we were able toget to show the home pages of the reporting serviceswhen we click on the report it gets "not authorized ...

6 answers | 952 bytes |

Yet another "Cannot create a connection to data source" error

I am experiencing the same problem that many, many other people have experienced. The dreaded An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'TradingDb'. (rsErrorOpeningConnection) For more information about this error ...

1 answers | 1960 bytes |

yesterday statement

Hi,I am trying to substract one day from my current date and are having difficulties any suggestions?=IIF(Fields!DOCDATE.Value = today-1 and Fields!SOPTYPE.Value =3,Fields!XTNDPRCE.Value,IIF(Fields!DOCDATE.Value = today-1 and Fields!SOPTYPE.Value ...

2 answers | 509 bytes |

Yearly, monthly... basis report based on the parameter values

Hi guys,I am created a bar chart report. The x-axis value of this chart is a timestamp(datetime) field of a dimension. Thousands of records are inserted in to this field everyday, as a result, I will have the timestamp information every second or minute. So here is the thing, If I want to ...

9 answers | 679 bytes |

Year on year comparison chart

I'd like to be able to produce a chart of, let's say, stock level (y axis) by date (x axis) for 2004 (series 1) and the same for 2005 (series 2). However, I just don't know how to do it. I guess I need to overlay one chart with another or something but just can't think my way around the ...

3 answers | 571 bytes |

Y-AXIS BUG - POINT PLOTTED INCORRECTLY

I am working on a project that uses Reporting Services Bar & Line charts. We have found in certain circumstances, when the y-axis interval is 0.2, the line or bar plotted is 0.2 less than it should be (according to the underlying data values fed in). Our charts use auto-scaling. We have ...

0 answers | 1059 bytes |

Y axis labels, major gridline

I have a horizontal barchart with integer values, both positive and negative. Major gridlines are shown and I have not specified the interval or the label format. Sometimes the gridline labels (Y axis) show decimal values. Is there anyway to format these? I have tried to format the labels as ...

2 answers | 539 bytes |

Y axis gridlines scaling problem

Hi there,I have several diagrams with percentages at the y-axis. The minimum is now, depending on the data, at around 40 %, but it should actually start at 0. I've already tried to set the minimum of the scale in the properties to 0 but then all major and minor gridlines are gone and can't b...

1 answers | 519 bytes |

XSLT Transform to text results in extra whitespace

All my reports that are getting transformed to text via XSLT has extra whitespace at the end of the report. Checked the file in hex mode and all that whitespace is hex code 00. On some reports, this whitepsace is 12 MB of a 32 MB report.It would be nice to get this fixed so we do not have ...

1 answers | 575 bytes |

xslt filters on xml output. cdata-section-elements and omit-xml-declaration problems.

Hi All,I'm using some xslt documents to transform the xml output of my Reportsbut have come across two curiosities where the xslt filter seems tobehave unusually.Firstly, I need the final saved file to have an xml declaration, whichI believe it should do by default. Even if I ...

4 answers | 2188 bytes |

QUESTION ON "SQL Server Reporting Services"

MSDN DEVELOPMENT

Home - About Us - Contact - Privacy Statement - Link Exchange - Bookmark - Map.XML - Rss.Xml
2.734