is there a way to merge datasource views?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Reporting Svcs
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Installing SRS where terminal services exists, or both .net 1.1 We are attempting to install Microsoft Dynamics CRM to a client site and have found that it just won't install.. The problem appears to be in installing SQL Reporting Services. They have an SBS 2003 SP1 Premium box as well as a Server 2003 Standard box - the server 2003 box is where they wanted to install CRM, and we were told all it ran was Blackberry server (I know, where SBS is involved, usually one would usually run MS CRM SB and put it on the same box as SBS - but the client didn't want to do this). What we later found out is that it also has terminal services amongst other things - and SQL Server Reporting services does NOT like terminal services, even using change user /install and change user /execute or add/remove programs.. So we then resolved to install SRS on the SBS premium box. On the premium box it complained it couldn't find Visual Studio - ok, no problems, we don't want to do any customisation on this system at this point. It also complained that it couldn't find .net 1.1 and that sharepoint services were installed. I read the notes on deregistering SRS from Sharepoint so that's ok.. As it said it couldn't find ASP.net 1.1, I downloaded the dotnetfx file and attempted to run it. It told me that ASP.net 1.1 WAS on the system. I then went to IIS Manager and found that indeed 1.1 was registered and that it was enabled, with 2.0 disabled. How do I get SRS installer to see .net and therefore install? Are there any other caveats I need to be aware of? Regards, Anthony Tag: is there a way to merge datasource views? Tag: 63714
  - 2
    - Average Percentage in Matrix Subtotal I have a matrix like the following: Period 1 2 3 4 etc. Should be: name1 3% 1% 2% 3% 2.25% name2 4% 2% 1% 5% 3% etc. Should be: 3.5% 1.5% 1.5% 4% I want to get the average percentage along the bottom row and the last column. Using subtotals it just adds all the percentages. Is there any way to do this? I've seen a lot about InScope but I'm not sure if it would help or how to use it. -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200612/1 Tag: is there a way to merge datasource views? Tag: 63713
  - 3
    - Barcode not Printing when exported to PDF This seems to be an issue for a lot of people. Is there a workaround for this? I am using 3of9.ttf it is on the report server and my local machine. the barcode shows up inthe web view but disappears in the saved/printed pdf. Tag: is there a way to merge datasource views? Tag: 63710
  - 4
    - How to use two aggregate functions in RS 2005 I am not able to use two aggregate functions to display a value in a table. Basically it is (Sum of (Sum of X)). How do we get around this? Please let me know. Thanks Tag: is there a way to merge datasource views? Tag: 63705
  - 5
    - How to add parameter for file name for subscription Hi, I working on Report Delivery by "Report Server File Share". I like to add parameters into the name. for example, report name is "order". there are paremeter name "startdate" and "endate". I'd like to change the filename "order_startdate_12_1_06_enddate_12_2_06" something like that. Is there any way to attach parameters to FileName? Thanks Ken Tag: is there a way to merge datasource views? Tag: 63704
  - 6
    - Render to PDF not printing all data I have aliased fields in my footer pointing to textboxes that are in a header/rectangle in a table. When rendered to the webpage the information is there and shows in the report viewer, but when its rendered to PDF for printing the information disappears. Before its asked, the activeX print control is giving us fits(taking several minutes to print) and this is our current workaround. but its not working around very nicely. Tag: is there a way to merge datasource views? Tag: 63703
  - 7
    - Page Break at start or end give a blank page I have a report with 2 groups. I want the inner group to page break before each new group. At the end I do not want it to throw a new page but to print the outergroup footer at the end of the report e.g Publisher Year Book title Year footer page Break ...etc. last page: Publisher Year Book title Year footer Publisher footer With no pagebreak between the year and publisher footers. I have tried using pagebreak at start but that leaves me with a blank page at the start of the report. I have also tried putting the calculation for publisher footer in the year footer, but then I get a blank page at the end of the report. Does anyone have a good answer or workaround? Michelle Tag: is there a way to merge datasource views? Tag: 63702
  - 8
    - How to extract dates from text string? We have a CRM application used for trouble ticketing. It doesn't have a field for the start date/time of the ticket or last action. Instead I have a text field which looks like this: Ticket created. Assigned to user davidp -- Friday 10th November 2006 12:36:41 PM by davidp--//-- -- Friday 10th November 2006 12:37:01 PM by davidp--//-- Transferred to group Support Group\. -- Monday 13th November 2006 02:06:39 PM by davidp--//-- -- Thursday 16th November 2006 10:47:40 AM by davidp--//-- Status Changed to Wait For Response\. Priority Changed to Normal\. Category Changed to Other Problem\. -- Thursday 16th November 2006 10:49:46 AM by davidp--//-- Priority Changed to 3 - Minor\. Category Changed to PC - Software\. -- Monday 04th December 2006 01:28:12 PM by davidp--//-- Or this: Ticket created. Assigned to group Support Group -- Thursday 16th November 2006 03:31:50 PM by davidp--//-- Status Changed to Closed\. -- Thursday 16th November 2006 03:59:30 PM by davidp--//-- I want to add a calculated field to extract the first and last dates & times in the string so I can use them in my report. Can anyone help? Tag: is there a way to merge datasource views? Tag: 63700
  - 9
    - Full-page watermark I need to add a full-page watermark to a report. In other words, an image that runs right to the edge of all printed reports. Is this possible? Anyone? Jeppe Jespersen Denmark Tag: is there a way to merge datasource views? Tag: 63699
  - 10
    - rsExecutionNotFound error on SSRS I got an error on SSRS, the story is, I installed Frontpage extension 2002 and then connect to 'localhost\reports\" from vs2005, then error comes up, before that the SSRS is running without any problem. The error message is Microsoft.Reporting.WebForms.ReportServerException: Execution 'sk024b30xmofwc45xeweqz45' cannot be found (rsExecutionNotFound) All the reports are only show this error message with difference executionID. When i try to create new reports, I can view the new report without any problem in my VS2005, but once published, the same happen in "localhost\reports\" Regards, Ken Lin Tag: is there a way to merge datasource views? Tag: 63698
  - 11
    - Linked subreports not showing Hi, I've been given the task of trying to sort out an issue with a linked report. Suppose we have Folder A for UserGroup A and Folder B for UserGroup B. Folder A has a report Report A which has sub reports A.1, A.2 and A.3 and we want to also grant UserGroup B access to this report and so set up a linked report to Report A and put the linked report in Folder B. The problem is, none of the sub reports (A.1, A.2, A.3) are showing when UserGroup B try to run the linked report. I've tried linking the sub reports also but this does not work. Is this actually possible or would I need to merget the report with its sub reports? thanks Matt Tag: is there a way to merge datasource views? Tag: 63694
  - 12
    - Group Printing Did you solve this? I have the same problem! Tanks for any info. If you've not solved it and you e-mail me if/when I figure it out I'll let you know. EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Tag: is there a way to merge datasource views? Tag: 63691
  - 13
    - Reporting Services Architecture Hi, In the company that I work at, we already have Reporting implemented for internal reporing use only. However, today my boss asks me if the RS can be open to the public. Let's say I have a client called "ABC" company. In order to give them better customer service, he would like to let user outside my company to access Reporting Services. That means I need a report server so that all web serivces will point to the report server if the clients want to view the report. The reason why they want to do that is we have a reporting group working in the company and it is easy to use and quick to generate the report. More importantly, it can easily generate the graphs on the report. My question is: 1. I have never used/seen any public websites that provide reporting services as part of the website. Is that a norm to post reporting services to the public? If so, is there any security problem and what need to be concerns? 2. I would like to suggest to my boss to use the data driven subscription to send emails along with attachments of the report to the client on scheduled time in stead of posting it to the public online. Is that a good way to do it rather than open the RS to the public? Any suggestion or idea is very appreciated Ed Tag: is there a way to merge datasource views? Tag: 63689
  - 14
    - How To: Install RS 2005 on SQL2005/Win2003 2-node Cluster Hi all, I'm trying to install Reporting Services 2005 on my 2-node SQL 2005/Win 2003 Cluster. I know RS is not cluster-aware. I've created a separate Instance to house the RS databases and plan on having RS run on only one of the nodes (licensing costs are preventing us from utilizing a web farm). How do I manually configure RS. I've been trying to create a virtual directory with a "$" in it, but it continues to error out. Can't seem to find any specific info on how to do this. Thanks for your help. tmk Tag: is there a way to merge datasource views? Tag: 63686
  - 15
    - Fix a Table size on the Report? Hi, i have a report for a printing purpose (on A4 size). Its a bill witch have on the top the adress etc. On the bottom are some other informations. My problem is now, i have in the middle of this report a table witch hold a few products for this bill. => if the product amount is greater then 3 pieces (rows) the bottom part its going on a second page :-( How can i fix the maximum size of this table? Thanks in advance for any Help Volkan Tag: is there a way to merge datasource views? Tag: 63683
  - 16
    - Data Source Wizard "Connection Manager" dialog box too big - can't use buttons When I am creating a new data source using the Data Source Wizard under VS 2005, the dialog box titled "Connection Manager" is too big for my screen - it is too tall. My video is running at 1024x768 resolution, and that dialog box takes up 75% of the visible screen, plus extends off the bottom. Because Windows won't allow the caption (top of the window) to go beyond the edge of the screen, I can never see or use the buttons that I believe lie at the bottom. My work-around is to press the TAB key one, two or three times after the last visible field in the dialog box and then press ENTER. For example, tabbing three times past the end of the dialog box seems to be a "Help" button, though I have never seen it. Other dialog boxes in the Reporting area also appear quite large. ---Wayne Erfling Tag: is there a way to merge datasource views? Tag: 63676
  - 17
    - Error: Subreport could not be shown Main report with 1 subreport, 1 parameter passed into the subreport, works fine in the report designer/Preview mode. But, When using C# codes to set ReportPath and ReportDataSource and use WindForm - reportviewr to refresh the report, always got "Error: Subreport could not be shown" in the subreport, works correcly in the main report part with the codes. Also, had try to remove parameter, same error in the subreport after reportViewer.RefreshReport(); Any clues would be very much appreciated! Tag: is there a way to merge datasource views? Tag: 63675
  - 18
    - Setup Web Service Identity When I go into Configure Report Server on my 2005 server, I get a red X on the Web Service Identity item and the ASP .NET Service Account is greyed out so I cannot setup this configuration. What can I do to complete this? Thank you. David Tag: is there a way to merge datasource views? Tag: 63674
  - 19
    - REport Definitions hi, I have created a report in RS 2005 but i want to use in RS2003 how i change the report definitions in the current report to make it compatable in RS 2003 Thanks in advance, Regards, Somu Tag: is there a way to merge datasource views? Tag: 63671
  - 20
    - Custom code dataset access Is it possible to access fields in a dataset from custom code in the report with out passing them into the custom functions as arguments? In other words, I want to write custom code that receives no arguments, is able to read fields in the reports' dataset, perform some logic, and return a value. Thank you all in advance. Tag: is there a way to merge datasource views? Tag: 63670
  - 21
    - CRITICAL:Web Reports Printing Slowly We have just deployed a solution to Beta Testing. The reports are taking anywhere from 30 seconds to 3 minutes to print using the activeX printcontrol on the ReportViewer window. If we export the report to PDF it only takes about 5 seconds. I have done some searching but have not found anything that is listed for this issue. Where can I look and what can I do to increase this performance? This is unnacceptable for our application. Tag: is there a way to merge datasource views? Tag: 63669
  - 22
    - Create Model from Cube Hi, When i try to generate model from Adventure Works DW i receive this error: Errore durante la generazione del modello semantico: [Crea ruoli da dimensioni di gruppi di misure]Index (zero based) must be greater than or equal to zero and less than the size of the argument list.. () (Microsoft.AnalysisServices.Modeling) Or in english, i think it should be: Error during create semantic model:[create role from dimension group] Index (zero based) must be greater than or equal to zero and less than the size of the argument list.. () (Microsoft.AnalysisServices.Modeling) Somebody can help me please? Thank Stefano Tag: is there a way to merge datasource views? Tag: 63668
  - 23
    - Subreports with report viewer control Hi all, i need to create subreports using report viewer control. i have to do it using only vb.net. how can i achieve this ? please provide some input and examples.i am totally blank and need really help from u people. thanks in adv to all miiki Tag: is there a way to merge datasource views? Tag: 63666
  - 24
    - Hiding field by asking if another field is empty Hello, I need to hide a field (or retangle) by asking if another field in the report, like text field (or some other entity i can create on the fly, that is not a Data field) for eg: I create a text field in a retangle. The text field include expression that determine what data to display, if any. I want to hide the retangle if the text field if empty. So, can i use in an expression somthing other then a Data field or a Parameter? Thanks in advance, Eitan perry Tag: is there a way to merge datasource views? Tag: 63657
  - 25
    - How to pass parameter from webform to reportviewer vb.net hello all, I have developed a form with a dropdown box and added reportviewer component to the webform. The report has a parameter staffname. Can you guys advice how to pass the value selected in the dropdown box as a parameter to the reportviewer. The code i have used, which dosent work: Protected Sub ddlStaffName_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlStaffName.SelectedIndexChanged Dim params As Microsoft.Reporting.WebForms.ReportParameter = New Microsoft.Reporting.WebForms.ReportParameter("@StaffName", ddlStaffName.SelectedValue, True) Me.ReportViewer1.LocalReport.SetParameters(params) End Sub Thanks in Advance. Tag: is there a way to merge datasource views? Tag: 63655
- Next
  - 1
    - Adding a Web Server to RS 2000 I currently have my report server and my reporting services database on two different machines. My company is now wanting to add another machine on the web server/service side. Can anyone refer me to a good article on how exactly to do this without killing my first machine and database? Thanks Scott Tag: is there a way to merge datasource views? Tag: 63651
  - 2
    - Cheap Export to Word I was wondering how everyone (if anyone) is exporting reports to Word? Does anyone know of an open source attempt at this or even one that is only a few hundred bucks? Thanks Scott Tag: is there a way to merge datasource views? Tag: 63650
  - 3
    - report builder ad hoc reporting Using SS2000 data with RS2005. If I build a report with report builder, is there a way to see what query the report builder is using to generate the report? I've built a model and created a report from the model. If I create a query in query analyzer to check the results that are generated by the report builder report, I'm off by quite a bit. If I could see the query that the report builder is generating maybe I could figure out where the problem is. Thanks, -- Dan D. Tag: is there a way to merge datasource views? Tag: 63645
  - 4
    - group by.... Hi, I am new to RS... here is problem. Its a simple report which shows the detail of top sale performers Nationally. We have 4 regions... east, west, north and south. I the report detail I print out a report card.... showing each performer's detail... somthing along the lines Region Rep $<sales> $<commission> ...... I want to have a snapshot at the top which will list the 4 regions and numbers of reps from each region that made the cut.... National Summary: East 4 West 5 North 16 Sount 0 I dont want to query the DB again as I already have that info. Basically I need to use a group by <region> in reporting serices with counting the reps? How do I accomplish this? Tag: is there a way to merge datasource views? Tag: 63643
  - 5
    - Navigation to a spreadsheet tab from a report In the textbox properties, navigation tab, I am trying to use the "Jump to URL" Hyperlink Action to jump to a spreadsheet tab. The following expression does not work: ="[http://bull/data/portacct/performance/latest_perf.xls]" & Parameters!Acct_Code.Value & "!A1" (A similar expression =HYPERLINK("[http://bull/data/portacct/performance/latest_perf.xls]"&B8&"!A1") works in Excel.) Any ideas on how I could make this work? Or will this only work if I convert the latest_perf.xls into HTML file(s) and use those as a target? TIA. Tag: is there a way to merge datasource views? Tag: 63641
  - 6
    - Two tables in a list with shared datasource I have a need to embed two tables within a list, all of which share the same datasource, for a reportâ?¦or at least thatâ??s my thinking. The purpose for it is to iterate through each drawing within an area within a department displaying info for each drawing; at the end of each area, I need to display totals for that area. As it is, Iâ??m able to display data similar to below: Architectural Department Area A1 DwgCode DwgScale HoursPerDwg CADD Comp 0001 1/4â?? 7.0 10 0 0002 1/4â?? 7.5 0 12 0005 1/16â?? 7.0 13 0 Area A2 DwgCode DwgScale HoursPerDwg CADD Comp 0003 1/4â?? 7.0 0 10 0004 1/4â?? 7.5 0 12 0007 1/16â?? 7.0 13 0 That part is easy, but what I need is to display the data similar to below: Architectural Department Area A1 DwgCode DwgScale HoursPerDwg CADD Comp 0001 1/4" 7.0 10 0 0002 1/4â?? 7.5 0 12 0005 1/16â?? 7.0 13 0 Total CADD: 23 Total Comp: 12 Area A2 DwgCode DwgScale HoursPerDwg CADD Comp 0003 1/4â?? 7.0 0 10 0004 1/4â?? 7.5 0 12 0007 1/16â?? 7.0 13 0 Total CADD: 13 Total Comp: 22 Instead, what I get is similar to below: Architectural Department Area A1 DwgCode DwgScale HoursPerDwg CADD Comp 0001 1/4" 7.0 10 0 Total CADD: 23 Total Comp: 12 0002 1/4â?? 7.5 0 12 Total CADD: 23 Total Comp: 12 0005 1/16â?? 7.0 13 0 Total CADD: 23 Total Comp: 12 Area A2 DwgCode DwgScale HoursPerDwg CADD Comp 0003 1/4" 7.0 0 10 Total CADD: 13 Total Comp: 22 0004 1/4" 7.5 0 12 Total CADD: 13 Total Comp: 22 0007 1/16â?? 7.0 13 0 Total CADD: 13 Total Comp: 22 Does anyone have an idea how I can accomplish what I need for this report? Thanks for any and all help. Tag: is there a way to merge datasource views? Tag: 63637
  - 7
    - Can the subscription subject value @ExecutionTime be formatted? Is there a way to apply formatting to the @ExecutionTime expression in a subscription subject line? Tag: is there a way to merge datasource views? Tag: 63635
  - 8
    - Subscription parameter expressions Is there a way to use an expression in a subscription's parameter settings? I want to use a sliding date range for a report without having to use the default settings for the report. Do they only support literal values? Is there a way to do this? For example: Start Date: "=Today.AddDays(-7)" End Date: "=Today" This way i can run a report for the last 7 days. Any ideas? Tag: is there a way to merge datasource views? Tag: 63634
  - 9
    - When rendering subreport RS tries to fit it on one page. Hello I am using RS for SQL Server 2005. I have one problem: I have embedded subreport in my report. The subreport contains quite many rows. The problem is: RS tries to fit subreport on one page so even though there is space on the first page of main report subreport is printed on a new page. Thanks in advance for your help. Tag: is there a way to merge datasource views? Tag: 63632
  - 10
    - Error in Locale when passing datetime parameter? Hello! I am using RS supplied with SQl Server 2005. I have one report and two subreports inside it. One of the subreports is embedded and another one can be navigated using hypertext link. All reports have one datetime parameter which is entered by user in the main report and passed to subreports. But when in the main report I enter 1-st of november 2006 in subreports it becomes 10-th of january 2006. All reports have language = default. When debugging report (F5) everything is ok. The problem comes out when publishing report to report server. Any suggestions/advises are welcome. Tag: is there a way to merge datasource views? Tag: 63631
  - 11
    - Using multiple fields in a single expression I have a value field and a group field in my dataset. Can I have an expression that sums the value field where the group field is equal to "A"? Tag: is there a way to merge datasource views? Tag: 63628
  - 12
    - Programming reporting service HELP Hello guys; I i have just found the solution to my problem but would like to full understand the solution so would be great full if you could enlighten me. OUR Set-up Server A = <WEBSERVER> SERVER B = <SQLServer & ReportingServer> Both in workgroups(but on the same domain) behind firewall. user logs into website, request a client report. connection made to webserver <Server A> webserver quiers Reporting Server <Server B> Reporting Server quiers SQLServer <Server B> Report Displayed in client browser Topic A: Web.config file on Server A <identity impersonate="true" userName="userX" password="userXpassword"/> Q) am i right in thinking with this setting in your web.config file you will be impersonating userX that has been setup on Server B and assigned the proper rights. Topic B: Passing credential as opposed to impersonating userX (Using form authentication to log users in - checking against user table in database) Q) Basically the user will select a report, once this selection is made the parameter collection is queried to get the required parameters for the report using this collection the appropriate control values are taken from the controls on the web page. to make system more secure i would prefer to pass the credentials from within the code. from my reading i figured that i have to 1) create a credentialcache and populate with user info i.e. code: Dim report As String = strReportPath & strReportName Dim forRendering As Boolean = False Dim historyID As String = Nothing Dim values As webServ.ParameterValue() = Nothing Dim credentials As webServ.DataSourceCredentials() = Nothing Dim parameters As webServ.ReportParameter() = Nothing 'Create an instance of the CredentialCache class. Dim cache As Net.CredentialCache = New Net.CredentialCache() 'Add a NetworkCredential instance to CredentialCache. 'Negotiate for NTLM or Kerberos authentication. cache.Add(New Uri(rs.Url), "Negotiate", New Net.NetworkCredential("userX", "userXPassword", "domain")) rs.PreAuthenticate =True 'Assign CredentialCache to the Web service Client Proxy(myProxy) Credetials property. rs.Credentials = cache ' get parameter parameters = rs.GetReportParameters(report, historyID, forRendering, values, credentials) 2) create a credential class that implements 'Microsoft.Reporting.WebForms' = (ReportVererCredentials) i.e code: dim clsObj as New ReportVererCredentials("userX", "userXPassword", "domain") ReportViewer1.ServerReport.ReportServerCredentials = clsObj I cant understand why i have to pass the credential twice in two different ways. but if i don't i get an "401 error access denied" as i said this code now works but im not sure if im am doing things correctly can you advise. Topic C I have a test web server that i use to run the website and it works fine on that but when i move the same code to my Main web server i get an error on the line dim clsObj as New ReportVererCredentials("userX", "userXPassword", "domain") COMPLIE ERROR MESSAGE: BC30002 Type 'ReportVererCredentials' is not defined. any ideas what this is, am i declaring the class 'ReportVererCredentials' properly Imports System.Web Imports System.Web.Services Imports System.Web.Services.Protocols Public Class UserObj Private Shared intID As Integer Public Shared Property ID() As Integer Get Return intID End Get Set(ByVal value As Integer) intID = value End Set End Property Private Shared strUserName As String Public Shared Property UserName() As String Get Return strUserName End Get Set(ByVal value As String) strUserName = value End Set End Property Private Shared intPermission As Integer Public Shared Property Permission() As Integer Get Return intPermission End Get Set(ByVal value As Integer) intPermission = value End Set End Property Private Shared intClientID As Integer Public Shared Property ClientID() As Integer Get Return intClientID End Get Set(ByVal value As Integer) intClientID = value End Set End Property Private Shared intEnabled As Integer Public Shared Property Enabled() As Integer Get Return intEnabled End Get Set(ByVal value As Integer) intEnabled = value End Set End Property End Class i also have the <add assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> in the web.config file a lot I know but your help most appreciated phil Tag: is there a way to merge datasource views? Tag: 63626
  - 13
    - Report Bodytext in various Languages? we need to format the bodytext on our reports in various languages. We created a Table in SQL Server: ReportLocalizationBodytext ID, strItem, strText, intLanguage 1, page, Seite, 1 2, page, Page, 2 etc... hundrets of entries We created a Stored Procedure: usp_RPTS_GetBodytext Input Parameters are: @ intLanguageID, @intReportID to identify the current report and the desired Userlanguage returned output-table of the stored procedure is: Select strItem, strText from ReportLocalizationBodytext where intReportID = @intReportID and intLanguage = @intLanguage And now begins the headache: Any one report contains around 20 diferent text labels which have to be localized. Currently we created one dataset for each text label. E.g. the text "Page 1 of 9 pages" needs at least three labels to be translated: "Page", "of" and "pages" so we have three Datasets like: bdytxtPage, bdytxtOf and bdytxtPages Each dataset receives the same 20 items and filters via a Report Definition Language Datase Filter its one only text translation, like: expression, operator, value =Fields!strItem.Value, =, page The final entry in the report-textbox is: =First(Fields!strText.Value, "bdytxtPage") & Globals.PageNumber & First(Fields!strText.Value, "bdytxtOf") & Globals.TotalPages & First(Fields!strText.Value, "bdytxtPages") In english there may be printed: Page 3 of 9 pages In German Seite 3 von 9 Seiten and so on Question: Wouldn't it be possible to create one lonely dataset e.g. Bodytext and then derive each bdytxtText from this complete dataset rather than to go out 20 times for each and every single word to retrieve each time the same dataset, but filter it in a different way? Tag: is there a way to merge datasource views? Tag: 63623
  - 14
    - Date Filter in Report Builder The "On or Before" filter does not work with the 'On' part of the filter i.e. On Or Before 30/11/2006 does not show items for 30/11/2006 but does show 29/11/2006. Is this a bug or maybe i'm missing something. Regards Tobi Tag: is there a way to merge datasource views? Tag: 63618
  - 15
    - Report Builder Date Range Filter When selecting From To date range filter you can no longer choose prompt for input. Why is this? Is there a fix for it. I can replicate the required functionality by using On or Before and On or After but it seems a bit messy. Regards Tobi Tag: is there a way to merge datasource views? Tag: 63615
  - 16
    - how to export an existing report in "custom" format i have an aspx-page which displays a reportingservices - report. i want the user to have the choice to export the report in a format he can choose (excel, pdf, xml, cvs). how can i export the existing report without being forced to call the render-method again? i tried to write the data to the response stream by setting the ContentType and adding an Header. This does not work though: Response.ContentType = "application/vnd.ms - excel"; Response.AddHeader("Content-Disposition", "attachment; filename=myReport.xls"); Response.BinaryWrite(report); i guess it's a pretty simple solution. can anybody help me please? thanks a lot in advance! JJ Tag: is there a way to merge datasource views? Tag: 63613
  - 17
    - Can this be done in the reporting services (SQL 2005) Based on the data in the SQL server table (Customers address table) I want to print letters (with individual customers address) as a pdf file? This is similar to Form Letters in Word document and use mail merge but my requirements is letters needed as a pdf file and the whole process should be an automated scheduled task? Tag: is there a way to merge datasource views? Tag: 63610
  - 18
    - report builder - need help reporting from multiple tables I created a data view and model that has two tables joined (one to many relationship). When I go into report builder, I see both entities available for me. When I click one of the entities, I am able to select that entities data items to drag onto my report. However, the other entity disapears. If I delete all the fields from the report, both entities are available again. So it appears as if I can have as many entities defined as I want, but can only use one at a time to report on. I know I am doing something wrong because I have seen samples that do what I am looking for - I just can't figure out how to do it. Tag: is there a way to merge datasource views? Tag: 63596
  - 19
    - Programming Reproting services Hello guys; I i have just found the solution to my problem but would like to full understand the solution so would be great full if you could enlighten me. OUR Set-up Server A = <WEBSERVER> SERVER B = <SQLServer & ReportingServer> Both in workgroups(but on the same domain) behind firewall. user logs into website, request a client report. connection made to webserver <Server A> webserver quiers Reporting Server <Server B> Reporting Server quiers SQLServer <Server B> Report Displayed in client browser Topic A: Web.config file on Server A <identity impersonate="true" userName="userX" password="userXpassword"/> Q) am i right in thinking with this setting in your web.config file you will be impersonating userX that has been setup on Server B and assigned the proper rights. Topic B: Passing credential as opposed to impersonating userX (Using form authentication to log users in - checking against user table in database) Q) Basically the user will select a report, once this selection is made the parameter collection is queried to get the required parameters for the report using this collection the appropriate control values are taken from the controls on the web page. to make system more secure i would prefer to pass the credentials from within the code. from my reading i figured that i have to 1) create a credentialcache and populate with user info i.e. code: Dim report As String = strReportPath & strReportName Dim forRendering As Boolean = False Dim historyID As String = Nothing Dim values As webServ.ParameterValue() = Nothing Dim credentials As webServ.DataSourceCredentials() = Nothing Dim parameters As webServ.ReportParameter() = Nothing 'Create an instance of the CredentialCache class. Dim cache As Net.CredentialCache = New Net.CredentialCache() 'Add a NetworkCredential instance to CredentialCache. 'Negotiate for NTLM or Kerberos authentication. cache.Add(New Uri(rs.Url), "Negotiate", New Net.NetworkCredential("userX", "userXPassword", "domain")) rs.PreAuthenticate =True 'Assign CredentialCache to the Web service Client Proxy(myProxy) Credetials property. rs.Credentials = cache ' get parameter parameters = rs.GetReportParameters(report, historyID, forRendering, values, credentials) 2) create a credential class that implements 'Microsoft.Reporting.WebForms' = (ReportVererCredentials) i.e code: dim clsObj as New ReportVererCredentials("userX", "userXPassword", "domain") ReportViewer1.ServerReport.ReportServerCredentials = clsObj I cant understand why i have to pass the credential twice in two different ways. but if i don't i get an "401 error access denied" as i said this code now works but im not sure if im am doing things correctly can you advise. Topic C I have a test web server that i use to run the website and it works fine on that but when i move the same code to my Main web server i get an error on the line dim clsObj as New ReportVererCredentials("userX", "userXPassword", "domain") COMPLIE ERROR MESSAGE: BC30002 Type 'ReportVererCredentials' is not defined. any ideas what this is, am i declaring the class 'ReportVererCredentials' properly Imports System.Web Imports System.Web.Services Imports System.Web.Services.Protocols Public Class UserObj Private Shared intID As Integer Public Shared Property ID() As Integer Get Return intID End Get Set(ByVal value As Integer) intID = value End Set End Property Private Shared strUserName As String Public Shared Property UserName() As String Get Return strUserName End Get Set(ByVal value As String) strUserName = value End Set End Property Private Shared intPermission As Integer Public Shared Property Permission() As Integer Get Return intPermission End Get Set(ByVal value As Integer) intPermission = value End Set End Property Private Shared intClientID As Integer Public Shared Property ClientID() As Integer Get Return intClientID End Get Set(ByVal value As Integer) intClientID = value End Set End Property Private Shared intEnabled As Integer Public Shared Property Enabled() As Integer Get Return intEnabled End Get Set(ByVal value As Integer) intEnabled = value End Set End Property End Class i also have the <add assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> in the web.config file a lot I know but your help most appreciated phil Tag: is there a way to merge datasource views? Tag: 63595
  - 20
    - Extend PDF rendering? Hi, I have a report which is pretty wide. I currently use a 3rd-party pdf renderer which allows me to specify that the pdf needs to fit-the-report-to-the-page. This then adjusts the fonts etc. to squash the report to fit it on an A4 landscape. Can I do the same for the out-of-the-box pdf renderer? Can I derive from it and extend the renderer? Thanks in advance, Regards, Datta Tag: is there a way to merge datasource views? Tag: 63594
  - 21
    - Alternate row in diffrerent colors Hi, I wish to change the back colour for alternate rows in a report (say Table). I haven't found anything that tells me the current-rownum. The RowNum seems more like a row-count. Please help!! Thanks in advance, Regards, Datta Tag: is there a way to merge datasource views? Tag: 63593
  - 22
    - Multiple tables in the dataset Hi, I have a stored proc which returns multiple result sets. I think SSRS picks up the first one by design. What's the best way forward, a data extension, or is there a simpler way? Thanks in advance, Regards, Datta Tag: is there a way to merge datasource views? Tag: 63592
  - 23
    - Custom columns in HTML Renderer Hi, Is there a way to add custom columns in the html renderer? E.g. I would like to add a javascript pop-up menu in a clolumn, with links to navigation reports based on values of other columns in a row (something like but not exactly a drill through). Does the custom report item allow anything else but images? In case a custom html renderer is the only way forward, can I derive from the existing HTML renderer and extend its functionality? Thanks in advance, Regards, Datta Tag: is there a way to merge datasource views? Tag: 63591
  - 24
    - What is the role of Reporting Services ? I am new to VS 2005 and SQL Server 2005. We recently bought an application for creating and delivering management reports that require us to install .NET Framework 2, Crystal Reports XI Runtime, SQL Server 2005 with reporting services & set up IIS. From the web, I find that it should be a CR XU application for Web Services. However, I just wonder why they require to get the SQL Server 2005 Reporting Services installed ? Besides, it requires us to set the remote connection as "TCP/IP and Named Pipes". Since all out clients are running Windows XP, does this requirement is for other company that may still using Windows 98 ? Thanks Tag: is there a way to merge datasource views? Tag: 63590
  - 25
    - Values missing I'll see if I can explain this thoroughly: I have a report that has 2 tables. Both Tables get data from the same data set but each are filtered to the type of data. There will alays be data in table 1 but may or may not have data in table 2. I have a text field within the report that describes which item the report is for. this field comes from the same dataset as the to tables. the problem is, when there is data in both tables available, the textfield shows what it is supposed to. But when there is no data in table 2, the textfield is blank. I have been able to solve this by placing table 2 in a subreport, but this makes the report take hours to complete where it only takes minutes to complete without the subreport. It looks as if the textfield only desplays data if there is data to display in table 2, even though there is data in the first table. All of the data comes from the same dataset. Any help muchly appreciated. -- John Cleveland Network Manager Urban systems Ltd Tag: is there a way to merge datasource views? Tag: 63588

I have created several datasource views. What I would like to do is
create one datasource view that contains all the tables. What I would
like to do is import the contents from one of my pre-existing
datasource views into a new one. Is this possible?

Top

Re: is there a way to merge datasource views? by Jeje

Jeje
Wed Dec 06 19:15:37 CST 2006

DSV file are XML files...

have you try to copy/paste some content from your files?

risky... so ... backup backup backup...

"steve" <stevensherman@comcast.net> wrote in message
news:1165451673.077999.187810@j72g2000cwa.googlegroups.com...
>I have created several datasource views. What I would like to do is
> create one datasource view that contains all the tables. What I would
> like to do is import the contents from one of my pre-existing
> datasource views into a new one. Is this possible?
>

Top

Re: is there a way to merge datasource views? by steve

steve
Wed Dec 06 19:32:47 CST 2006

That is a good idea. I was thinking of that also, but was wondering if
perhaps there was a utility that took care of it for me.

Top

Re: is there a way to merge datasource views? by Jeje

Jeje
Wed Dec 06 19:37:53 CST 2006

maybe using the API?

its certainly possible to create by code some table, links etc...

try to push your DSV into an SSAS database and use the ADOMD API.

I don't know if there is another way to access it.

"steve" <stevensherman@comcast.net> wrote in message
news:1165455167.285174.34870@j72g2000cwa.googlegroups.com...
> That is a good idea. I was thinking of that also, but was wondering if
> perhaps there was a utility that took care of it for me.
>

Top