• RELEVANCY SCORE 3.11

    DB:3.11:Ssrs 2005 Multiple Tables And Datasets s9




    Hello, I’m using SSRS 2005 and I’m looking to create one report having multiple tables with multiple dropdowns as options.
    The multiple tables will represent different queries and each should only display depending on the options picked from the dropdowns. Has anyone done anything like this or know of an example I can look at to get some ideas?

    DB:3.11:Ssrs 2005 Multiple Tables And Datasets s9

    Hi Unwind,
    Base on your scenario, you can create a parameter Dataset, and add the datasets name as the available values to the parameter.Then drag multiple tables controlto the design surface, one table display one dataset's data. And then set the tables
    visibility base on the parameter's value. Right-click table handleTablix PropertiesVisibility tab, here have some threads which is similar to yours, please see:
    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/39f60542-bef6-4949-8da9-4414c547f2a1/
    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/0a6d5134-20c2-4278-b13d-69335ed45b83/
    If you have any questions, please feel free to ask.
    Regards,Charlie Liao
    TechNet Community Support

  • RELEVANCY SCORE 3.07

    DB:3.07:Ssrs Report - Page Break After The Header When Export To Pdf 7j




    Hi,
    I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.
    I have grouped the report based on Invoice number, so that the invoices are printed sequentially and there will be page break after each invoice. Within each invoice there is a header, body and footer.
    My issue is after the header is printed, an automatic page break happens after the header, and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.
    I wish any one can solve this issue and grateful if they can give the solution for my problem.
    Thanks,
    Mahalingam

    DB:3.07:Ssrs Report - Page Break After The Header When Export To Pdf 7j

    Hi Mahalingam,
    Please check
    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/96845812-cb55-47c7-8835-8c8e862d886cto adjust report interactivesize to solve your issue.
    thanks,
    Jerry

  • RELEVANCY SCORE 3.07

    DB:3.07:Does Reportviewer 1.0 ( Vs 2005 ) Works Fine With Ssrs 2008 ? jf




    We Currently have SSRS 2005 and Reportviewer to display reports in our ASP.NET page. we are in process of migirating to SSRS 2008 .
    Based on our initial test we could not find any performance improvement in 2008 compared to 2005 .Our Asp.net application still uses Reportviewer 1.0 to display SSRS 2008 reports .
    My question are
    1) Does SSRS 2008 really improves performance ?
    2) Do i need to Reportviewer 2.0 for witnessing SSRS 2008 Performance improvement ?
    Cheers , Varun

    DB:3.07:Does Reportviewer 1.0 ( Vs 2005 ) Works Fine With Ssrs 2008 ? jf

    Hi varunragul,

    There is an article that describes breaking changes in Reporting Services, please see:

    http://technet.microsoft.com/en-us/library/ms143380(v=SQL.100).aspx

    The ReportViewer control in Visual Studio(VS) 2008 is similar to the VS 2005 SP1 ReportViewer control with additional bug fixes, wizards, and items like PDF compression.

    For more information about ReportViewer functionality in VS 2008, please refer to the blog below:

    http://blogs.msdn.com/b/bwelcker/archive/2007/11/26/younger-than-yesterday-reportviewer-in-vs-2008.aspx

    Thanks,
    Bin LongPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 3.07

    DB:3.07:Single Ssrs Report, Multiple Databases d7


    I have an inventory report built in SSRS 2005. The report is accessed by the end user via an ASP.NET inventory management website that runs the SSRS report via the SSRS SAOP API. I am deploying to a PRODUCTION environment where we have about 250 customer databases. The PRODUCTION databases are identical to the DEVELOPMENT database that the report was developed against. At runtime, when Customer A accesses our website and runs the report, it should display data from PROD Database A; when Customer B runs the report, it should display data from PROD Database B; and so on. How do I do this?Jamie SchatteProCare Rx

    DB:3.07:Single Ssrs Report, Multiple Databases d7

    Whoops. My mistake. Sorry. Thanks for
    jumping
    in.

  • RELEVANCY SCORE 3.04

    DB:3.04:Cross-Site Scripting (Xss) Prevention In Ssrs 2005 j1


    It seems to me that SSRS 2005's HtmlRenderer extension performs HTML-encoding on all output.  Therefore, if the pseudo-malicious datascriptalert(Gotcha!);/scriptwas in the dataset that SSRS was going to display, the HtmlRenderer extension would automatically encode that value tolt;scriptgt;alert(Gotcha);lt;/scriptgt;which would effectively prevent the malicious data from having a harmful effect.  This seems to be the case, but I can't find any documentation that absolutely confirms this.Can anyone point me in the direction of some documentation that confirms this to be true?

    DB:3.04:Cross-Site Scripting (Xss) Prevention In Ssrs 2005 j1

    Thanks again, Brian.  This is exactly the information I've been looking for.  After playing with it a bit, I finally managed to get a malicious alert(Gotcha!); to pop-up in a report.  In terms of XSS, I now know what to worry about:  using unfiltered parameters/data in the construction of a hyperlink.Thank you very much for your help!

  • RELEVANCY SCORE 2.96

    DB:2.96:Ssrs 2008 R2- Reset Page Number Issue xd


    I'm having an issue with the new Reset Page Number feature in SSRS 2008 R2.
    What I'm trying to do is print a batch of Sales Invoices. They print multiple Sales Invoice at once using a Batch Number as on of the parameters. I have the table grouped by Sales Invoice # and 2 sub keys.
    I can get it to work just fine in most cases, but in one case the page number resets before the last page. If the report is 4 pages, it will display all the detail pages from 1of3, 2of3, 3of3, but the last page gets printed as 1of1.
    The Sales Invoice# footer is about 7 rows tall which contains subtotal, taxes and other fees. The page number resets correctly if the footer fits within the last page. ie, there's still space below. But if the Footer is the last row and
    happens to push on to the next page, it resets the page number before the last page and the footer displays on it's own page with the page numbering as 1 of 1.

    I've tried changing the Group Pagebreak Location to all settings and it doesn't seem to change where the break and the numbers still reset the same no matter where I seem to put it.

    Anyone have any ideas?

    Thanks,
    Dennis

    DB:2.96:Ssrs 2008 R2- Reset Page Number Issue xd

    I wish I had a resolution, but all I can do is let you know you are not alone in experiencing this issue. I have been trying everything I can think of to resolve the problem with no resolution on the horizon. If you found anything helpful since last July,
    please let me know. My problem is not exactly like yours, but closely related. In my report design the ResetPageNumber doesn't work and the next group's pagination continues from the prior group. But not every time, only under certain conditions (which I haven't
    yet pinned down -- it seems random to me at the moment).

  • RELEVANCY SCORE 2.95

    DB:2.95:Pivoting In Ssrs 2005 Reports pz



    Now i am getting results from sql serverlike this
    Date_range Week Total
    06/01/2011-06/04/2011 1 18
    06/05/2011-06/11/2011 2 28
    06/12/2011-06/18/2011 3 38
    06/19/2011-06/25/2011 4 58

    but i want to display this data in the below format in SSRS 2005
    (06/01/2011-06/04/2011)(06/05/2011-06/11/2011) (06/12/2011-06/18/2011) (06/19/2011-06/25/2011)
    1 2 3
    4
    18 2838
    58

    Is it possible to achive this in SSRS 2005?

    DB:2.95:Pivoting In Ssrs 2005 Reports pz

    Hi Aravinda,
    Thanks for other communities' professional solution, here just give another alternative besides the T-SQL, we canstill achieve this requirement
    in reporting services level by creating a horizontal tables, steps are:
    1.
    Add a matrix to your report
    2.
    Right-click in the Data cell and select Add Row to add static row to the matrix, repeat for the number of fixed rows you want, here is Three rows for your requirement.

    3.
    Drag fields(Date_range\Week\Total) into the Data cells, you'll notice that the design tool automatically wraps your field reference in the First aggregate (e.g.
    =First(Fields!Date_range.Value)).please do not remove the aggregation function.
    4.
    Right-click on the column header and select Edit Group. Enter this for the group expression: =RowNumber(Nothing)to add a column group. This will cause
    the matrix to give you one column per row of data. Since horizontal tables can end up rather wide, you probably want your table wrap around to the next line after a specific number of columns.
    5.
    Add a list to your report and drag the table into it
    6.
    Right-click on the list and select Properties. Then click on Edit Details Group. Enter this for the group's expression: =Ceiling(RowNumber(Nothing)/3)
    This will cause the list to group on every three rows. So you'll get a separate table for every three rows. Note: you can change the number 3 to other number based on your requirement.

    7.
    Adjust the group expression in the matrix
    Edit the column group expression in your matrix and change the RowNumber argument to be the list group name.
    For example: =RowNumber(list1_Details_Group)
    Thanks,
    Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 2.92

    DB:2.92:Question Regarding Ssrs 2005 ff


    Hi Guys,
    I am using SSRS 2005.
    I am using a parameter named Employee (and it has the ability to accept multiple values like this : '100,200,300' or '100', or '100,'1453' etc. I made this possible in the Stored Proc using some Split function)
    Now What I want is when we enter values manually in the Employee parameter, I want to display their respective names in the Header part of the report.
    For example, if we enter values '100,'1453' and view the report, I want the Header information to be displayed as 'James,Steve'.
    And I am having fields named Employee_Code and Emplyee_Name in my report.
    And the report designed so that user should manually enter the values of employee codes.
    ANy ideas???
    Thanks,
    Bablu.

    DB:2.92:Question Regarding Ssrs 2005 ff

    Thanks Pavan and Bilal,
    I tried the FOR XML and it worked fine for me....
    and I will try the Bilal's solution also...........
    Thanks once again guys...........

  • RELEVANCY SCORE 2.90

    DB:2.90:Converting .Rdl File Of Ssrs 2008 To Ssrs 2005 ca


    is it possible to convert the .rdl file of ssrs 2008 to .rdl file of ssrs 2005? if yes, then how???

    DB:2.90:Converting .Rdl File Of Ssrs 2008 To Ssrs 2005 ca


    Hi Amar,
    I visited the website you posted 'www.applybi.com' where there is no information there about converting a report from 2008 to 2005.
    Cheers,
    Gus.

    Oh I see Amar, under the section download you are selling a tool to do it. Fair enough!

  • RELEVANCY SCORE 2.88

    DB:2.88:Sql Text Fields In Ssrs(2005) cj


    I am converting a crystal report to a SSRS (2005)report. The TEXT data type field displays with carriage returns or new lines at the line breaks; however, in SSRS there is no carriage return. the text simmply runs on. is the a way to display on the report
    as it is typed? Any help would be appreciated..

    DB:2.88:Sql Text Fields In Ssrs(2005) cj

    Perhaps, I am new to these forums.
    I think my question is more related to Sequel Server Reporting Service. I want to be able to view a microsoft GreatsPlains filed called commnttext which has a datatype of TEXT. When I use that field in the SSRS report , all of the text run together.
    When We view the comment in the Great plains program we see carrige returns/new lines present. The new line are also present in the crystal report. I am trying to determine how to show this text field with the line breaks.

    again thanks for your help

  • RELEVANCY SCORE 2.85

    DB:2.85:Repeating Table Header On Each Page For The Ssrs 2005 Report md


    We are facing issue in repeating Table Header on each page for the report generated by SSRS 2005. We tried setting “Repeat header rows on each” property for the table header. We are facing this issue when the row spans multiple pages.

    DB:2.85:Repeating Table Header On Each Page For The Ssrs 2005 Report md

    Hi,Are you sure the item you want to repeat is on the table header? Below are the codes which uses the data source AdventureWorks, please test them on your machine.
    ?xml version=1.0 encoding=utf-8?
    Report xmlns=http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition xmlns:rd=http://schemas.microsoft.com/SQLServer/reporting/reportdesigner
    DataSources
    DataSource Name=DataSource1
    rd:DataSourceID97d1eae1-17e9-4382-9269-899b0182248c/rd:DataSourceID
    DataSourceReferenceDataSource1/DataSourceReference
    /DataSource
    /DataSources
    InteractiveHeight11in/InteractiveHeight
    rd:DrawGridtrue/rd:DrawGrid
    InteractiveWidth8.5in/InteractiveWidth
    rd:SnapToGridtrue/rd:SnapToGrid
    RightMargin1in/RightMargin
    LeftMargin1in/LeftMargin
    BottomMargin1in/BottomMargin
    rd:ReportIDbdc20847-9964-46e0-8c8e-510d170639dc/rd:ReportID
    DataSets
    DataSet Name=DataSet1
    Fields
    Field Name=ProductID
    DataFieldProductID/DataField
    rd:TypeNameSystem.Int32/rd:TypeName
    /Field
    Field Name=Name
    DataFieldName/DataField
    rd:TypeNameSystem.String/rd:TypeName
    /Field
    Field Name=ProductNumber
    DataFieldProductNumber/DataField
    rd:TypeNameSystem.String/rd:TypeName
    /Field
    Field Name=MakeFlag
    DataFieldMakeFlag/DataField
    rd:TypeNameSystem.Boolean/rd:TypeName
    /Field
    Field Name=FinishedGoodsFlag
    DataFieldFinishedGoodsFlag/DataField
    rd:TypeNameSystem.Boolean/rd:TypeName
    /Field
    Field Name=Color
    DataFieldColor/DataField
    rd:TypeNameSystem.String/rd:TypeName
    /Field
    Field Name=SafetyStockLevel
    DataFieldSafetyStockLevel/DataField
    rd:TypeNameSystem.Int16/rd:TypeName
    /Field
    Field Name=ReorderPoint
    DataFieldReorderPoint/DataField
    rd:TypeNameSystem.Int16/rd:TypeName
    /Field
    Field Name=StandardCost
    DataFieldStandardCost/DataField
    rd:TypeNameSystem.Decimal/rd:TypeName
    /Field
    Field Name=ListPrice
    DataFieldListPrice/DataField
    rd:TypeNameSystem.Decimal/rd:TypeName
    /Field
    Field Name=Size
    DataFieldSize/DataField
    rd:TypeNameSystem.String/rd:TypeName
    /Field
    Field Name=SizeUnitMeasureCode
    DataFieldSizeUnitMeasureCode/DataField
    rd:TypeNameSystem.String/rd:TypeName
    /Field
    Field Name=WeightUnitMeasureCode
    DataFieldWeightUnitMeasureCode/DataField
    rd:TypeNameSystem.String/rd:TypeName
    /Field
    Field Name=Weight
    DataFieldWeight/DataField
    rd:TypeNameSystem.Decimal/rd:TypeName
    /Field
    Field Name=DaysToManufacture
    DataFieldDaysToManufacture/DataField
    rd:TypeNameSystem.Int32/rd:TypeName
    /Field
    Field Name=ProductLine
    DataFieldProductLine/DataField
    rd:TypeNameSystem.String/rd:TypeName
    /Field
    Field Name=Class
    DataFieldClass/DataField
    rd:TypeNameSystem.String/rd:TypeName
    /Field
    Field Name=Style
    DataFieldStyle/DataField
    rd:TypeNameSystem.String/rd:TypeName
    /Field
    Field Name=ProductSubcategoryID
    DataFieldProductSubcategoryID/DataField
    rd:TypeNameSystem.Int32/rd:TypeName
    /Field
    Field Name=ProductModelID
    DataFieldProductModelID/DataField
    rd:TypeNameSystem.Int32/rd:TypeName
    /Field
    Field Name=SellStartDate
    DataFieldSellStartDate/DataField
    rd:TypeNameSystem.DateTime/rd:TypeName
    /Field
    Field Name=SellEndDate
    DataFieldSellEndDate/DataField
    rd:TypeNameSystem.DateTime/rd:TypeName
    /Field
    Field Name=DiscontinuedDate
    DataFieldDiscontinuedDate/DataField
    rd:TypeNameSystem.DateTime/rd:TypeName
    /Field
    Field Name=rowguid
    DataFieldrowguid/DataField
    rd:TypeNameSystem.Guid/rd:TypeName
    /Field
    Field Name=ModifiedDate
    DataFieldModifiedDate/DataField
    rd:TypeNameSystem.DateTime/rd:TypeName
    /Field
    /Fields
    Query
    DataSourceNameDataSource1/DataSourceName
    CommandTextSELECT *
    FROM Production.Product/CommandText
    rd:UseGenericDesignertrue/rd:UseGenericDesigner
    /Query
    /DataSet
    /DataSets
    Width6.5in/Width
    Body
    ReportItems
    Table Name=table1
    DataSetNameDataSet1/DataSetName
    Top1in/Top
    Details
    TableRows
    TableRow
    TableCells
    TableCell
    ReportItems
    Textbox Name=ProductID
    rd:DefaultNameProductID/rd:DefaultName
    Style
    TextAlignRight/TextAlign
    PaddingLeft2pt/PaddingLeft
    PaddingRight2pt/PaddingRight
    PaddingTop2pt/PaddingTop
    PaddingBottom2pt/PaddingBottom
    /Style
    ZIndex2/ZIndex
    CanGrowtrue/CanGrow
    Value=Fields!ProductID.Value/Value
    /Textbox
    /ReportItems
    /TableCell
    TableCell
    ReportItems
    Textbox Name=Color
    rd:DefaultNameColor/rd:DefaultName
    Style
    PaddingLeft2pt/PaddingLeft
    PaddingRight2pt/PaddingRight
    PaddingTop2pt/PaddingTop
    PaddingBottom2pt/PaddingBottom
    /Style
    ZIndex1/ZIndex
    CanGrowtrue/CanGrow
    Value=Fields!Color.Value/Value
    /Textbox
    /ReportItems
    /TableCell
    TableCell
    ReportItems
    Textbox Name=Name
    rd:DefaultNameName/rd:DefaultName
    Style
    PaddingLeft2pt/PaddingLeft
    PaddingRight2pt/PaddingRight
    PaddingTop2pt/PaddingTop
    PaddingBottom2pt/PaddingBottom
    /Style
    CanGrowtrue/CanGrow
    Value=Fields!Name.Value/Value
    /Textbox
    /ReportItems
    /TableCell
    /TableCells
    Height0.25in/Height
    /TableRow
    /TableRows
    /Details
    Header
    TableRows
    TableRow
    TableCells
    TableCell
    ReportItems
    Textbox Name=textbox1
    rd:DefaultNametextbox1/rd:DefaultName
    Style
    TextAlignRight/TextAlign
    PaddingLeft2pt/PaddingLeft
    PaddingRight2pt/PaddingRight
    PaddingTop2pt/PaddingTop
    PaddingBottom2pt/PaddingBottom
    /Style
    ZIndex8/ZIndex
    CanGrowtrue/CanGrow
    ValueProduct ID/Value
    /Textbox
    /ReportItems
    /TableCell
    TableCell
    ReportItems
    Textbox Name=textbox2
    rd:DefaultNametextbox2/rd:DefaultName
    Style
    PaddingLeft2pt/PaddingLeft
    PaddingRight2pt/PaddingRight
    PaddingTop2pt/PaddingTop
    PaddingBottom2pt/PaddingBottom
    /Style
    ZIndex7/ZIndex
    CanGrowtrue/CanGrow
    ValueColor/Value
    /Textbox
    /ReportItems
    /TableCell
    TableCell
    ReportItems
    Textbox Name=textbox3
    rd:DefaultNametextbox3/rd:DefaultName
    Style
    PaddingLeft2pt/PaddingLeft
    PaddingRight2pt/PaddingRight
    PaddingTop2pt/PaddingTop
    PaddingBottom2pt/PaddingBottom
    /Style
    ZIndex6/ZIndex
    CanGrowtrue/CanGrow
    ValueName/Value
    /Textbox
    /ReportItems
    /TableCell
    /TableCells
    Height0.25in/Height
    /TableRow
    /TableRows
    RepeatOnNewPagetrue/RepeatOnNewPage
    /Header
    TableColumns
    TableColumn
    Width2.16667in/Width
    /TableColumn
    TableColumn
    Width2.16667in/Width
    /TableColumn
    TableColumn
    Width2.16667in/Width
    /TableColumn
    /TableColumns
    Height0.75in/Height
    Footer
    TableRows
    TableRow
    TableCells
    TableCell
    ReportItems
    Textbox Name=textbox7
    rd:DefaultNametextbox7/rd:DefaultName
    Style
    PaddingLeft2pt/PaddingLeft
    PaddingRight2pt/PaddingRight
    PaddingTop2pt/PaddingTop
    PaddingBottom2pt/PaddingBottom
    /Style
    ZIndex5/ZIndex
    CanGrowtrue/CanGrow
    Value /
    /Textbox
    /ReportItems
    /TableCell
    TableCell
    ReportItems
    Textbox Name=textbox8
    rd:DefaultNametextbox8/rd:DefaultName
    Style
    PaddingLeft2pt/PaddingLeft
    PaddingRight2pt/PaddingRight
    PaddingTop2pt/PaddingTop
    PaddingBottom2pt/PaddingBottom
    /Style
    ZIndex4/ZIndex
    CanGrowtrue/CanGrow
    Value /
    /Textbox
    /ReportItems
    /TableCell
    TableCell
    ReportItems
    Textbox Name=textbox9
    rd:DefaultNametextbox9/rd:DefaultName
    Style
    PaddingLeft2pt/PaddingLeft
    PaddingRight2pt/PaddingRight
    PaddingTop2pt/PaddingTop
    PaddingBottom2pt/PaddingBottom
    /Style
    ZIndex3/ZIndex
    CanGrowtrue/CanGrow
    Value /
    /Textbox
    /ReportItems
    /TableCell
    /TableCells
    Height0.25in/Height
    /TableRow
    /TableRows
    /Footer
    /Table
    /ReportItems
    Height2in/Height
    /Body
    Languageen-US/Language
    TopMargin1in/TopMargin
    /Report
    Thanks.Yao Jie Tang -Microsoft Online Community

  • RELEVANCY SCORE 2.85

    DB:2.85:Compare Rows In A Drilled Report 1c


    I have a drilled thru SSRS 2005 report. Got 2 items drilled. I want to compare the details(values) of 2nd item and display 'true' or 'false' against 2nd item. Does SSRS have any built in function?

    DB:2.85:Compare Rows In A Drilled Report 1c

    I have a drilled thru SSRS 2005 report. Got 2 items drilled. I want to compare the details(values) of 2nd item and display 'true' or 'false' against 2nd item. Does SSRS have any built in function?

  • RELEVANCY SCORE 2.84

    DB:2.84:Ssrs 2005 Doubt af


    Hi All,
    Is it like ,iam are having multiple matrices in an SSRS report (SSRS 2005) iam getting extra blank pages at the end along with the resultset. I have adjusted the Page size such that the (Body width of
    the report is = Page width Left margin right margin). Is it a drawback of SSRS 2005?
    Even if the SSRS report contains blank pages, if we try to show it via ASP.NET Report Viewer control, is there any way that we could supress those blank pages using the ReportViewer control .Please help

    DB:2.84:Ssrs 2005 Doubt af

    Hi Acinash,
    The extra blank page when you export report to PDF or preview in print layout caused by the structure of the report. It’s nothing to do with which control you are using to view report. So in your scenario, use report viewer control to show the report cannot
    avoid this issue, we can try to set the “ConsumeContainerWhitespace” property to “True”, or reduce the left/right margins.

    Here are some related threads about this topic, please see:
    http://social.technet.microsoft.com/Forums/en/sqlreportingservices/thread/702e2d22-3c5d-4842-bf74-ba6f9c0e7346
    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/346233aa-5072-4459-888b-bef6b0961e4f
    If the issue persists, please elaborate the structure of the report, if possible provide us some screenshots with sample data, so that we can make further analysis.
    Regards,
    Charlie LiaoCharlie Liao
    TechNet Community Support

  • RELEVANCY SCORE 2.81

    DB:2.81:Sharing Reports Across Multiple Databases 7k


    I'm new to SSRS development so please let me know what's the best way to achieve what I'm trying to do. We are using SSRS 2005 and WinForms application that needs to display server reports. These reports must be shared across multiple databases. WinForms application will establish db connection and this connection must be passed to SSRS reports on the reports server. Somebody mentioned that this can be achieved by parameterizing connection string of the reports (I'm not using shared connection) i.e. passing name of the server and database name as parameters to use in the report's connection string. I'm trying this approach but wanted to get some responses if that's the best way to do this. Thanks, Lev

    DB:2.81:Sharing Reports Across Multiple Databases 7k

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5e2c0245-d457-43a3-b585-9459463c7e5dcheck this outPraxy

  • RELEVANCY SCORE 2.80

    DB:2.80:Web Report Using Ssrs 2008 Appears To Be Trying To Connect To A Ssrs 2005 Instance Instead - Do Conflicts Exist With Multiple Instances? 9c


    I have an ASP.NET web page (built in VS2008) calling a report in a ReportViewer control. It gives an unathorized access error when trying to load the report - however in the stack trace it seems to be pointing to the 2005 SSRS instance. I have a key in my web.config file that specifies the report server name and points to the SSRS 2008 instance. This has always worked before, but this is the first time I've run on a machine with 2 instances of SSRS.
    Can anyone point me to some information on this?

    DB:2.80:Web Report Using Ssrs 2008 Appears To Be Trying To Connect To A Ssrs 2005 Instance Instead - Do Conflicts Exist With Multiple Instances? 9c

    Alright, I've found my own answer. I was missing the security tab in the properties of my folders in My Computer (and Windows Explorer) so I did notknow how to setfolder permissions for a while. I had to change XP to show the security tab and then set additional user permissions on my report server folder. Figures it would be something so simple...

  • RELEVANCY SCORE 2.80

    DB:2.80:Grouping Multiple Datasets In 2 Different Tables Ssrs 2005 xs


    Hello,

    Is it possible to group 2 datasets in 2 different tables together. I am sooo confused...
    Thanks

    DB:2.80:Grouping Multiple Datasets In 2 Different Tables Ssrs 2005 xs

    Hi fredz92,
    As per my understanding, you have two datasets in the report, dataset1 has the fields: Invoice No, AccountName, OrderNo, Surname and OrderStatus. Dataset2 has the fields: InvoiceNo, InstallsScheduled, OrderNo and OrderStatus. You want to create a tablix
    and retrieve data from the two datasets , then add group to the tablix. In Reporting Services 2005, we could not retrieve data from two datasets directly into one tablix. As a workaround, we can use subreport.
    To create the Subreport, please refer to the following steps:

    In design surface, in Solution Explorer pane, right-click Report and click New Item to create report named Report1.In Data tab, add DataSet1 with the query: select InvoiceNo, InstallsScheduled from table2.Add DataSet2 with the query: select InvoiceNo from table2.Click Layout tab, in the Toolbox, click Table, and then click on the design surface.Drag the InstallsScheduled field from the Dataset1 window to the middle (detail) row of the first column in the table, then delete the first row and the last two columns.Click Report in Toolbar, and click Report Parameters, set name and prompt to InvoiceNo, check Multi-value check box, set Available Values from Dataset2.Click and select the tablix, in Properties window, in Data section, click (…) button next to Filters.In Expression drop down list, select =Fields! InvoiceNo.Value, set Operator to In. In Value drop down list, click Expression, and type the expression like below: =Parameters! InvoiceNo.Value.

    To create the Master report, please refer to the following steps:

    In Solution Explorer pane, right-click Report and click New Item to create report named Report2.In Data tab, create two Dataset like step2 and 3 above.Add tablix to the report, and drag Invoice No, AccountName, OrderNo, Surname and OrderStatus from Dataset1 to the table as step4 and 5.Add parameter and filter to the report as step6 to step8 above.Right-click the last column handle, click Insert Column, and then click Right.In the Toolbox, click subreport, then click the middle (detail) row of the last column.Right click the subreport, and click Properties, from subreport drop down list, select Report1.Click the subreport, in Properties window, click (…) button next to Parameters, set Parameter Name to InvoiceNo, then set Expression to =Parameters! InvoiceNo.Value.

    In addition, if possible, we can merge the two datasets into one dataset by using join in a query like below:
    Select t1.InvoiceNo, t1.AccountName, t1.OrderNo, t1.Surname, t1.OrderStatus, t2. InstallsScheduled, t2.OrderNo, t2. OrderStatus
    From table1 as t1
    Inner join table2 as t2 on t1. InvoiceNo = t2.InvoiceNo

    If you have any questions, please feel free to let me know.
    Thanks,
    Wendy Fu

  • RELEVANCY SCORE 2.79

    DB:2.79:How To Add Or Use Muliple Page Headers For A Report In Ssrs 2005 9d


    Hi ,
     

    Can we add multiple Page headers for a report in SSRS 2005. If we can add can any one tell me how to add multile page headers for report in SSRS 2005. IF not is thier any solution for this issues.
     
     
    Anyone please reply back
     
     
    Thanks and Regards
    Manju
     

    DB:2.79:How To Add Or Use Muliple Page Headers For A Report In Ssrs 2005 9d

    Hi ,
     

    Can we add multiple Page headers for a report in SSRS 2005. If we can add can any one tell me how to add multile page headers for report in SSRS 2005. IF not is thier any solution for this issues.
     
     
    Anyone please reply back
     
     
    Thanks and Regards
    Manju
     

  • RELEVANCY SCORE 2.78

    DB:2.78:Ssrs 2005 - Printing And Pages ak


    I am have a deployed a SSRS 2005 basic report that contains a list in a table. When I view it in IE 8, it has 7 pages. When I print it it has 11 pages. Why isn't the screen display the same as the printed display? How does the screen display get set?

    DB:2.78:Ssrs 2005 - Printing And Pages ak

    Thank you. I set my Interactive Size to 0 also. What a good idea. I don't see any reasons to have pages in a browser.

  • RELEVANCY SCORE 2.76

    DB:2.76:To Customize The Order Of Display Of Items In The Legend In Ssrs 2005 3d


    Hi all,
    I am new to SSRS. Using certain links, i found to create a pie chart report using SSRS 2005. I want to know is there any possibility tocustomizethe order of display of items in the Legend.
    For Eg: If the legend is getting displayed as Color America
    Color India
    Color Russia
    Color Germany
    I want this legend to display in the following order: Color India
    Color Germany
    Color America

    Color Russia

    Please help me out in this issue.
    Thanks in Advance..
    Shiv!

    DB:2.76:To Customize The Order Of Display Of Items In The Legend In Ssrs 2005 3d

    Hi Tony,

    Thanks a lot for your detailed explanation. Your words have resolved my issue.
    Have a good day!!!

    Shiv!

  • RELEVANCY SCORE 2.76

    DB:2.76:Horezental Repeatation Oof Data In Ssrs 2005 k9


    hi , i want to spred my data horizental in ssrs 2005

    DB:2.76:Horezental Repeatation Oof Data In Ssrs 2005 k9

    Hello,
    Just as Sanjeewan post above, if you want to the report data can grow horizontally, you can try to use Matrix data region. Unlike a table, which has a static set of columns, matrix columns and rows can be dynamic. You can define matrices that contain static
    and dynamic rows and columns.
    For more information, please see:
    Adding a Matrix (Reporting Services)

    If I have any misunderstanding, please post more details about your requirement.
    Regards,
    Fanny Liu Fanny Liu
    TechNet Community Support

  • RELEVANCY SCORE 2.75

    DB:2.75:One Order Multiple Invoices dz


    Is it possible to create multiple invoices against single order with different details?
     

    DB:2.75:One Order Multiple Invoices dz

    But how can i manage partial orders this way?

  • RELEVANCY SCORE 2.74

    DB:2.74:Grouping Ssrs 2005 j9


    Hi to All,I am using SSRS 2005. In my report am searching based on designation it should display the employee details.For Example,  If i click admin designation 5 Employees are there. It should display like this..EmployeeNumber EmployeeName Designation E01                      AAA                    AdminEmployeeNumber EmployeeName DesignationE02                       BBB                   AdminFor this I have Inserted Group For the table in Fields EmployeeNumberBut My report is displaying like this,EmployeeNumber EmployeeName DesignationE01                        AAA               Admin---Here this header is not displaying (It is displaying First Time alone)---E02                        BBB                AdminIs this possible to do in SSRS 2005, Any one have idea about this?Regards,chitra.

    DB:2.74:Grouping Ssrs 2005 j9

    Hi Jerry,Thank u so much for ur reply. I got the report like that. It is Working Fine.Have a Nice TimeRegards,chitra.

  • RELEVANCY SCORE 2.74

    DB:2.74:How To Print Multiple Invoices In Smartform pz



    How to print multiple customer invoices on different pages in smartform, Invoice range is given by selection screen of driver program,

    In my case i have to go back and press print preview button to display next invoice.

    My requirement is next invoice will display on next page by pressing next page button.

    DB:2.74:How To Print Multiple Invoices In Smartform pz


    Hi Mandar ,

    I guess you can do this by using Standard Tcode VF31.

    Give a try to it.

  • RELEVANCY SCORE 2.73

    DB:2.73:Using \#\ To Pass Mulitiple Values To A Multivalue Parameter In Ssrs 2012 m8


    I'm using a graph to pass multiple values to a drill through report.

    Under the series properties, action options, I'm passing multiple values to another report's parameter.
    In SSRS 2005 I used to be able to do this passing in this format:
    ValueA\#\ValueB

    In SSRS 2012 this does not work. Is there a new delimiter, or is this simply not supported anymore?
    Now when I try to drill through on the graph, it is not populating the parameter at all.

    DB:2.73:Using \#\ To Pass Mulitiple Values To A Multivalue Parameter In Ssrs 2012 m8

    In this instance it is dynamic.
    So in one instance I might be passing A, in another B, and in another A and B.
    Let me try to describe the scenario more precisely.
    On the main report, there is a filter that one set of users use, and another set of users don't.
    So for one set of users, the value will be A or A and B and for the other group, the filter stays on A and B.
    I'm trying to pass this logic through to the drill through report using this:
    =iif(Parameters!Filter.Label = A,A,A\#\B)
    so for the Name, I use the parameter name and for the expression I am using the expression.

    I changed it to:
    =iif(Parameters!Filter.Label = A,A,split(A,B,,))
    and all works well now.
    I could have sworn I had tried split, but maybe I hadn't implemented it properly.
    Thank you!

  • RELEVANCY SCORE 2.73

    DB:2.73:Ssrs Multiple Results But Not Using Table But Using Page Layout 8j


    Hello,

    I hope SSRS can do this, i made a query, which brings back all customers with invoices past there due date, which i made have a nice invoice page layout, not a typical table layout, but a page with invoice number customer name, address etc., but when i run
    this in ssrs, it never displays any data, which i assume its because there is multiple results, and that it can only display 1 result, is there a way to display multiple results with my page layout but on different pages? i know it probably wont print out
    the same, my main thing is displaying results per page.

    thanks in advance

    DB:2.73:Ssrs Multiple Results But Not Using Table But Using Page Layout 8j

    Here is the msdn tutorial on Reporting services. It takes you step by step to use a dataset and a Table!
    http://msdn.microsoft.com/en-us/library/ms167305.aspx

    I hope it will help,
    Alex

    Edit :
    I know that Tables are a little wierd to use at start, but you can do the same display that you would do on Forms Reports or Crystal Reports. It is just a different approach!

  • RELEVANCY SCORE 2.73

    DB:2.73:Getting Data From Multiple List In Ssrs f8


    Hi,

    Is there any way to get the data from multiple lists or libraries and display in my report using SSRS 2005.

    Thanks

    MCTS,MCPD Sharepoint 2010. My Blog-
    http://www.sharepoint-journey.com
    If a post answers your question, please click Mark As Answer on that post and Vote as Helpful

    DB:2.73:Getting Data From Multiple List In Ssrs f8

    Hi,I don't think there is any OOB functionality to achieve this.There is a work around solution that will require some custom code. You have2 custom lists say List A andList B. Create a temporary list C which would be used for reporting services to plot the charts. When ever there are any data add/updates on List A or List B you need to sync the data to List C using a event handlers so that you have the latest data in the List C.Thanks,Skancharla

  • RELEVANCY SCORE 2.73

    DB:2.73:Image Not Exporting To Excel--Ssrs 2008 ap


    Hi Currently iam creating reports using SSRS 2008.When i try to export reports to Excel it does not export the header image.It exports it to PDF with no issues. I worked in SSRS 2005 before, i dint had any problems exporting to Excel any suggestions on what iam missing.And also the only option to add a image in SSRS 2008 seems is using Embedded compared to SSRS 2005 where we can add image to Solution Explorer and refer across multiple RDLs am i missing anything??

    DB:2.73:Image Not Exporting To Excel--Ssrs 2008 ap

    Nope its not a migrated report it is brand new report developed in SSRS 2008 and Image fomat iam using is JPEG.Thank You.

  • RELEVANCY SCORE 2.71

    DB:2.71:Images From Ssrs 2005 Report Not Deployed To Crm z1


    I have rdl report file I created in SSRS 2005. The report has to logos included but when I deploy the rdl file to the CRM, those images does not appear in the report. Is it possible that I have to upload the images on some certain location on the server so the CRM is able to display them?

    DB:2.71:Images From Ssrs 2005 Report Not Deployed To Crm z1

    We have a similar problem but it involves charts not images. Our embedded charts do not display in the deployed reports (but do show in VS, and the charts also show when the report is exported to a .PDF file.)

    Steve

  • RELEVANCY SCORE 2.70

    DB:2.70:Tooltip Display On Table Header In Ssrs 2005 zz


    Hi , I am working on SSRS 2005 reports. I want show tool tip on columns header where I can show formula used for values display in columns. I found that when I select column header,right click on that,select Properties, there is Tool Tip option.I set expression for that.But in preview I am not able to view  tool tip. Is there any solution?

    DB:2.70:Tooltip Display On Table Header In Ssrs 2005 zz

    Hi, Thanks for reply. For SSRS 2005,Tool Tip is working. Need to set Tool Tip Property like ToolTip and ToolTipLocId property. In Preview mode,we will not be able to view tool tip but once you deployed on Report server,Your report will display Tool Tip

  • RELEVANCY SCORE 2.70

    DB:2.70:Ssrs 2005 Global Security Changes f1


    Is it possible to assign users to an SSRS 2005 role in multiple reports or folders? Is there an SSRS API to create scripts do sweeping global administration type changes? I looked at the Reporting Services WMI Provider and Reporting Services Managed Programming Reference (such as Microsoft.ReportingServices.Interfaces Namespace) with no avail. Is it safe to update the ReportServer system tables such as PolicyUserRole?Thanks.

    DB:2.70:Ssrs 2005 Global Security Changes f1

    Hi Greg JQ,We are greate to hear that.If you have any other questions about SQL Server, please feel free to ask in SQL Server Forum.Have a nice day.Thanks,JinJin Chen - MSFT

  • RELEVANCY SCORE 2.69

    DB:2.69:Migrating Ssrs 2005 To Ssrs 2008 xj


    Hi,I know there are lot of positve points for Migrating SSRS 2005 to SSRS 2008.Is there any pitfalls for migrating the same?

    DB:2.69:Migrating Ssrs 2005 To Ssrs 2008 xj

    Hi Kushboo,
     
    As you know, there have a lot of positive points for migrating SQL Server Reporting Services 2005 to SQL Server Reporting Services 2008. For more information about this topic, please see “What's New (Reporting Services)”.
     
    For your question “Is there any changes between SQL Server Reporting Services 2005 and SQL Server Reporting Services 2008”, the answer is YES.
    For example:
    Migrating to SQL Server 2008 offers significant benefits in deployment and processing, but you should be aware that not all functionality from previous versions is available in SQL Server 2008. Specifically, if you are using a third-party single sign-on technology solution or custom features that integrate with Reporting Services through Internet Information Services (IIS), your current solution will not work on a new report server installation. You will have to redesign your solution for a SQL Server 2008 report server.
    The SQL Server Reporting Services does not allow anonymous access, if we have implement a custom application for SQL Server Reporting Services 2005 that using anonymous authentication, the custom application won’t work for SQL Server Reporting Services 2008.
     
    Before you migrate, evaluate the new software and test reports and other items to ensure your business requirements are met. The following links provide information to help you determine a migration strategy:

    Deprecated Features in SQL Server Reporting Services
    Discontinued Functionality in SQL Server Reporting Services
    Breaking Changes in SQL Server Reporting Services
    Behavior Changes in SQL Server Reporting Services

     
    Please feel free to ask, if you have any more questions.
     
    Thanks,
    Jin ChenJin Chen - MSFT

  • RELEVANCY SCORE 2.69

    DB:2.69:Slow Chart Rendering Ssrs 2005 V Ssrs 2008 11


    Hi,I am current using SSRS 2005 and am having an issues with slow chart rendering in my report with lots of multiple charts across multiple pages.This issue is a known issues as discussed here: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/9b53f8bd-bf67-43ef-89ad-99730f7b55c6Does anyone know if this has been resolved in SSRS 2005... or address in SSRS 2008?Thanks in advance.

    DB:2.69:Slow Chart Rendering Ssrs 2005 V Ssrs 2008 11

    Hi,I am current using SSRS 2005 and am having an issues with slow chart rendering in my report with lots of multiple charts across multiple pages.This issue is a known issues as discussed here: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/9b53f8bd-bf67-43ef-89ad-99730f7b55c6Does anyone know if this has been resolved in SSRS 2005... or address in SSRS 2008?Thanks in advance.

  • RELEVANCY SCORE 2.69

    DB:2.69:Partially Bold Text In Ssrs 2005 Using Expression ? 38


    Hi,
    I am using SSRS 2005.
    I have one requirment. I need to Partially Bold some part of Text in column.
    Below is the Example.
    Name - -- Column in SSRS 2005 Report.
    This column contains combination of Last Name and First Name. All Database record contains Last name , while in some record our requirment is to append First Name with that.
    That is i aleady handled using Nested IIF Expression.
    Now, i want to display appended First Name in normal while all Last Name whihc is Database Field in BOLD Font.
    How is it possible ?

    DB:2.69:Partially Bold Text In Ssrs 2005 Using Expression ? 38

    Here's a specific example of what would work:
    http://www.sqlchick.com/entries/2010/10/31/using-different-formats-within-a-single-textbox-in-ssrs.htmlI hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful. Michael Mayo

  • RELEVANCY SCORE 2.68

    DB:2.68:Can I Set A Table To Display 20 Rows And Then Scroll Instead Of Expanding Down The Page? (Ssrs 2005 ) 8k


    Can I set a table to display 20 rows and then scroll instead of expanding downseveral page? (SSRS 2005 )

    DB:2.68:Can I Set A Table To Display 20 Rows And Then Scroll Instead Of Expanding Down The Page? (Ssrs 2005 ) 8k

    Hi
    Challen ,
    It works great for fixing the number of rows for a table. Thanx a lot.
    Regars,
    Chander Sharma

  • RELEVANCY SCORE 2.67

    DB:2.67:Ssrs Display Text On Every New Group xj


    I have requirement. I have an SSRS report which has invoice no ( group field) I want to display another text in header based on this invoice no group. I want to display only if its new group. may be for same invoice no there will be multiple pages where
    i dont want to display. Please help

    DB:2.67:Ssrs Display Text On Every New Group xj

    Hi Jinesh,
    According to your description, you want to show the group name (InvoiceNo) with the group in the header. Right?
    In this scenario, we can put the tablix into a List, set the group for List and set page break between each group instance, then we just need to add a row above the header row. Put the expression =Fields!InvoiceNo.Value into textbox. The group name will
    repeat with each group. We have tested this scenario in our local environment. Here are screenshots for your reference:

    If you have any question, please feel free to ask.
    Best Regards,
    Simon Hou

  • RELEVANCY SCORE 2.67

    DB:2.67:Ssrs Report Page Break When Export To Pdf a8


    Hi,
    I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.
    I have grouped the report based on Invoice number, so that the invoices are printed sequentially and there will be page break after each invoice number. Within each invoice there is a header, body and footer.
    My issue is for certain cases the line items in the body of the invoice, onlythe lastline item moves to the next page.Cretaing a large gap in the body of the report. This happens only for some invoices. I am using Land scape type report,
    having Page size as 11 * 8.5 inches.
    I wish any one can solve this issue and grateful if they can give the solution for my problem.
    I can also send the RDL file, sample data as well as the PDF output for review.
    Thanks,
    Mahalingam

    DB:2.67:Ssrs Report Page Break When Export To Pdf a8

    i've got the same problem. but don't really understand.
    I found that it need two rectangles inside one another.
    Apply the conditional formatting to the outside rectangle.
    and the pagebreak inside.
    but i just think what the hack is going on with ssrs. :)

    RegardsOne who can read, have a clear advantage!

  • RELEVANCY SCORE 2.66

    DB:2.66:Multiple Datasets Using Same Data Source? 8k


    Here's the scenario:

    Using 2005
    3 stored procs in a database
    MUST use the procs for the report
    CANNOT alter the stored procs
    CANNOT combine the stored procs
    CANNOT use subreports

    That said, I need to be able to create multiple datasets for this report, based on the 3 stored procs. Apparently, however, SSRS wants you to use differnt datasources for each proc. I tried using a wrapper, which executed perfectly in SQL,but SSRS will still only display the first set of data. Are there any known ways to work around this?
    TIA.

    DB:2.66:Multiple Datasets Using Same Data Source? 8k

    Multiple datasets (and thus SPs) can use the same datasource, not quite sure what the problem is there. Do you have the datasource as a shared datasource rather than embedded into the report?Failing that...You could always do some dynamic SQL in the data tab to combine the data. Nasty, but it would probably work.LaCie drives. Failing when you need them most.La meaning Terrible, Cie meaning customer service

  • RELEVANCY SCORE 2.66

    DB:2.66:Ssrs 2008 - Deployed Reports Dont Render Matrix k9


    I created a new matrix report which displays properly in BIDS 2008. I deployed it to my report server, but when I run it in Report Manager the matrix part of the report doesn't display. My server has SSRS 2008 installed and also a SQL Server
    2005 database engine. My other reports which were previously made in SSRS 2005 display just fine. Maybe it isn't displaying the new tablix features?
    Is there possibly some configuration problem on my report server?
    Any help would be appreciated.

    DB:2.66:Ssrs 2008 - Deployed Reports Dont Render Matrix k9

    I created a new matrix report which displays properly in BIDS 2008. I deployed it to my report server, but when I run it in Report Manager the matrix part of the report doesn't display. My server has SSRS 2008 installed and also a SQL Server
    2005 database engine. My other reports which were previously made in SSRS 2005 display just fine. Maybe it isn't displaying the new tablix features?
    Is there possibly some configuration problem on my report server?
    Any help would be appreciated.

  • RELEVANCY SCORE 2.66

    DB:2.66:Ssrs 2005 Column Chart How To Display Series Lable On Top Of The Each Corrosponding Data Value ? fz


    Hi friends,
    I have a Column Chart in SSRs 2005.
    I need to display Each Series Lable on top of the corrosponding data value inside the chart.
    Pls provide any suggestions.
    Let me know if need more information.
    Thanks !!!

    DB:2.66:Ssrs 2005 Column Chart How To Display Series Lable On Top Of The Each Corrosponding Data Value ? fz

    Can you help me with this below my problem.
    Actually, i want to Hide Row Group Total which is Horizontal in Last column of matrix total.
    below is the more detail explanation.
    Employee 1
    Employee 2 Employee 3 Total
    Mumbai 3
    6 7
    16 - Want to Hide this Row Group total
    Delhi 20
    5 7 - Want to Hide this Row Group total
    Bangalore 1
    2 912
    - Want to Hide this Row Group total
    Total 6
    8 21
    35 ----NEED TO SHOW THIS TOTAL

    I tryied using InScope Function to control this , but no luck yet.
    Can anybody gudie me , how can i hide this in SSRs 2005 Matrix ?

  • RELEVANCY SCORE 2.66

    DB:2.66:Display Percentage(%) 3p


    How to display percentage in labels in pie charts in ssrs 2005 ?Satish

    DB:2.66:Display Percentage(%) 3p

    Have you tried to use Supported Keywords like #PERCENT?
    For more info please refer to the link below:
    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1244bb04-3664-4821-ae60-90a46aac6a76
    Hope this helps!Thanks, Michael Mei

  • RELEVANCY SCORE 2.66

    DB:2.66:Help With A Complex Query 9m


    Here is my problem:
    I am working with Microsoft Dynamics CRM 3.0, MS SQL Server 2005. I am trying to do a very complicated multiple join in a dataset I want to use to display data in a chart in a report. I am building
    the report using Business Intelligence Studio 2005.

    Here are the data series for the chart:

    Value of Open Opportunites = sum of estimatedvalue (display Est. Value) of active opportunity related to campaign that does not have an active quote, COSLA (order) or any invoice
    related to the open opportunity.

    Value of Open Quotations = sum of totalamount (display name Total Amount) on Quote entity for all quotes where quotation is active and is related to an opportunity related to campaign
    in report

    Value of open Coslas (schema salesorder) = sum of totalamount (display name total amount) on salesorder (COSLA) entity for all coslas where COSLA is active and is
    related to an opportunity related to campaign in report

    Value of Invoices (schema invoice) = sum of totalamount (display name total amount) on invoice entity for all invoices related to an oppotunity related to campaign in report.

    Target Revenue = expectedrevenue (display name Target Revenue) from campaign entity

    I have been trying using all kinds of joins but I cant all the data in one dataset query and I cant use multiple datasets in the same chart
    I suspect that I need to use a sub query but I dont how write it.
    Could someone give me some guidance with the query, or suggest a good resource where I can get good info and examples on how to write complex queries that use sub queries and unions.

    Thank you
    PWR

    DB:2.66:Help With A Complex Query 9m

    Glad to help. Happy Holidays!

    Brent Greenwood, MS, MCITP, CBIP
    /*************************************************
    --Please mark correct answers and helpful posts--
    *************************************************/
    http://brentgreenwood.blogspot.com

  • RELEVANCY SCORE 2.65

    DB:2.65:Passing Multiple Values Into Parameter When Using Like Operator ( Ssrs 2005) pd


    Hello SSRS gurus,could somebody please give me ideas on building  a simple  report whose parameter accepts multiple values from the usersmy query is as follows: select drug_id, drug_namefrom drugwhere drug_name like '@D_Name'Now I want my parameter @D_Name to accept say 2 or 3 key-words simultaneously and generate results accordingly Appreciate your inputs

    DB:2.65:Passing Multiple Values Into Parameter When Using Like Operator ( Ssrs 2005) pd

    HELLO RAYMOND,
    I AM USING SQL SERVER 2005 RS .
    I FOLLOWED YOUR STEPS LIKE BELOW,
    STEP 1 - SAME EXACTLY
    STEP 2 - EXACTLY SAME
    STEP 3 - EXACTLY SAME
    BUT I DID NOT UNDERSTAND BELOW PORTION,
    Edit the dataset, in dataset window, switch to parameter tab. Set the name to be “@tt1” and the value to be =join(Parameters!tt1.Value , ,)
    WHERE AND HOW TO DO THIS?
    WHEN I TRIED IN PREVIEW TAB THEN IT GIVES ERROR PROCEDURE OR FUNCTION
    account_Staus
    HAS TOO MANY ARGUMENTS SPECIFIED. (MAY BEBECAUSEI SKIPPED THE ABOVE PART WHICH I DID NOT UNDERSTAND)

    h2007

  • RELEVANCY SCORE 2.65

    DB:2.65:Ssrs 2005 Report To Display Data For Two Different Date Range And A Set Of Computed Columns f1


    Hi,

  • RELEVANCY SCORE 2.64

    DB:2.64:Format Labels In Charts zj


    how to format x-axis labels in charts in ssrs 2005?
    how to display cross labels in chartsin ssrs 2005?
    please give examples

    DB:2.64:Format Labels In Charts zj

    Hi KUAMR,
    Rotating text at an angle is not supported in Sql Server Reporting Service2005. The direction of the text is determined automatically
    based on the available space the actual X-Axis label (e.g. if it contains spaces and it is very long, it may get split into multiple lines). However we can easily achieve this in Reporting service2008 by setting the Rotate Degree. So
    to workaround the issue, you could increase the width of the column chart automatically. For detailed steps, please get a reference from the blog written by
    Robert in this link:
    http://blogs.msdn.com/b/robertbruckner/archive/2008/10/27/charts-with-dynamic-size-based-on-categories-or-data.aspx . Of course, you could also follow Rajkumars reply by changing the chart type to Bar chart.
    Hope this helps.
    Regards,
    Challen Fu

  • RELEVANCY SCORE 2.63

    DB:2.63:What Is New In Ssrs 2008 Over Ssrs 2005 kc


    Hi friends, can anyone tell me what all are the new features added in SSRS 2008 over SSRS 2005.ThanksThanks!!
    MCP

    DB:2.63:What Is New In Ssrs 2008 Over Ssrs 2005 kc

    Here is the online features:http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspxThere is the addition of gauges is new to SQL 08 along with the ability to export reports now to Word.  The tablix is new as well as how the report engine renders multiple pages more efficiently.Report builder 2.0 is an awesome new tool and is far superior to report builder 1.0 providing greater flexibility for the end user to create their own report(s).David Dye

  • RELEVANCY SCORE 2.63

    DB:2.63:Single Sales Return From Multiple Invoices 7f



    Hi all,

    how to create single sales return doc. from multiple invoices

    thanx,

    sourav

    DB:2.63:Single Sales Return From Multiple Invoices 7f


    Dear sourav

    Yes it is certainly possible.

    In VA01 after giving the return order type and sales area, system will ask for billing reference. Give one billing reference and select "copy". Now it will take you to the main screen. Select "Sales Document" on top and "Create with Reference" so that again it will ask for billing document reference. Giver another billing document and you can now see that the number of line items in the return order will increase.

    Thanks

    G. Lakshmipathi

  • RELEVANCY SCORE 2.63

    DB:2.63:What Ssrs 2005 Features (If Any) Are Depreciated Or Have To Be Reimplmented When We Switch To Ssrs 2008? z7


    Hi ,
    I am going to shift from SSRS 2005 to SSRS 2008. Can any one help me which SSRS 2005 features are not supported in SSRS 2008 or which SSRS 2005 features replaced and beter in SSRS 2008? Or nothing but which are all SSRS 2005 features are depreciated or have
    to be reimplemented when we switch to SSRS 2008?
    Thanks,
    Palash

    DB:2.63:What Ssrs 2005 Features (If Any) Are Depreciated Or Have To Be Reimplmented When We Switch To Ssrs 2008? z7

    Hi Rajkumar,
    Why am I loosing visibilty settings when I upgrade SSRS 2005 reports to SSRS 2008?
    Is there a way to preserver these settigns/
    Thank you in advance.
    Bharat.bgadhia

  • RELEVANCY SCORE 2.63

    DB:2.63:Ssrs Page Break When Export To Pdf kk


    Hi,
    I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.
    I have grouped the report based on Invoice number, so that the invoices are printed sequentially and there will be page break after each invoice number. Within each invoice there is a header, body and footer.
    My issue is after the header is printed, an automatic page break happens after the header and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.
    I wish any one can solve this issue and grateful if they can give the solution for my problem.
    Thanks,
    Mahalingam

  • RELEVANCY SCORE 2.63

    DB:2.63:Ssrs 2005 - How To Display Y-Axis Number In Chart In Terms Of Billions ? pa


    Hi Friends,

    Below is my details problem description.

    I am using SSRS 2005 Chart.

    I need to display Number on Y-Axis in Billions.

    Example : 1,000,000,000,000 - Right Now it is displaying this formate on Y-Axis.

    My requirment is to Display in formate of 1 Bn.

    How can i display like this on Y-Axis ?

    If you need more information , let me know.

    Thanks.

    DB:2.63:Ssrs 2005 - How To Display Y-Axis Number In Chart In Terms Of Billions ? pa

    Hi,
    Please ask different questions on different thread, if you main question answer has been resolved please mark this thread as Mark As Answer too.
    In that way you WILL get replies faster.
    Have you tried writing queries using ReportServer db from SSMS, please tried it, you might will get your answer in your question itself.
    Thanks
    KumarKG

  • RELEVANCY SCORE 2.63

    DB:2.63:Cycle Time Report In Ssrs 2005 sf


    Hi,
    I am using SSRS 2005. Can i create a report,

    DB:2.63:Cycle Time Report In Ssrs 2005 sf

    Yes you certainly can, please see the following for an overview; -
    http://msdn.microsoft.com/en-us/library/ms159106(v=SQL.90).aspx
    For tutorials, (how tos) ; -
    http://msdn.microsoft.com/en-US/library/ms157143(v=SQL.90).aspx
    Kind Regards,
    Kieran.If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood

  • RELEVANCY SCORE 2.62

    DB:2.62:Ssrs Font Family ax


    Hi,
    what are fonts supported by SSRS 2005 SSRS 2008.
    eg.,Calibiri etc.,

    Regards,
    Jayakumar.J

    DB:2.62:Ssrs Font Family ax

    You need to install the font on the report server itself as it's using server-side renderingEric

  • RELEVANCY SCORE 2.62

    DB:2.62:Ssrs Paga No. Issue When Subscription sc


    Hi,
    I am using SSRS 2005 version. I am generating invoices in the Report by passing multiple invoice numbers separated by commas as a string. There is a grouping on Invoice no. in the report and the invoices are printed in order. I have used page number in each
    page and the page no. is printed for each page of the invoice. The page no. resets for each invoice and it starts from Page:1 in the next invoice. This works correct when we run the report from report server by passing the parameters.
    When I Schedule the reprort using subscription, invoices are generated and the page no. is not printing correctly. I find this issue only in the subscription of invoices. I am giving the codes used for this report below.
    The following code is used inside the text box where the Page number is printed.
    =Page
    No: Code.GetGroupPageNumber(ReportItems!txtInvoiceNo.Value,Globals!PageNumber)
    The following function
    is used to display the page number, to reset page number for each invoice.
    Shared
    offset as Integer
    Shared currentgroup as Object
    Public Function GetGroupPageNumber(group as Object, pagenumber as Integer) as Object
    If Not (group = currentgroup)
    offset = pagenumber - 1
    currentgroup = group
    End If
    Return pagenumber - offset
    End Function
    I request,any one canunderstand this issue and find the solution, this is very urgent and I appreciate for the earliest
    response. I can also send the RDL files and the code used if needed.
    Thanks,
    Mahalingam

    DB:2.62:Ssrs Paga No. Issue When Subscription sc

    Hi Tony Chain,
    Thanks for your direction. I have contaced Microsoft connect and theywere working in this issue.
    They come to a conclusion, this is a limitation with SSRS 2005, using custom function for the Page number.
    Pls find the content below I recieve from Microsoft.
    --------------------------------------------------------------------------------------------------------------------------------------

    As discussed on call today ,this feature isnt natively supported within Reporting services 2005 for this reason you are using custom code to achieve it by tracking group breaks in a shared variable and subtracting off the page offset
    of the first page of the group from the current page number.

    Based upon the customer feedback from world over we have included Reset page number on Group as a feature in SSRS 2008 R2. Please refer blog for it:
    http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/report-design-reset-page-number-on-group.aspx

    Root cause of the problem is clashing of variable state happening due to
    report being generated via data driven subscription ,through a single schedule filtering the report for different invoice no.

    This issue is fixed in SSRS 2008 R2 so please check at your end to upgrade to SSRS 2008 R2 to resolve this issue.
    w--------------------------------------------------------------------------------------------------------------------------------------------
    as Thanks Regards,Mahalingam

  • RELEVANCY SCORE 2.62

    DB:2.62:Ssrs 2005 Project In Vs 2008 j3


     Does VS 2008 support SSRS 2005 project?

    DB:2.62:Ssrs 2005 Project In Vs 2008 j3

     
    Hi,This forum is to support open specifications.
    After reviewing your questions,  I would suggest you start searching the forums in case someone has already asked a similar question.
    http://social.msdn.microsoft.com/Forums/en-us/categories/
    There are very helpful communities on Visual Studio that would help with your answer.You also can consider the Microsoft NewsGroups.http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
    Thanks,Edgar

  • RELEVANCY SCORE 2.62

    DB:2.62:Multiple Users Posting To Invoice 77



    Dear Experts,

    I have an AddOn made in .net 2005 wich creates multiple invoices per user, in this company there are multiple users trying to create invoices through this AddOn. Here are my questions...

    a. Would It be helpful if i use oCompany.InTransaction so that the "Posting to Invoice" process will be FIFO for scenarios that multiple users posts their invoices at the same time.

    b. Will it work on MS SQL 2005 ?

    c. Would you like me to post my code for clarifications?

    Best Regards,

    Frabulous

    DB:2.62:Multiple Users Posting To Invoice 77


    Hello,

    You can use the transaction object. You should know, that the huge global transaction is "blocking' the system.

    During the transaction, if your objects have any errors, the transaction is automatically rolled back.

    Usage:

    Try
    If oCompany.InTransaction Then
    MsgBox("Cannot start transaction, becuase the previous transaction has not been finished!")
    End If

    oCompany.StartTransaction()
    ' Do your transaction here
    '
    ' Commit the transaction
    oCompany.EndTransaction(BoWfTransOpt.wf_Commit)

    Catch ex As Exception
    If oCompany.InTransaction Then oCompany.EndTransaction(BoWfTransOpt.wf_RollBack)
    Finally
    GC.Collect()
    End Try

  • RELEVANCY SCORE 2.62

    DB:2.62:2005 Vs. 2008 Ssrs Export To .Pdf - Micr - Word - Excel s8


    We havereports that we use to export to a .pdf from SSRS 2005.The reportsuse a MICR Font in a particular textbox. This works fine in SSRS 2005
    We are testing SSRS 2008. When exporting to a .pdf in 2008, the MICR Font is not rendered in the .pdf. The Font is installed on the SQL Server as well as the local machines viewing
    the .pdf. We have tried several different MICR Fonts, and same result, no MICR font in the SSRS2008 rendered .pdf. When exporting to Word or Excel, the MICR font is working as it should. We had no issue with this in SQL 2005. Anyone have
    any ideas? Like I said, the 2008 SSRS exports display the MICR font in Word and Excel, but not in the .pdf

    DB:2.62:2005 Vs. 2008 Ssrs Export To .Pdf - Micr - Word - Excel s8


    Hi tommyzt,

    Thanks for your feedback.

    If you truly use the Microsoft Unicode font type, you can refer to the Jin Chens reply to apply the SP1 updating to your
    reporting services, with font embedding the documents can be viewed the same way as the report server regardless of the client environment.

    The thread you mentioned above link should be:
    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/58905ec1-d1a1-47c4-a73f-1ab0b448dda1

    Thanks,
    Bill Lu
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 2.62

    DB:2.62:Ssrs 2005 - Multiple Page Reports - Each Page With Different Types Data Region - Is It Possible ? How ? 38


    Hi friends,
    I need to developed one report in SSRS 2005.
    Report is of 6 pages. and each pages need to display with combination of different kind of Data Regions.
    Lets Say,
    1st page need to display one Chart and one table level summary for that page.
    2nd page need to display one Chart and two table level summary.
    3rd page need to display three charts and one table level summary for that.
    4th page No Chart - only display two table level summary.
    How to formate in Layout, so only perticulary charts and Tables display on appropriate pages.
    Each pages need to display data based on different kind of Products.
    pls provide guidance,suggestions or ideas.
    Thanks.

    DB:2.62:Ssrs 2005 - Multiple Page Reports - Each Page With Different Types Data Region - Is It Possible ? How ? 38

    What you have to do is establish each page as a subreport. Then the main report will act as an executive.Phil

  • RELEVANCY SCORE 2.62

    DB:2.62:Dynamic Image From Database ( Path) To Be Displayed In Ssrs 2005 da


    Hi,
    Am having a column in my database which contains id and path for images and not image files...
    i need to display images dynamically in SSRS 2005 based on input ID ...
    As i have only the path in my database , i couldnt display image based on path..

    Any help would be greatly appreciated...

    Regards,
    Gayathri

    DB:2.62:Dynamic Image From Database ( Path) To Be Displayed In Ssrs 2005 da

    Hi All,
    Thanks for your responses... but i t worked for me when i have my images in report server... but my problem isi have those image path in database...
    i want to display it dynamically from database and NOT REPORT SERVER.

    Regards,
    Gayathri

  • RELEVANCY SCORE 2.62

    DB:2.62:Multipel Invoices For The Same Material In J1ig For 561 Document zx



    Hi Friends

    We have faced an urgetn issue after uploading intial stocks

    1. We have uploaded inventory with 561 document

    2. We we having multiple invoices for the same material with different year, excise invoice number, date and other duty values

    3. we have uploaded multiple excise invoices for the same material in J1IG

    4. Invoice posted successfully

    Issue

    Now the issue is that,

    The material code is blank in J1IG-Display mode for the item for which there is a multiple invoices for the item.

    While posting J1IJ, user are not able to select the excise invoice for the material as system is not showing any excise invoices in J1IJ

    Can anybody help me in getting this fixed or any alternative to resolve this issue

    Thanks

    Ranjith

    DB:2.62:Multipel Invoices For The Same Material In J1ig For 561 Document zx


    Hi,

    First thing, J1IG is updated with reference to 561 material document. In J1IG, system copies material code, qty, UOM, etc from the material document. So, i don't understand, how material code went blank in J1IG. You should raise an OSS message for this issue.

    Alternative solution will be to update the material code manually in J_1IRG23D table then try J1IJ again.

  • RELEVANCY SCORE 2.61

    DB:2.61:Display Ssrs Report Using Two Select Statements k1


    Hi, I want my report to display results from two select statements. Basicly, one select statement is active users, and the other is non-active users.
    How do I structure the data tab of the report (I am using SSRS-2005)?
    Thanks
    Frank

    DB:2.61:Display Ssrs Report Using Two Select Statements k1

    Prasanna, YOU ARE THE GREATEST!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • RELEVANCY SCORE 2.61

    DB:2.61:Diff Bw 2005 And 2008 Ssrs? k3


    what is the difference between ssrs 2005 and 2008?

    DB:2.61:Diff Bw 2005 And 2008 Ssrs? k3

    For the differences SSRS 2005 / 2008 see
    http://msdn.microsoft.com/en-us/library/ms170438(v=SQL.100).aspxOlaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog
    Xing

  • RELEVANCY SCORE 2.61

    DB:2.61:Data Driven Subscription, Send Email With Multiple Reports Attached. xj


    Is there an option to send multiple reports attached in one mail via data driven subscription?
    We are sending invoices per data driven subscription and one email address will get more invoices per month.
    This works fine, but does generate a lot of email traffic. We may not render the invoices as one pdf file while the invoicing software (from the customer) sees every file as one invoice.
    Therefore we would like to send one mail with multiple reports as attachments. Is this possible using SSRS data driven subscription only?
    As the subscription tables hold the information we need to send the email (like address) we would like to use the data driven subscription functionality to send email and not use another service that needs configuration.
    Thanks in advance,
    Peter

    DB:2.61:Data Driven Subscription, Send Email With Multiple Reports Attached. xj

    Thanks all,
    Unfortunately, the customers do not have access to our local network, thus linking via url is not an option.
    So that leaves me no other option than creating an extra job that sends multiple files. (like SSIS)

  • RELEVANCY SCORE 2.61

    DB:2.61:Dependency Between Multiple Parameters In Ssrs 2005 m8


    Hi All,
    I have 3 parameters in a report.
    If i select first parameter(Country) then only should enable second parameter(State),
    Now if i select second parameter then should enable third parameter and also by default it should take all the values from that third parameter and display the report.

    NOTE: In third parameter i don't want to select any value .It should take all the values automatically

    Thanks in advance.

    DB:2.61:Dependency Between Multiple Parameters In Ssrs 2005 m8

    not sure you need code
    Assujming that countries states are in the same table (if not then method is the same but query is different)
    Param1 uses dataset 1
    SELECT distinct Country as Val, Country as lbl
    FROM CountryStateCityTable
    union
    SELECT '%' as Val, '(All)' as lbl
    Param2 uses dataset2
    SELECT distinct State as Val, State as lbl
    FROM CountryStateCityTable
    WHERE Country like @Param1
    union
    SELECT '%' as Val, '(All)' as lbl
    Param3 uses dataset3
    SELECT distinctCity as Val,City as lbl
    FROM CountryStateCityTable
    WHERE Country like @Param1 AND State LIKE @Param2
    union
    SELECT '%' as Val, '(All)' as lbl
    For Param3, also set the default value = '(All)'
    For each of the 3 parameters, set the value field = 'Val' and the label field= 'lbl'

    Rgds Geoff
    ----------------------------------------------------------
    Mark as Answer if this resolves your problem or Vote as Helpful if you find it helpful.

  • RELEVANCY SCORE 2.61

    DB:2.61:Ssrs 2005 Group Headers xk


    I have some data on a SSRS 2005 report set to autogrow.

    Sometimes it spans multiple pages. When the data spans multiple pages, group headers do not repeat.

    Does anyone know of a fix for this?

    DB:2.61:Ssrs 2005 Group Headers xk

    The report has the option Can Grow enable. Some of the data can span more than one page. When this occurs group headers in the table are not repeated.

  • RELEVANCY SCORE 2.61

    DB:2.61:Display Total On Top Of Stacked Chart cz


    hi Experts ,
    can any 1 let me know how to Display Total on top of Stacked Chart in SSRS 2008. or a detailed process of how to do it.. I have a blog which can do it in 2008 R2 but It's not working with SSRs 2005.
    I referred this blog.. it's exactly as i want.. but in 2005. this blog dosent work with 2005.
    https://community.altiusconsulting.com/blogs/altiustechblog/archive/2011/03/16/ssrs-charting-display-total-on-top-of-stacked-chart.aspx
    Thank you.

    DB:2.61:Display Total On Top Of Stacked Chart cz

    Just to update on this, that i have resolved this :)
    I have changed my data structure and captured the Total of all the fields in the Select statement as follows:
    SELECT [Function],SUM(Zero) as NotReported, SUM(NonZero) as OnPlan,SUM(DelayMilestoneCount) as Delayed,SUM(Completed) as Completed,(SUM(Zero) SUM(NonZero) SUM(Completed) SUM(DelayMilestoneCount)) as Total
    FROM ...
    the underline above is the sum of each row, and rest can be done by the BIDS 2008 for you. All you have to do is to drag and drop the the field in the category section of the chart along with the field you need the total for.
    For eg. in my case, i have drag/drop the Function and Total to the category field area, and the total for each function appeared with the brackets.
    even the above URL i have suggested for you is doing the same, i.e. changing the data structure to capture the total first. so its about the changing your query to capture the rite data and then rest will be not to difficult to achieve.

    Hope this helps you.
    Hope this helps.| Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |

  • RELEVANCY SCORE 2.61

    DB:2.61:Parameters With Multiple Values In Sql / Ssrs 2005 m3


    Hi ,
    I am writing SSRS 2005 (SQL 2005) report.
    In this report I have only one parameter @Param which is Query parameter i.e. writing in my SP at SQL level
    SELECT...
    FROM...
    WHERE column_type = @Param
    Now, this @Param is able to select multiple values in the SSRS report. I can handle this in SSRS by checkin the option allow multiple values and I can may be use JOIN function for this.
    But the question is how do I accomodate this in my SQL i.e. is it something like below ??
    WHERE column_type IN (@Param)
    Please advise. Thanks

    DB:2.61:Parameters With Multiple Values In Sql / Ssrs 2005 m3

    Hello,
    If I understand correctly, you want to filter the report data based on the field Column_name: the values of Column_name exist in the drop-down list of the multiple-value parameter Param, or the value Column_name is NULL. And then you can specify
    the filter condition as follows:
    1.Expression:=IIF(Instr(Join(Paramsters!Param.Value),Fields!Column_name.value)0 or IsNothing(Fields!Column_name.value) ,true,false)
    (Select Boolean on the second drop-down section ).
    2. Select “=” from Operator drop-down list.
    3. Type in “=true” in the Value textbox.
    If I have any misunderstanding, please let me know.
    Regards,
    Fanny LiuFanny Liu
    TechNet Community Support

  • RELEVANCY SCORE 2.61

    DB:2.61:Display Column In Ssrs a8


    Hello All,
    I am having issue with filtering the data in SSRS. Following is the table of records. I want to display
    LineNumber 0 and LineCode NY in my report for each invoices. The problem is
    LineCode NY can be on any of the LineNumber depending on the user entering the information. Is there a way in SSRS to find a way to dynamically select LineCode? Please help. Stuck with issue for too long

    DB:2.61:Display Column In Ssrs a8

    Any thoughts on this. Please help.

  • RELEVANCY SCORE 2.61

    DB:2.61:1sales Order-1delivery-Multiple Invoices??? as



    Hi All,

    1SO(Value 5000Rs.)-1DEL-5 Invoices(Each of Rs. 1000)

    Can we create 5 invoices, each of Rs. 1000/- ?

    ie

    1Sales Order-1Delivery-Multiple Invoices???

    Reg,

    Antaa21

    DB:2.61:1sales Order-1delivery-Multiple Invoices??? as


    You can achieve this by doing some coding in the copying control from delivery to billing document ,

    You include split logic as per your requirement and can be controlled through some maintanance table .

    Regards,

    SmartSD.

  • RELEVANCY SCORE 2.60

    DB:2.60:How To Display Varbinary(Max) That Contains Byte[] In Ssrs Report z3


    I have a field in the SQL server named Data with a datatype of varbinary(max). It contains array of bytes (byte[]). How will I display the byte[] into multiple rows in SSRS report?
    Thank you :)

    DB:2.60:How To Display Varbinary(Max) That Contains Byte[] In Ssrs Report z3


    I have this code in C# that converts byte[] to float[]

    for (int
    i = 0; i byteArray.Length; i=sizeOfFloat)
    retFloats[i / sizeOfFloat] =
    BitConverter.ToSingle(byteArray, i);

    where byteArray = varbinary(max), sizeOfFloat = size of float in bytes, retFloats = float[]
    Do you know how to write this using SQL or Stored Procedure?

    Thank you

  • RELEVANCY SCORE 2.60

    DB:2.60:Show/Hide Subreport Based On Date Value In Ssrs 2008 fa


    Dear All,
    I have one report with multiple sub reports. Based on the following expression, I show/hide my subreport. The problem is it is working fine in SSRS 2005 but it doesn't work in SSRS 2008.
    =iif(Format(Fields!createdon.Value, d-MMM-yyyy) 01-Mar-2011, False, True)
    Please help to elighten me how can I do in SSRS 2008.
    Thanks in advance!

  • RELEVANCY SCORE 2.60

    DB:2.60:Ssrs 2008r2 Report Not Rendered On Client Machines 7s


    After the upgrade of SSRS from SQL 2005 to SQL 2008R2, reports are not rendered on Client machine, after providing credentials multiple times. Same report works if run from the servers.

    DB:2.60:Ssrs 2008r2 Report Not Rendered On Client Machines 7s

    Thanks Charlie..Just to add to the issue..Plz refer the link below, which is similar to what Im facing..only difference is my machine is running on Win2K3 all Client machines are Win7. Reports works fine, if connected from inside the server locally,
    butif attemptedfrom any client machine,blankscreen shows up after3 loginattempts
    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/cf0f2331-852e-42f4-89bd-4c081d0464c1/
    All option available areexactly sameon the server are as specified in link still no luck...Exhausted all the options!!

  • RELEVANCY SCORE 2.60

    DB:2.60:Display Unicode In Ssrs Report fd


    I have multiple languages stored in the name column in sql server in unicode format. Ex. #20013;#26449; Can someone explain how do I show these in in SSRS report in the actual language?

    DB:2.60:Display Unicode In Ssrs Report fd

    Hi Rajakanna,there is no settings to do to dipslay unicode in SSRS Report.It automatically takes the data from sql server..in other words when u insert unicode value to Sql server. the sql server storesi t in diffrent format.But when u display it in ssrs report. U can be able to find the results as expected  instead 12223#003 and others.

  • RELEVANCY SCORE 2.60

    DB:2.60:Ssrs Page Break When Export To Pdf cx



    Hi,
    I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.
    I have grouped the report based on Invoice number, so that the invoices are printed sequentially and there will be page break after each invoice number. Within each invoice there is a header, body and footer.
    My issue is after the header is printed, an automatic page break happens after the header and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.
    I wish any one can solve this issue and grateful if they can give the solution for my problem.
    Thanks,
    Mahalingam

    DB:2.60:Ssrs Page Break When Export To Pdf cx

    Hi Nevermind,
    I thought you need custom breaking for custom page breaks we use the rectanles which will break based on the values .
    You can control thelarge no records by using the below expression in the group values.i considered 10 records for a page.
    =Ceiling(RowNumber(Nothing)/10)
    Thanks,
    Veeren.Thanks & Regards, Veeren Chowdary.

  • RELEVANCY SCORE 2.60

    DB:2.60:Onion Charts And Hovering Metadata In Ssrs 05 s7


     has anyone ever developed an onion chart in SSRS 2005, like the example below at this link?
    http://www.slate.com/id/2206356/Is there any way to get meta-data to display when hovering over data points in an SSRS 05 report?-dk 

    DB:2.60:Onion Charts And Hovering Metadata In Ssrs 05 s7

    We don't have a specific onion chart type in 2005, or 2008 for that matter.  For the meta data, in 2008 we added tooltips which you can add to just about any element of the chart.  My opinion on the onion chart though is that it's very difficult to understand the relative size of each ring.  It seems to suffer from many of the same problems that pie charts have.-SeanProgram Manager, SQL Server Reporting Services

  • RELEVANCY SCORE 2.60

    DB:2.60:Ssrs 2005 Report Expression In Matrix To Display Last 13 Month ? ja


    Hi friends,
    I want to display last 13 Month - to display on Matrix Report Column ?
    How is it possible using Report Expression ?

    DB:2.60:Ssrs 2005 Report Expression In Matrix To Display Last 13 Month ? ja

    Whatever you did till now is right. Follow bellow steps may that can help you.
    -GO to X-Axis Properties, Check Show labels ,Uncheck major gridlines, Check minor grid line, specify Interval for major gridline one value greaterthan Maximum value. Let say you put maximum = 1000 than interval will be 1001 that will solve your one problem.
    -DO samething for Y-axis properties.
    -But for this you have to put some expression for Maximum value and Interval in y axis properties.For X axis you can put anything.-Kishan --Mark it as Answer if this post helped you.--

  • RELEVANCY SCORE 2.59

    DB:2.59:Ssrs 2005 - Multiline In Text Box With Bold Line ? 3d


    Hi Friedns,
    I developed SSRS 2005 Report.
    I did multiline Text box , so it displaying me two line in one text box.
    But, i need to display Bold straight in between of that two Text.
    Below is my MultiLine Text Box.
    Total Count
    Total Revenue
    Now, i need below formate.
    Total Count
    _________ ---- Need Bold Straight Line in between this two.
    Total Revenue
    How we can do in SSRS 2005 ?
    Let me know if you need more information.
    Thanks.

    DB:2.59:Ssrs 2005 - Multiline In Text Box With Bold Line ? 3d

    Arun, thanks for the replying me.
    Arun, i followed your steps.
    In my Case , i have a Matrix , and i am implemented this on Matrix Subtotal Text Box.
    Line is displaying out side of Subtotal Text box of matrix.
    let me know.

  • RELEVANCY SCORE 2.59

    DB:2.59:Multiple Tables In Ssrs 2005 8p


    I have a report that required multiple tables in SSRS 2005. Is there any way to make the report so that one table is processed before all others.

    DB:2.59:Multiple Tables In Ssrs 2005 8p

    I'm not sureof the ordering of things, this is more of a question for the developers.Try two things. Make sure table_main is first in the order of the tables and make sure that the Dataset is before the others. If that doesn't work, then I'm not really sure.Sorry I wasn't able to help out that much. Hopefully one of the developers or SSRS team will be able to answer this.Josh George
    LiveLogic, LLC

  • RELEVANCY SCORE 2.59

    DB:2.59:Differences Between Ssrs 2005 And Ssrs 2008 k1


    HI,
    what is diffrences in ssrs 2005 and ssrs 2008.please help me....Thanks In Advance

    DB:2.59:Differences Between Ssrs 2005 And Ssrs 2008 k1

    Hi,
    Few of the major differences between SSRS 2005 and SSRS 2008 are as follows:

    SSRS 2005 report server requires IIS, whereas SSRS 2008 comes with a build-in web server and hence does not require IIS.SSRS 2005 is multiple services architecture (Windows Service IIS Service), whereas SSRS 2008 is a single service architecture (Windows Service) due to the presence of an inbuilt web server.SSRS 2005 deployment configuration involves lot of effort and a little bit of complexity due to the dependency on IIS, whereas SSRS 2008 deployment is much simpler especially with the help of Reporting Services Configuration Manager.SSRS 2005 has less visualization components, whereas SSRS 2008 has a very rich set of visualization components like Dials, Gauges, Sparklines etc.

    New Features in Reporting Services 2008 and 2008 R2

  • RELEVANCY SCORE 2.59

    DB:2.59:Vb Identifier For Giving Tab Or Multiple Spaces In Rdl File + Ssrs kk


    I am using SQL 2005 for report serverI am using VBCRLF identifier for new line in SSRS to replace , with new line.Likewise what is identifier used for giving tab or multiple spaces.The following tag works fine for new line but when i replace VBCRLF with vbTab i am getting an error as unrecognized identifier.
    =REPLACE(Fields!PreviousData.Value,

    , , VBCRLF)

    DB:2.59:Vb Identifier For Giving Tab Or Multiple Spaces In Rdl File + Ssrs kk

    I am using SQL 2005 for report serverI am using VBCRLF identifier for new line in SSRS to replace , with new line.Likewise what is identifier used for giving tab or multiple spaces.The following tag works fine for new line but when i replace VBCRLF with vbTab i am getting an error as unrecognized identifier.
    =REPLACE(Fields!PreviousData.Value,

    , , VBCRLF)

  • RELEVANCY SCORE 2.59

    DB:2.59:Ssrs 2005 Heading Repeat Problem. x1


    I have a SSRS 2005 report using a table to display data. I am using a parameter to change visibility of the first column depending upon the sort selected, so I am also using group headings to display the column headings (instead of a page heading)
    so that the column headings line up properly whether the first column is displayed or not. The group heading lines are marked to repeat, and one contains adataset field as heading information. The table has multiple detail lines defined,
    and the last line contains a text field (memo field) which can contain LOTS of data. If this field contains enough data that it takes an entire report page, the group heading is not displayed on this page, so all the column headings are gone for this
    page. That is my problem.
    There is a lot going on in this report, and the design, as it stands now, accomplishes all I need (dataset field in heading, optional column display with headings, proper sorting and breaking) with the exception of when this text field fillsan entire
    page...in this case, the headings disappear.
    Any thoughts on getting around this? Thanks!

    DB:2.59:Ssrs 2005 Heading Repeat Problem. x1

    Any further comment on this
    Challen, or another Microsoft Rep, would be greatly appreciated.

  • RELEVANCY SCORE 2.59

    DB:2.59:Ssrs 2005: Cant Choose Or For Multiple Filters - Always Uses And jm


    I have two filter conditions and I want an 'Or' between them, not 'And'. It does not appear that I am able to change the 'And' to 'Or'. Is this a limitation in SSRS 2005? I tried adding the filter on the dataset as well as on the report
    table and neither place allowed me to make the change.Janice Juszczec

  • RELEVANCY SCORE 2.59

    DB:2.59:Credit Memo Request With Referance To Multiple Invoices xc



    Dear All,

    How to create credit memo request with referance to multiple invoices.

    Regards,

    ramesh

  • RELEVANCY SCORE 2.59

    DB:2.59:Generate Ssrs Line Chart In Multiple Page. xm


    I have generated the columnchart using SSRS, but i am not able to generate the in multiple page if the chart had larg datas, please refer the link for my sample chart

    http://i1092.photobucket.com/albums/i405/vijaykalaiselvan/Chart.png

    and need to show the XAxis label clearly.

    I need to increase the chart width based on the dataset size.
    I am Using SSRS 2005 and

    Thanks

    vijay.k

    DB:2.59:Generate Ssrs Line Chart In Multiple Page. xm

    Thanks Eileen, We are decide to upgrade RS2008

    Thanks vijay.k

  • RELEVANCY SCORE 2.59

    DB:2.59:Report In Excel Multiple Sheets Name Required jc


    hi all
    i m working with ssrs 2008 when we export a Report in excelmultiple sheets will open. How we can give the sheet name according of that report. I know it is not possible till ssrs 2005 does ssrs 2008
    have any option to do that
    let me know about the same.
    best regards:
    ajeet

    DB:2.59:Report In Excel Multiple Sheets Name Required jc

    Hi ajeet,
    as mentioned by the previous poster, you can accomplish this starting with SSRS 2008 R2. An example with detailed steps is posted here:

    http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx
    HTH,
    RobertRobert Bruckner http://blogs.msdn.com/robertbruckner
    This posting is provided AS IS with no warranties, and confers no rights.

  • RELEVANCY SCORE 2.59

    DB:2.59:Display Multiple Records In Single Row -Ssrs Report.Ms Crm 2013 Online 9d


    Hi,
    I have a Account entity linked with Contact entity with 1:N relationship. I want to make SSRS report based out of this.
    In a single row, i want to show information of related records as well. Quick help would be appreciated.

    DB:2.59:Display Multiple Records In Single Row -Ssrs Report.Ms Crm 2013 Online 9d

    I can think of two ways to achieve this..

    First one
    one way to achieve this is using creating place holder field on account record, so create 4 contact ID fields on Account and have plug in which populates them when new contacts created/updated against account.
    this way you can build report against account and put this 4 fields on your report using standard report,
    but this solution will have limitation as mentioned below and even though it is not correct way to resolve this, this solution might work as per your requirement..
    1. only work with 4 contact records max.
    2. some development work required (to do plug in/ workflow) which updates record id on account
    3. storing duplicate data and same ids are present in related contact records..

    Second one
    There is one more way to resolve this by using SSRS Fetch XML based report, so create your report in online then download locally and modify as per your requirement. following steps might be involved for your requirement.
    1. create fetchXML report in SQL SSRS (refer this articlehttp://garethtuckercrm.com/2011/03/24/fetch-xml-reports-for-crm-2011-online/)
    or alternatively create report in CRM reporting wizard and download this report and add this report in your SSRS Solution
    2. once your have SSRS Report, you can modify existing report which might have table to replace this with Matrix (on right hand side on toolbar you will see open to add Matrix)
    3. in Matrix you can columns dynamically (please refer this video example on how matrix based report works,https://www.youtube.com/watch?v=99Slt49pYEk)

    Hope this helps...

    MayankP
    My Blog
    Follow Me on Twitter

  • RELEVANCY SCORE 2.58

    DB:2.58:Splitting A Column In Tabular Report Into Multiple Sub-Columns In Ssrs Tabular Reports mf


    Hi,
    I need to create sub columns in a tabular report in SSRS 2005. My report should be something like below. I cannot use matrix reports as my report has dynamic columns and 3 levels of row grouping. Please can anyone let me know how to split a column into multiple
    sub-columns in a tabular SSRS reports.

    Name

    Vth Std

    VIth Std

    VIIth Std

    English

    Maths

    Science

    English

    Maths

    Science

    English

    Maths

    Science

    Ram

    90

    80

    70

    70

    90

    80

    80

    70

    90

    Regards,
    Ram.Chaitanya

    DB:2.58:Splitting A Column In Tabular Report Into Multiple Sub-Columns In Ssrs Tabular Reports mf

    Hi Ram,
    From your description, it seems that there are three hierarchical row groups and two hierarchical column groups in the report. If so, I think a matrix control is the best choice. That is because a matrix grows horizontally and vertically at runtime. For
    more information, you can refer to:

    Working with Matrix Data RegionsHow to: Add a Dynamic Column or Row to a Matrix
    In this way, we can design a report as below:

    If you have any questions, please feel free to let me know.
    Regards,
    Mike Yin

  • RELEVANCY SCORE 2.58

    DB:2.58:We Have Migrated Ssrs Report From 2005 To 2008r2 But Report Not Showing Multiple Record For Same Project_Id In Sql Server 2008 R2 pa


    We have migrated ssrs report from 2005 to 2008R2 but report not showing multiple record for same project_id in sql server 2008 r2 its showing only one record please find attached screen shot

    I attached both report 2005 and 2008 r2
    I have checked all settings , setting are same on both server

    DB:2.58:We Have Migrated Ssrs Report From 2005 To 2008r2 But Report Not Showing Multiple Record For Same Project_Id In Sql Server 2008 R2 pa

    Hi Parul,
    Please run the store procedure in the query designer in SQL Server Reporting Services (SSRS) 2008 R2 and SSRS 2005. If you get the same result, then please check the dataset if there has any filter in it.

    Besides, there are some new features and break changes in SSRS 2008 R2, please refer to the link below to see if there are some break changes cause this issue:
    http://msdn.microsoft.com/en-us/library/ms143380(v=sql.105).aspx
    http://msdn.microsoft.com/en-us/library/ms170438(v=sql.105).aspx
    If the issue persists, please describe the structure of your report and provide us some screenshots about it, so that we can make further analysis.
    Regards,
    Charlie LiaoCharlie Liao
    TechNet Community Support

  • RELEVANCY SCORE 2.58

    DB:2.58:Ssrs 2005: Less Than Sign Displaying As Lt; When Report Viewed In Report Manager? s1


    A report in SSRS 2005, when viewed in report manager, is displaying the contents of a textbox incorrectly.
    The actual string value in the sql data is .01, but SSRS is displaying lt;.01 (without the space between lt;)-- how's this happening? What's the fix?
    It appears that SSRS is converting the less than sign into its html expression equivalent... makes no sense to m. Is there a way to force the textbox to accept the sting value as is without converting its display?
    Thanks in advance,Pete

    DB:2.58:Ssrs 2005: Less Than Sign Displaying As Lt; When Report Viewed In Report Manager? s1

    Turns out that the problem has nothing to do with SSRS.The data I pull from is based on a concantenation of values using FOR XML. Whenever FOR XML encounters or , it converts these characters to their expression equivalents of lt; and gt;, respectively.
    Thus, I merely needed to wrap a couple of replace() functions around the field to reconvert the expressions back to and .
    So, all is well.--pete

  • RELEVANCY SCORE 2.58

    DB:2.58:Ssrs 2005 ap


    Hi
    I have two dropdown controls. Initially i want to display one dropdown control. If i select one value in the dropdown control, the another dropdown control will display the value based up on the value selected in the first dropdown control. Whether it is
    possible in SSRS 2005 or not.
    Thanks
    Belfin

    DB:2.58:Ssrs 2005 ap

    Hi Belfin,

    As thethere exising answer work for your original question, I would suggest you mark the correct answerand postnew question in a new threadwithmore details about the currentscenario and the result you expected. And wewill
    provide you further assistance.

    Thanks,
    Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help

  • RELEVANCY SCORE 2.57

    DB:2.57:Is There A Way To Join Multiple Mdx Query Results To One Dataset? jx


    I have a situation where I need to display muliple numberic data with different scopes on a SSRS report under the same timeline. i.e. Complete Work, Baseline Work by Team and by Work Item Type. I know how to get the data I need for each scope using MDX query. But since SSRS 2005 doesn't support multiple datasets, I need to find out a way to Join the data together like in a SQL query. So far,  I haven't been able to find any MDX function that could do that. Any help would be appreciated!Kee

  • RELEVANCY SCORE 2.57

    DB:2.57:Duplucation Excise Invoice In Are1 Document z7



    Dear experts,

    I have created an ARE1 document (tcode: J1IA101) and assigned multiple excise invoices (04 excise invoices) in Internal document of ARE1 (not yet posted). When I display the ARE1 document (J1IA101 - Display) 08 excise invoices are being shown as assigned i.e. each invoice is coming twice. as a result, in print preview of ARE1 document, excise detail is coming twice.

    Kindly help how to solve the problem

    thanks in advance.

    DB:2.57:Duplucation Excise Invoice In Are1 Document z7


    Can you try in DEV systems, also compare plant and excise grp configuration in CIN.

  • RELEVANCY SCORE 2.57

    DB:2.57:Ssrs 2005, Period Format Function? f1


    Hi, I have dataset with column PERIOD like 0905, 0904, 0903, 0903,….0812,0811,…0712,0711,….
    I want PERIOD in Month-YY format like i.e. for 0905 I want to display as May-09, for 0904 as April-09 for 0903 as May-09,…..
    Any SSRS 2005 function pls. Thanks.

    DB:2.57:Ssrs 2005, Period Format Function? f1

    Try this expression , it may work =MonthName(Month(cstr(right( Fields.Inputparameter.value,2)) +/01/2000))+- +(left( Fields.Inputparameter.value,2) ~~ Mark it as Answer if you find it correct~~

  • RELEVANCY SCORE 2.57

    DB:2.57:Ssrs 2008 - Output To Single Or Multiple Page Based On The User Selection 1j


    We have to display the output in single view of report viewer control(i.e. long scrollbar).

    DB:2.57:Ssrs 2008 - Output To Single Or Multiple Page Based On The User Selection 1j

    Hi,You may try customize render extension. More info, see http://msdn.microsoft.com/en-us/library/ms155344.aspxThanks.Yao Jie Tang -Microsoft Online Community

  • RELEVANCY SCORE 2.57

    DB:2.57:Opening Ssrs 2005 In 2010 dj


    How to convert my SSRS 2005 project to vs 2010 project?test

    DB:2.57:Opening Ssrs 2005 In 2010 dj

    You mean you cannot open .sln file in BIDS?
    If you just double click on RDL file it will just open as XML file in BIDS/VS.
    If you want to open RDL file you need to create a Report Project/Solution first, then Right-click Reports folder in Solution ExplorerAddExisting Items.
    Hope this helps!Thanks, Michael Mei

  • RELEVANCY SCORE 2.57

    DB:2.57:Differences Between Ssrs 2005 And Ssrs 2008 R2? c8


    What are the differences between SSRS 2005 and SSRS 2008 R2?

    DB:2.57:Differences Between Ssrs 2005 And Ssrs 2008 R2? c8

    Please go through the post belowon same topic
    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/cb525609-79df-4671-8a3d-2d5eb5730274MSBI Developer

  • RELEVANCY SCORE 2.57

    DB:2.57:Can I Display Report Item From Sub Report In Footer 8x


    I am using SSRS 2005
    I have a field in a sub report that needs to be shown in the footer of the report. Normally, I would type something like =ReportItems!fieldname.value in a textbox in the footer. How do I reference a field in a subreport?
    The subreport is necessary as it deals with pagination issues with long fields that span to multiple pages.
    -Report Writer 'SSRS User'

    DB:2.57:Can I Display Report Item From Sub Report In Footer 8x

    Hi Report Writer 'SSRS User',

    In Reporting Services, the Subreport is designed only to display another report in the main report. So we are not allowed to retrieve data in main report.

    One possible workaround is to add the counterpart dataset and control of the subreport on the main report, and then we can refer to them utilizing ReportItem in the Page Footer.

    Thank you for your understanding. If you have any question, please feel free to ask.

    Regards,
    Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help

  • RELEVANCY SCORE 2.57

    DB:2.57:Joining Two Tables pd


    I imported two excel spreadsheets from excel to Access.  Invoice Register 2005 table and Invoice Register 2006 table.  These excel files were exports from peachtree.
    Each client can have multiple invoices in each of these registers. Each client though does have a unique client numbers but in these tables there are duplicate client numbers because off the multiple invoices created throughout the year.
    I created a query linking these two tables together and what is happening when I link the two tables using the Client ID numbers the invoices are listing more than once.
    Example there is a client with 3 invoices in 2005 and 3 invoices in 2006 (different invoice numbers) so in stead of listing six invoices for this one client there are nine records.  The query shows nine invoices but there are only six for this one client - it is duplicating some of these invoices twice.
    What I am trying to show is the client ID and Client name and the invoice register for 2005 and 2006.  Is this possible?
    Lborshard
     
     
     
     
     

    DB:2.57:Joining Two Tables pd

    phe,
    Thanks for the help the Union did work - what a learning experience. 
    The only thing now, is that I need  the 2005 Invoice Column/field and the 2006 Invoice column/ field to be seperate columns as I started with in the import.
    The query combined the 2005 and 2006 invoices underneath each other.  Is there any way I can list these two columns in the union query?
    lborshard
    Originally when I linked these two seperate tables together it seemed to copy/duplicate some of the invoice.  For example: one client had 3 invoices in 2005 and 3 invoices in 2006 - the client ID was the link - Instead of showing 6 individual invoice for that specific client it showed nine.
     
     

  • RELEVANCY SCORE 2.57

    DB:2.57:Cancel Multiple Invoices x8


    Hi Gurus,We can cancel invoice through MR8M. But how can we cancel multiple invoices?Please revert asap.Thank You

    DB:2.57:Cancel Multiple Invoices x8

    hicancelling multiple invoices is not possible u have to create LSMW recording for this and then process all required invoices regardsKI

  • RELEVANCY SCORE 2.57

    DB:2.57:Legend Display Setting In Ssrs 2008 dj


    In SSRS 2008 when you have only one series , it displays the name of series in legend series 1. But when you have more than one series group it displays with the true series name in legend box. However, in SSRS 2005 for the same report ,legend box displays
    the true series name whether I have one or many series groups. Is there any way to control how legend displays the selected series name insteady of series 1 in SSRS 2008? What I want to do is replacing series 1 with Quarter1 in legend box in SSRS
    2008.
    Below is how legend displays series group in SSRS 2005 and SSRS 2008 respectively,

    Quarter 1
    Quarter 2

    DB:2.57:Legend Display Setting In Ssrs 2008 dj

    Hi,
    note the legend text for series can be configured.
    In Report designer,

    select the series go to Series Properties go to Legend Custom Legend Text is what you are looking for
    Programmatically, theChartSeries classhave a property called
    ChartItemInLegend, which may allow you to achievethe same result. (I did not test it, though.)

  • RELEVANCY SCORE 2.57

    DB:2.57:Is Vbtab Supports In Ssrs 2005 81


    I am using SSRS 2005 for displaying reports in report viewer.I have used vbcrlf in rdl files expression to replace , with new line. it works fine for vbcrlf.=REPLACE(Fields!PreviousData.Value,, , VBCRLF)But if vbcrlf is replaced with vbTab then i am getting error as unrecognized identifier.=REPLACE(Fields!PreviousData.Value,, , vbTab)Is i am wrong in syntax or vbTab is not supported in ssrs 2005 but resolved in ssrs 2008.Or can anyone plz suggest me how should i display value in textbox with multiple spaces or by giving tab in between values.Expected output in a textbox:Empname:ABC         EmpID:123         EmpAddress:XYZ

    DB:2.57:Is Vbtab Supports In Ssrs 2005 81

    Hello Priyanka,you can use the SPACE(3) function for displaying three blank spaces.you can specify any valid int value for the argumentChandra, http://www.ggktech.com

  • RELEVANCY SCORE 2.56

    DB:2.56:Does Repeatwith Parameter Work In Ssrs 2008 xk


    Does anyone know if the RepeatWith parameter of a Line works in SSRS 2008?We have a report that has a header, rectangle, and footer.  Inside the rectangle is the data table, table1.  It is an invoice form that needs to repeat vertical lines not only at the edges of the rectangle, but also to separate the columns of the table, and the lines need to always go to the bottom of the page, so using the right and left borders of the text boxes in the tables won't work.  We got this to work in SSRS 2005 by drawing vertical lines inside the rectangle to separate the columns of data, and setting the RepeatWith Property of each line to be table1 (our data table that is inside the rectangle).We are currently trying to convert to SSRS 2008 and the lines only display on the first page of the report, they will not repeat on multiple pages in preview or PDF.  Has anyone been able to get this to work in SSRS 2008?   Any help would be greatly appreciated.

  • RELEVANCY SCORE 2.56

    DB:2.56:Multiple Condition Checks In Ssrs Fields s3


    Hi i have a column name CODE in ssrs 2005 report which displays values like ES,GB,FR,SE and i have another column VALUE which should display values based on 1st column values(CODE) . The values in 2nd column should display like ES-Spain,FR-France,SE-Sweden.
    I want to implement a condition based on values in first column, i tried different options but of no use.
    Can someone guide me on this issue, i want to have multiple condition check in in expression of VALUE Field.

    Thanks
    Achuth

    DB:2.56:Multiple Condition Checks In Ssrs Fields s3

    Hi achuthkumar,
    Is the value ES,GB,FR,SE inone row'stextbox(left) or different rows' textbox(right)?
    ES,GB,FR,SE | ES
    |GB
    | FR
    | SE

    Ifin one row's textbox,I would recommen you achieve this requirement in SQL backend just like Rakesh's advise, you can create a table to store the information about the relationship of (ESE, S-Spain),(FR,FR-France),(SE,SE-Sweden)......Then create
    a new datafield in your report's dataset.
    If the value in different row's textbox just like the right sample report, I think you can make use of Switch function to build the relationship between (ESE, S-Spain),(FR,FR-France),(SE,SE-Sweden)......
    For more information about switch function in reporting services, please see
    http://msdn.microsoft.com/en-us/library/ms157328.aspx
    Thanks,
    Challen Fu

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 2.56

    DB:2.56:Csv Export 2005 Vs 2008? ff


    In SSRS 2005 when I exported to CSV nothing from my headers were shown in the resulting file. However in SSRS 2008 I now see data. In my header I display the report name, so in the csv file I receive the report name on every line. Is there any way to turn this feature off in SSRS 2008?Thanks.