Reports Containing Drill Through Interactive Bar Charts Not Working Properly When Deployed
Feb 9, 2006
Hi all,
Drill through bar charts work great in the report designer preview, but as soon as I deploy the report, and view the report in a webpage, drill through does not work smoothly.
I have to move the mouse around to be able to find a place on the bar to click through to the next report. Sometimes, I am able to click on the bar to go to next report, but then sometimes I have to click on the label, and other times somewhere in the vicinity of the label.
Any help will be much appreciated.
Thanks,
Kanwal
View 1 Replies
ADVERTISEMENT
Dec 20, 2007
Hello,
I have a drill down report and would like to add interactive sort on two columns:- column 1 & column 2. These two columns should be in descending order. By adding this, when user's click on column 1 they will see the data based on the sorted order.
Does anyone help me on this issue.
Thanks,
BL
View 5 Replies
View Related
Aug 20, 2015
I am using Report Builder 3.0 and i have report which has a drill down group. The report opens in a collapsed form.This report has interactive sorting on a column. But,when we drill down and sort the column, the group collapses and the details disappear.
In some posts, i have seen that instead of interactive sorting, people recommended a parameter. But i have to do interactive sorting only.
View 3 Replies
View Related
Jan 17, 2006
Interactive sorting works just fine on my report until I set the
execution property to render from snapshot. When viewing a snapshot,
clicking on the column sort arrows will not sort the data I'm viewing. If I turn the snapshot feature off, then I get the interactive sort functionality back.
Is this by design or am I missing something fundamental here?
Using SQL 2005, RS 2005, VS 2005.
Thanks.
View 2 Replies
View Related
Sep 17, 2007
Hi,
I am new to reporting services. We are creating a report with drill-down capability. We have a Date dimension hierarchy defined as Year - Month - Day.
On the report, we expect reporting services send MDX query to SSAS to get the total sales just for the the year, say 2007, when we click the year 2007. Then it send query just to aggregate sales for that month when we click a month.
But when we build the reports, it looks like it always aggregate for all levels. So the performance is bad to first open the report.
How do I resolve this issue? Please help.
Thanks,
Jia
View 3 Replies
View Related
Aug 28, 2013
I have a report  that has a drill down option that shows all workgroups within a specific  parent group and an interactive sorting ass well on both columns  parent group &  workgroupÂ
This is displayed  in pps combined with a SharePoint
The problem is that after sorting the parent group column by name I then press the drill through icon  (+) next to it hopping to see all workgroups related to each parent group - but insteadÂ
I receive this Reporting Services Error  :
The value for parameter 'SortItem' is not specified. It is either missing from the function call, or it is set to null. (rsMissingParameter)
If I don't press the sorting and just drill through it works fine. the sorting itself also works fine.
View 3 Replies
View Related
Feb 17, 2012
I replied to an thread in the pre-2010 forum before I realized the forum I was in...
I'm using Visual Studio 2008 to Design my SSRS reports. The report viewer is using SharePoint 2010 SP1 integrated mode.
I am using a conditional statement to determine which report to drill to based on the SSRS textbox's column.
=iif((Fields!Type.Value =
"Total")OR
(Fields!Type.Value ="Variance - (F)/U"),"DivisionSpendingReport","DivisionSpendingReportDetail")
Works fine in Visual Studio. Once deployed to SharePoint though, the drill through returns an error that says report can't be found. So I added the .rdl to the conditional statement in the report Design.
=iif((Fields!Type.Value =
"Total")OR
(Fields!Type.Value ="Variance - (F)/U"),"DivisionSpendingReport.rdl","DivisionSpendingReportDetail.rdl")
It now works in SharePoint but not in Visual Studio...
Do I need to keep adding and removing the ".rdl" in order to make any changes to this report???!!!
View 4 Replies
View Related
Oct 25, 2007
Hi All,
We have 10 charts in One RDL file, out of these 10 charts 3 Pie charts are displayed dynamically,
Using 'Visibility' property expression in the 'Hidden' sub property as below.
Code Block
=iif(Sum(Fields!Total.Value, "DataSet")=0,true,False)
Which returns 'true' or 'false' for 'Hidden' property.
Each chart has to be displayed on separate page, hence we have set 'PageBreakAtEnd' Property to true for each chart.
Problem:
But, when this RDL file is deployed on report server, these charts are all displayed on single page without any page breaks.
however, when the RDL file is exported in PDF format, the report is rendered with charts on separate pages as expected.
Is there any way to ensure the charts are rendered properly, in report viewer of report server ?
View 1 Replies
View Related
Jul 31, 2007
Hi All,
I deployed many reports in sql server 2005 reporting services. I want to remove some of the unnecessary reports. How to remove those reports?
thank you
thanks,
Muniappan Kandasamy
View 1 Replies
View Related
Apr 27, 2007
I have created several reports in SRS and I deploy them by establishing a VPN connection than deploying. That much works fine.
Now I want to allow user of my website to access the reports by clicking on a link. Do I need to establish user level access for the reports for each user or just one public access account? How do I pass login and credential information with the link so that users can access the report.
Thanks in advance
View 3 Replies
View Related
Jul 13, 2007
My reports are not allowing me to "Clickthrough" to more detailed reports.
I want my report to automatically show a detail record when they select some "interactive data" in my reports.
I have read a page on this stuff ( http://msdn2.microsoft.com/en-us/library/ms345252.aspx ) which states:
In Report Builder, a clickthrough report is a report that provides detailed information about the data contained within the main report. A clickthrough report is displayed when the Report Builder user clicks the interactive data that appears in the main report. These reports are automatically generated by the report server. You, as the model designer, determine what is displayed in clickthrough reports by setting the DefaultDetailAttribute and DefaultAggregateAttribute properties that you assign to an entity in the report model.
Hence, within my report model i have created an entity with a number of DefaultDetailAttributes.
I have not created a specific "click through" report as i would be happy to view the automatically generated report that should contain the attributes defined in the "DefaultDetailAttributes" list.
However, when i view the report, no data items are links (or "interactive data" as the msdn article describe them).
Has anyone got any ideas on how to make the report data interactive?
Thanks,
pete
View 1 Replies
View Related
Mar 31, 2006
Hello-
I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.
Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'
I get these errors also when invoking these reports through a form post.
It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.
Thanks.
View 13 Replies
View Related
Sep 14, 2005
I am writing a VB6/SQL Server database app.I know I can't add charts to data reports.What is the best means of creating printable reports containing charts -should I simply create a form which contains the required charts & make itpossible to print this out ?.TIA,woodglass...
View 2 Replies
View Related
Aug 3, 2007
Hi to all,
I am newbie to Reporting Services technology
I am trying to develop some reports in Reporting Services using Visual Studio Management Express.
Is there a way to create some charts and graphs inside a report?
Have I to use Report Builder?
Thanks a lot
Bye
View 2 Replies
View Related
Jun 15, 2007
I am just starting with Sql Server reporting, but I can't get interactive sort to work for columns with aggregate fields.
I am using the following query for DataSet:
SELECT
Store.ID as StoreID,
Store.Name as StoreName,
COUNT(*) as NumReservations,
SUM(Appointment.TotalBeforeTaxes) as Revenue
FROM Store LEFT JOIN Appointment ON Store.ID=Appointment.StoreID
GROUP BY ALL Store.ID, Store.Name
ORDER BY Store.Name ASC
For report, I am using tabular data view. Interactive sorting works great for StoreID, StoreName, but doesn't work for NumReservations and Revenue fields. I turned it on for all 4 columns.
What could be causing this problem?
View 1 Replies
View Related
Aug 7, 2007
I'm having problem with sorting in matrix. My report looks something like below.
Name* Avg.* | Test1 Test2 Test3
==============================================
Jim 50% | 100% 40% 10%
John 28% | 5% 40% 40%
The column with * need to be sorted. I can sort the name and average fine in Microsoft SQL Server Reporting Services Version 9.00.2047.00. BUt when I run this in another environment, sorting on Avg doesn't work. The version on that is Microsoft SQL Server Reporting Services Version 9.00.3054.00.
I put together a sample code against the northwinddatabase. Sorting works in 9.00.2047.00 but not 9.00.3054.00. Any ideas??
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataSource11">
<DataSourceReference>DataSource1</DataSourceReference>
<rdataSourceID>632d2cbd-3d9c-44fe-97ac-fbdef687ef47</rdataSourceID>
</DataSource>
</DataSources>
<BottomMargin>0.25in</BottomMargin>
<RightMargin>0.25in</RightMargin>
<PageWidth>11in</PageWidth>
<ReportParameters>
<ReportParameter Name="objecttype">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Student</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Object Type</Prompt>
</ReportParameter>
<ReportParameter Name="testid">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>481</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>testid</Prompt>
</ReportParameter>
<ReportParameter Name="groupby">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Element</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>groupby</Prompt>
</ReportParameter>
<ReportParameter Name="usertestdoc">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>6453bybbyq</Value>
</Values>
</DefaultValue>
<Prompt>usertestdoc</Prompt>
</ReportParameter>
<ReportParameter Name="dbserver">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Data Source=10.88.22.00;Initial Catalog=xxx;User ID=sa;Password=xxxxx</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>dbserver</Prompt>
</ReportParameter>
<ReportParameter Name="copyright">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value>Copyright 2007 </Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>copyright</Prompt>
</ReportParameter>
<ReportParameter Name="levelby">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Teacher</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>levelby</Prompt>
</ReportParameter>
<ReportParameter Name="objectid">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>0</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>objectid</Prompt>
</ReportParameter>
</ReportParameters>
<rdrawGrid>true</rdrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:GridSpacing>0.0625in</rd:GridSpacing>
<rdnapToGrid>true</rdnapToGrid>
<Body>
<ReportItems>
<Matrix Name="matrix1">
<MatrixColumns>
<MatrixColumn>
<Width>1.73189in</Width>
</MatrixColumn>
</MatrixColumns>
<Left>0.5in</Left>
<RowGroupings>
<RowGrouping>
<Width>2.3125in</Width>
<DynamicRows>
<ReportItems>
<Textbox Name="shipcountry_1">
<rdefaultName>shipcountry_1</rdefaultName>
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=count(Fields!orderid.value)</Value>
</Textbox>
</ReportItems>
<Grouping Name="matrix1_RowGroup1">
<GroupExpressions>
<GroupExpression>=Fields!shipcountry.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicRows>
</RowGrouping>
</RowGroupings>
<ColumnGroupings>
<ColumnGrouping>
<DynamicColumns>
<ReportItems>
<Textbox Name="customerid">
<rdefaultName>customerid</rdefaultName>
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!customerid.Value</Value>
</Textbox>
</ReportItems>
<Grouping Name="matrix1_shipcountry">
<GroupExpressions>
<GroupExpression>=Fields!customerid.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicColumns>
<Height>0.4375in</Height>
</ColumnGrouping>
</ColumnGroupings>
<DataSetName>dataset</DataSetName>
<Top>0.625in</Top>
<Width>4.04439in</Width>
<Corner>
<ReportItems>
<Rectangle Name="rectangle1">
<ReportItems>
<Textbox Name="textbox1">
<Left>0.0625in</Left>
<Top>0.1875in</Top>
<rdefaultName>textbox1</rdefaultName>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=count(Fields!orderid.Value)</SortExpression>
<SortExpressionScope>matrix1_RowGroup1</SortExpressionScope>
</UserSort>
<Value>SORTME</Value>
</Textbox>
</ReportItems>
<ZIndex>3</ZIndex>
</Rectangle>
</ReportItems>
</Corner>
<Height>0.88597in</Height>
<MatrixRows>
<MatrixRow>
<Height>0.44847in</Height>
<MatrixCells>
<MatrixCell>
<ReportItems>
<Textbox Name="textbox4">
<rdefaultName>textbox4</rdefaultName>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=count(Fields!orderid.Value)</Value>
</Textbox>
</ReportItems>
</MatrixCell>
</MatrixCells>
</MatrixRow>
</MatrixRows>
</Matrix>
</ReportItems>
<Height>2.5625in</Height>
</Body>
<rd:ReportID>98ed88ab-a457-4446-8b4c-ff275e2b5e03</rd:ReportID>
<LeftMargin>0.25in</LeftMargin>
<DataSets>
<DataSet Name="dataset">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select top 30 shipcountry, customerid, orderid from orders</CommandText>
<DataSourceName>DataSource11</DataSourceName>
</Query>
<Fields>
<Field Name="shipcountry">
<rd:TypeName>System.String</rd:TypeName>
<DataField>shipcountry</DataField>
</Field>
<Field Name="customerid">
<rd:TypeName>System.String</rd:TypeName>
<DataField>customerid</DataField>
</Field>
<Field Name="orderid">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>orderid</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Code />
<Width>10.3125in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<PageFooter>
<Height>0.1875in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>0.25in</TopMargin>
<PageHeight>8.5in</PageHeight>
</Report>
View 2 Replies
View Related
Jul 30, 2007
We will making a change to our Reporting Services deployment next month. We will be moving from our SQL 2000 server to a new SQL 2005 server. In addition, we will moving from a Local Catalog Deployment to a Remote Catalog Deployment. My question is this: Is there a way I can prevent my team from having to manually redeploy our reports in the new system? They have not been diligent about saving the Visual Studio solution or project files, so they will have to pull the most up-to-date RDL's off the server and deploy them on the new server one by one.
I suppose I can install SQL 2000 on the new server first, then move the Reporting Services databases to the new server, then upgrade the server to 2005, but installing 2000 and upgrading to 2005 does not sound like a best practice. I would prefer a clean install of 2005. Does anyone know if I can move the deployed reports from one server to another?
Paul Teal
paul@partytilyoupop.com
View 1 Replies
View Related
Oct 20, 2007
Hi All,
we are changing some reports from English to German...some of the reports that we have changed generate the message 'An internal error occurred on the report server. See the error log for more details.'
We go to
C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles
On the machine but we cannot find any more detailed error messages...
Does anyone have any idea as to whether the messages migh be written somewhere else?
Thanks and Best Regards
View 1 Replies
View Related
Feb 13, 2007
Hello,
We have successfully developed the reports on our testing machine with SQL Server 2000 Enterprise + Reporting Services 2000 Enterprise. Is there any problem if we deploy the reports to the production machine that runs SQL Server 2000 Standard and Reporting Services 2000 Standard?
Thanks in advance!
View 1 Replies
View Related
Mar 7, 2008
Hi all,What is Drill Down Reports in Reporting Servies.How can i design Drill Down Reports.
Give me any example to desing Drill Down Reports.
Regards.
View 5 Replies
View Related
Feb 21, 2007
Any way to have the drill through report open in a new window on the web?
View 4 Replies
View Related
Sep 11, 2007
Hi all
is it possible make drill down reports in crystal
my requirement is like
i have n rows in my report
if am clicking the first column in first row it will list details of that row in between first and second row
Same for all the rows
Quick reply is appreciated
Regards
Rameez
View 2 Replies
View Related
Jan 17, 2007
Hello, i have something like this, i want the annoucements (status = 0) to be on top, then topics with (status = 1) below, then the rest of the topics.
So i tried:
SELECT forum_topics.id, forum_topics.status, forum_topics.username AS starter, forum_topics.subject, forum_topics.closed, forum_topics.answerpostid, forum_topics.views, forum_topics.answers, forum_topics.lastanswer, forum_topics.lastanswerid, forum_topics.created AS started, forum_answer.username, forum_answer.answer, forum_answer.created FROM forum_topics LEFT OUTER JOIN forum_answer ON forum_answer.id = forum_topics.lastanswerid WHERE (boardid = @ID OR boardid = 0) ORDER BY (status) ASC, (created) ASC
Problem is that they are not sorted diffrently, when i change the (created) ASC to (created) DESC i get the same result and the rows are not sorted, they only get sorted by status so i have status=0 at the top, then status=1 then the rest. How do i get them to be sorted first by status ASC then by created ASC/DESC?
Patrick
View 1 Replies
View Related
Apr 21, 2008
Hello friends, I have developed an ASP.NET 2.0 application. The problem is that the IIS server returns the next error:
SQL Server does not allow remote connections
Sometimes returns:
SQL Server does not exists.
My question is if there is any known bug with ASP.NET and SQL Server. My sql server have activated the Remote Connections (its working properly on other web page).
Its a problem of the number of connections??
Its a problem ofbad configuration??
Its a IIS problem??
Please bring me some help.
View 8 Replies
View Related
Dec 25, 2007
Hi,
I am exporting a table to a fixed width flat file using "Ragged Right" format. Though i specify carriage return for the last column, the text file is not taking it up.
I am doing the following for connection
cmFlatFile.properties("Format").SetValue(cmFlatFile,"RaggedRight")
cmFlatFile.properties("RowDelimiter").SetValue(cmFlatFile,vbCrLf)
and while adding the column i am setting up the width as follows
vColumns = flatFileDestination.InputCollection(0).GetVirutalInput().VirtualInputColumnCollection
For cols = 0 to vColumns.Count -1
Dim col As IDTSConnectionManagerFlatFileColumn90 = ff.Columns.Add()
if cols = vColumns.Count - 1 Then
col.ColumnDelimiter = vbCrLf
end if
cols.ColumnType = "FixedWidth"
cols.Columnwidth = 20
......
Next cols
Still the rows are exported next to each other just like when we use FixedWidth.
View 4 Replies
View Related
Oct 2, 2007
Hi,
I have several packages where I set up a SQL Server log provider. The packages are all called from jobs.
However, for some reason, only ONE of the packages is logging to the sysdtslog90 table in my specified database.
All of packages have the identical set up for the logging. Here are my settings under logging:
PROVIDERS AND LOGS:
Name: SSIS Log Provider for SQL Server (box is checked)
Configuration: ServerName.DBName (I use this same connection for all the packages)
DETAILS:
OnError is checked
CONTAINERS:
All items are checked
So what's going on here? I have successfully logged to this table using test cases in BIDS, and as I mentioned, ONE of the packages is actually logging to the table when it's called from the job.
Thanks
View 5 Replies
View Related
Mar 15, 2007
I've installed Report Server 2005 Express on my XP Pro workstation. When I try to pring up the reports page (http://localhost/Reports) all I get is the following:
"<%@ Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePage" %>
<%@ Register TagPrefix="MSRS" Namespace="Microsoft.ReportingServices.UI" Assembly="ReportingServicesWebUserInterface" %>"
I've been trying to go through the Video training from MSDN, and followed the install as they did it, but my page won't come up. Very new to this so any and all help would be greatly apprecicated. My IIS knowledge is beginner.
Thanks,
C.J.
View 5 Replies
View Related
Nov 21, 2007
Hi All,
Am new to Reporting Services. I need to create some drill down reports. Am unable to find any guidance or tutorials. Anyone please help me to create drill down reports
Thanks in advance
Regards
Nataraj.C
View 3 Replies
View Related
Nov 21, 2007
Hi all,
Am new to SQL Server Reporting services. I need to create some Drill down reports. Am unable to find any guidance or tutorials for that. Please help me to create variety of drill down reports.
Thanks in advance.
Regards
Nataraj.C
View 2 Replies
View Related
Jul 23, 2007
How do I drill through to a report from a report that's in a different directory? In the designer I can only drill through to reports that are in that project. I'm sure that there is a simple solution (hopefully!).
View 1 Replies
View Related
Oct 11, 2007
Hi all,
I use SqlHelper to connect to database. I need to set a timeout to execute some sp because I don´t want to wait for this sp if it make me wait a lot. So I set the Connection TimeOut every time I execute a sp. But this seems not working properly. I set this value to 5 and I execute a sp than runs in 15 but It waits for it.
Any idea
Best regards
www.ITCubo.net
View 1 Replies
View Related
Oct 4, 2004
We've altered an UPDATE trigger - now it doesn't work properly. When updating a record (via a web application) by clearing the value for a particlar column, we get error:
UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
Code = 800a0c93
Source = ADODB.Recordset
Description = Operation is not allowed in this context.
What the trigger does is prevent a zero-length string from being inserted into the database, which violates a check constraint, and instead inserts NULL. The web app - whose code we cannot modify - apparently does this. This was working fine, until we altered the trigger to add an additional column for update. Our SQL developer person has left, so us less knowledgable (about SQL) folks are trying to pick up the slack.
trigger code:
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
ALTER TRIGGER trigViaNetCardholderUpdateEmptyStrings
ON viewViaNetCardholder
INSTEAD OF UPDATE AS
UPDATE tblIDCross
SET
tblIDCross.chUSCId = CASE WHEN ins.chUSCId = '' THEN NULL ELSE ins.chUSCId END,
tblIDCross.chNineDigit = CASE WHEN ins.chNineDigit = '' THEN NULL ELSE ins.chNineDigit END,
tblIDCross.chPID = CASE WHEN ins.chPID = '' THEN NULL ELSE ins.chPID END,
tblIDCross.chEmployeeId = CASE WHEN ins.chEmployeeId = '' THEN NULL ELSE ins.chEmployeeId END,
tblIDCross.chAIMSNumber = CASE WHEN ins.chAIMSNumber = '' THEN NULL ELSE ins.chAIMSNumber END,
tblIDCross.intCustomerType = ins.intCustomerType
FROM INSERTED ins
WHERE tblIDCross.intUSCardId = ins.intUSCardId
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Please help...
View 1 Replies
View Related
Mar 28, 2008
Hi guys, I am importing a file using the Bulk Insert command, but the fieldterminator is not working for me.
My data:
“lname�, “fname�, “addr�, “phone�, “lang�
My command:
BULK INSERT dbo.zGE_RCF_POS_IMPORT FROM 'E:operationsdatafilesGEFTPINGE_RCF_POS_EXPORT.txt'
WITH (FIELDTERMINATOR = '","')
The quote are removed from every field except the first quote in front of lname and the trailing quote behind lang. I tried changing the command to:
BULK INSERT dbo.zGE_RCF_POS_IMPORT FROM 'E:operationsdatafilesGEFTPINGE_RCF_POS_EXPORT.txt'
WITH (FIELDTERMINATOR = '"')
But ran into field conversion problems, I also tried defining two fieldterminators got a syntax error. How can I get the desired results of removing all dbl quotes? Or do I have to write something to follow the Bulk Insert to remove the leading and trailing quotes?
View 4 Replies
View Related
