Probelm With Report Charts
Sep 20, 2007
I have two data sets but from the same data source. I created two different tables from these two data sets. Now I want to include a chart too. But When I insert the chart, it gives a erorr message.
The dinfinition of the report/my report name is invalid.
More than one data set, data region or grouping in the report has the name'chart1_seriesgroup1'. data set, data region and grouping names must be unique within a report.
Does any body know why this happen?
Thanks
View 3 Replies
ADVERTISEMENT
Feb 15, 2007
Hi,
We have developed few reports displaying data using chart layout. In the Data tab, we have specified MDX query that will return top 10 records.
But now, instead of restricting to just top 10 records, we would like to display all records and go in for pagination.
Is there some setting in the chart properties, where in I can display the first n records in first page, and the next n records( if available) in the next page and so on?
Can I specify the value of n somewhere in the propeties?
I read through many posts regarding pagination but those couldn't help me much.
Please help me in solving this problem.
Any help would be appreciated.
Thanks in advance!
View 5 Replies
View Related
Jul 11, 2007
Hi, I have 8 charts on a report that no longer show up on the report.
the datasets they are based on still produce data when queried.
All I see is white space plus the textbox titles?
The charts are there in layout view and still correctly reference the right datasets and fields.
View 1 Replies
View Related
Jan 21, 2008
Is it possible to place Column chart, Line Chart and Pie chart in one single report with single/different datasets?
View 4 Replies
View Related
Aug 23, 2006
I've searched the forums on this issue, haven't really found the answer.
I have several nifty little sales reports which crunch a ton of data quite efficiently and render in just a few seconds in Report Manager. I've pushed as much of the data processing back to the server as possible, use a stored procedure (with parameters) in a shared datasource, don't return unneccessary data, all that. It works great.
When I first developed the reports, I continued generating my charts (which use the same data as the reports, just grouped differently) in Excel and pasting them in as images. Now I want to stop that nonsense and use the SSRS charts. I fooled around with the charting function and got a reasonable facimile of my Excel charts, two per report, which use their own separate stored procedures and the same shared datasource.
Now, reports that used to render in 5-8 seconds may take 1-5 MINUTES. Help! It's definitely the charts--taking them back out fixes the problem.
I have complete control over the datasources--would it make more sense to use non-shared sources, or to create totally separate shared sources? I saw a post that recommended "making data calls non-synchronous," but I have no idea how to do that.
Thanks for any suggestions.
View 6 Replies
View Related
Aug 27, 2015
I am able to preview my report in Microsoft Visual Studio with a chart embedded at the top of the report. However after uploading the report to Report Manager, the chart is blank. How can I get the chart to be visible in Report Manager? I am using SQL Server 2012 on a Windows Server 2012 R2 machine. I can see the chart if I edit the report in Report Building in the print layout mode. I can also see the chart in my Microsoft Visual Studio Project.
View 5 Replies
View Related
Nov 8, 2007
Hi
Does any body know that creating free form rports using Report Builder is possible?
Free-form report - in the sense - that user should be able to drag the fields from the leftside fields pane and drop on body as we do in report designer using BI studio.
I could not figure out a way to do so. Is this a limitation?
Thanks
Raj Yennam
View 5 Replies
View Related
Apr 11, 2005
strsql = " select * from dic where english='" & SearchBox.Text Or TextBox4.Text & "'"The machine said Input string was not in a correct format. How can i select database with or operator in asp.net .Is it possible to select database in sql from more textbox ?
View 1 Replies
View Related
Jun 7, 2005
hi,I wrote this sp :CREATE PROCEDURE ins_AddOrder( @CartId NVARCHAR(50), @CustomerId INT, @OrderDate DATETIME, @OrderId INT OUTPUT)AS
DECLARE @ins_error INT, @sel_error INT, @var_rowcount INT
BEGIN TRAN AddOrder
INSERT INTO tbl_orders( customerId, orderDate)VALUES( @CustomerId, @OrderDate)
-- SET THE @@ERROR VALUE TO @ins_errorSELECT @ins_error =@@ERROR
/*IF INS_ERROR != 0BEGIN ROLLBACK TRAN RETURNEND*/
SELECT @OrderId = @@identity
INSERT INTO tbl_orderDetails( orderId, productId, quantity, productPrice)SELECT @OrderId, tbl_product.productId, quantity, tbl_product.productPriceFROM tbl_shoppingCartINNER JOIN tbl_product ON tbl_shoppingCart.productId = tbl_product.productIdWHERE cartId = @CartId
-- SET THE @@ERROR VALUE TO @sel_errorSELECT @sel_error = @@ERROR
-- SET THE @@ROWCOUNT TO @var_rowcountSELECT @var_rowcount = @@ROWCOUNT
IF @sel_error <> 0 OR @var_rowcount = 0 BEGIN ROLLBACK TRAN AddOrder RETURN ENDELSE BEGIN EXEC del_EmptyShoppingCart @CartId COMMIT TRAN AddOrder ENDGOIn the last few lines i try to prevent adding new row to tbl_orders (first statement), while the SELECT (second statement) does not return any row .It still not work.Can anyone help please?thanks.
View 1 Replies
View Related
Dec 1, 2005
I Have create a trigrer for my table transhd to update something in my detail table..
when i updated one record the trigger works fine..
but when i run command to update a batch of record in header
using command [update XXXX where cont] the trigger only fire for the last record in the batch..
is this the ms sql default behavior.. anyway to the around it
thanks in advance
View 1 Replies
View Related
Dec 1, 2005
I Have create a trigrer for my table transhd to update something in my detail table..
when i updated one record the trigger works fine..
but when i run command to update a batch of record in header
using command [update XXXX where cont] the trigger only fire for the last record in the batch..
is this the ms sql default behavior.. anyway to the around it
thanks in advance
View 1 Replies
View Related
Mar 19, 2004
I have a login in my sql server with windows authentication.When i tried to connet to the sql server with that login its not allowing me to connect even though I was logged on into my system.What should be the reason and what should i do?
View 2 Replies
View Related
Apr 19, 2005
I have met a problem in the ASP.NET project creation with SQL Server Database Connection.
"Can't Login to My ServerName/ASPNET
How to solve the problem?
View 1 Replies
View Related
May 31, 2006
Hi , I just put my files up on a web server. I can view my aspx pages..but when I try to login to the website I get the following;
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Can you help? I can understand that it cannot find the specified instance of sql server, however I don't remember ever configuring it look to at a specific sql server. When i created the site in web dev express edition and added the login controls and set the asp config tool to use internet security it created the database itself and so I didn't have to put a connection string in. I also cannot see a connection string in tthe web.config file.
The aspnetdb.mdf file is there on the server. is this something i need to configure with the hosting company or do i set it in my webconfig file.
Thanks
View 4 Replies
View Related
Jun 15, 2007
I need to create some tables dynamically using sp_executesql. But the problem is the length of sql string is more the 4000 characters. How can I solve this problem?
Thanks
View 3 Replies
View Related
Jul 20, 2005
hello ![color=blue]>>> I am trying to intstall Mysql binary version with installor in Windows> XP machine . But it is not working . i have installed in the default> path ,in windows service componenet its showing server is running,since> it is mysqld-nt so name-piped servr is also running.>> But still client is able to connect to server.>> when i am tring to instal manually it is showing>> " service already exists;> the currect server intstalled is c:mysqlinmysqld-nt.exe>> when trying to connect to server> C:> c:mysqlinmysql test> ERROR 2003 : cannot connect to MYSQL server on localhost <10061>>> C:> telnet localhost 3306> connecting to localhost.......> could not open connection to host,on port 3306No connection shb ne made> because the target machine actibvely refused it.>> plz help me in installing ,pls clarify the problem.> pls reply soon.>>> regards> Smita[/color]
View 1 Replies
View Related
May 18, 2007
We have a config table which has columns like pollingfolder, cop to folder etc.
Data looks like this
Config id polling folder
1 d:dataloadacn
2 d:dataloadship
under ACN and Ship folders we can have more than 1 source files which had to be loaded into target
the load process has to be repeated for each file in all the folders like ACN and ship
I have used for each loop container to poll the folder.
Can we set the directory to be polled at runtime taking from config table.
For doing this I have used the property Directory in expression editor of for each loop. But it is not working.
If I hard code the variable value in variables section , then its working.
How to change the directory to be polled value at runtime?
View 1 Replies
View Related
May 15, 2008
I had installed SQL server 2005 4 bit version. I created on SSIS package through export wizard.
the SSIS packages will transfer data from database to Excel file. But it is giving the below error.
Message
Executed as user: XXXXXSYSTEM. ... Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 07:00:00 Error: 2008-05-14 07:00:00.51 Code: 0xC0202009 Source: Interface Connection manager "DestinationConnectionExcel" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2008-05-14 07:00:00.51 Code: 0xC00291EC Source: Preparation SQL Task Execute SQL Task Description: Failed to acquire connection "DestinationConnectionExcel". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 07:00:00 Finished: 07:00:00 Elapsed: 0.344 seconds. The package execution failed. The step failed.
please any one guide me to reolve this issue.
View 4 Replies
View Related
Dec 16, 2005
Someone, please help me understand:
I have the following code:
Dim conString As String = ConfigurationManager.ConnectionStrings("WebAllianceConnectionString").ConnectionStringDim dsrc As New SqlDataSource()dsrc.ConnectionString = conStringdsrc.SelectCommandType = SqlDataSourceCommandType.StoredProceduredsrc.CancelSelectOnNullParameter = Falsedsrc.SelectCommand = "sp_GetCustomerInvoiceList"dsrc.SelectParameters.Clear()dsrc.SelectParameters.Add("@QueryType", "DATE")dsrc.SelectParameters.Add("@CustCode", "BAM7")dsrc.SelectParameters.Add("@OrdNumber", " ")dsrc.SelectParameters.Add("@InvStartDate", "1/1/2005")dsrc.SelectParameters.Add("@InvStopDate", "1/31/2005")dsrc.SelectParameters.Add("@PONumber", " ")Return dsrc.Select(DataSourceSelectArguments.Empty)
When this runs, it throws an exception:Prodecure or Function 'sp_GetCustomerInvoiceList' expects parameter '@QueryType', which was not supplied.
I'm confused... I clearly added that using the .Add method?What am I doing wrong?
View 5 Replies
View Related
Jul 3, 2001
has anyone had a problem restoring a SQL 2000 without sp1 to a SQL 2000 sp1 box or vice versa? I have had 2 failures telling me to call MS support in the message?
View 1 Replies
View Related
Feb 17, 2004
Hi
Can i be able to use the DLL which is created in VB for Extended Stored Procedures.
if so how?
View 1 Replies
View Related
May 30, 2007
hi everyone,
How do i declare a global variable in my package which takes a numeric value like User::VAR1 = 200402 and later on work on it
Later in the properties of the Dataflow i want to have this expression..
"select * from " + "TAB1" + " where Date=" + @[User::VAR1]
Here i want to subtract 190000 from @[User::VAR1] to get it in to myformat i.e the DATE format in the table
I can only see String datatype and othe datatypes wont allow me to to do any kind of manipulation in the expression:
and to be more specific what are
Int16
Int32
Int64
Double
I tried to use all of the above but the expression doesnt allow me as once i use any of the above it says :
TITLE: Microsoft Visual Studio
------------------------------
Nonfatal errors occurred while saving the package:
Error at Extract: The data types "DT_WSTR" and "DT_I8" are incompatible for binary operator "+". The operand types could not be implicitly cast into compatible types for the operation. To perform this operation, one or both operands need to be explicitly cast with a cast operator.
Any help would be appreciated..
thanks,
ravi
View 8 Replies
View Related
May 21, 2007
Hi,
I have the same problem like Ben. Trying to connect to database engine but failed all the time. I use a SQL 2005 Enterprise Eval version. When I connect to database engine, I put <my computer name>SQLEXPRESS, it gives me this message:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
I checked the sqlbrowser and it's running. I also enabled port 1434 in Firewall. But it still doesn't work. However, when I connect to analysis service using just <my computer name>, it lets me connected. I tried many ways to fix this problem but still no luck. Could anyone help me solve this problem please? Thanks so much.
Carl
View 6 Replies
View Related
Sep 5, 2007
Hi all ,
i need to have outside label position for my data in 3d pie chart. How can i implement outside labelling?
Thanks
View 1 Replies
View Related
May 4, 2007
I have created a bar graph but cannot find a way to change the bar's color for different series.
I have a graph which has sales men and their sales between dates
Thanks for your help
View 5 Replies
View Related
Jan 10, 2007
Hi, I have a quick question about charts in SQL reporting services...
Is it possible to have a page through chart, meaning that an user can page through multiple pages of the same chart?
View 1 Replies
View Related
Mar 1, 2007
hi,
I would like to have a bar chart with the values of each bar on the top of the bar. How can I do this.
thanks,
naveen
View 1 Replies
View Related
Nov 14, 2007
Hi All,
I'm using DTS in Sql Server 2000 for the first time, and would like to create Ad-Hoc reports with Pie/Charts and graphs. Is this possible in SQL Server/DTS, or would I need something like Cyrstal Reports?
Thanks!
Matt
View 2 Replies
View Related
Jun 21, 2008
Hi
I have developed some line charts in reporting services with some parametrs
On the bottom axis is the month and the upper is no. hours.
The problem is that when i select certain parametrs becaus there is no data for that month the line just ends and then starts at a new month.
Does anyone know anyway of telling it to go to zero if there is no data for it so there is a continous line
Thanks
View 2 Replies
View Related
Mar 18, 2008
Can you loop through the records of one dataset and create a chart for each record?
View 2 Replies
View Related
Jan 4, 2008
Hi,
How can we use the line chart in the Sql Server Reporting Services 2005.
Please explain about the each and every properties in chart control.
Thanks In Advance
Shoba
View 1 Replies
View Related
Aug 2, 2007
Does anyone here use 3rd party graphs and charts for SSRS 2005?
What do you use? Is there a superior package out there?
Thanks
-JW
View 1 Replies
View Related
Feb 28, 2007
I've got a report with a table holding a subreport that contains a number of Dundas charts. Each of these charts displays A LOT of data.
Now... after deploying the report, only a few charts at the bottom of the report are displayed -- the rest display the Image-doesn't-exist icon (File image with red X across it). Can anyone tell me what's going on? My best guess is that this is a memory issue on the server side...
View 1 Replies
View Related
