View Complete Post
Do we have some kind of Equivalent of Solution generator 2008 (SharePoint 2007 to generate list definitions and site definitions via SharePoint 2007 UI and use it in our WSP) in SharePoint 2010?
is there a way to build a report with a tablix and let the columns movable for the users?
from another post i figured out, that this feature is not supported in sql server 2008.
is it featured in 2008 R2 or in 2010? :)
I am using c# in VS 2010 Express. I have a MDF database that I connect to through "Database Explorer". Database Explorer will not let me SAVE columns that I have modified. As I know in SQL Server 2008 full edition you can change the setting
"Prevent saving changes that require table recreation" in Management Console to prevent this. I haven't got Management Console and can't see it in install.
How do I change this setting if I haven't got management console? Is it in Registry or Config File.
I have many reports that hide/show columns based on either parameters or user input.ÃÂ When columns are hidden the body size is not recalculated and also cannot be set through expressions.ÃÂ This leads to at best extra blank pages when reports are printed, at worst reports that cannot be embedded as subreports into other reports because they off-set the elements around them when the area into which they are inserted automatically resizes in rendering.ÃÂ This should be considered a bug in the current release (2005).
Is there any chance of this making it into the new version (either that the renderer recalculates the body width or that expressions could be used in fields such as body width)?
I've recently upgraded from SQL Server 2000 to SQL Server 2008. My accounting and marketing team is skilled and has been using SQL Query Analyzer for years to run smaller queries and build small Crystal Reports. Unfortunately Query Analyzer is
now bundled into the management studio. That's a bit too much software for this level of power users.
Is there a client-side query analyzer for SQL Server 2008? I'd rather use a Microsoft product than a 3rd party tool, but I suppose I could do that too. Looking for something simple that will:
1. Show users the database tables and/or views
2. Run queries
Perhaps query analyzer isn't the way to go and my team needs a different reporting system. If this is the way MS is heading, could you direct me towards a product or service that allows power users to get the information they need? They will
still need to look at raw data to build Crystal Reports though.
I've got following issue. I have a matrix like this
Sales January February March April May ... January + February February + April
10 20 15 5 30
I have a row group "Sales" and a column group "Months". Now i need to build different subtotals oh the column group, for example January+February. Which would be 30 in this case.
Any ideas how ideas how i can build these totals???
Does the 2008 R2 Data Alignment in the columns (Domain Scope) work with multiple tablix's or only with one Tablix with different groups?
I have been trying to use it for a report that has 3 tablixs (the same dataset and same format) but it doesnt seem to work. All the examples i find are for a single tablix.
Sorry if this is a total newbie question. I've searched all around and it would seem like the answer would be 'no'. The point of confusion is that visual studio lets me write the code in a sql project but then barfs with this error:
"One or more types required to compile a dynamic expression cannot be found. Are you missing references to Microsoft.CSharp.dll and System.Core.dll?"
System.Core I can actually reference. Microsoft.CSharp I cannot and I understand that this is a security issue. Fine. But is DLR usage considered dynamically compiled code? Seems a little weird since all it really is is a hashtable
lookup and some late-bound dereferencing (yes, it could take down your server, but there you go.)
Anyway, is there a way for me to use a 'dynamic' object in SQL server 2008 R2 or am I just out of luck?
I have recently upgraded to SQL Management Studio 2008. The first thing I noticed is it wouldn't allow me to save changes to my table structure at all. I fixed this by disabling "Prevent Saving Changes that requre table re-creation" under Tools..Options...Designers...Table and Database Designers. Now it lets me save. However, if I rename a column in a table that has data in it, I get a warning telling me my data will be lost since the old column will be gone and the new column has no data in it. Since when does renaming a column require a table to be recreated? Is this some sort of setting in SQL Management Studio? If I can't don things like rename clolumns (even change column data types) without losing all my data, then what is the point of using SQL management studio?
I have a SSRS 2008 report which has 3 column groups which when i export to Excel the resulting excel spreadsheet has an additional total column for each of the groups. I dont have this displayed in the report and dont want it displayed in teh excel
export, is there anyway to turn this off?
I've had a search of this forum but so far i've been unable to find a solution(or someone else having the same problem)
I have a report implemented on SSRS 2005 that for the purpose of hiding the toggle sign (+/-) when there is no detail data has an expression on the Hidden property of the text
Now when migrating to 2008, the table has been automatically upgraded to a tablix with the undesired behavior that, when a field is hidden on a row, the remaining fields are shifted
to the left to occupy the space of the hidden field.
This happens only when the report is rendered on the web. On Visual Studio it works as in 2005.
Is there a way to avoid this kind of shifting? Why will I want to render a field on a space designated to the field on the left that it may not even fit?
HI AllI have 3 dimensions in our Data Warehouse, dimCampaign, dimCampaignList and dimCampaignTargetThink of dimCampaign as a marketing campaign, that contains one or more Campaign Lists (offers) for which many customers (dimCampaignTargets) receive. The are foreign key relationships between these 3 tables, and it is the dimCampaignTarget ids that are written to associated fact tables
I have created a single dimension in Analysis Services 2008 that contains these 3 tables and their respective relationships were set up in the DSV so that I could do this. Rather than use the 'referenced' dimension method, I wanted a 'single' dimension containing the 3 tables and their snowflake relationships in order that I can create a hierarchy that contains attributes from differing tables (namely the Campaign Description from dimCampaign, and Campaign List Description from dimCampaignList).
My hierarchy has those 2 levels, top level is Campaign (description), and the 2nd level is Campaign List (description). The Campaign Targets are not shown in the hierarchy, their attribute is only used in the dimension as the join to most of the fact tables.
Problem is when I set up my hierarchy, I go to change the Key Columns property of the Campaign List attribute to make it a collection of keys (Campaign and Campaign List) as I did in
I have a report with 15 columns of data (each column is approximately 1inch~2inch), when I preview the report and click PRINT icon (which is very next to refresh icon) then save it as Microsoft xps document writer, it shows only first 5 columns of data,
even data is truncated at end of each page in .xps.
I have selected A4 paper type in report properties, So please assist me how to print all 15 columns (along with header and footer) of data ? If I change the width and height in report properties then it affects rendering to PDF, DOC etc ..
Any suggestion is also welcome