Parameters with a union statement

SQL Server Reporting Services

Index ‹ SQL Server
- Archive
  - Windows Forms
  - Dotnet
  - Windows Live
  - VS 2008
  - ISV
  - Smart Device
  - Office
  - SharePoint
  - VB
  - Architecture
  - Windows Vista
  - Visual Studio
  - Visual C#
  - SQL Server
  - IE
  - VS Express
  - VFP
  - VC++
  - Game

- Previous
  - 1
    - Why was ReadWriteVariable not populated/updated with a value of the dynamically generated string? Hi, I have a script task in SSIS which dynamically generates a string for a file name to be used as flat file source. I execute the task and it executed with success; but when I checked the result of the variable TotFileName from the Expression builder window for the flat file connection manager it was not populated with a file name like \\MyServer\MyDrive\MyFolder\200706daily.txt . So something might still be missing from the script below. Or is the way I do it correct Can someone help with this Thanks a lot!! I have created package level variables ImportFolder (value like: \\MyServer\MyDrive\MyFolder ) and TotFileName (value field empty) and make ImportFolder a ReadOnlyVariable and TotFileName a ReadWriteVariable. Then I use expression to set the property for flat file connection manager to use the TotFileName variable. (Basically the idea is: if now is July 2007 then the filename should be 200706daily.txt; if now is Jan 2008 then the filename should be 200712daily.txt) -----code------ ' Microsoft SQL Server Integration Services Script Task ' Write scripts using Microsoft Visual Basic ' The ScriptMain class is the entry point of the Script Task. Imports System Imports System.IO Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Public Class ScriptMain ' The execution engine calls this method when the task executes. ' To access the object model, use the Dts object. Connections, variables, events, ' and logging features are available as static members of the Dts class. ' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure. ' ' To open Code and Text Editor Help, press F1. ' To open Object Browser, press Ctrl+Alt+J. Public Sub Main() Dim TotFileName As String Dim TrueFileName As String Dim sYear As String Dim sMonth As String Dim sDate As String sYear = CStr(Year(Now())) sMonth = CStr(Month(Now()) - 1) If (Month(Now()) < 11 And Month(Now()) > 1) Then sMonth = "0" & sMonth End If If (Month(Now()) = 1) Then sMonth = "12" sYear = CStr(Year(Now()) - 1) End If sDate = sYear & sMonth TrueFileName = sDate & "daily.txt" TotFileName = CStr(Dts.Variables.Item("ImportFolder"). Value) & TrueFileName Dts.Variables.Item("TotFileName").Value = TotFileName Dts.TaskResult = Dts.Results.Success End Sub End Class Tag: Parameters with a union statement
  - 2
    - DTS Code works only with VS 2003 but not with VS 2005 ? Hi; I wanted to use the following code to run a DTS package from a 2005 Web Page code behind partial class. This code works fine in a VB 2003 module going against SQl Srvr 2000. Here is the code: (It initiates from a button click handler) Dim conn As New SqlConnection( "initial catalog=MY_Data;server= XYZ081552X7X441\TRSQL;integrated security=SSPI" ) Dim hold1 As Integer Dim hold_source As String = "" Dim hold_desc As String = "" Try conn.Open() Catch ex1 As Exception MsgBox( "The Test connection failed to open" & vbCrLf & ex1.Message) End Try MsgBox( "About to create a DTS object" ) Dim oPackage As New DTS.Package2Class (Compiler doesn't like this line) Type DTS.Package2Class is not defined. Dim oStep As DTS.Step (Or this one) Type DTS.step is not defined. oPackage.LoadFromSQLServer( "XYZ81552X7X441\TRSQL" , , , DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , , "cpyPrinters2Excel" , ) For Each oStep In oPackage.Steps oStep.ExecuteInMainThread = True Next oPackage.Execute() For Each oStep In oPackage.Steps If oStep.ExecutionResult = DTS.DTSStepExecResult.DTSStepExecResult_Failure Then oStep.GetExecutionErrorInfo(hold1, , ) Else End If Next oPackage.UnInitialize() oPackage = Nothing conn.Close() Has Microsoft changed the DTS objects so that they work only with SQL Srv 2005 Thanks for your insights. Tag: Parameters with a union statement
  - 3
    - i want know the difference between "SQL Server 2005 -Std Edition" and "SQL Server 2005 Std license" hai to all, i want know the difference between "SQL Server 2005 -Std Edition" and "SQL Server 2005 Std license" can any one tel regarding that. Tag: Parameters with a union statement
  - 4
    - Report Definition Is it possible to control the number of table rows that can be displayed by modifying the report definition Tag: Parameters with a union statement
  - 5
    - Access To Dts.Variables Causes Exception Hey all...I'm pretty new to SSIS packages and things are coming along nicely. My problem is accessing variables in script tasks. I've created two variables (package scope, strings, readonly = false) - aDetailFiles and strDetailFile Within a Foreach Loop I loop through a folder. I've added a script task and within that I try the following: Dts.Variables("User::aDetailFiles").Value = Dts.Variables("User: trDetailFile").Value.ToString() + "|" + Dts.Variables("User::aDetailFiles").Value.ToString() Everytime this script executes I get the following errors: at Microsoft.SqlServer.Dts.Runtime.Variables.get_Item(Object index) at ScriptTask_feac87c947ce4431a4fee0ba0e13631d.ScriptMain.Main() in dts://Scripts/ScriptTask_feac87c947ce4431a4fee0ba0e13631d/ScriptMain:line 25 I have searched this error message but the only thing I found was to set the ReadWrite variable property but I don't know where to set that. Expresion property set as false also. Any ideas Thanks. Tag: Parameters with a union statement
  - 6
    - Property DefaultSchema is not available for Database [DatabaseName] We're using Windows Authentication with our SQL Server. We've added a domain group to the SQL Server groups and would like to give it a default schema. The properties window is the same for users and groups but the default schema field is enable only for user entities. We cannot add a default schema to a group. Is this by design, a bug or a problem with our SQL Server installation Updated on 2005/08/29 My first try was done at through Database\Security\Users. I tried going through Server\Security\Logins and I got this error message Alter failed for User 'Domain\Group'. (Microsoft.SqlServer.SMO) Additional Information: --> An exception occured while executing a Transact-Sql statement or batch. (microsoft.SqlServer.ConnectionInfo) --> The DEFAULT_SCHEMA clause cannot be used with a Windows group or with principals mapped to certificates or asymmetric keys. (Microsoft SQL Server, Error: 15487) Why can we not set a Default Schema to a Windows group This would be more efficient then to add all the users to the Sql Server logins list. Tag: Parameters with a union statement
  - 7
    - Cannot insert duplicate key I am using SQL Server 2000. I have a table (tbDupes) with duplicate records. I want to populate another table (tbUnique) with unique records. My tbDupes has about 50 columns and three of them make up my primary key in tbUnique. I thought I could get unique records by using the following SQL statement. Code Snippet INSERT INTO tbUnique SELECT * FROM tbDupes I received this error: Cannot insert duplicate key Is there a database setting that will allow me to insert the first record and prevent any duplicates from being inserted I thought this was the default behavior and think that maybe the DBA changed it. I know I can achieve this by creating a cursor with tbDupes and then something like "IF NOT EXISTS(...) THEN INSERT". However, I would prefer to avoid using a cursor. Tag: Parameters with a union statement
  - 8
    - RS Integration with SharePoint 3.0 - Query with userid parameter When integrating SQL Reporting Services 2005 with Sharepoint Services 3.0, and you have a SRS report that runs over a view with the UserID as a parameter (to filter the records the user has access to), will the SharePoint ReportViewer passover the UserID to RS and RS to SQL Sharepoint security with Reporting Services stops at Item level or does it impersontate down to SQL Should authenticating be Integrated or SQL Should the userid in SQL be exact match with Sharepoint Or are they mapped somewhere Thank You!! Tag: Parameters with a union statement
  - 9
    - SQL 2000 - All Client Tools I've been asked to buy a license for the above. I've had a look on the net for this and I'm not sure if I'm being thrown a spanner. Does anyone know if this is just a generic term for several client tools for SQL 2000 or is this actually a component / product I can/could have bought thanks for your help Tag: Parameters with a union statement
  - 10
    - Printing in Reporting Services hangs Please Help!!! We have never been able to get the printing to work on any of our reports using SQL Server Reporting Services 2005 SP2 in our production environment. Without this feature of printing a report, we cannot go live with SSRS at all. We have tried adding the SP2 after a clean install on a new server -- yet we still have this problem. I read a few some posts about uninstall the old ActiveX control used for printing, so I did this and installed the new one but that didn't help either. We can print to files without issue - only when we try to print to a real printer does it hang forever. It doesn't matter how big the report is, 100 pages or 1/4 of a page, same problem. We do the following: 1) Run the report 2) Click the print button 3) Select a printer and press ok 4) "Printing Now..." dialog box appears 5) "Print Error" dialog appears and never goes away - and nothing is printed out. Have to close IE and crash the report session to get out of it. This is the result on every client computer we have ever used in trying to access the report server. It also hangs in running a Print Preview for all reports. We are printing to network printers from IE6 and IE7. Since this is on a server, we do not have a local printer to this server computer to try to print to. Even if it worked on a local printer, this is supposed to be an enterprise solution. Almost all of our employees print to network printers. I am logged into my machine as a domain admin. I have no printing problems in any program printing to any printer, except when using Reporting Services. We are trying to print from an ASP web application which runs the reports in an iframe using URL access. We are able to print the same reports on all of our development environments using the same ASP web application and RDL. Again, Please help!!! Tag: Parameters with a union statement
  - 11
    - SUM in Report I need to do a function in my report, i'm trying use =Sum(Fields!FlagPresents.Value) but it sum all value in my table, i need some how =Sum(Fields!FlagPresenca.Value = 1), i want that when my value = 1 then sum, but i don't know how i can do it. Help me please. Thanks a lot! Tag: Parameters with a union statement
  - 12
    - Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception Hi I am using sql reporting service 2005 with .NET 2.0. I have created a custom dll file for report and put this dll in appropriate folder. Report is running fine in designer project. but when I am trying to view this report after uploading to report manager it give me an error like Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception. (rsErrorLoadingExprHostAssembly) Is there any solution for that thanks and Regards Apurv Shah IBM India pvt Ltd Tag: Parameters with a union statement
  - 13
    - Could not create Maintenance Plan Hello, if I try to create a Maintenance Plan from my local workstation I get the following Error Message: TITLE: Microsoft SQL Server Management Studio ------------------------------ The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2005 Management Tools on the remote computer, and then try again. For more information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server 2005 Books Online, or find the article on MSDN at http://go.microsoft.com/fwlink/ LinkID=57083 . (ObjectExplorer) For help, click: http://go.microsoft.com/fwlink/ LinkID=57083 On my local workstation I have performed a full installation of the client tool with SP 1. The Server is an SQL 2005 Cluster with SP1. If I try to create a Maintenance Plan on an SQL Server without SP 1 it works. What is the problem Thanks, Markus Tag: Parameters with a union statement
  - 14
    - Cascade Issue By: IT In: microsoft. public. sqlserver. programming I have 2 tables A and Table B respectively: Table A: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aa]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[aa]( [aa1] [int] NOT NULL, [aa2] [int] NULL, [aa3] [int] NULL, CONSTRAINT [PK_aa] PRIMARY KEY CLUSTERED ( [aa1] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END Table B: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bb]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[bb]( [bb1] [int] NOT NULL, [bb2] [int] NOT NULL, [bb3] [int] NOT NULL, CONSTRAINT [PK_bb] PRIMARY KEY CLUSTERED ( [bb1] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_bb_aa]') AND parent_object_id = OBJECT_ID(N'[dbo].[bb]')) ALTER TABLE [dbo].[bb] WITH CHECK ADD CONSTRAINT [FK_bb_aa] FOREIGN KEY([bb2]) REFERENCES [dbo].[aa] ([aa1]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[bb] CHECK CONSTRAINT [FK_bb_aa] IF NOT EXISTS (SELECT * FROM SYS.FOREIGN_KEYS WHERE OBJECT_ID = OBJECT_ID(N'[DBO].[FK_BB_AA1]') AND PARENT_OBJECT_ID = OBJECT_ID(N'[DBO].[BB]')) ALTER TABLE [DBO].[BB] WITH CHECK ADD CONSTRAINT [FK_BB_AA1] FOREIGN KEY([BB3]) REFERENCES [DBO].[AA] ([AA1]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [DBO].[BB] CHECK CONSTRAINT [FK_BB_AA1] creating FK_BB_AA1 fails with the following error: Msg 1785, Level 16, State 0, Line 3 Introducing FOREIGN KEY constraint 'FK_bb_aa1' on table 'bb' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Msg 1750, Level 16, State 0, Line 3 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_bb_aa1' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. How to get this working. Tag: Parameters with a union statement
  - 15
    - An error occurred during local report processing. Index was outside the bounds of the array. I got rid of the .rdl.data files, which apparently has been a successful fix for this problem in the past. Everything worked fine Thursday when I left (I was off Friday - Saturday), but today I get this error for all but one of the reports in the solution when I try to preview the report. BTW, the published stuff works fine. Thanks in advance for any help. Tag: Parameters with a union statement
  - 16
    - Unable to connect to the remote server Hi, After installation when I browse home page of Reports folder http://localhost/Reports$SQL2008/Pages/Folder.aspx I got the following message Unable to connect to the remote server What have I missed, do you have any suggestions Thanks Tag: Parameters with a union statement
- Next
  - 1
    - What is the best most efficient performant way to do a Control break in SSIS? I have an EDI file with Different Transaction types. I would like to read for a Header, capture some specific info on the header, and read for another specific tran type that comes after and capture additional info. I have a couple of ideas like tagging the records with a key and loading into two temp tables for matching later but that means I would have to do double processing. Maybe a conditional split for the two transaction types and then unioning them downstream, but not sure if the right records would be associated. Possibly tagging sequential key and writng to raw files and matching on the raw file keys downstream. I have a lot of ideas but I am looking for the best proven practice here so i don't spin my wheels or have to go back and re-engineer later. Thanks, Larry Tag: Parameters with a union statement
  - 2
    - Virtual cube In As2000 we can link 2 cubes together to create a virtual cube. But I don't see this in As2005. How can I link 2 cubes together Tag: Parameters with a union statement
  - 3
    - How to convert SQL Server datetime to Oracle timestamp (or other type with similar precision)? In SQL Server I've created a linked server to an Oracle database. I am trying to insert (within the context of an sql server table trigger) an SQL Server datetime to an Oracle column with similar precision. Oracle timestamps are not compatible with sql server datetimes and I don't know how to convert the data (or if I should use a different type of column to store the data in Oracle). I have full control over the structure of the Oracle table so I can use a different type if timestamp is not best, but I need the destination column to have at least the same precision as the sql server datetime value. What is the easiest way to do this Tag: Parameters with a union statement
  - 4
    - Domain account without a SQL login account I have a situation that I have discovered in our QA database that I need to resolve. When I looked at the Activity Monitor for our server, I discovered that a process is running under a domain user account for one of our .Net applications. The problem is that that domain user account has not been created as a SQL login account on the server. I am trying to figure out how someone can log in to the database server with a domain user account that has not been added to SQL Server as a login account. Does anyone have any insight on this I don't like the idea of someone being able to create domain account that can access the database without me granting them specific access. - Larry Tag: Parameters with a union statement
  - 5
    - SQLServerException: The statement did not return a result set when sp uses cursors I'm trying to migrate to the 2005 JDBC driver against SQL Server 2000, but I'm getting the following exception: com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set. This is similar problem to a past thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=413019&SiteID=1 The difference is that my stored procedure uses cursors. This same stored procedure works fine with the 2000 JDBC driver. Does anybody have any ideas how to resolve this problem Tag: Parameters with a union statement
  - 6
    - flat file to excel hi, i have a flat file with over 66,000 records. When I transfer it to excel (2003), it does not fit in due to limitation of rows. What can I do so that the remaining rows which will not fit in will go to another sheet. thanks a lot! cherriesh Tag: Parameters with a union statement
  - 7
    - Displaying an database image in SSRS Report page header How to display an database image in the Report page header of sql server reporting service Tag: Parameters with a union statement
  - 8
    - group by and count of each group Hi, I use group by myItem, that displays rows for each value of myItem. I want at the end of each group for each specific myItem, I want an extra row to tell me the count of the rows for that group. How do i do that please. Here s what I need, for example for this set of rows: myItem colum2 colum3 711056 22662 Finances / -2291 -2479916 711056 22663 Finances / -2380 -2576255 711056 43428 Cda) -323 -349635 711056 43428 . -B-(Cda) -44 -47628 711057 44348 . -B-(Cda) -355 -384273 711057 47033 . -B-(Cda) -1278 -1383384 I need 2 extra rows, one at the end of the items 711056 telling me there are 4 rows for the item 711056 and one row at the very end telling me there are: 2 rows for the item: 711057 Thanks a lot. Tag: Parameters with a union statement
  - 9
    - Advice on developing a mobile app that uses SQL 2005 CE Hi, I am new to SQL 2005 CE but fairly experienced with SQL 2000 and know my way around SQL 2005. I am creating a PDA app that must support the following scenario: My company has a SQL 2000 server with a "computer assets" database. This asset database must be able to be transferred to an .sdf file (SQL 2005 mobile) on the PDA when the user docks their PDA to the desktop PC (not the same machine as the SQL 2000 server). This transfer can be via an option in the mobile app that is initiated by the user, or automatic. The mobile application basically supports stock-taking of the assets, so users go out on site and record information about the assets. This information is stored in a separate .sdf database on the PDA. When the user gets back to the office they dock with their desktop and then must transfer the data from the second .sdf database onto the SQL 200 server. Lets call this the "asset metadata". thats basically it! but im having issues finding the right process to attack the data transfer tasks. My issues: - Firstly, how do i populate the .sdf on the PDA for development purposes Microsoft tutorials seem to be geared at SQL server 2005 management studio only. I only have SQL server 2005 Management Studio Express on my development machine as well as all the necessary SQL 2005 CE SDKs and VS2005. We do not use SQL Server 2005 at my organisation as yet and it will be some time before we migrate across. In effect im looking for something that behaves like a DTS package to transfer data across. - How to populate the "asset database" .sdf file from the SQL 2000 server when the user has docked to their desktop PC (This needs to be refreshed ) - How to transfer the "asset metadata" from the .sdf on the PDA to the SQL server ive looked at merge replication a little but am not sure whether this is what i need and again most online information seem to be tailored to SQL Server 2005. Can anyone kindly point me in the right direction Tag: Parameters with a union statement
  - 10
    - Simultaneous execution of the same SSIS package from code Hello I am trying to call the same package with different starting parameters using asynchronous method calls. My code is namespace ReconHost { public partial class HostContainer : Form { public delegate void InvokePackageHandler ( Microsoft.SqlServer.Dts.Runtime. Application app, int var ); Microsoft.SqlServer.Dts.Runtime. Application app; public HostContainer() { InitializeComponent(); for ( int i = 0; i < 2; i++) { app = new Microsoft.SqlServer.Dts.Runtime. Application (); InvokePackageHandler asyncInvokePackageHandler = InvokePackage; asyncInvokePackageHandler.BeginInvoke(app, i, null , null ); } } public void InvokePackage(Microsoft.SqlServer.Dts.Runtime. Application app, int var) { Package pkg = app.LoadPackage( @"c:\GRS\GRS\GRS\Test_Async.dtsx" , null ); pkg.Variables[ "intVar" ].Value = var; pkg.Execute(); pkg = null ; } } } If I set the for loop to loop just once, the package is executed fine. Any more than once and only one instance of the package is executed. Does anyone know what I am doing wrong I know it is possible to execute the two package instances simultaneously because you can use DTexecUI.exe on two clients to do this. Thanks in advance Tomo Tag: Parameters with a union statement
  - 11
    - Folder Location Hello, We have as a part of our application installer, a section where the user has the ability to set up the database for the application. We create the database using SMO. The data files are created at a default location. What I would like to acheive is the possibility of allowing the user the ability to select a location where the files may be created. Essentially something on the lines of what is available via the enterprise manager. Something that will allow the user to explore the file system on the database server. I dont want to be doing any extensive custom work in order to acheive this feature. Is there a simple way we can do this Is there some API that will let me explore a remote file system quite easily Thanks, Avinash Tag: Parameters with a union statement
  - 12
    - How to alter(add) a Table with a default value and by allowing Nulls? Hi I am using this query to alter a table ALTER TABLE myTable ADD age int NULL DEFAULT ( 0 ) But above query is adding age field by storing Nulls but not with default values So I need to add age field to the table by storing default value as 0 and by allowing Nulls Please advice Thanks Tag: Parameters with a union statement
  - 13
    - Configuration File Woes!! I have a package for which I have set ProtectionLevel to DontSaveSenstive. I connect to a SQL Database which supports mixed authentication. To connect to this server in a flexible way, I have enabled SSIS package configuration. I have edited my dtsconfig file with notepad and put the right password there (I am able to use management studio to connect to that database using same password). Now when I come back to BIDS and double click on my connection manager, it doesn't read the configuration from the config file. (it just has a blank password). So it seems that BIDS doesn't read the config file. What can I do to make BIDS read the config file. Also, is there a way to encrypt the password (without keys) in the configuration file regards, Abhishek. Tag: Parameters with a union statement
  - 14
    - Filtering Most recent Date using ssis Hi I have a issue here where i have to store a record from a flat file into Sql Server Table. The criteria is that there are records in flatfile having same business key but different transaction dates. I have to place only htose records into the table which are having recent or greater transaction date . example name age date xyx 34 00000000 xyx 34 20071103 xyx 34 20071031 key age and Name ihave to pick only one record with greater o recent date from 3. What approach should i take. Some of the Business keys conssit of 2 or 3 columns . I have to insert or store only the recent Date consisting records. how do i acheive this please help me. Tag: Parameters with a union statement
  - 15
    - Issues with Logging option in SSIS Hi, I have enabled logging in my package and am using sql table to capture. i have defined a connection for it and i have defined it in the logging option. Once the logging is enabled, using package configurations, i am storing the value for the property "logging mode= 1", which means enabled in the table. But when i close and reopen the package, the package is failing to enable the logging. Even though i have stored the logging mode value in the configurations table, it is not getting enabled. Please help me solve this. Workaround i have tried is declaring a variable explicitly to store the logging mode value and use it in the expressions of the pkg to define the logging mode. This variable is saved in the configuration table. This way works. but i want to know why it is not working with loggingmode value reading directly from configuration entries. Vivek S Tag: Parameters with a union statement
  - 16
    - How to Set Record Length for the Flatfiles in SSIS I am trying to transfer the data from OLEDB source to Flatfile destination. My Client need the flatfile of Record Length 80 Bytes. What does this means Does it mean the output width or does it mean the flatfile format should be fixed length please explain Tag: Parameters with a union statement

ordure

I have a report that is using a union statement to pull in data from two identical tables except that one is for current month, the other for archived data.

What I want to do is prompt the user once for a date and use the value to select from the right table. Since a sales date can only exist in one of the tables, one union will work, the other not.

But the report in prompting me for a parameter for each query....which is in Informix and the prompt is this: " "

Is there anyway to force both halves of the query to see this as one parameter so the user is only prompted once

Thanks

Top

Re: Parameters with a union statement

NoKnight

Have you tried to use this sql structure

="select * from table_1 where Sale_date = '" & format(Parameters!date,"MM-dd-yyyy") & "'"
union
select * from table_2 where Sale_date = '" & format(Parameters!date,"MM-dd-yyyy") & "'"

Top

Re: Parameters with a union statement

ordure

Can I do this in the data set

Thanks

Top