Heirarchy Already Appears In The Axis1 Axis

May 22, 2008

Hi All,

I'm using VS2005 and I'm trying to create a report but two of the parameter, I think, have the same heirarchy?
Well, I am getting this error when I go to view the report:

An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for data set 'dsWorkItemHistory'
The System_State heirarchy already appears in the axis1 axis
My problem is I want one parameter to be WorkItemType and another parameter to be WorkItemState.
For WorkItemTypeParam
I have:


Parameter: WorkItemTypeParam
Dimension: Work Item
Hierarchy: Work Item.Work Item Type
Multi-Value with Default All
For WorkItemState
I have:


Parameter: WorkItemState
Dimension: Work Item
Hierarchy: Work Item.State
Multi-Value with Default All
My Dataset is:

WITH

MEMBER

[Measures].[Date Key] AS

[Date].[Date].CurrentMember.UniqueName

MEMBER

[Measures].[Moving Average] as

AVG({[Date].[Date].currentmember.lag(@IterationParam):

[Date].[Date].currentmember},[Measures].[Configuresoft_ComplexityRank])

SELECT

{

[Measures].[Date Key],

[Measures].[Configuresoft_ComplexityRank],

[Measures].[Moving Average]



} ON COLUMNS,

(

[Work Item].[System_State].[System_State],

(StrToMember(@StartDateParam):StrToMember(@EndDateParam))

)

ON ROWS

FROM [Team System]

WHERE

(

STRTOMEMBER("[Team Project].[Team Project].["+@Project+"]"),

STRTOSET(@IterationParam),

STRTOSET(@AreaParam),

STRTOSET(@AssignedTo),

STRTOSET(@WorkItemTypeParam),

STRTOSET(@WorkItemState)

)


Does anyone have any suggestions on this?

Thanks,
Nici

View 7 Replies


ADVERTISEMENT

Question (X-axis): How Does Automatic X-axis Label Positioning Work?

Jul 19, 2007

All,

I have read through the following:

http://technet.microsoft.com/en-us/library/aa964128.aspx.

The relevant section of this document is :-

Question (X-axis): How does automatic x-axis label positioning work?
Answer: Currently, built-in Reporting Services charts only allow automatic positioning in order to avoid overlapping the x-axis labels. The label direction (horizontal/vertical) of the axis labels depends on the label string sizes and the available space. X-axis labels are either shown horizontally in one line, horizontally in multiple lines with line breaks, or vertically. Showing x-axis labels at an angle, or explicit manual control over individual x-axis label positions is currently not supported.

Note There are several third-party chart add-ins that enable more control over axis labels. These add-ins can be installed on top of Reporting Services 2005.

I have exactly the problem indicated above in that some sectors of my Pie Charts I am are trying to produce are small and are close together thus labels overlap in some cases. As it says above, only automatic placing of the labels is available, but there could be a solution through third party software.

Does anyone know of a 3rd party solution/add in or a workaround?

Thanks
Msuk

View 3 Replies View Related

Chart Problem: Multiple Values To Y-axis For The The Same X-axis Value

Jan 14, 2007

I have a simple-column chart and in the x-axis I put the date values and in the y-axis the sale price values.

The chart works perfectly in the case when there is only one sale price for the same date. But, when the price changes during the same day, then there is problem. In the following example

x y

1/1/2007 6.25

2/1/2007 7

2/1/2007 4

3/1/2007 8

the chart will have three columns and in the date 2/1/2007 will display the min or max of the two values. What I need is to represent all the values i.e. the chart must have four columns , as much as the rows of the dataset

Is it possible?

View 1 Replies View Related

Function On Heirarchy Nodes

Feb 3, 2006

Hi
i have 3 master tables 1)RoleDetails(Roleid(PK),name,masterroleid(fk) ref:RoleDetails roleid)
2) PositionDetails(positionid(PK), name,MasterPositionid(FK) ref:PostionDetails postionid,Roleid(fk) ref:Roledetails roleid)
3) Userdetails(userid(pk), loginid,pwd,roleid(fk) ref:roledetails roleid,positionid(fk)ref:postionDetails positionid,fname,address)
how to Create two functions one return child nodes as per Case 1 and another one is return Parent Nodes
as per case 2
(Manager) a -- r1 (roledetails)
/

(ROL)a1 (ROL) a2 -- r2
/ | / | |
(RO)b1 b2 b3 b4 b5 b6 -- r3
Case 1:
On passing the User ID of (a) , should get the Output as User id of ( b1,b2,b3,b4,b5,b6) along with their Role ID.

On passing the User ID of (a1), should get the Output as User ID of (b1,b2,b3)along with their Role ID.

Case 2:
On passing the Role ID of (R3), should get the User ID of all the Parent roles( a1 and a2 (R2), a(R1)long with their Role id
Case 3: on passing role id of child node , should get only all particular parent userid and roleid's.

thanks in adv.,
chakri

View 14 Replies View Related

How To Create This Table With Specific Heirarchy

Feb 20, 2007

Hi i need to create this query. I have a table here named "Subject" from the database "Filteredtask". I want the output to show in this way:

Subject Quantity

Application Recieved count of application recieved
Process Application count of process application
Screen Application count of screen application
Initial Interview count of initial interview
Technical Exam and Interview count of technical exam and interview

I have used this code. My problem is that i put it in descending order to obtain this output, but if for example Screen application had more count it will ruin the hierarchy of the subject.

SELECT subject, COUNT(subject) AS Expr1
FROM dbo.FilteredTask
WHERE (subject = N'application received') OR
(subject = 'process application') OR
(subject = 'screen application') OR
(subject = N'initial interview') OR
(subject = 'profiles assessment') OR
(subject = 'technical exam and interview')
GROUP BY subject
ORDER BY expr1 DESC

__________________________________________________
Your future is made by the things you are presently doing.

Andrew

View 4 Replies View Related

Chart X-axis Y-axis

Jan 17, 2007

I'm trying to convert an old chart to Reporting Services.
We have used the same dataset for years, it is very very simple. But it seems to me that Reporting Services can't deal with this simple dataset.

My question is: How can I get create a line chart using this dataset.

The data set consists of 1 row with 96 columns (a day divided into 96 sets of 15 minutes). Each column records how many events occurs within the 15 minutes. Along the x axis I would like to display a vertical line every 4 hours. The y axis should be numbered 0 to the highest value in the results.


I could not make this dataset any more simple than it is. But Reporting Services just chokes on this.

Here is a sample of the dataset :
1 2 0 4 5 6 7 8 9 10... 96

View 1 Replies View Related

Scheduler 2 Appears To Be Hung.??

Apr 26, 2004

Hi,

Below messages got throwed to sql ErrorLog. I could'nt understand what it means.. any help is appericated.

The Scheduler 2 appears to be hung. SPID 0, ECID 0, UMS Context 0x03CBAA40.

Error: 17883, Severity: 1, State: 0

WARNING: EC 36b9c098, 8 waited 300 sec. on latch 444f3b84. Not a BUF latch.

thanks,
-J

View 3 Replies View Related

Scheduler 0 Appears To Be Hung

Aug 13, 2004

Hello,

The users of my microsoft SQLServer 7 database could not log on to the database after the following message has appeared in the log file;

The Scheduler 0 appears to be hung. PSS 0x5B1630C8, EC 0x5B163278, UMS Context 0x3FC37E88

The problem was solved after I have restarted the database. I would be grateful if you could show me how to avoid such a problem in the near future.

Regards,

Albert

View 4 Replies View Related

Euro Symbol Appears Like A '?' Instead '€'

Apr 6, 2004

I have SQL Server 2000 SP3 and the default Code Page is:

I have a Table with a column of the type 'text'.
In this column sometimes it's necessary introduce the euro symbol (€). Now, when we write this symbol, after the SQL Server show it with a '?'.

I tried change the column collation to 'Latin1_General_CI_AI', ‘SQL_Latin1_General_CP1_CI_AI’ and ‘SQL_Latin1_General_CP850_CI_AI’ but there is the same problem.

Does any know what the cause off this problem is?

Thanks in advance!

View 2 Replies View Related

Appears To Load 3.0 In Emulator Instead Of 3.1

Feb 12, 2007

Here's what I did to a VS2005 Smart Device application.


Removed the reference to System.Data.SqlServerCe.dll.
Set a reference to C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce500 System.Data.SqlServerCe.dll.
While it€™s loading in the emulator I notice that it appears to still be loading SQLCE3.0 instead of 3.1.
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500ARMV4isqlce30.ppc.wce5.armv4i.CAB'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500ARMV4isqlce30.repl.ppc.wce5.armv4i.CAB'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500ARMV4isqlce30.dev.enu.ppc.wce5.armv4i.CAB'

Do I need to set something else?

View 1 Replies View Related

SSIS Appears To Be Installed But I Cannot Use It?

Nov 8, 2007

Hi,

When I start "SQL Server Business Intelligence Development Studio" from the start menu it fires up Visual Studio 2005 with no SSIS project options. I appear to have it installed as the service is present in the Services control panel, and DTExecUI.exe and DTExec.exe are present, but there does not appear to be an integration with Visual Studio 2005. I have attempted to start up the SQLServer configuration application from the Add/Remove Programs control panel, however it always exits with an error. What do I need to do to get this running in Visual Studio 2005?


Thanks,

Mitch

View 9 Replies View Related

I Need Help With What Appears To Be A Botched Install.

May 12, 2006

Okay, i'm learning VB.NET (and having quite a bit of fun with it). Well, I had the old beta version. Anyway, went away for a week and found I could no longer use it. Why?

"Beta period is over.".

Yeah, it sucks.

Well, I uninstalled it via the uninstaller. I upgraded my .NET framework, etc, and redownloaded VB.NET. Everything installed okay, save for the SQL server. It repeatedly fails.

I have hunted down and shot each component quite ruthlessly, but I don't know what beta component remains. I can't get it to install because it says I have beta components left.

And VB.NET works. Barely. I had to disable the hosting process, otherwise it gives me a message about an invalid binding handle. Not often that a Beta product works better than the production one.

The uninstall tool won't work for some reason. I'm this close to just reformatting.

Please help, I'd like to code again.

Thanks.

View 3 Replies View Related

A CAST That Appears To Use A Template. Is This Correct?

Feb 22, 2008

I need some feedback on how this sql is perfroming a cast. I have used CAST before, but I amlooking at a stored procedure, and the CAST looks slightly different. Usually when I do acast, it is of the form CAST(ColumnName,DataType) but this cast is slightly different as theyappear to be using some type of template to cast with. Here is the code. I will put line numbers in for reference.
 
1    CREATE TABLE #Groups2    (PartyId uniqueidentifier)3    INSERT INTO #Groups (PartyId)4    SELECT PartyId5    FROM ttg_sfGroupsByPartyId(@PartyId)67    IF (@PortalId = CAST('00000000-0000-0000-0000-000000000000' AS uniqueidentifier) AND88 @TabId = CAST('00000000-0000-0000-0000-000000000000' AS uniqueidentifier))0     BEGIN
Also just to let you know, the the values PartyId, and PortalId are GUIDS.
So, I guess my question is, are they using a kind of template to format the data? So look at lines7 and 8. Are they using some type of template to signal the compiler, that the data will be of thatformat and will be seperated by dash symbols?

View 2 Replies View Related

UMS Context Appears To Be Non-yielding On Scheduler

Feb 14, 2005

Hi,

We are running SQL Server 2000 SP3 + security patches on Windows 2000 Advance Server.

After we did the security updates released before Jan 8th,

We are getting the below error 2 times within a month and the sql server is not responding after this error. After rebooting the server, it responds and works normally.

please give me a solution for this

2005-02-13 07:16:22.54 server Error: 17883, Severity: 1, State: 0
2005-02-13 07:16:22.54 server Process 89:0 (12a68) UMS Context 0x129E1EE8 appears to be non-yielding on Scheduler 0.

2005-02-13 07:16:26.27 server Stack Signature for the dump is 0x00000000
2005-02-13 07:16:26.27 server Error: 17883, Severity: 1, State: 0
2005-02-13 07:16:26.27 server Process 86:0 (1418c) UMS Context 0x12A36D98 appears to be non-yielding on Scheduler 5.

View 2 Replies View Related

Xp_sendmail @subject Appears In Body

Nov 12, 2004

My @subject in an xp_sendmail job is appearing in the email subject where it's supposed to, but also as the first line of the body. Does anyone know of a way to disable this behavior?

View 3 Replies View Related

Document Map Not Appears When Using Internet Explorer 7

Sep 4, 2007

Hey,



I'm trying to enter reports using Internet Explorer 7, but it shows me an empty Document map.

When I'm trying to enter the same reports from other computer using Internet Explorer 6, the Document map is filled.

I compared the security options on both machines, and also added the URL of the server to the Trusted sites, but the problem still exists.



The server environment is:
WINDOWS 2003 R2 (SP2)

MSSQL 2000 (SP4) + REPORTING SERVICES



I'm trying to access the report using Windows XP (SP2)



Anyone ever handled this issue?

Any ideas how to solve it?



Thanks in advanced,


Ravid

View 7 Replies View Related

How To Add Comment Which Only Appears On The First Page Of The Report?

Sep 13, 2007

Hi, experts,

How can we add comment which only appears on the first page of the report?

I am looking forward to hearing from you for your help and thanks a lot in advance.

With kindest regards,

Yours sincerely,

View 2 Replies View Related

PDF Appears In Landscape But Prints In Portrait

Apr 28, 2008

All of my reports that are formatted 11x8.5 are outputting to PDF correctly. When I open the PDF in Adobe Acrobat, it appears in Landscape on the screen. However, when I click the print button, by default it is printing it in portrait. I can go to File-->Print Setup and change the orientation from Portrait to Landscape, but why doesn't it translate from the file orientation? This may just be a bug in the Adobe Acrobat software, but I want to make sure there isn't something I can do.

Thanks.

View 1 Replies View Related

SqlDataSource Inserted Event Appears To Execute Twice!

Nov 9, 2007

Hello
I have a piece of VB.NET code that generates an email on the SqlDataSource Inserted event.  It appears to be executing twice because it is sending two emails.  If I place the code on any other event, it just sends the one email.  Does any have a suggestion on how to handle this?
Protected Sub SqlDataSource1_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles SqlDataSource1.Inserted 
Dim MailServerName As String = "alvexch01"Dim Message As MailMessage = New MailMessage
Message.From = New MailAddress("sender@email.com")Message.To.Add("receiver@email.com")
Message.Subject = "Near Miss"
Message.Body = "Test"
Message.IsBodyHtml = True
Message.Priority = MailPriority.NormalDim MailClient As SmtpClient = New SmtpClient
MailClient.Host = MailServerName
MailClient.Send(Message)
Message.IsBodyHtml = True
Message.Dispose()
End Sub

View 1 Replies View Related

Error: 17883 - The Scheduler 0 Appears To Be Hung.

May 6, 2004

Environment:
Clustered SQL Server 2K sp3a (single instance)
Product version: 8.00.760
Problem:
I end up in error 17883.
I am aware that the solution is to apply this patch:
821277 MS03-031:Security Patch for SQL Server 2000 Service Pack 3.
I am also aware that after you install this cumulative patch you will end up in this problem:
826161 FIX: You are prompted for password after you change a standard SQL Server login.
After reading this one I found that there are 2 possibility to solve this problem, one if you have already installed the security patch from MS03-031 and another one if you do NOT have installed this patch.
Question:
Do I only need to apply this last one (is it also cumulative?) or do I need to first apply MS03-031 and then later the FIX 826161?
Please advise.
Kind regards.

View 1 Replies View Related

Saving DTS Package Appears To Work But Doesn't

Jul 11, 2001

I have several DTS packages saved 'locally' to the SQL server. I want to duplicate a package, so that I can make some changes then replace the original. I certainly don't want to rebuild the entire package from scratch. So, I open up the original package, go to the 'Package' menu and choose 'Save As', then give it a new name and press OK. No errors, all appears well, the title bar even shows the new name of the package. But, when I close the package and go the the 'local' package list, it (the new package name) doesn't appear in the list. Refresh, exit SEM, reboot - doesn't show up. I even looked in the MSDB table where packages are supposed to be stored (at least the name / package id / etc), and it doesn't show there as well. Tried from several client machines.

OS: Windows 2000 Server (advanced) SP2
SQL: SQL 2000 Server (no SP's)

Any help would be great.

Bryan Parke

View 2 Replies View Related

Delete From Table1 Data That Appears In Table2

Mar 21, 2008

Hi,

I have 2 tables. Table1 and Table2.
In Table1 i have 10 rows of data and in Table 2 i have 1 row of data (which also appears in Table1).

How do i delete from Table1 the data that appears in Table2 (without using an ID key)?



Example:
I want it to be like when i use "insert into".

Insert into Table1
select * from Table2


I want it to be something like that:

Delete from Table1
select * from Table2


View 11 Replies View Related

DB Engine :: Cannot Access Destination Table - Appears Sometimes

Apr 23, 2015

I have a simple powershell script, that is writing single row to remote SQL server as sort of keepalive solution for branch machine. It opens System.Data.SqlClient.SqlConnection, SqlBulkCopy writes table, and closes connection.

Sometimes script throws an error in form of - Cannot access destination table.

We are not managing internet connectivity in that place, so I don't know for sure, but can this error be caused by connection timeout that comes when script tries to write ?

View 4 Replies View Related

<Long Text> Appears From Access Database Import

May 15, 2001

When I import data from MS Access databases, some fields appear as
"<Long Text>" in SQL. I cannot edit these fields in SQL. I have to export
the table to Access, update the field, and then import again.

There's got to be an easier way. What am I missing here?

The field in Access is of type 'memo'.

View 1 Replies View Related

Function Appears To Affect All Rows Not Just Those That Meet Condition

Jan 31, 2007

Hi below sample data incoming from a source that cannot be changed. Please ignore the mishandling of zls. Obviously it is not insurmountable - I am just interested in why it is happening because I cannot explain it. DECLARE @t TABLE(the_data CHAR(73)) SET DATEFORMAT dmySET NOCOUNT ON INSERT INTO @tSELECT ' 11'+SPACE(5)+'1649KN889001 2'+space(10)+'0'+space(10)+'08 01 2002'+space(10)+'04 10 2002'UNION ALLSELECT ' 11'+SPACE(5)+'1649KN889001 2'+space(10)+'109 08 2004'+space(20)+'21 07 2005'UNION ALLSELECT ' 11 13026721XX198734 1'+space(10)+'0'+space(10)+'XXXXXXXXXX'+space(10)+ '09 01 2003' SELECT CAST(REPLACE(REPLACE(date1_text,' ','/'),'XXXXXXXXXX',NULL) AS SMALLDATETIME) AS date_1_prob,CAST(REPLACE(REPLACE(date1_text,' ','/'),'XXXXXXXXXX','') AS SMALLDATETIME) AS date_1_ok_ish,CAST(NULLIF(REPLACE(date1_text,' ','/'),'XXXXXXXXXX') AS SMALLDATETIME)AS date_1_fine, date1_textFROM--derived table - selecting relevant substring(SELECT LTRIM(RTRIM(SUBSTRING(the_data, 44, 10))) AS date1_textFROM @t)AS der_t date_1_prob date_1_ok_ish date_1_fine date1_text----------------------- ----------------------- ----------------------- ----------NULL 2002-01-08 00:00:00 2002-01-08 00:00:00 08 01 2002NULL 1900-01-01 00:00:00 1900-01-01 00:00:00 NULL 1900-01-01 00:00:00 NULL XXXXXXXXXX Can anyone explain the result in the first row first column? Thanks

View 8 Replies View Related

Enterprise Manager Appears To Slow My Dial Up Connection

Jul 23, 2005

I am using a dial up connection to the Internet and to an online SQLServer database.I have a problem in that when I use Enterprise Manager to access evenmy local server , or even, it appears, when it is just open with noconnection to any SQL Server, I experience very slow data transferover my normal dial up connection.I am reasonably sure it is Enterprise Manager causing the problem aswhen I close it and redial I have an acceptable rate of data transferusing my dial up connection.Can anyone:a. support my conclusion that Enterprise Manager is the probablecause of the slow connection.b. suggest a solutionBest wishes, John Morgan

View 1 Replies View Related

Our Logo Image Appears In Designer But Not In Report Viewer

Dec 25, 2007

I created a virtual directory in IIS that points to a folder on c: where my images reside. I use a URL to reference one of those images in my report heading. It appears as it should in designer's preview tab but only as a big red X in Report Viewer from my browser.

Directory security on the virtual directory is set to Integrated Windows.

Right clicking on red x in IE7>properties shows a path to report server instead of the special virtual directory I created.

RDL snippet shows:
<PageHeader>
<PrintOnFirstPage>true</PrintOnFirstPage>
<ReportItems>
<Image Name="image1">
<Sizing>AutoSize</Sizing>
<Top>0.125in</Top>
<Width>2.07292in</Width>
<MIMEType />
<Source>External</Source>
<Style />
<ZIndex>3</ZIndex>
<Left>0.25in</Left>
<Height>0.32292in</Height>
<Value>http://localhost/vddirectoryname/filename.BMP</Value>
</Image>

Any thoughts on what I'm doing wrong?

View 9 Replies View Related

External Image Appears Broken When Using Interactive Sort

Jun 15, 2007



We have a logo image in our report that is an external image that references a url similiar to: http://www.myserver.com/images/logo.gif.



In the same report we have a table with interactive sorting set on several column headings.



When we initially view the report the external logo image appears perfectly and the data in the table looks fine.



If we click on a column heading to sort the column then the logo image appears as a broken link as soon as the page refreshes.



Has anyone had a similiar experience with external images appearing normally and then appearing as broken when sorting a table?



We have configured the Execution Account and it is working normally and so do the reports except when we try to sort.



Any advice would be appreciated.

View 1 Replies View Related

Comma Appears In The Decimal Node Of XML File, How To Handle?

Nov 1, 2007

we defined a xml schema. ONe node was defined as decimal data type.
When the coming data of this node in this XML file is more than 999, then it will add a comma in the figure , looking like 1,024.00.
then SSIS can not regard this as a decimal.

Any experience to share ?
i dont wanna change the schema from decimal to string.




Thanks in advance

View 4 Replies View Related

IO Completion Listener Worker Appears To Be Non-yielding Message

Aug 3, 2006

We are using SQL Server 2005 (not on SP1), and keep getting the following message in the SQL Server log:

IO Completion Listener (0x15e8) Worker 0x00B7E0E8 appears to be non-yielding on Node 0. Approx CPU Used: kernel 0 ms, user 0 ms, Interval: 35092.

After receiving this message, the server slows down considerably and we receive numerous messages saying:

SQL Server has encountered 61 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [xxxxx.MDF] in database [xxxx] (22). The OS file handle is 0x00000CDC. The offset of the latest long I/O is: 0x000000fa21a000

I have not been able to find any documentation or explanation of what the IO Completion Listener message is about or how to correct whatever problem is causing it.

Any help would be greatly appreciated!

View 8 Replies View Related

2nd Y Axis

Jul 17, 2007

How do i add a 2nd Y axis? i can't believe MS would leave out such an obvious feature?

View 6 Replies View Related

Second Y Axis

Aug 6, 2007

Good day,

I would like to know if it is possible to add a second Y axis to a reporting services chart?

Please can someone advise on how this can be done

Thank you in advance

View 5 Replies View Related

Transact SQL :: Split Data Into Two Columns Based On Where Space Appears

Jul 8, 2015

I have a field in a table that contains addresses e.g

15 Green Street
5F Brown Steet
127 Blue Street
1512 Red Road

I want to output the numbers into one column and the address to another column as i need to produce a report that only shows streets and roads but no numbers.

So basically no matter how many characters before the first space which can be numbers or letters i want these output into two columns.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved