Expressions in RS

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
    - How do I get the user's selected parameter values from the HTML Vi How do I get the user's selected parameter values from the HTML Viewer in order to pass the USER'S SELECTED parameter's in the render method. Code.GetReportParameters only gets me the defined parameters, but does not retrieve the user's selected parameter's on the HTML Viewer. mSQLReportServer.GetReportParameters(mstrpath & "/" & mstrReportName, Nothing, False, Nothing, Nothing) I need the parameters to pass through to the Render function below. The report expects three parameter's. Dim ReportData As Byte() = mSQLReportServer.Render(mstrpath & "/" & mstrReportName, "Exel", Nothing, Nothing, ReportParameterValues, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing) -- Erol Tag: Expressions in RS Tag: 30821
  - 2
    - Specific order of running dataset statements? Hi all, I was wondering whether there was a specific order in which dataset statements are run in. The reason for this is that rather than have multiple stored procs to return data that is essentially drawn over one work table, I was thinking of having 3 datasets: The first populates a work table with data as well as returning a small SQL select statement The second dataset is a SQL statement over the work table The third is also a SQL statement over the work table You see the second and third datasets depend on the first one to run first so that the work table is populated with data. How can I achieve this? Tag: Expressions in RS Tag: 30813
  - 3
    - Access Denied and Server Error after RS Installation I have installed Reporting Services on a computer running Windows Small Business Server 2003 with IIS 6.0 and MS SQL 2000 Standard Edition with SP3a. During the installation, it does not allow me use NETWORK SERVICE as Service Account to access RS so I selected Domain User as Administrator instead. At the end of the installation it told me it could not automatically configure/start reporting services and that it needed to be done. The server is a domain controller and the proxy server. When I go to the page for ReportManager I get an access denied and the ReportingServices page has a page cannot be displayed error. Any help is greatly appreciated. Also I have tried to activate RS by using rs command referred in RS Book Online but it does not work too. Tag: Expressions in RS Tag: 30812
  - 4
    - MSAccess Database Can i connect to MSAccess Database in reporting services? If so, any sample connection string? My mdb is stored in C:/test.mdb Thanks Tag: Expressions in RS Tag: 30809
  - 5
    - beginndate and enddate as parameters ich want to report inforamtions between one begindate and enddate.the begin and the enddate can i give as Parameters.In the ReportParameters Tool i have indicated this 2 Parameters as DateTime typ and in the SQl Query i wrot but i have got wrong Results.i have wrote the sql Query as follows: SELECT Format(TimeLogged, 'dd/mm/yyyy hh:nn') AS TimeLogged, OriginatorAddress, RecipientAddress, SUM([Size]) AS TotalTrafficVolume, COUNT(*) AS TotalItems, AVG(DeliveryTime) AS AvgDeliveryTime FROM MailTraffic WHERE TimeLogged >= @startdate AND TimeLogged < @enddate GROUP BY OriginatorAddress, RecipientAddress, TimeLogged; Can you help me ??? Tag: Expressions in RS Tag: 30808
  - 6
    - Features request Hi all. I've been working with RS for a month or so migrating all our client-side reports (MS Access) to server-side (RS). I have a bunch of them to be converted yet but I think I have some experience and can do some suggestions to a product that is a very good product to be the 1st version. I hope next version in SQL Server 2005 improves some things like: * Add the option to select a RGB color for using it as transparency for the Image control: You can add transparencies to the images themselves when using GIF or PNG formats. However when images are bitmaps, since bitmap format does not have support for transparency layers, it would be usefull to have that support from RS itself. * Render to .SNP format (MS Access Snapshot format). * Within the VS IDE, when you copy a group of controls and paste them in another report, they are not located at the same X,Y positions as they were in the original report, but at the middle/center of the space they have been inserted into (parent). I think that report designers would prefer to paste the copied controls in the place they were instead of another coordinates that sometimes are not aligned to the grid either (even though align to grid is active). * When you copy a control named MyUserRenamedControl1 (a textbox for instance) and paste into the same report, since that control name is already used, the new control is named TexboxX (being X a free number that makes the name unique in the report). I think that if report designers have renamed a default name component to another name (for whatever the reason), the IDE should try to keep the same name and add numbers to the end of the name that the designer has selected. In this case the names of new controls should be MyUserRenamedControl2, MyUserRenamedControl3, etc. * Rounded corners for rectangles, components for circles, ellipses, oblique text (number of degrees selectable). This might be of less use for many people, mainly when they use RS to generate pure-listing reports. However if you use RS to generate invoices or other kind of documents that need quality and be visually attractive, this kind of improvements would help a lot. Regards and congratulations for such a good work. Tag: Expressions in RS Tag: 30806
  - 7
    - Reporting Services 2005 requires which SQL Server version? Very quick question - as our customers have mission critical databases and will not allow us to upgrade right after Yukon is released, can Reporting Services 2005 use SQL Server 2000 to hold it's databases? If so then I can upgrade the non-critical report servers and leave the databases alone for the moment. Thanks in advance, James Snape Tag: Expressions in RS Tag: 30805
  - 8
    - Legend error when customized color on a bar graph Hi, I have a bar graph which displays per department (5) the status of the x incidents. Late incidents are Red, Next week indients are green, etc etc ... When I try to add the legend below the bar graph, the color are mixed on the legend, I mean Late is red in the graph and green in the legend. I have customized my colors using a formula in the appearance tab. Does anybody have an idea ? Thanks. Tag: Expressions in RS Tag: 30804
  - 9
    - 'My Reports' folder not being created for some users Hi, I was just nosing around the DB, and I noticed that all the users are in the 'users' table, but the user accounts don't appear in the 'PolicyUserRole' table, and hence there are not any policies for them. I don't know if this helps any or just confuses... And there aren't any application events in the log on the server, either. "Lance" <lance@[nospam]keayweb.com> wrote in message news:11869vtmjhs8i08@corp.supernews.com... > Hi, > Thanks for the reply, but I am a bit confused about it! Maybe if I explain > a bit more about the setup: The ReportServer is set up with no common > reports. Each user can *only* view the reports in their own 'My Reports' > folder. As such each user *must* have a 'My Reports' folder! (obviously) > > Here is how the server is set up: > * There are the standard 'Item-level' roles and an additional one, > 'Viewer' - which is a limited acct, that just allows the user to 'view > folders' and 'view reports'. None of the non-admin users can create > reports. > * The 'System Roles' are the standard 'System Administrator' and 'System > User' - the 'System User' has the 'View report server properties' and 'View > shared schedules' tasks. > * The 'Enable My Reports to support user-owned folders for publishing and > running personalized reports.' checkbox is checked in the 'Reporst Server' > 'Site Settings'. The 'Choose the role to apply to each user's My Reports > folder' dropdown is 'Viewer' > > To set up for a new user: > * Each new user is added to the 'Users' group on the server (windows 2000 > server). > * The user logs in, and a 'My Reports' folder should be created. > > But mostly, a 'My Reports' folder is *not* created. Or perhaps just not > shown. I don't know how to check whether there is a 'My Reports' folder for > the user - I am thinking that there is a value in the DB somewhere that > tells me... > > I was experimenting with a dozen new users, and the docs say that as soon as > a windows user logs in, a 'My Reports' folder should be created. I tried > both creating a 'System Role' for the user and *not* creating a system role, > but the creation of the 'My Reports' folder seems to occur randomly. I say > *seem*, as I am sure that I am missing a step or something, as I confess > that I find the role assignment somewhat confusing. But I'm new, and I am > sure I'll get used to it... > > > In response to your kindly answer: > So, from my limited understanding, the 'My Reports' role is an 'item-level' > role; I can only seem to assign to this at the report level (ie an 'item') > *not* to a user. But if the 'My Reports' folder is not being created, I > can't assign this 'tiem-level' role to it! > > > In short: I am still stuck with some users having a 'My Reports' folder and > most users *not* having one! > Thanks, > Lance > > > > > > > Lance, > > > > Have you checked to ensure all users are are included in the "My Reports" > > role - or in some custom role that includes the required permissions. > > > > Regards, > > > > > > -- > > Rob Labbé, MCP, MCAD, MCSD, MCT > > Lead Architect/Trainer > > Fidelis > > > > Blog: http://spaces.msn.com/members/roblabbe > > > > "Lance" <lance@[nospam]keayweb.com> wrote in message > > news:11849vnplj1n02@corp.supernews.com... > > > Hi, > > > I am having some trouble getting the 'My Reports' folder to appear for > all > > > users. The docs just say that as long as the user exists as a windows > > > user > > > and the 'My Reports' option is ticked in 'Site Settings', ReportServer > > > should just create a 'My Reports' folder the first time a user logs onto > > > the > > > ReportServer. But this is not working for all users. About half of the > > > users have the 'My Reports' folder created. So I need to know how to > > > create > > > them manually, or at least some workaround to get each user a 'My > Reports' > > > folder! > > > > > > I don't see any difference between the user accts (other than the > names). > > > > > > Thanks, > > > Lance > > > > > > > > > > > > Tag: Expressions in RS Tag: 30801
  - 10
    - Sort by value from a sub report? Hi, Is it possible to sort a Table using value from subreport with in the table? My main report has the following structure: ... <Table> ... <Header> ... <ReportItems> <Subreprot> my_sub_report which executes its own stored procedure. </Subreport> </ReportItems> </Header> <Grouping Name="group1"> <Parent>=Fields!CaseKey.Value</Parent> </Grouping> ... ... my_sub_report has "txt_AnItem" which contains the value I want to sort the table with. Is the "txt_AnItem" referable from within the main report? Siew Fai. Tag: Expressions in RS Tag: 30797
  - 11
    - Help, how to export to PDF with Chinese characters I try to save in PDF. Everything is ok, but ... Chinese characters. In PDF, chinese characters will become strange symbols. Should I take some setting before exporting to PDF? I had updated RS Service Pack 2, and Acrobat 7.0 Thanks!!. -- work, lots of works Tag: Expressions in RS Tag: 30794
  - 12
    - Stored procedures in Oracle I've followed the instructions in Robert Bruckners earlier mail about this subject (http://support.microsoft.com/default.aspx?scid=kb;en-us;834305 and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcontheadonetdatareader.asp ). But I can't get it to work. I've created the following stored procedure in oracle: ------------------------ create or replace package body Stored_Procedures is Procedure ACNamen(p_acnamen Out refcur) Is Begin Open p_acnamen For Select * From activiteitencentra; End; end Stored_Procedures; ---------------------------- I've made an "oracle"' data source When I type ACNamen in the SQL-pannel or Stored_Procedures.ACNamen I get errors: "Invalid SQL statement" and "MinimumCapacity must be non negative" Would appreciate some help. Tag: Expressions in RS Tag: 30790
  - 13
    - Help!. Images not Displaying Hello i have made a report and inserted some company logo in the report header ,,, from the image wizard i selected Embeded type ,, But when i run the port in asp.net by calling its webservice ,,,images are not shown. Plz help me to solve this problem Thanks Tag: Expressions in RS Tag: 30788
  - 14
    - getting the total sum below the page sum hi all, looking at the previous thread i know how to get a page sum in the footer , but is there any method for me to insert a total sum below the footer? as i cant place a text box in the footer and set the expression as sum of a field in the table.(footer wont allow sum of field) what i can do now is a total sum above the page sum. thanks in advance. Tag: Expressions in RS Tag: 30785
  - 15
    - getting sum group by page number hi all, i got a table, how can i get the sum of total ONLY for each page?(not sum of the whole table) thanks in advance Tag: Expressions in RS Tag: 30780
  - 16
    - Ask: Feature of Reporting Service Dear All, Since Reporting Service is part of SQL Server 2000. Is there any features difference of Reporting Services which is part of SQL Server 2000 Enterprise Edition and Reporting Services which is part of SQL Server 2000? Thanks Robert Lie Tag: Expressions in RS Tag: 30772
  - 17
    - Hyperlink to send an Email Hello, I am looking for a way for users to click on a textbox and send an Email. I got that to work if I set up 'On action' URL to 'mailto:myemail@mycompany.com'. My problem is this email address is variable. If a user clicks next to A then Email should go to A@myemail.com and if they click next to B email should go to B@myemail.com so on and so forth. I have A and B here is value in my field MYFIELD. I tried using mailto:Fields!MYFIELD.value that won't work. Any ideas will be appreciated. Thanks. Tag: Expressions in RS Tag: 30771
  - 18
    - a quick question about subscription when I create a subscription through report manager it work ,but if I create the subscription through my application (I'm using my own domain credentials to authenticate to the server).It dosen't work. Any idea? Thanks Tag: Expressions in RS Tag: 30769
  - 19
    - Bookmark Functionality and HTMLFragment I have a report displayed within a frame. A different frame in the frameset is posting parameter values to this report display frame. The bookmarks on the report do not work when displayed within the frame. The onclick javascript command is not created for the bookmarks. I have the following HTML configuration settings: Format = HTML4.0 Toolbar = False Parameters = False HTMLFragment = True If I set the HTMLFragment = false, the bookmarks work, but my subreports are not rendered in IE (but the subreports are rendered in Firefox), instead I get the typical red X indicative of a missing image. When I view the report via Report Manager, the bookmarks work correctly. When I include the toolbar on the report, the bookmarks work correctly (and I see the bookmark onclick code generated when I view the source of the report). Any help appreciated. Tag: Expressions in RS Tag: 30768
  - 20
    - installing client side printing activex control Our workstation support has locked down our client workstations so they can't download and install activex components. All software is installed by Zenworks when the user logs into the workstation using elevated privileges. If I install sp2, I think the client will not allow the control to be installed (I haven't tried it yet). Can I install the activex control at login time the way we do other software packages? If so, is there a place I can download the cab file to test before I upgrade my server. I don't want to set up a test server and install report services just to get my hand on this one file. Can someone point me to a publicly available web page that uses this cab file? Tag: Expressions in RS Tag: 30764
  - 21
    - Licensing: SQL Reporting services on SBS? Is the Small Business Server SQL Server license sufficient for the use of the Reporting Services on the SBS (2000 or 2003 Premium) or there has to be separate SQL Server license? Thanks for info, Martin Tag: Expressions in RS Tag: 30761
  - 22
    - Hide document map label using expression When a report item is hidden, its document map still shows. I would like to access the hidden attribute of the item (in this case they can be table or chart, but I believe the model to be the same). I can't seem to find the object model how to access that attribute. I tried ReportItems!table1.hidden, ReportItems!table1.visible, ReportItems!table1.Visibility and they all say those attributes do not belong to the member. Anyone can point me to the doc? I'll try to dig around and find the dll for reporting services and see if object browser might help. Thanks. Tag: Expressions in RS Tag: 30757
  - 23
    - Export report to an *existing* Excel spreadsheet Hello all - I have a report that I need to export to an existing Excel spreadsheet, but I haven't seen so far any options where I can accomplish that. For example, I have a generic skeleton spreadsheet that contains two worksheets, "PivotTable" and "DetailData". The PivotTable worksheet contains a pivot table that is bound to data in the DetailData worksheet (stating the obvious, I know.) Based on the parameters entered in the Reporting Services report, I want to populate the DetailData tab with the corresponding data. That way, when the user opens the spreadsheet, it will contain the data based on the selected parameters, and the pivot table will be refreshed. I've explored 3rd party components, which work like a charm whether it be a Windows or a Web application, but they can run in upwards of $5,000 per processor. That said, I'm looking for a more cost effective solution where I can do everything withing Reporting Services. I realize too that I can use Excel automation to programmatically manipulate the spreadsheet generated from Reporting Services, but server-side Office automation is a NO-NO due to its instability and inability to scale. Anyone have any ideas on how to accomplish this? Thanks for your help! KSA@discussions.microsoft.com Tag: Expressions in RS Tag: 30752
  - 24
    - HELP - PDF Rendering not working New to reporting services. I have a report rendering in HTML4.0 just fine using web services. Changing the rendering to PDF with content-type and content-length header makes the PDF appear as a blank page when rendering. If I add a content-disposition header and save the file download off as a .pdf and then view it in adobe reader (v6) it looks just fine. Somehow I can't seem to get the PDF to display. The web page just comes up blank - no errors, no hits, no runs and I guess no one left on base...... code below... any suggestions..... Dim rs As New ReportingService rs.Credentials = New System.Net.NetworkCredential("me", "mypass", "mydomain") ' Render arguments Dim x As Integer Dim result As Byte() = Nothing Dim reportPath As String = "/My Reports/MembersPayments" Dim format As String = "PDF" Dim historyID As String = Nothing Dim devInfo As String = "<DeviceInfo><PageHeight>8.5in</PageHeight><PageWidth>16in</PageWidth><Toolbar>False</Toolbar></DeviceInfo>" ' Prepare report parameter. 'Parameters are optional but must be defined as nothing Dim parameters() As ParameterValue Dim credentials As DataSourceCredentials() = Nothing Dim extensions As Extension() = Nothing Dim showHideToggle As String Dim encoding As String Dim mimeType As String Dim warnings As Warning() = Nothing Dim reportHistoryParameters As ParameterValue() = Nothing Dim streamIDs As String() = Nothing Dim sh As New SessionHeader rs.SessionHeaderValue = sh result = rs.Render(reportPath, format, historyID, devInfo, parameters, credentials, showHideToggle, encoding, mimeType, reportHistoryParameters, warnings, streamIDs) Response.ClearContent() Response.AppendHeader("content-length", result.Length.ToString()) Response.ContentType = "application/pdf" Response.AddHeader("Content-Disposition", "Attachment; filename=C:\Myfilepdf1.pdf") Response.BinaryWrite(result) Response.Flush() Response.Close() sh.SessionId = rs.SessionHeaderValue.SessionId Tag: Expressions in RS Tag: 30751
  - 25
    - subscription I have a set of emails in my app which I'd like to execute a report for them and send it to them "ONCE ONLY",next time emails are changed,parameter of the report is changed and I don't want to have schedules.At the same time I'd like to snapshot the report into the file system.How should I do it? Thanks Tag: Expressions in RS Tag: 30749
- Next
  - 1
    - Connection Pooling for Data-Driven Subscriptions? Is there any way to get a data-driven subscription to share the DB Connection between iterrations? The behaviour we're seeing currently is a new connection being opened/closed for each report delivered by our data-driven subscription. This is impacting our server perf. Suggestions? Pointers? Did I miss anything in the docs? TIA Tag: Expressions in RS Tag: 30747
  - 2
    - Querying Active Directory From SQL Server in report I set up a view in my SQL Server so that i can query ADSI like in this article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_94fn.asp Everything works fine from Query analyzer, but when i try to select from the view in the Reporting Services Designer DataSouce it gives me the following error. "Could not generate a list of fields for the query. Check the query syntax or click Refresh Fields on the query toolbar. An error occurred while preparing a query for execution against OLE DB provider 'ADSDSOObject'." I've tried it with SQL Authentication as well as Integrated Window Authentication. My Query is as follows using the SQL OLE Provider. Select * from vADSI My View is as Follows. CREATE VIEW dbo.vADSI AS SELECT * FROM OpenQuery( ADSI, '<LDAP://DC=myDomain,DC=com>;(objectClass=user);name, adspath, title;subtree') Seem simple enough. Like i said, works fine from query analyzer. Bombs in Reporting Services. Please help pctc_IT Tag: Expressions in RS Tag: 30746
  - 3
    - Need to Conditionally Supress a Subreport HELP! I've seen a message thread from July of 2004 about this and it never got fully answered. I'm hoping some one has come up with an answer by now. I have a subreport that is pulling data based on one parameter from the main report. Sometimes, the subreport comes up with 1 row, sometimes several, and sometimes it returns nothing but null or blank fields. When it returns null or blank fields, no matter how I size it on the main report, it takes up a good inch to 1 & 1/2 inches of white space on the report and will not "collapse". I need to suppress (not hide) the subreport completely if it has null or blank values. Essentially, I want to get rid of the white space if there's nothing to print, but I want it to show or print if there are values in it. Is there anyway to do this? Or can a subreport pass a value back to the main report I can use for formatting purposes? The one thing I hate about RS is its complete lack of a true supression capability (like Crystal has). You have to jump through hoops to get the white space to disappear from a report when something is hidden. PLEASE, Microsoft, fix this issue with your next version!!! White space = poor readability & paper waste = less trees = everyone on the planet becomes blind and sufficates due to lack of oxygen... ..or maybe I've just read too much Dilbert. @=) Anyway, if someone could let me know if that problem has been resolved, is going to be resolved or there's a work around, I would appreciate it. Catadmin -- MCDBA, MCSA Random Thoughts: If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back??? @=) Tag: Expressions in RS Tag: 30743
  - 4
    - Subscription I have a set of emails in my app which I'd like to execute a report for them and send it to them "ONCE ONLY",next time emails are changed,parameter of the report is changed and I don't want to have schedules.At the same time I'd like to snapshot the report into the file system.How should I do it? Thanks Tag: Expressions in RS Tag: 30742
  - 5
    - parameter in URL passed to Report is not working anymore Any suggestions??? Below is my URL, and the report works fine from report manager, and the parameter is SchoolCD spelled exactly as it is in both places? It was working and now all of a sudden it has stopped working. SchoolCD = Request.QueryString("SchoolCd") ReportViewer1.ServerUrl = "http://servername/ReportServer" ReportViewer1.ReportPath = "/TechReports/SummarybyTypeLocation" & _ "&SchoolCd=" & SchoolCD & "" ReportViewer1.Toolbar = ReportViewer1.multiState.True ReportViewer1.Parameters = ReportViewer1.multiState.False ReportViewer1.Zoom = "75" -- Message posted via http://www.sqlmonster.com Tag: Expressions in RS Tag: 30737
  - 6
    - Matrix subtotal row appearing inconsistently Greetings. I've got a report with a matrix in it that has two grouping levels. For example, two levels of item categories. For display, I want the row to display two fields for the label and then show the totals. I added a subtotal row that is supposed to do much the same thing. However, the subtotal row text does not always show up. I've got a sample all set if you need it. Just let me know how to deliver it. I'm on RS SP1. Thanks. Dale. Tag: Expressions in RS Tag: 30728
  - 7
    - Programatically Creating Report In PDF Format My users have a lot of reports that they need to generate and save in PDF format. Each report is the same, except using different parameters. What I'd like to do is programatically generate a bunch of PDF report files to a folder on the network, each one using just a different set of parameters. I have successfully generated a report using the URL: http://localhost/reportserver?/Profit%20And%20Loss%20Report&Company=0&JobCode=757375&CustomerGroup=&rs:Command=Render&rs:Format=PDF&rc:OutputFormat=PDF This pops up a Save As.... dialog box, prompting the user for a path and file name. I'd like to control and set the path file name programatically to automatically generate all the report permutations by passing different parameters. Is the URL method the right approach? Any advice would be appreciated, or at least point me in the right direction so I can research the actual mechanics of doing this. Thanks!!! Tag: Expressions in RS Tag: 30727
  - 8
    - RS Hidden parameter error Hi, We have a report with parameters which works fine but when we want to recover a hidden parameter which comes from a query (doesn't appears as a filter), an exception is thrown. In the report parameters properties, we left in blank the property "Prompt" so that it is not showed as a filter. The error is this: "An unexpected error occurred in Report Processing. Exception of type Microsoft.ReportingServices.ReportProcessing.aw was thrown". [This error is not given without the use of this parameter, of course]. Thanks in advance! Tag: Expressions in RS Tag: 30724
  - 9
    - Subreports Pageheaders Missing In order to batch a group of standalone reports I have included them in a Master report, each as a Subreport. The data displays as expected in all the report Bodys responding correctly to shared timespan parameters, but no Subreport Pageheaders show. Is this a known problem? Is there another way of batching the reports which I generate individually, programatically by consuming the Reporting Services Web Service. Tag: Expressions in RS Tag: 30723
  - 10
    - Preview and PrintPreview show two different page counts The preview of the report is showing 5 pages, but when I print it, it prints 8 pages. It looks like the preview is larger than the 8.5 by 11 page setting for the report. All of the data is there. Has anyone run across this and find a way to sync the preview to match the printing pages? I have a feeling that the users will question if there is missing data in the preview when they see this happening. Tag: Expressions in RS Tag: 30721
  - 11
    - Stored Procedure - Fields Definitely a newbie question and I apologize. When I base my dataset on a stored procedure, I can return rows based on the parameters off the data tab. Column Headers and data look perfect. Now I want to add these Fields/Column Headers to the Layout of the Report. Unfortunately, when i click "Layout" there are not any fields available to pick from the "Fields" tab and drag to the report. In addition, I can not seem to master the manual creation of the sp fields when editing the dataset. Can anyone shed some light? I'm using SQL 2000 server (developer), vs.net 2003, rs sp2. Thank you in advance. -- Seth Tag: Expressions in RS Tag: 30720
  - 12
    - Accumulated value in table detailrow I have a dataset with a GROUP BY connected to my table. In the detailrow I want to add a accumulated value calculated from another field. Like this: MonthX ValueY Acc. value -------------------------------- Month 1 10 10 Month 2 20 30 Month 3 30 60 Month 4 40 100 Can I do it by referencing the textboxes in the table, or can i change my transact-SQL in any way? (SELECT MonthX,SUM(SomeValue)/SUM(AnotherValue) AS ValueY FROM MyTable GROUP BY MonthX ORDER BY MonthX) Please help! Tag: Expressions in RS Tag: 30717
  - 13
    - Forms Authentication Requirements Do you need to be running the Enterprise edition of SQL in order to use forms authentication or can it work with the standard edition? Tag: Expressions in RS Tag: 30716
  - 14
    - Layout/Formatting question Is there any way to fix the footer of a table to the end of the page so that the summing totals of a row appear always on the same position? As far as I know, I can RepeatOnNewPage=True and the footer will appear more or less on the same position in every page... but what happens to the final page? It does not apear at the end of the page but when the number of records ends (and that might be just at the begining of a new page or at the middle of it). And what happens when the report has just one page? The footer does not appear either at the end of the page. Using page footers are not an option because in page footers one cannot use fields in either headers nor footers of a page. I need a field at a fixed position of a page measuring from the bottom. Is there any workaround to this limitation? Regards. Tag: Expressions in RS Tag: 30715
  - 15
    - SP2 - Printing from a URL Joel Rumerman posted that he'd found a way to print directly from a URL (apart from having to select the printer!) The command is "&rs:Command=Get&rc:GetImage=8.00.1038.00RSClientPrint.html" This works fine with non parameter reports - anyone know how to use it with parameters? Thx Tag: Expressions in RS Tag: 30713
  - 16
    - data connection to fox pro file Hi, I have to connect to a foxpro file. What I've attempted thus far is set up a System DSN. It's pathed to the .dbf file, and I selected the Free Table Directory option under Database Type. In RS, I choose ODBC driver for my Provider and for Connection, I choose the DSN I set up. When I try to choose the Initial catalog, I get an error. The first says The Parameter is Incorrect and the second says Login failed. Catalog Info cannot be retrieved. Any suggestions? Thanks! Tag: Expressions in RS Tag: 30712
  - 17
    - Pagination fails on appling visiblity Expression on Table Hi All, I have some report elements that have their visibility set conditionally using an expression on Table. The expression is based on the value returned by a query . Now on applying pagination , the entire data is being shown on single page. On removing of the visibilty expression from Table property, the pagination works well. Please give me workaround for the problem. Waiting urgently. Thanks in advance. Regards, Ajay kumar Tag: Expressions in RS Tag: 30711
  - 18
    - Dynamic RDL problem - Content Model Type 'all' I am getting the following problem while generating RDL dynamically.... Message "The report definition is not valid. Details: Element 'Width' cannot appear more than once if content model type is 'all';. An error occurred at , (127, 4). --> The report definition is not valid. Details: Element 'Width' cannot appear more than once if content model type is "all". An error occurred at , (127, 4)." If I go and delete the referenced element, then it works... but I do not get this problem when loading the exact same RDL into Visual Studio and compiling/deploying it from there. What is "content model type" of 'all'? How do I change this so that my RDL can be saved to the DB with equal freedom using CreateReport as it has through Visual Studio? I've been scouring the internet and any documentation I can find and have run about 100 different tests and cannot figure this one out... Can anyone shed some light on this for me? Thanks! John Tag: Expressions in RS Tag: 30709
  - 19
    - URL print to PDF file not found I have RS 2000 with SP2 on Windows 2003 server. I am trying to directly print a report to a PDF using something like the following: https://ServerName/ReportServer?/GPO_Application/AFE%20v4.00.00&fcobAppID=20030010969&rs%3AFormat=PDF I know the report renders just fine without the PDF format stuff tacked on the end. But when I try to use the rs%3AFormat=PDF it tells me that the file cannot be found. Any suggestions would be appreciated. Thanks, Christina Tag: Expressions in RS Tag: 30708
  - 20
    - BinaryFormatter versions incompatibility Hi all, I'm trying to custom the security in RS by programming a new authorization class. For this, i use partially the sample code (in MSDN) 'using forms authentication'. Just a detail, I'm still in Windows authentication. The problem is in the method 'DeserializeAcl(byte[] ...)'. I encounter this kind of bug : BinaryFormatter versions incompatibility : Excpected version 1.0, received version 880850475.24252454. Here is the line which generate the exception : acl =3D (AceCollection)bf.Deserialize(=ADsdStream); I searched on the Web, but all the answers i found are not explicit. Thanx for your help Tag: Expressions in RS Tag: 30707
  - 21
    - Report pagination w/in web browser I have a report that is designed with 3 matrices in it -- xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx x x x x x Item Data x x Aggregate x x x x Row Data x x xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx x x x Aggregate Column Data x x x xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx My client would like all of the data from the report to be displayed on 1 page so the employee who uses this application does not have to navigate between pages in order to see all of the data. I've tried messing around with the page break settings in the Item Data matrix and the Aggregate Column Data matrix to no avail. Is there any other way I can get around this limitation of HTML rendering of the report. TIA, Bill Youngman Tag: Expressions in RS Tag: 30702
  - 22
    - calculation with textboxes from different tables I have found a hint in this newsgroup on how I can calculate with textboxes. The formula is: = ReportItems!Textbox1.Value - ReportItems!Textbox2.Value What if the textboxes I want to do a calculation with are not in the same table? If i.e. textbox1 is in tableA and textbox2 is in tableB? How can I cope with this? Thanks, J. Schuetz. Tag: Expressions in RS Tag: 30699
  - 23
    - different filter on different rows instead one filter for the tabl This is what I am trying to accomplish: I have got one dataset. I want to display this dataset in one table. The table has different rows. Each row should be displayed according to a different filter. Unfortuanately the only way I have been able to apply a filter statement is for the whole table, not for single rows of this table. That leaves me with defining a new table for each row - not very elegant. Can filter statements for single rows be accomplished? And how? As I am not a programmer, please try to be specific... (-; Thanks, J. Schuetz. Tag: Expressions in RS Tag: 30695
  - 24
    - Programmatically toggling/showing the Docment Map Hello, I was wondering if anyone had any ideas on how to hide/show the Document Map in a report viewed directly in Report Manager. I know I can use a URL Access Parameter to show or hide the document map by appending rc:DocMap=false to the URL, but in my case I need it to be a little smarter... In my report, I have a report parameter which displays a drop down list box containing an "All Items" entry as well as all other valid values for the report (~ 200 of them). What I want to do is to display the document map if the user chooses the "All Items" entry, but then don't show it if a specific item is choosen from the list. In my report designer, under the "Document map label" text box, I tried adding the following expression: = IIf(Parameters!parmAgencyCode.Value = "ALL", "(" & Fields!AgencyCode.Value & ") " & Fields!AgencyName.Value, "") -- parmAgencyCode is the name of my input parameter -- the expression will look like: "(0023) Agent ABC, Inc." Anyway, when I try that expression and choose my "All" entry, the document map displays as before, listing all the items available. However, when I choose a specific item from the parameter drop down list, the document map pane still displays, but doesn't have any child nodes -- it displays the parent node, which is the name of the report. Also, I realize the "Hide duplicates" and "Containing group or dataset" options work in conjunction with the document map settings, and I tried playing around with the containing group expression as well. But I got a compilation error when I tried that. Anyone had any luck with trying to do this? Thanks for your help! Tag: Expressions in RS Tag: 30694
  - 25
    - Conditional Parameters Hi all I cant get my head round conditional parameters. I have a report with two parameters and I would like the user to be able to select either one or both of the parameters. IE. Param 1 Firstname Param 2 Lastname The user should be able to enter into the first parameter, or the second parameter or both. How do I acheive this and construct the SQL accordingly. Thanks Dave. Tag: Expressions in RS Tag: 30692

Hi,
Im using the following expression to calculate the percentage
=iif(Fields!BudgetedRevenue.Value = 0,0,(Fields!BudgetedRevenue.Value-
Fields!BudgetedCostStan.Value- Fields!BudgetedCostOT.Value-
Fields!BudgetedCostExp.Value)/ Fields!BudgetedRevenue.Value)

if the Fields!BudgetedRevenue.Value = 0 it is returning the #error,instead
of 0.

Fields!BudgetedRevenue.Value is of datatype money.
Thanks in advance.

Top

RE: Expressions in RS by goldpetalgraphics

goldpetalgraphics
Fri May 13 07:17:21 CDT 2005

Try using this:

=iif(isnothing(Fields!BudgetedRevenue.Value),0,(Fields!BudgetedRevenue.Value-
Fields!BudgetedCostStan.Value- Fields!BudgetedCostOT.Value-
Fields!BudgetedCostExp.Value)/ Fields!BudgetedRevenue.Value)

I belive the isnothing() should take the place of the = 0 and might help
your formula calculate correctly.

Let me know if that didn't work.

Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back???
@=)

"CCP" wrote:

> Hi,
> Im using the following expression to calculate the percentage
> =iif(Fields!BudgetedRevenue.Value = 0,0,(Fields!BudgetedRevenue.Value-
> Fields!BudgetedCostStan.Value- Fields!BudgetedCostOT.Value-
> Fields!BudgetedCostExp.Value)/ Fields!BudgetedRevenue.Value)
>
> if the Fields!BudgetedRevenue.Value = 0 it is returning the #error,instead
> of 0.
>
> Fields!BudgetedRevenue.Value is of datatype money.
> Thanks in advance.

Top