Evaluation copy has expired

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
    - Best approach SQL Reporting Authentication - WorkGroup Hi there Situration 1.Development Server is on WorkGroup, not main Domain. (win 2003 server(std)) 2.Accessing dev server via \\Main Domain\Administrator 3.SQL 2K (Std) SQL Reporting 1.Using SQL authentication for shared resource, rather win authentication. 2.Shared folder, access set to everyone. Current Situration 1.Have created 5 reports, each has a url within Domino Notes application. Click on anyone of them (assuming \\Main Domain\Administrator\) --> reports work ok. 2.Log-on as non-administrator --> click on url, enter site ok, but popup appears asking for authentication of user e.g. name, pwd & domain. Constraints 1.Development Box cannot be joined to main domain i.e. Non-Wins authentication 2.Host name e.g. http:\\wtdev01\reportserver --> dealt with WINS server, not host file ! Requirement Any user clicks on URL for the report, will open the report and be run without authentication issues. Tried 1.Custom Authentication (e.g. Form Authentication) - issue cannot use Standard version of SQL Server ! Needs to be Enterprise. Dead end. Any ideas. Tag: Evaluation copy has expired Tag: 13874
  - 2
    - Reporting Service - Installation Error 25619 Hi I am quiet new to Reporting Service. I was installing SQL Server Reporting Service 120 days evaluation version on my machine. Mine is a Windows Erver 2003 Enterprise Edition with SQL Server 2000 installaed on it. I tried to install both Server and Client versions of Reporting Service on my machine. Befor installing Reporting Service I ensured that I ran the latest SQL Server 2000 Hotfix as described in MS Knowledge Base. Basically I am domain user having admin privileges. I ensured that ASP.NET is enabled and all pre-requisites are present. I selected Reporting Server to ru in default SERVICE ACCOUNT as I ran the hotfix. It went through fine till the end. At the end of the installation while configruing IIS I got an error Error: 25619. From internet I found that I need to enable ISAM_machineName account for this and also restart MS-DTC service. Actually this account is ENABLED for me. I checked that by getting into Computer Management - Local USers. Also I did restart of MS-DTC> In spite of that I am getting the same error. I even tried the instalaltion by logging in as local administrator. That also did not solve the problem. Any inputs or help please. If I do not run Report Service in SERVICE account(that is running the service in DOmaion User account), then I am not getting this error. I am stranded here. Thanks in advance Tag: Evaluation copy has expired Tag: 13873
  - 3
    - "String constants must end with a double quote" error Hi, I've created a bunch of reports locally on my machine, where they all run just fine, but when I try to deploy them to a server I run into some problems. I only have access to the server through a third party remote desktop application (NetOp), so I have to do the deployment by manually uploading the .rdl file in Report Manager. The reports uses MDX queries which I've had to change into concatenated strings to allow for parameters, but when I try to upload the files I only get the "BC30648 String constants must end with a double quote." error. If I remove the parameters, and the quotes around the whole query the files upload just fine. Additionally, I've tried uploading the files manually both on my own machine and a colleague's without getting this error. The reports also run fine on these two machines after the upload (and configuration of datasources). Below is a sample of the query in a report that will throw the error on the remote machine (for clarity this one doesn't use parameters): <Query> <DataSourceName>SullandGruppen</DataSourceName> <CommandText>="SELECT {[Measures].[Faktisk denne mnd]} ON COLUMNS, {[Dato].[All Dato].[2004].[January]} ON ROWS FROM Finanskube WHERE ([Avdeling].[Salg], [Avdelingsstruktur].[All Avdelingsstruktur].[3 Inntekter], [Firma].[Gjovik Auto])"</CommandText> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> </Query> Does anyone have any idea why this might be happening? This is a fresh install of Reporting Services, so I haven't tried deploying reports to it before. It have only got the Server Components and .NET runtime installed. Many thanks for any input! -Christian Nordbakk Tag: Evaluation copy has expired Tag: 13872
  - 4
    - "Install" reports on ReportServer? Hi! I have done a web page where the user can select data and then render reports. it works fine. The web page is done with asp.net and c#. I am working on a Installshield package for the whole Web page and the reports. I want to somehow include "deployed" reports to this package and put them in the reportserver db. I cannot just include the rdl-files because thay are worthless without deployment to the Reportserver. The only place I know where you can deploy a report to the server is from the Visual Studio.net report designer. Is it possible to place reports on the reportserver with some command? (I don't want the users to use the Visual studio and "deploy") My wish is that the only thing the user have to do is to install the Reportserver and then install the webpage+reports with my installpackage. /Martin Tag: Evaluation copy has expired Tag: 13870
  - 5
    - Problem with HTML rendering Hi I'm facing a problem when i render a report in HTML format. When i see the report in the preview section of the report designer it is perfect as desired. After deployment, when i export the report in HTML format there are a lot of white spaces inserted vertically. But it doesn't happen when it is exported in PDF format. Please suggest some methods to overcome this problem. Thanks in advance Prathima Tag: Evaluation copy has expired Tag: 13869
  - 6
    - Delivering RS Reports to a customer I will like some help please. I created some reports with RS. They were deployed to Report Manager and run well within the office. We have a customer who wants these reports and has a SQL 2000 Server Standard Edition License. What do I have to do to transfer these reports unto the customer's server and have them run from there? The reports will be using the customer's data and will be out of our hands from then on. Thanks. seanpollonais Tag: Evaluation copy has expired Tag: 13867
  - 7
    - Fit All Columns In One Page Hi, I have a report(matrix report) with 14 columns,when i export it to PDF format for printing purpose, all columns are not displayed in one page, how to do this, i need all 14 columns to be fit in one page only. Please help to find a solution for this. Thanks And Regards, Rajesh. Tag: Evaluation copy has expired Tag: 13866
  - 8
    - Reporting services installation error (Error 29525 in RSMSI** log file) Hi, I have a problem during installation. I've got the 1603 error. Note that http://support.microsoft.com/?kbid=867872 suggestions didn't help to solve the problem. Quatation from RSMSI** log file: ".... Action 13:57:32: Do_sqlScript. Configuring Microsoft SQL Server Do_sqlScript: Running SQL Script: ...\ReportServer\CatalogTempDB.sql <Func Name='LoadRSCatalog'> error parsing script file ...\ReportServer\CatalogTempDB.sql: 87 Error 29525. SQL Setup failed to execute a command for server configuration. Refer to the Server error logs and setup logs for detailed error information. <EndFunc Name='SqlScriptHlpr' Return='1603' GetLastError='0'> <EndFunc Name='Do_sqlScript' Return='1603' GetLastError='0'> ..." Thanks in advance for your time and help Nick J Tag: Evaluation copy has expired Tag: 13864
  - 9
    - Render directly to printer Hi, we would like to send our report directly to the printer in PDF format. Is this possible using the Render method (or some other) thanks Matt Tag: Evaluation copy has expired Tag: 13859
  - 10
    - Conditional Formatting Loss from SQL RS to Excel When I export a SQL RS report to Excel, the conditional formatting is lost. Using the BOL example: =iif(Fields!Profit.Value < 0, "Red", "Black") works in SQL RS, but when exported to Excel, I get odd behavior...one column is red while the rest of the columns are black. I'm running SP1. Has anyone had this problem? Is there a fix out there? Thanks, Dean Tag: Evaluation copy has expired Tag: 13858
  - 11
    - group number i have the following data in the database: hk a aa aaa hk b bb bbb hk c cc ccc uk d dd ddd uk e ee eee us f ff fff and they are displayed in a matrix like below hk a aa aaa b bb bbb c cc ccc uk d dd ddd e ee eee us f ff fff i would like to add a number to any new row like below 1 hk a aa aaa b bb bbb c cc ccc 2 uk...... 3Us... how can i do this...i have tried rownumber and runningvalue but it doesnot work please help~~ thank you so much in advance Tag: Evaluation copy has expired Tag: 13855
  - 12
    - How do you include running total in a matrix Is anybody aware of how to add a running total against columns in a matrix? The output would look something similar to this: Col A Col B Col C Row 1 1 (1) 2 (3) 2 (5) Row 2 3 (3) 1 (4) 7 (11) The numbers in brackets are the running totals. Many thanks ***************************************** * This message was posted via http://www.sqlmonster.com * * Report spam or abuse by clicking the following URL: * http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=9a8c728cd64c47cba81c03e9203b7291 ***************************************** Tag: Evaluation copy has expired Tag: 13844
  - 13
    - ASP.Net RS Rendering Rpt Mgt? I'm looking for a concise source (links) of info on how to manage, render RS reports through ASP.Net. I can URL render, I can render "A" report; I can preAuthenticate using credentials whose source comes from web.config, but what I want is a dynamic way to say.... Display all the reports in a folder that I associate with an application. *Launch each of those reports and dynamically render in an ASP.Net panel or similar the typed fields for the required parameters. Offer Mime type selection. *A good example of this I can imagine. TIA JeffP.... Tag: Evaluation copy has expired Tag: 13842
  - 14
    - MDX support in next version of Rept. Svcs. (MS Question) Hi. We are doing quite a bit of work with Analysis Server and Report Services. I understand the next version of Rept Svcs will support Analysis Server and MDX queries quite a bit better. So before we put a lot of effort in building better support for creating MDX based reports, I would like to understand what that support will be and an estimate when it will be avail. for beta testing. Thanks, Bill Tag: Evaluation copy has expired Tag: 13833
  - 15
    - convert to VB Hello, How cab I do this in VB. SetParameter is not recognized. public void SetQueryParameter(string ParamName, string ParamValue) { SetParameter(ParamName,ParamValue); } ReportViewer1.SetQueryParameter("SalesOrderNumber","SO5018") Thanks, Jim. Tag: Evaluation copy has expired Tag: 13832
  - 16
    - Project Type - Business Intelligence I have sql server 2005 beta 2 and Visual Studio .Net 2003 installed. I do not have the project type "Business Intelligence" in Visual Studio. I have tried everything I could think of. it is supposed to be there correct? Tag: Evaluation copy has expired Tag: 13831
  - 17
    - Max number of columns allowed on a Matrix style report ? Anyone know the Max number of columns allowed on a Matrix style report ? Tag: Evaluation copy has expired Tag: 13826
  - 18
    - Pls Help - Getting Error on Report App I finally got reporting services running. Downloaded trial version of Sql Server and Trial Version of Reporting services. I created the web service from the Microsoft sample. Then I created a report (rdl) and deployed it. I can preview it with no problem. When I created the app and entered the ReportPath, I get the following: The operation you are attempting on item '/Report Project1' is not applicable to this item type. (rsWrongItemType). Any Suggestions will be appreciated. If I can get just one report to work, I'll be on my way. Tag: Evaluation copy has expired Tag: 13823
  - 19
    - parameter to report query Hello, I am calling a report like http://localhost/reportserver?/myreportanme in my asp.net application. I have a textbox on my asp.net application and I need to use the value of this textbox as a where clause in the query of the report. So I need to pass parameter to the query of the report, can I do that? Thanks, Jim. Tag: Evaluation copy has expired Tag: 13821
  - 20
    - Reporting Services install options opinions Hello, We have been using Reporting Services for a few months doing some prototyping and it has gone well enough that we are now being tasked with rolling out an implementation to the enterprise. Here is the hardware that I have to work with: 3 Web Server Cluster managed via Application Center 1 Active/Passive Sql Server Cluster (IIS Installed for XMLA) Attached to fiber array. So here is my dilema. Is it better to install the Reporting Services WebService on the web servers and have them all pointing to the database server or should I install the web servcies on the same box as the Database. In my mind it could work either way and may even keep the web servers cleaner to go with option 2. I see that the directions show how to install RS into the web farm as in my option 1 but before I went either way I thought I would ping the source and see what you all though. Thanks for any guidance and direction you may be able to give. Thanks. Rich Tag: Evaluation copy has expired Tag: 13811
  - 21
    - calling report in asp.net app Hello, I created a few reports by using RS2000, now I want to call these reports in my asp.net web application through a selection box. What is the best and easiest way to handle this. Thanks, Jim. Tag: Evaluation copy has expired Tag: 13809
  - 22
    - Missing Chart Image This has been brought up before, but I have not found an answer yet. So far, I have only been able to replicate this 'error' on one user's computer. I have a report that is launched in a frame and is displayed with the standard 'broken image' indicator (the red X). Consequently, none of the other drill downs work. As I just mentioned, I've only seen this happen on one user's computer but it is consistent - the report displays fine on all of the other PC's I've seen. We were able fix this by adding the website to the user's list of trusted sites in the Privacy tab of IE. This is not a viable solution as I cannot control how the users have IE configured. Now, to stop all of you pistoleers from jumping to the answer that I'm completely sick of, THERE IS NO UNDERSCORE IN THE NAME OF THE SERVER. Additionally, I have changed the UseSessionCookies entry in the ReportServer db to "false". So, that said, what's going on? Any solutions? Tag: Evaluation copy has expired Tag: 13807
  - 23
    - percentage values in reports hello, i have a percentage field which returns 0.50 i want to report to show it as 50% is there any way to do this appreciate any help Tag: Evaluation copy has expired Tag: 13806
  - 24
    - Data Extensions - Through Business Logic I have a multi-tier application that does a lot of business processing of data. I am looking for a way to use SQL Report Server to render reports based upon this data. I have looked at several examples of extensions and built one using a serialized XML file. What I am looking for though is to be able to create an extension that uses data that has been processed from the business logic in real time without creating a serialized XML file. Any help would be appreciated Tag: Evaluation copy has expired Tag: 13805
  - 25
    - Books for Reporting Services I am looking to purchase a book or books on Reporting Services. Any opinions on the best book or books to buy? -- Darrell Tag: Evaluation copy has expired Tag: 13804
- Next
  - 1
    - kerberos Hi Want to know how to get kerberos to work 3 workstations involved User computer with Windows 2000 runs I.E 6.0 and accesses a web page on Reporting services server (Web Portion-IIS) running windows 2003. USer is running a report that runs an mdx statement on a data server which is also windows 2003 We included in the connection string sspi=kerberos We also when to the domain controller which is windows 2003 and enabled kerberos delegation on the web and data server. We still get the below error An error has occurred during report processing. (rsProcessingAborted) Get Online Help a.. Cannot create a connection to data source 'OLAP'. (rsErrorOpeningConnection) Get Online Help a.. The operation requested failed due to security problems - the user could not be authenticated b.. Thanks in advance Tag: Evaluation copy has expired Tag: 13798
  - 2
    - No report server Hello I installed RS2000 and create and report application. When I run my report it tells me â??No report server found at http://localhost/reportserver â?? What is problem? Thanks, Jim. Tag: Evaluation copy has expired Tag: 13791
  - 3
    - expand collapse not working properly I'm seeing a problem with expand and collapse when I run the "Territory Sales Drilldown" sample report. If I just keeping clicking expand/collapse repeatedly, it will sometimes not perform the expand or collapse. I'm just viewing the report in IE. Anybody have suggestions on what the problem may be? Tag: Evaluation copy has expired Tag: 13790
  - 4
    - Zero Values Not Showing In Deployed Report I have a report that returns 0's for several of the controls. These 0's render as 0's in Visual Studio. When I deploy the report, the 0's no longer show, almost as if they were a NULL or non-existent value. This is raising questions from my end users? I realize it's a different control in Visual Studio than in the Reporting Services engine? Is this what's causing the problem? Is there a hot fix or somethign that might fix this anomaly? Tag: Evaluation copy has expired Tag: 13783
  - 5
    - Clicking on Print Preview yealds Error Processing Errors - Index was outside the bounds of the array. Hi Who can help, I have a report, when I am in the Preview table the report shows fine, when I click on the Print Preview button I get the following error dialog box titled "Processing Errors" with the following error message "Index was outside the bounds of the array.". Can any help me with this probelm. Thanks! Jeff Tag: Evaluation copy has expired Tag: 13781
  - 6
    - Set Has Default property How do I code the setting of the "Has Default" property for parameters, like the Report Manger does. Or better yet, what method is it using to do that? Tag: Evaluation copy has expired Tag: 13779
  - 7
    - criteria select We are a hospice facility. We have a description field that tells under what circumstances a patient left our care (most are death under certain insurance coverages) Our descriptions may read "death at home"; "Death at hospice house"; etc. However some of them might read "discharged to self"; "change of insurance". Is there a way that I can set the criteria of this description field to search for the word "death" as a part of the string and if it is present return the record, otherwise not? Thanks for your help. P.S. I'm not a programmer and this is all new to me. Tag: Evaluation copy has expired Tag: 13774
  - 8
    - Dynamic Graphs I want let the end user decide on which type of graphic(via a report parameter) is used for displaying the data (Bar, Column, 2D, 3D, etc.) I couldn't find any option to define the chart type e.g. with the aid of an expression. Do I have to place any possible chart type in my report layout and control the appearance by defining an expression for the 'visibility' property? Tag: Evaluation copy has expired Tag: 13773
  - 9
    - Export Report to File Iâ??m a Crystal developer who has been unsuspectingly thrust into SQL Server Reporting Services. I am at a loss as to how I can access report services object to export it to a file (.PDF, .XLS, etc.) from a Windows application. (With Crystal, ActriveReports, etc. this would be 4 or 5 lines of code.) Anybody kow is this done for Reporting Services? Thanks in advance for your assistance. Tag: Evaluation copy has expired Tag: 13772
  - 10
    - Snap Shots and Copied Reports When I copy a report using SOAP method, and the original report has default values set, the copy does not set the "has default" to true. Without the "has default", I can't make a snapshot from the copy. Can someone please advise how to set the "has default" property to true thru code? Tag: Evaluation copy has expired Tag: 13771
  - 11
    - Preventing automatic generation of report Is there some easy way to prevent a report from generating once the last non-defaulted parameter is selected. This behavior is driving everyone nuts. I have a whole series of reports where a user will select a company, and then select a month, which is defaulted to the previous month but can be changed. Because it is defaulted, the report runs as soon as a company is picked, and the user never gets the chance to change the default month. It needs to wait for me to finish selecting and confirming all parameters. Tag: Evaluation copy has expired Tag: 13767
  - 12
    - Question: Using web service as a data source in reporting services Hi: I was wondering if there is anyway of using a web service as a data source to a report in Reporting Services. I have a legacy app that can be accesed thorugh a web service. It returns an xml. I wanted to use reporting services to render a report based in this data but was tryin g to avoid having to extend reporting services. Any idea? Thanks --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: Evaluation copy has expired Tag: 13765
  - 13
    - Installing Reporting Services I am trying to get a grip on how to install Reporting Services using a Windows 2000 professional machine as a starting point in a test environment. I want to be able to run Report Manager from the workstation. On the server Installed SQL Server 2000 On the client (Windows 2000 professional) Installed VS.net 2003 Enterprise Manager client tool When installing Reporting services on the client, I am getting stuck on the "Report Server Database" Step. 1. By SQL server instance I assume that would be the same as the "registered server" as used in Enterprise manager ? 2. When clicking "Next" using Credential Type "service Accout" - stated I did not have the permissions 3. When I tried a SQL server Account - I used the sa login and got the following message "The setup account doesn't have sysadmin rights for the SQL server instance that hosts Report Server Database." Any ideas ? Tag: Evaluation copy has expired Tag: 13761
  - 14
    - Using a proxy with the Report Server I am currently using a virtual directory to act as a proxy to talk to our report server that is behind our firewall. We are trying to use URL Access to bring up Sql Reporting on the internet but we only have the Standard Edition. We also don't want to have our Report server available to the outside with Anonymous Access turned on since it allows for direct browsing of the server directories. We've been able to get this to work using some address translation and some identify impersonation in the proxy code but it does not render the toolbar back (fyi - this is not using the SOAP API, we have an .aspx page in the virtual directory running as the proxy into the Report Server). As of now, I can use URL Access strings to talk to my proxy aspx and render the report back to the browser from my internal report server, but the toolbar does not come up. And yes, I have rc:Toolbar=true set in the string Anyone else trying something like this and had success? Thanks! Tag: Evaluation copy has expired Tag: 13757
  - 15
    - +++TotalPages in Page Body Section+++ Hi, I need Total number of Pages in Detail Section(Page Body) (1) If I try =Globals!TotalPages in any of the textbox in Body, I get the following error "These global variables can be used only in the page header and page footer" (2) I tried referring a textbox that is in the Page Footer(=ReportItems!textbox1.value), I get the error "Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope." Is there any way to get the Total Pages in Body Section Any help will be appreciated Regards and Thanks Ponnurangam Tag: Evaluation copy has expired Tag: 13755
  - 16
    - Dynamically changing a parameter value based on a table group Is there a way to change the value of a parameter based on a table group. I need to do this to build a query where, the where clause is based on the table parameter. Tag: Evaluation copy has expired Tag: 13752
  - 17
    - Custom Toolbars Has anyone developed a custom toolbar in lieu of using the html viewer that comes standard with SRS? Specifically, toolbars accessed through URL Access to the report server. If so, can you direct me to some knowledge bases articles or examples of how they've been developed or deployed? Thanks! Tag: Evaluation copy has expired Tag: 13746
  - 18
    - Another one for the wishlist Make the "Scale" properties of graphs accept a formula. Now we have many graphs one next to the other but scales vary. I want to put something like =max(Fields!MyValue, MyOuterList) That way the graphs would still adapt to the data and have a common scale. Oh, and clearly indicate which field accepts formulas and which doesn't. The "Title" property accepts formulas it seems... Regards, Tom Tag: Evaluation copy has expired Tag: 13735
  - 19
    - taking one date from another for a derived field Hi all, In my report (which im building in Visual studio) I have two sets of dates. The first is called required date - thats the date an employee of the company was required to perform a certain task. the second is completed date. thats when he or she actually completed the task. what i need to do is derive another field - with a success or failure rate. I have tried the following expression : but it doesnt work: =if Fields! Fields!Completed_Date.Value <= Fields!Required_Date.Value then "Success" else "failure" anyone know how i can do this...have been looking at this all day !! lol in Business objects it took me about 30 seconds!! but alas my company is switching to RS!! any help greatly appreciated Greg Tag: Evaluation copy has expired Tag: 13730
  - 20
    - MDX and Drilldown How could I do real drilldown in RS? By real I mean that I load only one level of data at a time. I tried to do it with using parameter that defines level in mdx (dynamic query) but I couldn't make it work because the names change with level. Can I define name in the layout with expression or something like that? MC Tag: Evaluation copy has expired Tag: 13723
  - 21
    - Rendering to PDF, bold Hi again, unfortunately I have to use ARIAL MS UNICODE font in my reports, because I can't use more than one format in 1 cell (normal/superscript/subscript). I'm using chemical formulas, for example SO<sub>4</sub><sup>2-</sup>. Main problem is, that ARIAL MS UNICODE doesn't have BOLD. My question is, it will be possible (I already read that is know issue rendering bold to PDF) after installing new service pack, if rendered PDF will have BOLD characters even if font doesn't have BOLD. -- Ing. Branislav Gerzo / [2ge] / Slovakia Tag: Evaluation copy has expired Tag: 13721
  - 22
    - Programmatic Render of Reports into PDF format Hi, Can anybody please convert the following C# code into VB.Net Code.I tried but its saying Object Reference not set to an instance of an object. Or give me VB.NET(Web Application, CodeBehind:VB.Net) code to programmatically render reports into PDF format. // Prepare report parameter. ParameterValue[] parameters = new ParameterValue[1]; parameters[0] = new ParameterValue(); parameters[0].Name = "Parameter1"; parameters[0].Value = Request.QueryString["id"]; Thanks Rajesh Y Tag: Evaluation copy has expired Tag: 13720
  - 23
    - Invalid object name... Hello all, however, this is my first question to this news. I am working with RS SP1, and have question. I have example procedure: CREATE PROCEDURE GEGE_test_a @ord SQL_VARIANT AS SET NOCOUNT ON CREATE TABLE #table (ID SQL_VARIANT) INSERT INTO #table(ID) VALUES (@ord) SELECT * FROM #table DROP TABLE #table GO When I want add DataSet with this procedure (EXECUTE GEGE_test_a @OrderID) I get following error: Could not generate a list of fields for the querry... Invalid object name #table Ofcourse, this procedure works good in Query Analyser. Anyone has idea, why this is not working ? -- Ing. Branislav Gerzo Tag: Evaluation copy has expired Tag: 13718
  - 24
    - textbox referece into a matrix hi, i have a matrix with a static rows and a dynamic group on columns. the rows have the tables inside. one of the tables must use a value calculated in another textbox. i tried to put this textbox in the same row but on the column with the dynamic group. the error is like: "Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope". i also tried to put it in anothr static row that i've created. but it gaved me another error, after it becomes the run-time. please help me, thank you in advance for any help, Mirela Tag: Evaluation copy has expired Tag: 13717
  - 25
    - display data alternately from two tables? hi all, would anyone know how to display data alternately from two tables? thanks in advance Tag: Evaluation copy has expired Tag: 13715

Is it possible to uninstall the evaluation copy and install my developers
edition without loss of service, or do I have to purchase a standard or
enterprise edition for my Win2000 server running SQL2000?

Top