I have deleted the entry
<RenderingExtension>HTMLOWC</RenderingExtension>
from the rsreportserver.config file
but I still can't see HTML OWC in the export drop down.
what else do I need to do?
I'm very disappointed that OWC has been "deprecated" ie. ripped out - see http://msdn2.microsoft.com/en-us/library/ms143509.aspx . This is a major step backwards as we have got our users used to pivottables - they allow them to restructure and group summary data the way they want to save us admins from providing every possible grouping combination. Aaarrrgghhhh!
I tried the code from the above but even after restarting the SSRS and IIS no joy. The Apress Pro SSRS 2005 book also complains about the deprecation, and offers an augmented code for the rsreportserver.config file but it still doesn't work:
Code Block
<Extension Name="HTMLOWC" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="true">
<Configuration>
<OWCConfiguration>
<OWCDownloadLocation language="en">http://office.microsoft.com/downloads/2002/owc10.aspx
</OWCDownloadLocation>
</OWCConfiguration>
</Configuration>
</Extension>
I appreciate another thread mentions poss necessity of previous DLL however we don't have old installations and old DLLs surely shouldn't be nec. Any further help greatly appreciated.
Has anyone made the OWC work under SQL 2005? Why are MS making this awkward?
Hi All,
I am placing a Matrix inside the table control for grouping requirements,but when we export the report to the Excel, the contents inside the table cell are ignored. Is there any way to get the full report exported, as per the Requirement.Please help me with this issue.
With Thanks
M.Mahendra
Hi!
Today we moved from 32bit to 64bit computing environment. 64bit Window server 2003 and SQL 2005 are now our playing ground. And 32 bit Office 2003 is also installed. Excel in Office program plays important roll in our mission.
One of our routine task is that
step 1. get Excel data files from other websites and
step 2. extract specific data from them and
step 3. converting them into some type of data that can be compatible with SQL
Our problem occured in step 3. To convert data, we realised taht 64 bit excel driver, which we believe is not yet available, is required.
My questions are:
1. Is 64 bit excel driver (of office 2003 or office 2007) available now?
2. Is there any way OR IS IT POSSIBLE to use 32 bit excel driver with 64bit SQL 2005?
If possible, please enlighten me.
I would appreciate it very much if anybody answer my questions.
Sincerely
Hi all,
I'm using matrix control as my reporting tools.
But i found one trouble, how can i do my matrix become like this.
Product A
Product B
Customer
Price
Qty
Price
Qty
Customer A
10
10
140
160
Customer B
12
120
120
160
Customer C
10
10
110
140
The price and qty is the static column, and i would like to make the static row also. (show in red color) but i can't.
Please help...
Thanks
Kendy
Hi all,
Can the matrix configure to show total rows and total columns? If yes, how?
Regards,
Farouk Yew
Just wondering when is it preferred to use Matrix control as opposed to a table? Also, on a related note, can a table control be used for displaying information from one data set or could information coming from multiple data sets be bound to a single table in such a way that there could be logically different sections within the same table?
Thanks.
Hi there.
I am creating a report that the requirements need different background colors based on the row or column as shown below:
Community
Total # of Respondents
Resident's Overall Satisfaction Rating
Quality of Repair
May '07
41
3.6
5.0
April '07
14
1.8
3.0
Q2 '07
55
2.7
4.0
March '07
36
3.6
3.0
February '07
28
4.0
1.2
January '07
22
2.2
4.0
Q1 '07
86
3.3
2.7
YTD '07
141
3.0
3.2
December '06
33
3.8
4.2
November '06
27
2.6
5.0
October '06
42
1.8
3.0
Q4 '06
102
2.7
4.1
September '06
58
4.0
2.2
August '06
84
2.0
1.6
July '06
52
3.2
3.4
Q3 '06
194
3.1
2.4
June '06
40
2.4
4.2
May '06
41
3.6
5.0
April '06
14
1.8
3.0
Q2 '06
95
2.6
4.1
March '06
67
N/A
3.8
February '06
38
N/A
2.8
January '06
N/A
3.8
N/A
Q1 '06
105
3.8
3.3
YTD '06
496
2.9
3.5
Rolling 12 Month Average
477
2.9
3.3'
I can get the row colors to work great with an expression, but when I try to add the gray column with conditional formatting for the Resident's Overall Satisfaction Rating question, it clobbers my row formatting. I am thinking that I will have to do some gnarly expression in each of the rows and columns using the InScope function. Does that sound about right, or is there an easier way?
Thanks, Mike
All,
I am able to display the data in matrix, however I need to place it next to a table report item, so that the rows in table and matrix together would represent the data for same entity. In order to accomplish that, the Matrix rows need to be properly aligned with Table rows. But thats not happening. For some reason, in the Layout view they align properly, but when I Preview the report, the rows are not aligned. I have checked the cell sizes of both in the properties, they are both identical. So, I am very surprised why the Matrix row size is growing less than Table row size when the report is generated. Any ideas how to fix this?
Thanks.
All,
Is it possible to Group data in a Matrix exactly similar to Table Control. For example, my table control would group data as follows:
Region Country City $ales
North America
USA
Chicago 4 MM
LA 10 MM
NYK 6 MM
Canada
Toronto 4 MM
while the matrix would display as:
North America USA Chicago 4MM
LA
NYK
Canada Toronto ...
Do you see the problem? The matrix is starting the subgroup at the same level as the parent group. How do I make a sub group start at the row below the parent group row in matrix just like in the table above?
hi everyone:
the report show two tables two matrixs
how can i control the distance between them
I want to set the same distance between the table and matrix
or (table and table )
Hello All,
In my report, I have a Matrix control placed next to a table. It renders properly and displays data aligned in two controls in Visual Studio Preview. However, when I deploy to production, it wraps the matrix control below the table, in fact puts the entire matrix control underneath the table. Why such strange behavior and not in the Preview of the report but only in Production? Any ideas how to fix this?
In VS Env. Preview --> [Table][Matrix]
In Report Svr Prod --> [Table]
[Matrix]
Thanks,
When I created a Table control, I was able to read things like .Color, FormattedValue, etc. from SSAS. This was great, because I could control all existing and future reports' formatting via one change in the cube.
Now, I've decided that a Matrix control is superior for various reasons. However, I notice that I MUST apply an aggregate function to get a cell value...well, it appears that this means there's no longer any way for me to read my SSAS formatting.
I tried =First(Fields!DataValue.FormattedValue), =Max(...), etc.
I also tried it with the color property, etc. Nothing worked.
Are there any workarounds? I'd hate to embed the formatting into each of my 40 reports, because the user is likely to change his/her mind after the fact.
Thank you,
Bert
Hi all
I have taken Marix control in my report,But i am unable to increse Rows and cols.
How can i make it?
Reagards.
I need to design a report like as below
Location jan feb mar april total %
abc 1 2 1 1 5 % calculated value
ddd 1 1 1 1 4 % calcualtedvalue
------------------------------------------------------------------------------------------------------
total 2 3 2 2 9 total(%calculated value)
i was able to get everything except last column. i am using Matrix control. can any one help me how to another column after sub total in matrix control.
hii
Everybody
In my report i have a matrix,but i want to show only 10 columns in one page and rest of the data should come in next page?
so is there anyway to control the number of columns in a matrix to be shown in the priview?
please help me with some suggestions.
its orgent
thanks in advance
Mahasweta
I have a matrix report:
My Expression in the data fields inside design mode is:
IIF(Fields!Row_num.Value mod 2 ,"White","LightGrey")
I am using a Dense rank Function at the dataset level in order to group id column wise. So Fields!Row_num.Value comes from that set.
Earlier it was BLANK values: Please see below for reference.
Tried IsNull on SQL Server already and does not work because there are no NULLs in the data I am retrieving. The empty cells happen when the matrix creates the crosstab report - where there is no data for a column. Everything else works well except the BLANK values being not colored as you see in the screen shot, im using ISNOTHING function to achieve those 0's if NULLS inside the report. But though we have a value inside the cell coming from report it does not colour the entire group.
My requirement is coloring the entire column group irrespective of the NULLs' or Blanks.
Have also tries several functions, but of no use. I am missing with a tiny thing I guess which I am unable to figure out.
Other Functions Tried:
=IIF(VAL(ReportItems!ROWCOLOR.Value) MOD 2,"WHITE","LightGrey")
=iif(RunningValue(Fields!City.Value,CountDistinct,Nothing) Mod 2, "LIGHTBLUE", "SILVER")
=iif(RunningValue(Fields!DQLogDateTime.Value,CountDistinct, Nothing) MOD 2, "LightGrey","White")
Everything I've read says that custom data flow components are built by inheriting from the Microsoft.SqlServer.Dts.Pipeline.PipelineComponent class.
But the stock components such as the Derived Column data flow transformation must each be implemented by their own class. So how do I base my custom components on those classes? The documentation for the PipelineComponent class doesn't list any such subclasses.
Hi,
In another thread Jamie Thomson very informatively said "The components in SSIS
are deliberately atomic (i.e. they do something very specific) so that
its easy to put them together to build something greater than the sum
of the parts". Which does make a lot of sense. However, I've been finding that I end up having to create exactly the same "pattern" of combined transform components again and again in order to solve the same problem but in different dataflows (or even within the same dataflow). Cut-and-paste-tastic! In order to obtain real re-use, it seems to me like SSIS is crying out for an easy way to create new components by using composition - i.e. the ability to take commonly-used combinations of existing components and create new "super" components (without having to write Custom Transform Components in C#/VB.Net and handle everything in code).
Does anyone know if this sort of functionality is likely to make it into SSIS in the forseeable future?
Regards,
Lawrie
does any one have and example of how to embedd a flash swf file onto a report.??? Is it possable? any examples would be helpful.
View 1 Replies View RelatedI got the following code to add a column in a matrix with a variance:
IIF(IsNothing(Previous(Sum(Fields!Amount.Value))) or Fields!year.Value=First(Fields!year.Value,"Category") or Previous(Sum(Fields!Amount.Value))=0,nothing,
(
(Fields!Amount.Value)
/Previous(sum(Fields!Amount.Value))
)
)
This code works fine, except that the first row of the matrix shows an #error
This happens with each matrix where I use this expression. A warning emerges:
rsruntimeerrorinexpression the value expression for the textrun Textbox43.Paragraphs[0].TextRuns[0]' contains an error.
Attempted to divide by zero.
The strange thing is that the part
Fields!year.Value=First(Fields!year.Value,"Category")
should prevent an error and I expect it to show 'nothing'
An screenshot of the table. (each color is a different category. Each row stands for 2013, 2014, 2015)
As you can see, all other 2013 rows show a blank cell, except the first row.
I have a Matrix table that expands to the right when choosing an amount of months to be shown. Under this matrix I have to Charts. The two charts are situated together, that is no space between them, and to the left of the report.
Now, if I choose a lot of months, say three years the matrix diagram will be huge to the right. The problem I have is that the second diagram, the one on the right, moves to the right depending on how big the report gets, and this is not good at all. The two charts are supposed to be all the way to the left.
How? Why does the right chart move?
Thanks in advanced
Kind Regards
When is the Add-in going to be updated for the RTM of office?
View 1 Replies View RelatedI have a SQL 7.0 backend for a new DB of mine. This is the first time I
have developed a SQL backend from scratch, so the problem may be my design.
The problem may lie with my Access frontend (I have tried both 97 and 2k),
but I am inclined to think not considering the behavior.
On only one table (the master table no less), I cannot add records during
business hours. I can add records to other tables and edit records on this
table though. This troublesome table has a field indexed as unique that is
not the PK (don't know if that has any bearing, but it is the only table in
this DB that has that property).
The adding records problem appears to be network traffic related because
sometimes records can be added at lunchtime and definitely after hours. I currently only have 3 connected users. I had these problems with only one connected user, so the DB itself is not being strained by traffic. I often have more traffic on the DB after hours to avoid the problems. I have worked on the connection and network traffic angle for awhile, when I stumbled upon the bizarre part. If I add a record via a stored procedure and run this SP on the SQL query analyzer on the server (no network is involved) it is still slow to add the record (30 minutes or more). Needless to say this would equate to an failure on the front end. The same query will run in 0-3 seconds after hours!
Does anyone have any clue how this could happen? I am stumped.
I do have a budget for a consultant if I need one, but I need to find
someone who has a chance to fix this problem. If you don't know the answer
but can refer someone in the DFW area, I am in your debt.
Debbie
Using SSIS, every month/week I have to generate serveral excel files. I need to find a way to automatically format these excel files (Bold, Headings in Different color etc.). Is there a way to integrate MS Office excel task in SSIS?
Thanks
Shafiq
is it at all feasible to embed an office doument (specifically word) into an ssrs report so that the document will print out when renderered to pdf?
View 4 Replies View RelatedHelp! My network support staff just upgraded my MS Office products from Office 2003 to Office 2007, and now I no longer get the "F5 = Run" option in Microsoft Visual Studio to run any of my SSIS packages that ran just fine yesterday, before the upgrade.
The "Debug" option does not occur in the menu choices across the top of the screen. (They are File, Edit, View, Project, Build, Data, Format, SSIS, Tools, Test, Window, Community, and Help -- no Debug.)
I store my packages in the File System. I can run many of them just fine, even today, with the Execute Package Utility. My problem occurs when I try to run them in Visual Studio.
Even if I make a simple, new package that moves a table from Access 2003 to SQL Server 2005, I see no Debug menu selection option when I am finished with the new package.
I figure it must be something simple -- I just don't know where to find it in the Visual Studio menu.
Most of the packages I am trying to run do not access Office files: they access dBase 5 files (database); they run processes on SQL Server 2005 servers. I realize that I may have to make some adjustments to connections to Access databases, should such databases be upgraded to Office 2007.
Thanks in advance.
Dan
Hi All,
Do anybody know if it's possible to have an SQL 2005 server deal with and out of office reply from an email its send via the new Database Mail?
My application sends mail to users, giving them task instructions via Database Mail, however if they have thier out of office set true, I just get a reply msg in the profiles inbox. I would like the SQL server to know that they are out of office.
I can recogise the replys by the subject and I have control over the format of the replies, so its just case of getting the SQL server to read msg in the inbox.
Thanks
Gary T
Hi,
A while ago we changed from Sybase to MS Sql Server 2000. Thereby we also introduced Windows Authentication instead of SQL Logins. When end-users wanted to read directly (tools like Enterprise Manager/Query Analyzer/ isql and Office products (like Access and Excel via MS Query)) from the Sybase database we managed that with a SQL login with read-only rights. With Windows Authentication in MS Sql Server 2000 the end-user can enter the database with update rights. Is there a way to manage tools like EM/QA/isql/Office products etcetera so that the end-user can approach the database only with a SQL Login instead of Windows authentication ? Although we are building tooling to kill every user who approaches the database with the tooling mentioned, we think this is not a proper way to manage database access.
We hope someone has encountered the same problem and knows how to handle this and can help us.
Greetings,
Ferrie
Hi guys,
I'm trying to write an SSIS script that will create an excel file and append data to it.
I downloaded the Office 2007 PIAs (Primary Interop Assemblies) and installed them on my desktop PC where i'm developing from.
However, and even though the assemblies are in the GAC, they don't appear when you look in "Add Reference" for your script task.
If i create a standard .NET web or windows app and try to "Add Reference" I can find them there.
Am I missing anything obvious?
Thanks for your help in advance
Mike
Does SQL Server Express work *easily* with Office 2003? I'm especially interested in using Access 2003 & Excel 2003 with SQL Server Express.
I did a search here, but found nothing.
I see Oracle is now giving away their "Express" Oracle 10g; I'm weighing options...
Help!
I've been using MS Office Accounting 2007 (free version) and today the application says that the database cannot be connected to. Basically, the SQL service will not start or run. Could it be due to Symatec's firewall? Please help.
Thanks,
What is the best way to insert records into an SQL Server 2005 database that's being hosted with my website. The data will originate from customer sites as transactions. Do I connect to the hosted database using TCP/IP or do I create web pages that accept the data variables? This is all new to me!
I need this to happen unattended and 24/7/365
Thanks
Tim