View Complete Post
How to link multiple DataSets (why SSRS call it a DataSet even there is only one bunch of data fields in it) using keys, then put data fields from multiple DataSets into one Data Region? The reason I have to do this is: There will be 6 major DataSets to be used together few times in same report, it is not make sense to build a huge Matrix for all of them together. (in some data region I use data from dataset A and B, some times I use data from dataset A and C, D ...)
I have a flat file with 320k rows. Each row contains generic data such as a supplier number, plant name, and dock code. Each row also contains 5 sets of 4 fields route name, region code, arrival date and departure date. Each of the 4 fields
begin SX_ where the X is the set number. So for example the column names per row are:
SUPPLIER_ID, PLANT_ID, DOCK_ID, S1_ROUTE, S1_REGION, S1_ARRIVAL, S1_DEPARTURE, S2_ROUTE, S2_REGION, ...
What I need to do, using the flat file as a source, is to read the generic fields into one dataset and the SX fields into another. I then need to copy these datasets to an OLE DB destination into their respective tables. This is very easy using
a Windows Service and VB.NET. Anyone have any ideas how to accomplish this using SSIS 2008?
Requirement:A custom activity called "Number"ÃÂ which is used to set value of a variable.ÃÂ A custom activity called "Add" which is used to add two numbers.Drag and drop "Number" activity to the flowchart.Name the activity to Number1.Set the value to 5.Drag and drop another "Number" activity to the flowchart.Name the activity to Number2.Set the value to 10.Make the connections in this wayNumber1-------------------->ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ AddNumber2-------------------->"Add" activity should automatically check its inputs(Number1 = 5ÃÂ ,Number2 = 10) from the arrows and do the computation to give result 15.HowÃÂ it can be achieved using FlowChart elements by writing custom activities for the arrow,Number,Add?Please let me know if the question is not clear.
I am using SSRS 2008. I have a line chart which queries a huge dataset and shows the datapoints really close to each other that the labels and grid-lines are overlapping onto each other.
Is there a way to split the chart and show it on different pages.? Thanks in Advance :)
I have a stacked bar chart showing my values by geographical region. Within each region I have x-number of DataAreaIDs. I want the user to be able to see the distinct DataAreaIDs via a mouse over on each bar.
I therefore entered this formula in the tooltip option for the regional bar but it only displays #Error: "=join(Fields!DataAreaID.Value,", ")".
I appreciate your help!