I have a report which doesn't work. It has a datatset based on a store procedure. The store-procedure take 10 to 50 second to execute, depending on the parameters.
But, I can't never see my report as i wait more than 10 minutes and it's never generated.
So, I have think that maybe it could be because of the matrix inside the report, so I have try to create another report which have the same dataset but with nothing inside, just a textbox, and it doesn't work too !!
So now, i'm very disapointed and I don't know what to do !
Someone can help me please ? It's very important.
Semantic query execution failed. The 'PerspectiveID' custom property for the 'query' perspective is either not set or is not set to the string data type.
Hi I have a windows application. I am using following code right after setting the LocalReport ReportPath. Report rendering is too slow if use following line of code and Report viewer does not show spiny and the text that says €śReport is being generated.€?
I have created a report and deployed it successfully to a seperate machine with SSRS on. Both my dev machine and the SSRS machine are in the same workgroup. I can then Browse to the Report Manager though IE and click & run the report (The connection is using integrated security). The report requires a single parameter to be entered which once done works successfully. The report has a single table, an inbedded image and a few static fields in the report header.
If I however add a report viewer control to an aspx test form all is not well. As soon as the page opens I am prompted to enter the parameter which is good news as it shows there has been some communication with the SSRS metabase. I then click the view report button. Using Profiler I have proved that the report Stored Proc. is running with the correct parameter value. The report viewer however seems to hang and only displays "Report is being generated" without displaying the results. It does this even with a timeout set of 1000ms.
I don't think this is a security issue as both the Report Manager works and the test form prompts me for the parameter and effectively runs the report SP. I can only assume it is a problem with returning the report to the browser.
I followed the tutorial http://msdn2.microsoft.com/en-us/library/ms167305.aspx with no problem but when I tried to preview the report the green circle just kept spinning and spinning.
I'm able to execute the command under the data tab with no problems. I'm able to view built in reports for SQL Server 2005. I've tried restarting Visual Studio and the entire PC but the report will still no generate.
I have a VS2005 Windows application that displays a reportviewer (SQL 2005) report in a tab control, then displays a second report in a second tab with reportviewer, and so on. The really strange thing is that I had this application working for about 3 months. I even had up to 30 reports in 30 tabs at one point. BUT, for some reason now all I get is the first report and the second, third, etc. tabs show a reportviewer with "Report being generated" that never displays the report. Even worse, another user is able to run this application and DOES get all the reports displayed. So what could have been updated on my PC that is causing this problem?
Is it possible to reposition the "Report is being generated" graphic?
I have most of my reports set to 1000 px by 1000 px which forces the graphic off of the screen. I would like to be able to see it without having to scroll to it.
Also, is there any way to change the properties of that image? I would think a progress bar that actually showed how far along the report was before completion would be better.
I develop some application using SQL Server Reporting Services 2005 to Russian customers. They usually don't know English well. That's why I really want to change phrase "Report is being generated" to Russian words. How can I do it? I tried to fing this phrase in configuration files or registry but there wasn't success.
I want to remove default animated gif report is being generated, how can i achieve it when i upload the rdl to share point, Need to remove actions and print option avialble when i upload my rdl to share point.
In the above code, the XML parser does not understand the Parameters element. I've also tried ReportParameters as the name of the element. I don't seem to understand why, because in the SQL data tab, Parameters is a subelement of DataSet. Why am I getting this error and how do I programmatically specify that I want a report created on the fly to have parameters?
Deserialization failed: The element 'DataSet' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' has invalid child element 'Parameters' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'. List of possible elements expected: 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Fields http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Query http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:CaseSensitivity http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Collation http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:AccentSensitivity http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:KanatypeSensitivity http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:WidthSensitivity http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Filters ##other:*'. Line 21, position 8.
This is the actual code which generates one .htm file every 24 hours with the count of hourly logins. So the entries (as per the below logic) start at 12:00 AM everyday and end at 11:00 PM. The catch is - the entries come up fine upto 10:00 PM. The '11:00 PM entry' is missing in all the .htm files. I tried several options and later, I 'force added' an ELSE IF condition especially for the 11:00 PM case, indicated in the code below but it doesn't seem to help... Also, I'm not really sure if this is a row limitation in the .htm file - like x no: of rows per .htm file.
Am I missing something here?.. Please advise. Let me know if I'm not clear. Thank you.
CREATE PROC CONDOR_CLIENT_LOGINS_PERHOUR AS BEGIN
IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[DBO].[TBL_CUSTOM_LOGINSPERHOUR]') AND OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1) DROP TABLE [DBO].[TBL_CUSTOM_LOGINSPERHOUR]
DECLARE @FLAG SMALLINT DECLARE @REPFLAG SMALLINT SET @FLAG = 0 SET @REPFLAG = 0
IF DATEPART(HH,GETDATE()) = 0 BEGIN
SELECT CONVERT(NVARCHAR,HOUR,100)AS [ROW1], CONVERT(NVARCHAR,NUMBER_OF_USERS) AS [ROW2] INTO #TEMP_LOGINSPERHOUR1 FROM TBL_LOGGEDIN_USERS_PERHOUR WITH (NOLOCK) WHERE HOUR = DATEADD(DAY,(DATEDIFF(DAY,0,GETDATE())),0) ORDER BY HOUR SET @FLAG = 1
END -- this is added for 11:00 PM entry START
ELSE IF DATEPART(HH,GETDATE()) = 23 BEGIN
SELECT CONVERT(NVARCHAR,HOUR,100)AS [ROW1], CONVERT(NVARCHAR,NUMBER_OF_USERS) AS [ROW2] INTO #TEMP_LOGINSPERHOUR2 FROM TBL_LOGGEDIN_USERS_PERHOUR WITH (NOLOCK) WHERE HOUR >= DATEADD(DAY,(DATEDIFF(DAY,0,GETDATE())),0) ORDER BY HOUR SET @FLAG = 2
END
-- the above is added for 11:00 PM entry END
ELSE BEGIN
SELECT CONVERT(NVARCHAR,HOUR,100)AS [ROW1], CONVERT(NVARCHAR,NUMBER_OF_USERS) AS [ROW2] INTO #TEMP_LOGINSPERHOUR3 FROM TBL_LOGGEDIN_USERS_PERHOUR WITH (NOLOCK) WHERE HOUR >= DATEADD(DAY,(DATEDIFF(DAY,0,GETDATE())),0) ORDER BY HOUR
END
INSERT INTO TBL_CUSTOM_LOGINSPERHOUR SELECT 'HOUR', 'NUMBER OF CLIENT LOGINS' UNION ALL SELECT '' , '' UNION ALL SELECT '' , ''
IF @FLAG = 1 BEGIN INSERT INTO TBL_CUSTOM_LOGINSPERHOUR SELECT * FROM #TEMP_LOGINSPERHOUR1 SET @REPFLAG = 1 END ELSE IF @FLAG = 2 BEGIN INSERT INTO TBL_CUSTOM_LOGINSPERHOUR SELECT * FROM #TEMP_LOGINSPERHOUR2 SET @REPFLAG = 2 END ELSE BEGIN INSERT INTO TBL_CUSTOM_LOGINSPERHOUR SELECT * FROM #TEMP_LOGINSPERHOUR3 END SELECT '' , '' UNION ALL SELECT '' , ''
I never got an answer on this so I am reposting this issue. Also, please note that I have consistently reproduced this issue on multiple perspectives within and accross multiple cubes on 3 different SQL Server Instances. I have also had no problem with perspectives within Report Models that were not generated from an SSAS Cube.
Specifics:
=========
I have created a simple cube in BI Studio against an Oracle Relational Data Warehouse. In this cube I have created a perspective in which I have selected (included) only a small subset of measures and dimension. When I view this perspective on the Browse Tab of BI Studio, only the entities that were included in the perspective were available for report construction as was expected.
Next, I generated a model for this cube in Report Manager. Now here is the problem, I then opended the model in Report Builder and selected the same perspective from above, but all of the Entities in the cube were displayed including the fields I explicitely did not include in the perspective. I then looked at the .smdl file describing the Model and it looked like in the Perspective description section all of the cube's entities were included, even the ones that should not have been included. It seems as if the problem is ocurring durring the model generation. I also tried generating the model in Management Studio and it seems to be doing the same thing.
Any ideas on how to fix this? Could I be doing something wrong(probably)? I have to give a presentation soon and this is a big deal for the Project Stakeholders.
By the way, I am using the 180 Day Evaluation of Sql Server 2005 with SP2 CTP installed.
I am creating a SSRS report which would be executed by User manually through ReportServer URL.User would be generating the SSRS report for different Customer ID based on ad-hoc basis.
I am passing CustomerID as input parameter to the report. Is there any way to get the manually generated SSRS report name as 'Report_CustomerID_TodayDate.xls'.
E.g.If User is generating report for Customer ID 123 today then report name should be 'Report_123_07092013.xls'
i need to get the result of two different queries into 2 different sheets of the same excel file while exporting a report to excel using reporting services..
I tried the Beta 1 of the service pack 1 to .net 3.5. If I try to add an entity (and try to save this), I get the Exception "No support for server-generated keys and server-generated values".
How can I add entities to my Sqlce- database?
I tried to give the id- column (primary key) in the database an identity, another time without identity, only primary key --> none of them worked. I always get the same error.
What do I have to change to make successfully a SaveChanges()?
I've a problem with auto-generated key. In my parent table, some lines have been deleted. I would like to add new lines with the same content in order to restore my database, but I cannot decide on the id value which is an auto-generated key. Is there a solution to set an auto-generated key with a specific value ?
In Column I there is a sequence of numbers from 1 to 3 with a step of 1 In Column 2 there is a sequence of numbers from 100 to 120 with a step of 2 In Column 3 there is a name that is repeated accross the whole column
Can I generate such a table with just a single SQL Statement . I don't see any reason why it should not be possible. We know the logic to generate all the numbers of every row. It would be possible using a while loop , but that is be tedious and I am looking for a better way.
One application I can think of is, Suppose I want to find out all deleted primary key ids from a table or say if I have a set (1,2,3, 7,8,9) , and wish to know the missing numbers in the range 1 to 9. If an sql like above is possible I could use it in a left join to get me the desired output.
Could anyone tell me if it is possible and if not , why not ?
Is there any way to look at behind-the-scene SQL query that gets generated by SSRS engine to pull the data out of the data source (particularly SQL Server).
So far, I only know that you can see the query generated by semantic query engine by changing trace option in configuration file.
I created a PDA application with a database, which has a table with a uniqueidentifier field and primarykey.
While doing the bulk insert from dataset into sql mobile database, It is inserting the record but it is not inserting the id which was entered into the sql server 2005 database, instead the id by creating a new id and the code is as below.
conAdap = new SqlCeDataAdapter(strQuery, conSqlceConnection);
SqlCeCommandBuilder cmdBuilder = new SqlCeCommandBuilder(conAdap);
I created a new DataSet object using the wizard and had no probs, it's very straightforward. I created a GetProducts() method and also added a GetProductCount() method. I read somewhere that when the DataSet is saved, it will generate the TableAdapter classes and store them in the project nested under the DataSet object. This isn't happening, the files aren't there and yes I'm displaying all files. There *is* however the TableAdapter class but it's in not in the project, it's a temporary file w/ the following path:
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Fileswebsitef38f8b5500014aeSources_App_Codepw_products.xsd.72cecc2a.cs.
I saved the DataSet several times, compiled the entire solution and even closed the solution yet this temporary file isn't getting saved where it should be. Does anyone have any ideas abt this? I'm eager to start developing my DAL and def want to use these TableAdapter classes.
Can someone explain the generated sprocs of VS2005 if one column can be nullableDependentOfSeqID = @Original_DependentOfSeqID OR ((@IsNull_DependentOfSeqID = 1) AND (DependentOfSeqID IS NULL))In VS2003 the generated sprocs would beDependentOfSeqID = @Original_DependentOfSeqID OR ((@Original_DependentOfSeqID IS NULL) AND (DependentOfSeqID IS NULL))Which is the best?
HI all, if this issue has been solved, please provide me the post, or I've put this issue in a wrong category please let me know. The following is my code: DateTime dtBFWNow = DateTime.Today; String dtBFW_range1 = dtBFWNow.AddDays(-7).ToShortDateString(); String dtBFW_range2 = dtBFWNow.AddDays(3).ToShortDateString(); SqlDataSource1.SelectCommand = "SELECT * FROM [MORTGAGE] WHERE ([BringForwardDate] is not null) and ([BringForwardDate]>= '" + dtBFW_range1 + "' and [BringForwardDate] <= '" + dtBFW_range2 + "')"; lblHeader.Text = "Bring Forward Reminders Due From '" + dtBFW_range1 + "' To '" + dtBFW_range2 + "'"; lblHeader.ForeColor = System.Drawing.Color.FromName("#000000"); GridView1.DataBind(); When I compiled, the following exception occurred: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. and the exception points right at the line: GridView1.DataBind() I use the webhost4life as my server provider. My codes run fine with the server. I mean I uploaded my program to the server, set up and run the program online, everything is fine. But on my PC it gives me the above exception. I can't compile my code. There must be some sort of setting somewhere in my PC that can't handle the exception. Please help. Regards. Joey.
I ran a SP that lists fragmented tables in our DB which listed almost all the tables and indexes in the DB. The list includes index names that start with "_WA_Sys_tablecolumn name_.....". Are these SQL Server generated indexes or are these statitics on the tables? What are they? If these are system generated indexes as I thought they were, how are they generated? Can these indexes be dropped or should one want to? IF so, how? Any effect on the DB performance if dropped?
I am using Enterprise Manager to generate a script of the stored procedures on my database. Under File|Options, I selected Windows Text(ANSI). The file which is generated contains all stored procedures, but there are some procedures which are so long that they wrap to the next line.
When I then try to run this script from ISQL in a batch file, those procedures which wrap error out. Is there any way to generate the script in a more formatted manor, avoiding the wrapping?
I'm having trouble getting the namespaces correct in the XML that is generated by SQL. The XML consists of two parts: a header part with some context information and the payload part with the actual data. With my current SQL script, the namespace is also copied to the payload part.
Here are some DDL and DML scripts to generate two test tables and some test data:
Code: CREATE TABLE dbo.context( idintNOT NULLconstraint pk_dbo_context primary key, namenvarchar(100)NOT NULL ) INSERT INTO dbo.context(id, name) VALUES (1, 'Here comes some great context information.')
[Code] ....
This is my current FOR XML script that generates the XML:
Code: ;WITH XMLNAMESPACES (DEFAULT 'http://services.registersubscription-02_00.a.cool.url.com') SELECT CEXT.name AS [Context/Name], (SELECT CONT.id AS [Content/Reference],
[Code] ....
This generates this XML (notice that the namespace is repetated in the <Questions> element):
Code: <RegisterSubscription xmlns="http://services.registersubscription-02_00.a.cool.url.com"> <Request> <Context> <Name>Here comes some great context information.</Name>
[Code] ....
The XML should be like this:
Code: <RegisterSubscription xmlns="http://services.registersubscription-02_00.a.cool.url.com"> <Request xmlns=""> <Context> <Name>Here comes some great context information.</Name>
[Code] ....
The generated XML does not pass the XSD validation.
use dbWebsiteLO SELECT A.vehicleref,A.manufacturer,A.cvehicle_shortmodtext,A.derivative,min(a.ch) as price,A.capid,B.studioimages,(SELECT term FROM vwAllMatrixWithLombardAndShortModel WHERE vehicleref = a.vehicleref and ch = price) FROM vwAllMatrixWithLombardAndShortModel A LEFT OUTER JOIN dbPubMatrix..tblCarImages B on A.capid = b.capid WHERE a.source <> 'LOM' AND a.type = 'car' GROUP BY a.vehicleref,a.manufacturer,a.cvehicle_shortmodtext,a.derivative,a.capid,b.studioimages
I get Invalid column name 'price'. I'm trying to reference the "min(a.ch) as price"
SELECT DISTINCT product.product_id AS Expr1FROM [SELECT product.product_id, product.item_name, product.display,product.selling_price, product.smallpicture, product.main_size,product.main_dinnerware, dbo_coupon_special.coupon_id,dbo_coupon_special.special_price, coupon.effective_date,coupon.expiration_date, dbo_ssc_product.mc_idFROM dbo_ssc_product LEFT JOIN ((product LEFT JOIN dbo_coupon_specialON product.product_id = dbo_coupon_special.product_id) LEFT JOINcoupon ON dbo_coupon_special.coupon_id = coupon.coupon_id) ONdbo_ssc_product.product_id = product.product_idGROUP BY product.product_id, product.item_name, product.display,product.selling_price, product.smallpicture, product.main_size,product.main_dinnerware, dbo_coupon_special.coupon_id,dbo_coupon_special.special_price, coupon.effective_date,coupon.expiration_date, dbo_ssc_product.mc_idHAVING (((product.item_name) Like "*coaster*") AND((product.display)="y"))]. AS [Alias]This is the error I get:The identifier that starts with 'SELECT product.product_id...' is toolong. Maximum lenght is 128Incorrect syntax near the keyword 'AS'Any ideas?Thanks
When editing the data driven subscription query I SOMETIMES get the following error: The dataset cannot be generated. An error occurred while connecting to a data source, or the query is not valid for the data source. (rsCannotPrepareQuery) Invalid object name '##XX'. The datasource is ok, authentication also, the query works... Why can't it see the temporary table?
I am working with an .xml file that I want to break up into various tables. A couple of fields in my xml file include html tags (<p> tags specifically). The generated xsd file thinks these are nested xml tags and creates a "P" table for the information contained. Is there a way I can modify the generated xsd within the designer? Or is the only way to fix this is to manually modify the xsd?
There is also an <id> tag within the xml. However, SSIS is not using that <id> as the primary key as it adds data to the various tables that I've specified. Instead it appears to be creating its own primary key - calling it "Id". Is there some way to specify that SSIS use the <id> tag contained within the xml instead of creating its own primary key?
