Here:
http://msdn2.microsoft.com/en-us/library/ms160911.aspx
I read that this sample is included, however when I install the samples the other three are in the "Extension Samples" directory but the "Custom Report Item Sample" is missing. Can anybody please tell me where I can find it?
Thank you!
I have one SSRS report which contains indents but it is not included when exporting to excel sheet. Is it possible to include indents when exporting to excel?I have included indent in the textbox property of a field-->Alignment-->Padding Options-->Left-->Exp-->
=CStr(2+(Level()*20))&"pt"
This is working fine in the SSRS report but its not applied when exporting to excel.
hi everyone
what the matrix's class name ?
where is the matrix's dll?
Can i create a new class extends the matrix?
I want to override the matrix's onpaint method.
Can i do this ?
why the table not have the column group?
I'm trying to add a custom report format to ssrs 2005 as per this [URL] I've added the code snippets in the example to three different ssrs 2005 server RSReportServer.config files but it does not work i.e do not show up in the export drop down when rendering report.
I've tried starting and stopping reporting services and it still does not works.
I've also modified the existing csv extension  with different options to see if it works but to no avail.However it works with SSRS2008 R2 . In fact it works right after I saved the config file, no restart needed.For SSRS2005 the file is in C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer. I checked the registry setting  just to make sure I'm looking at the correct installation 'HKEY_LOCAL_MACHINE', 'SOFTWAREMicrosoftMicrosoft SQL Server90ToolsClientSetup', 'SQLPath' The three ssrs2005 instances are in three different physical servers and the problem is with all of them so it is not an isolated incident. I've dbowner rights to all three servers. The server versions are 9.0.4060, 9.0.4035 and 9.0.4053
Hello, any information about this issue would certainly be appreciated! I've been trying to install SP1 for my SQL Server 2005. There is a failure for the reporting services which appears in the following text from the log:
--------------------------------------------------------------------------------------------------
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:417]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:417]: Executing op: CacheBaselineFile(Baseline=0,FileKey=RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587,FilePath=C:Program FilesMicrosoft SQL ServerMSSQL.1Reporting ServicesReportManagerBinReportingServicesWebUserInterface.dll,,Existing=1)
MSI (s) (7C:38) [13:43:05:433]: Note: 1: 2318 2: C:WINDOWSInstaller$PatchCache$ManagedE281BDB31738DB64CA931CA4195DEE8F9.0.1399RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587
MSI (s) (7C:38) [13:43:05:621]: Executing op: FileCopy(SourceName=WebUse~1.dll|ReportingServicesWebUserInterface.dll,SourceCabKey=RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587,DestName=ReportingServicesWebUserInterface.dll,Attributes=20992,FileSize=1235744,PerTick=32768,,VerifyMedia=1,,,,,CheckCRC=0,Version=9.0.2047.0,Language=0,InstallMode=58982400,,,,,,,)
MSI (s) (7C:38) [13:43:05:621]: File: C:Program FilesMicrosoft SQL ServerMSSQL.1Reporting ServicesReportManagerBinReportingServicesWebUserInterface.dll; Overwrite; Won't patch; Existing file is a lower version
MSI (s) (7C:38) [13:43:05:621]: Source for file 'RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587' is compressed
MSI (s) (7C:38) [13:43:05:636]: Re-applying security from existing file.
MSI (s) (7C:38) [13:43:05:667]: Verifying accessibility of file: ReportingServicesWebUserInterface.dll
MSI (s) (7C:38) [13:43:05:667]: Verifying accessibility of file: ReportingServicesWebUserInterface.dll
MSI (s) (7C:38) [13:43:05:667]: Note: 1: 2318 2: C:Config.Msi73537e.rbf
MSI (s) (7C:38) [13:43:05:667]: Using source file security for destination.
MSI (s) (7C:38) [13:43:05:667]: Note: 1: 1310 2: 5 3: C:Config.Msi73537e.rbf
MSI (s) (7C:38) [13:43:05:667]: Transforming table Error.
MSI (s) (7C:38) [13:43:05:667]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.
MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.
MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.
MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.
MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.
MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.
MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.
MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Product: Microsoft SQL Server 2005 Reporting Services -- Error 1310. Error writing to file: C:Config.Msi73537e.rbf. System error 5. Verify that you have access to that directory.
Error 1310. Error writing to file: C:Config.Msi73537e.rbf. System error 5. Verify that you have access to that directory.
MSI (s) (7C:38) [13:43:05:730]: User policy value 'DisableRollback' is 0
MSI (s) (7C:38) [13:43:05:730]: Machine policy value 'DisableRollback' is 0
Action ended 13:43:05: InstallFinalize. Return value 3.
MSI (s) (7C:38) [13:43:05:746]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=892169565,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (7C:38) [13:43:05:746]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (7C:38) [13:43:05:746]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005 Reporting Services)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi73536e.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi73536f.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735370.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735371.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735372.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735373.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735374.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735375.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735376.rbf)
--------------------------------------------------------------------------------------------------
Please note that I develop reports locally against a database on another server; would this be part of the problem? Let me know if you need more info, too. Thanks.
As per Documentation for Installing Reporting Services using command prompt
http://msdn2.microsoft.com/en-us/library/ms144272.aspx
Included the option RS_Tools in ADDLOCAL clause The error message displayed is €œThe feature(s) specified are not valid for any SQL Server products€?, if the RS_Tools is excluded the command works fine.The option doesnt exist in template.ini
The error message displayed on screen is "The feature(s) specified are not valid for any SQL Server products"
Command to Reproduce
"D:Serversetup.exe" /qb INSTALLSQLDIR="D:" INSTANCENAME=MSSQLSERVER ADDLOCAL=RS_Server,RS_Web_Interface,RS_Tools RSCONFIGURATION=FilesOnly RSACCOUNT=ServiceAccount RSPASSWORD=xxxxxxxxxx RSAUTOSTART=1 SQLBROWSERACCOUNT= Service Account SQLBROWSERPASSWORD=xxxxxxxx SQLBROWSERAUTOSTART=1
Setup Log : SQLSetupxxxx_MachineName_Core(Local).log
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Failed to find feature:RS_Tools : 70002
Message displayed to user
The feature(s) specified are not valid for any SQL Server products.
I am new to report builder. I have created a report with a calculated cell that returns a true or false value based on a true or false value from another column (from a dataset field). I want to create a filter for the calculated field (which is a ReportItem), that will only show cells that are True.
I have tried several ways to add this filter, but each time, I get an error message saying that filter or sorting cannot be created for ReportItems.
How to achieve by using SSRS. How we can "quick run" report within the subscription menu to ensure report was set up correctly during creation.  Is there any way to generate sample subscriped report without waiting for scheduled time.
I mean whether we can verify the report parameters & data in generated the report. I have verified SSRS report manager .i cant see any button or option to test run the report in subscription feature.
i am using Microsoft Sql Server 2008 Report buider 3.0. and i generated report and that report how to use custom variables.
View 2 Replies View RelatedI have an application that will ask a user about faults in a car. The info is stored in a database.
I want to create a report that will have a 'picture' of a car, as in the below; and will be highlighted depending on which part is faulty.
For example, if the bonnet is faulty, then it must be highlighted in a specific color.
I am working on SSRS report with project server 2013 and I want to add custom dll in SSRS report.I have create dll first then add into GAC Assembly After that i have add this dll in report project in SSRS.when i have try to deploy and build report...
.An error Occurred during local report processing.
Failed to load expression host assembly.
Details : Cannot Perform CAS Asserts in Security Transparent methods.
I have developed a custom report item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:
1. Deployed the report using Visual Studio
2. updated the rsreportserver.config file with the following entry:
<ReportItems>
<ReportItem Name="PedigreeChart" Type="Uabr.Rap.PedigreeChart.PedigreeChartRenderer, Uabr.Rap.PedigreeChart" />
</ReportItems>
3. Updated the rssrvpolicy.config file with the following entry.
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinUabr.Rap.PedigreeChart.dll" />
</CodeGroup>
I've also tried using the StrongNameMembershipCondition with no better results.
4. The dll and its dependencies are copied to the bin directory of the report server.
5. When I load a report with this custom report item on it, the report loads fine with no errors or warnings in the log file (even with verbose tracing). The area where the custom item should be is just white. It's almost like Reporting Services isn't registering the item correctly.
This is particularly frustrating because the report works fine in Visual Studio - apparently I configured that correctly. Any suggestions would be greatly appreciated. I'm stumped.
How would one go about setting the height of a custom report item programmatically?
I have a custom report item that renders back an image of indeterminate height. I cannot simply set RenderItem.Sizing = Image.Sizings.AutoSize; As the image is being rendered back at 300 dpi and will require being set to FitProportional. Therefore I need to set the height to a scale height. I've tried setting CRI.Height to a ReportSize value, but it tells me that I cannot because of the current state of the item.
Hi,
I'm trying to create a custom report item with the action functionality without sucess, in the Process method I create the Action like this:
Action action = Action;
action.SetDrillthroughAction("myreport");
if (imageMapArea.ActionInfo == null)
imageMapArea.ActionInfo = new ActionInfo();
if (imageMapArea.ActionInfo.Actions == null)
imageMapArea.ActionInfo.Actions = new ActionCollection();
imageMapArea.ActionInfo.Actions.Add(action);
m_ImageMap.Add(imageMapArea);
The Action is the property of the interface:
ICustomReportItem
public Action Action
{
get
{
if (m_action == null)
{
m_action = new Action();
return m_action;
}else
return m_action;
}
}
}
When I click in my custom report item I get theses error message: "The source of the report definition has not been specified"
If I change the line:
action.SetDrillthroughAction("myreport");
for this:
action.SetHyperlinkAction(http://www.google.com/);
Every thing works fine. How can I solve this?
I'm developing a Custom Report Item that generates a BarCode.
I developed all control functionality but now the problem resides on the Deploy Process.
For the fisrt time I followed 2 steps to deploy component on Visual Studio:
1) Copy the dll on " Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies "
2) Configure the control in "Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesRSReportDesigner.config"
RSReportDesigner.config
<ReportItems>
<ReportItem Name="BarCodeReportItem" Type="BarCodeReportItem.BarCodeReportRenderer, BarCodeReportItem"/>
</ReportItems>
<ReportItemDesigner>
<ReportItem Name="BarCodeReportItem" Type="BarCodeReportItem.BarCodeReportDesigner, BarCodeReportItem"/>
</ReportItemDesigner>
On the other Hand I configured SQL Server Reporting services doing that:
3) Copy the dll on " Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerin "
4) Configure the control in "Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer
sreportserver.config"
<Extensions>
....
....
<ReportItems>
<ReportItem Name="BarCodeReportItem" Type="BarCodeReportItem.BarCodeReportRenderer, BarCodeReportItem"/>
</ReportItems>
</Extensions>
5) Configure the control in "Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer
ssrvpolicy.config"
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants BarCodeReportItem.dll FUllTrust permission. ">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="D:APPSmssqlMSSQL.3Reporting ServicesReportServerinBarCodeReportItem.dll" />
</CodeGroup>
But when I add the control to the toolbox and Drag Drop the control to the Report Designer an error occurs:
"Custom Report Item BarCodeReportItem is not installed"
What Can I Do?
Thanks for all!
Hi,
We are developing a custom report item but we cannot find a way to get the report parameters. In Vb examples there is mentioning of globals but these do not seem to be present in the c# enviroment.
Could anyone give a solution on how to get to the report parameter collection in run-time.
Thanks,
Arwin van der Laan
I'm looking at creating a custom report item which will allow me to input data into a textbox on the rendered report and dynamically update a textbox or another custom report item once I leave focus of that initial textbox. Is there a way to accomplish this? I have read that you can only create CRIs which use "graphic elements and images". Is that a true statement?
The reason why I don't want to have the initial value as a parameter is becuase the client doesn't want to have to click "View Report" everytime they want to see an updated value.
Thanks,
--Josh
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'
Hello,
I am having a problem with deploying a CRI.
On my local machine the CRI works fine, only at the development machine it doens't works.
I did the following steps:
copy the .dll to the C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies
copy the .dll to the C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesReportServerin
put this code in rsreportserver.config:
<ReportItems>
<ReportItem Name="BusinessConnectDiagram" type="LogicaCMG.BusinessConnect.DiagrammingCRI.GenerateDiagramRenderer,LogicaCMG.BCDiagramming"/></ReportItems>
put this code in rssrvpolicy.config:
<CodeGroup
class="UnionCodeGroup"
Version="1"
PermissionSetName="FullTrust"
Name="BusinessConnectCodeGroup"
Description="Code group for the Business connect diagrammer">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="1"
PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010051C346CB2A79947C83804E550CF1561729DB2B5C7DEFF93758E419F16390A295DF4906ADD8FD9A29559D5E3C8BFA73D8D21B64724B1B0E688091C1541FD54D5290D6968C73E9ACA842B1E42AB3DE369F7B545933C8E101A737BB7D22F937921E7F02E00C5121D1DC312DBE96154E5A4E47BD7F489A655A09CF08EABCFB6AB7C1"
/></CodeGroup>
put this code in rsreportdesigner.config
<ReportItems>
<ReportItem Name="BusinessConnectDiagram" type="LogicaCMG.BusinessConnect.DiagrammingCRI.GenerateDiagramRenderer,LogicaCMG.BCDiagramming"/>
</ReportItems>
<ReportItemDesigner>
<ReportItem Name="BusinessConnectDiagram" Type="LogicaCMG.BusinessConnect.DiagrammingCRI.GenerateDiagramDesigner,LogicaCMG.BCDiagramming" /></ReportItemDesigner
I get the following error message:
Could not load file or assembly 'ReportingServicesWebServer,
Also when i stop Reporting Services it won't start again. I get a timeout.
Is there any way to get more information for when IAuthorizationExtension::CheckAccess fails to grant access to a report item for the current user? Specifically, it would be useful to know:
1. URL of attempted report
2. IP address of user agent
3. Identity of current user
4. Date/Time of the failed attempt
ssrs2014
I wrong a custom code in my report - Public shared Function Myfunc and in the header textbox - I tried to reference this code = Code.Myfunc.... the Myfunc gives an error Unrecognized identifier.The code is written in the report properties = Code Tab.
View 4 Replies View RelatedI have developed a renderer that renders the xml to paint a rectangle with textboxes in all the right places based on the data retrieved off the database. When i render the a complete report to the reportviewer i have no problem.
I need however to render the rectangle into a custom report item for reusability and different scenarios. This just seem to be impossible since it seems like I cant use anything other than an imagemap to render custom report items. Is this true?
To make sure you understand....in other words....
Is there a way to develop a Microsoft.ReportingServices.ReportRendering.IRenderingExtension that renders the required xml like rectangles/textboxes etc. and then migrate this to a custom toolbox item. It just seems like this should be a very easy thing to do and something regularly needed. For example when you want to use textboxes in certain positions within a rectangle to draw a organisational chart.
Does anyone know if this box will accept VB.Net code or just VB code (old style) .... nothing indicated within the applicaiton IDE ....
Thanks ...
Hi,
I'm developing a Custom Report Item and would like to fill my properties dialog in design mode with real data. I have the name of the data source and the command text for the corresponding report dataset, read from the report design.
Is it possible to create an ado.net dataset so that I can display and use real data in my properties dialog box? First problem I have is to get the connection string from the data source string. I found no docs for that, especially the Microsoft.ReportingServices.DataExtensions.ReportDataSource class is not documented. Am I on the right way with that?
Thomas
Hi All,
I want to get the Font,Background colors of the report item(Textbox) changed in Runtime,According to the value in the Textbox. The idea is to get this done by using the Same Custom code for getting both the Foreground,Background colors, I thought to implement this with flag, But I dont know how to do this..
Reporting experts ..please help me with this issue.Thanks in Advance
-Mahendra
Hi All,
Please let me know where can i find the sample files and rs2005sbsDW database in msdn library as i dont have CD provided along with the book.
Please give me the link of the sample files so that i can download it for testing the sample application.
Regards,
Prabhanjana
Hi
Books online mention the existence of sample code for several custom tasks, including the one mentioned in the title. But, when I try to find this code in the location mentioned it is nowhere to be found.
I have run a search on the rest of my drive and come up empty.
Can anyone tell me where to find this?
Thanks
I have a scenario where given an incident, for example a helpdesk request, I need to get the time invloved given the status of the incident as it moves through a queue. Each incident has a unique incidentID and can have any number of status events, each with a statusID (1 to many) For example:
status1(S1) - Incident opened -- the time here is captured as start time
S2 - misc. status - time to capture is time between start time and the new status time i.e., 2 minutes
S3 - misc. status - time to capture is time between start time and S3 i.e., 3 minutes, and the time between S2 and S3 i.e., 1 minute
... can include any status count -->> Sx
... ending with a closing time
I'd like to able to capture any time between any 2 status levels between the start and closing time.
I'm figuring that using cursors would be the best way to go, but realize that there are always better ways to do things. Listed below is the SQL I plan to use. If anyone has a better way to go about accomplishing the desired goal please let me know. The code should be able to run under either SQL Server 2000 or 2005. Thanks in advance.
SAMPLE SQL:
declare @ticketnumber varchar(20)
,@opendate int
,@closedate int
select ticketnumber,min(opendate),max(closedate)
into temp
from mastertable
group by tickernumber
declare MyCursor cursor for
select *
from temp
order by 1
open MyCursor
fetch next from MyCursor into @ticketnumber,@opendate,@closedate
while (@@FETCH_STATUS =0)
begin
select sum(.....)
from mastertable
where ticketnumber = @ticketnumber and ?field? = 'EX'
fetch next from MyCursor into @ticketnumber,@opendate,@closedate
end
close MyCursor
deallocate MyCursor
Can someone verify that Report Builder is included in SQL Server 2005 Standard edition?
I have a book that says it's only included in Enterprise edition, but the following chart says it is included in Standard:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Does anyone know if it's possible int sql 2000 reporting to change the color of an alternating item, similar to a datagrid in asp.net?
View 1 Replies View RelatedI want a sum of the rows I have but only the unique items, for example
Client Name           Amount
Client 1Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $10
Client 2Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $20
Client 2Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $20
Client 3Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $30
Client 4Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $40
Client 4Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $40
Client 4 Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â $40
I want the sum of this to be Client 1 + Client 2 + Client 3 + Client 4 which is $100. But if I just do a sum it adds up each row. I also have them grouped together, so when it's shown, I only seen one of each item, but a sum still grabs all the duplicates.How can I go about getting the unique sum
I have a table where I am grouping on one field and would like an individual (separate) count of values from another field of same table. So for example, I have following data:
instance_id, area,       values
101             North      1
102             North      2
103            East         2
104            East         2
I would like to report on Area, and count of rows with different Values types, for example:
Area                           Value - 1,   Value - 2, Value - 3
North                                1             1             0
East                                  0            2                0
I am not sure what the technical term is for such report, but I can group by Area column, and but its aggregating counts on different Value types that I am having difficulty in performing in SSRS.
When I try to put a new report in existing folder there's no problem,but now i have fresh installed Reporting Services and no Visual Studio2005. How do i open a new folder?
View 1 Replies View Related