Is there a third party tool or something similar that will allow users to create reports on their own without any programming? One code base but custom reports for each user in the system that they create.
View 7 Replies
Is there any component of the Microsoft Business Intelligence Stack that could be used by an end-user (i.e., not a coder, a business analyst) where they can drag and drop tables/columns onto a canvas and create reports themselves? I've been looking and can't seem to see anything I would want to give to an end-user.
I am trying to find something that is like the Cognos Report Studio/Query Studio products. They are pretty intuitive and users are able to create their own reports without the of IT. They can drill through folders, pick columns, drag them onto a canvas, sort the data, filter the data, group the data, add titles, all without having to know SQL (joins are made automatically).
I've looked at PowerPivot but that seems mostly targetted at OLAP users. What I am looking for is the ability to create list style reports with charts etc.
I have a table in my databse called MailAlerts in this table following are the fields
AlertDetail (which contain the message detail)
AlertParticipent (Which Contain the email address for the users who should receive this alert as example[URL]
AlertSent (Which is BIT fields and will be set to 1 after the email has been sent)
I send automatic email alerts to the AlertParticipent emails with message content which will be extracted from AlertDetail. I am using SQL2005 and asp.net 3.5 as main development tool.
I have a series of reports that run off a one table. The problem is, I have to read in data from a flat file from a large data source in order to update my SQL table. Right now, I read the tables in then the last thing I do is truncate the table I report from, fill the table with the necessary data and run a few small stored procedures to update some of the fields. Then the users are ready to run their reports.
Is there a better way to do this or a way I can lock them out while the table is filling and updating?
I have a report that has authentication set to domain users and users can view the report. However a few of the users are getting permission errors when they try and export the report to excel. They are able to view the report, but cannot extract into excel? Has anyone ran into this before?They are getting this error:HTTP 401 ( You are not authorized to view this page).
View 1 RepliesI have developed a set of ssrs .rdl reports and am trying to display them from the reportviewer control embeded in my asp web page. The problem is that when I select the print icon on the reportviewer control I am prompted to install ms sql server. What is the best way to print .rdl reports from the web page's embeded reportviewer control to the client's local network printer.
View 2 RepliesIs it possible to programmatically disable/enable say column field drill through capability of the matrix table report depending on the textbox.text of dropdownlist value but retaining drill through capability of row fields ?
View 1 RepliesI have done it as mentioned in the readme file in the samples folder. But after completing all the steps when I open my browser and give in the url http://<servername>:<portnumber>/Reports, it shows the following error:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
After being thoroughly frustrated with the typed datasets using the xsd designer, i built a custom class as an alternative. When I built it, I used the ComponentModel.DataObjectMethodType and ComponentModel.DataObject so that I could access them from the wizards. In the aspx file where the rdlc resides, using the wizard, I can select an objectdatasource and set the typename and selectmethod and add the object to the file. But when I go into the reportviewer, it doesn't show up as a project datasource for me to be able to add it to the reportviewer even after rebuilding the website. A few google searches didn't help so here I am asking if anyone can point me down the correct path.
View 5 RepliesI have developed this code .It is giving sumpoistive ,sumnegative correct .But count of positives and count of negatives it is not showing value...It is not showing error but not giving result..it is giving 0 as count for the coun_positive n for negative aslo..
Please tune my logic...
Public pos_sum AS INTEGER =0
Public neg_sum AS INTEGER=0
Public pos_coun AS INTEGER
Public neg_coun AS INTEGER
FUNCTION SUMFUNCTION(ByVal Field AS INTEGER) AS INTEGER
if Field>0 then
pos_sum=pos_sum+Field
return Field
End IF
IF Field<0 then
neg_sum=neg_sum+Field
return Field
End IF
End FUNCTION
FUNCTION COUNTFUNTION(ByVal Field AS INTEGER) AS INTEGER
if Field>0 then
pos_coun=pos_coun+1
return pos_coun
END IF
IF Field<0 then
neg_coun=neg_coun+1
return neg_coun
End IF
END FUNCTION
Function SumPositive() AS INTEGER
return pos_sum
End FUNCTION
Function SumNegative() AS INTEGER
return (-neg_sum)
End FUNCTION
Function couPositive() AS INTEGER
return pos_coun
End FUNCTION
Function couNegitive() AS INTEGER
return neg_coun
End FUNCTION
I am maintaing binay data in sql table field-'StImage' . Actually i don't know how to show image from database field.
After lots of googling i tried to make it a reality .
I have dragged and droped a 'Image' control into my table in MyReport.rdlc[Design]
I set the following properties to the 'Image' control
name=ImgSt
MIME Type= image/jpeg
Source=Database
Value==Code.ByteToImage(Fields!StImage.Value)
Then i have added the following code to the 'Code' tab of Report Properties window
[Code]....
[Code]....
[Code]....
In my report I want to display the dollar amoumt in textboxs.
So I set the textbox property Format as currency.
My question is that I want to reports show brackets for negative dollar values. Ex : ($100) but
i want to report only display the negative values -$100
i'm developing a "small" warehouse-management WebApplication for few users(5-10 parralel) but with a complex authorization system(checking if pages,menus,TabPanels, UserControls and even single controls are visible or enabled) and permanent and frequent access. Because i've only limited experiences with the ASP.Net MembershipProvider, i'm unsure what's the best approach for following goal:
I want to hold all users, roles and frequently used masterdata in the Cache(in a Dataset). Hence every readonly access should be faster and causes less traffic than always using the database. On updates,deletes and inserts i would update the cached dataset and also the database.Can i use or extend the SqlMembershipProvider to achieve this goal and if possible how?Should i use the stored-procedures from asp.net or simply use the standard CreateUser, GetUser, DeleteUser-functionality? Does this approach makes sense at all?
I'm have a doubt using membershipuser to create users in the AD with Membership.CreateUser Method, does any one knows how can i send other attibutes to the AD, such as First Name and Last Name?, besides those ones: username
As String, _
password As String, _
email As String, _
passwordQuestion As String, _
passwordAnswer As String,
I'm creating a new middle tier where all of our client calls will go through a WCF service. We're using ASP.NET membership with the service in order to authenticate users. The middle tier will be hitting an existing database in which we already have an InetUsers table containing usernames and passwords.This is where it starts to get messy. This new middle tier will be used by our web application, but not by our existing desktop application, which will - until we rewrite it at some point in the future - be using the old COM+ middle tier. Administration of the users for the web application takes place in the desktop application. In other words, users will be created and passwords set and changed from within the desktop application, which in turn hits the already existing InetUsers table.Ideally, what will happen is when we deploy the new middle tier, we'll take all of the users from the InetUsers table and create records for them in aspnet_Users and aspnet_Membership. Then we'll set a trigger on the InetUsers table to keep aspnet_Users and aspnet_Membership up-to-date.There's a whole bunch of questions wrapped up in this, so I'll try and list them all out here:Is this the right approach? Obviously having this data in two places isn't ideal, but bear in mind here that I'm not the final decision maker here and we're kinda stuck with some legacy stuff here, at least for now. Still - maybe there's a better way.In the same vein - would we be better off coding our own membership provider rather than using the SqlMembershipProvider? How difficult/easy is it to do so?If we use this approach, I plan on using the aspnet_Membership_XXXX stored procedures for the initial population of the tables as well as in the triggers. Having done some research into this, it appears that if I want to call aspnet_Membership_CreateUser directly from SQL (ie in a trigger...) rather than using the API, I have to store clear text passwords since I can't get the salt and the hash right otherwise. Is this true?Does any of this even make sense or am I going about this the wrong way to begin with?
View 2 RepliesI am having the binary data in sql table field 'ImgSt' .
I want to show the binay data as a jpg image. Therefore i used the for converting the binay data to image
[Code]....
[Code]....
I have also set in 'DataOutput' Tab
the the ElementName='imgSt' which is my Image's name
DataTranform==Code.ByteToImage(Fields!StImage.value)
For the value field of my 'Image' in report i have set
value==Code.ByteToImage(Fields!StImage.value)
But i am getting the error as the following
' MemoryStream' is not defined
I have at least 87 report in my project what i am thinking to create a custom header and footer item in the report. In Header and footer we are showing a image so if we want to change the image then we need to change the image in all my 87 reports so is there any template that we can set in my header and footer so child report inherits from them.
View 1 RepliesI'm currently working on a project that will allow users to do the following:. Choose one or more reports from the report library.2. Cycle through each report, choosing the parameter values to use to run each report.3. Generate a pdf containing all of the reports in one large file.4. Download the pdf.I'm handling 1, 3, and 4 just fine but running into some problems with item 2. The multi-select parameters are giving me headaches. Basically I want a page that contains the parameter selection piece of the standard SSRS web interface but instead of "View Report" it would fire off a function I've created that saves the parameter values and then reloads the page for the next report in the list chosen by the userDoes anyone know if the Report.aspx source code is available somewhere? I'm currently using a PopupControlExtender, CheckboxList, and Textbox to try and mimic the functionality of the multi-select parameter interface that's provided by SSRS but am having trouble getting the page to postback when the user clicks outside the list
of parameter values (the default SSRS interface does this).
In my asp.net application, users are created by the administrators & those users need to log-in into the system using their own email/password or openid. So what is the best option to implement in this scenario?
I mean, as users can't register them self,do administrator required to associate each openid with the users & what kind of table structure do I need?
And do I also need the log-in interface like that of [URL] showing multiple types of authentication(default & openid from various providers)?
I've been using the CreateUserWizard to create my users as well as to assign them roles/permissions. My problem is that, once created, I have no idea how to edit or delete their details without using the Asp.net Website Administration Tool. Where can I get some extensive but easy to understand literature on the subject?
View 4 Replies I am stuck here with the color for the graph values i want to give custom colors for each values present in the graph, is it possible in SSRS2000.
Problem Statement : Suppose if i want to display two data fields as bar graph
Data Fields are : Vegetable Count and Fruits Count
I want Vegetable count to be in Blue Colour and I want Fruits count to be in green colour.
I need to get list of users reporting to a particular manager from the Active directory. In the active directory there is manager property with contains the data in the following way.
CN=Gegore Lid,OU=IT,OU=Sales,OU=XXXXX,OU=XXXX,DC=YYYY,DC=intra
[Code].....
I am new to SQL Server Reporting Services. I am generating Reports VS 2005 Business Intelligence Report Server Project.
Here I got a general QQ when I am generating report.
How can i add custom text if column value is null. I tried to add it by column Expression property.
i,e =IIF(IsNothing(Fields!DOB_YY.Value) , "Null", Fields!DOB_YY.Value)
Here I added custom text as 'NULL'. But its not doing any changes in my pages.
I am using Excel 2007 to connect to a SQL Server 2008 Analysis Services database.
View 4 RepliesI'm having trouble setting up a custom NEW User Screen. Here is my situation, I have a Request for Access Screen that uses the CreateNewUser Wizard Control. I want to leave the Question and Answer for this, however I also want a custom NEW User Setup which I build myself to allow the system administrators to setup users, but for this setup I don't want the administrators to have to pick the question and answer for the NEW user, so I would like to bypass this for this setup. However, my Membership.CreateUser keeps asking for it. How can I accomplish this? I've included a copy of my current web.config file. You will notice a AspNetAdminMemberhip which I use to allow the System Administrators to reset passwords.
<?
<
<
<
<
<
<
<
<
</
</
</
</
<
<
<
<
</
<
<
<
<
xml
version="1.0"?><configuration>configSections>sectionGroup
name="system.web.extensions"
type="System.Web.Configuration.SystemWebExtensionsSectionGroup,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">sectionGroup
name="scripting"
type="System.Web.Configuration.ScriptingSectionGroup,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">section
name="scriptResourceHandler"
type="System.Web.Configuration.ScriptingScriptResourceHandlerSection,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
requirePermission="false"
allowDefinition="MachineToApplication"/>sectionGroup
name="webServices"
type="System.Web.Configuration.ScriptingWebServicesSectionGroup,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">section
name="jsonSerialization"
type="System.Web.Configuration.ScriptingJsonSerializationSection,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
requirePermission="false"
allowDefinition="Everywhere"/>section
name="profileService"
type="System.Web.Configuration.ScriptingProfileServiceSection,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
requirePermission="false"
allowDefinition="MachineToApplication"/>section
name="authenticationService"
type="System.Web.Configuration.ScriptingAuthenticationServiceSection,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
requirePermission="false"
allowDefinition="MachineToApplication"/>sectionGroup>sectionGroup>sectionGroup>configSections>connectionStrings>add
name="LBX_ChangeControlConnectionString"
connectionString="Data
Source=10.31.30.26;Initial Catalog=LBX_ChangeControl;Persist Security Info=True;User ID=sa;Password=wstinol"
providerName="System.Data.SqlClient"/>remove
name="LocalSqlServer"/>add
name="LocalSqlServer"
connectionString="Data
Source=10.31.30.26;Initial Catalog=LBX_ChangeControl;Persist Security Info=True;User ID=sa;Password=wstinol"
providerName="System.Data.SqlClient"/>connectionStrings>system.web>membership>providers>add
name="AspNetAdminMembership"
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="LocalSqlServer"
applicationName="/"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
enablePasswordRetrieval="false"
maxInvalidPasswordAttempts="5"
minRequiredPasswordLength="8"
minRequiredNonalphanumericCharacters="1"
/>
</
</
<
<
<
<
<
<
<
<
providers>membership>roleManager
enabled="true"/>authentication
mode="Forms"/>profile
enabled="true">properties>add
name="FirstName"
type="string"/>add
name="LastName"
type="string"/>add
name="Gender"
type="string"/>add
name="ProfileImageID"
type="string"/>add
name="Department"
type="string"/>add
name="PhoneNumber"
type="string"/>properties>profile>pages>controls>add
tagPrefix="asp"
namespace="System.Web.UI"
assembly="System.Web.Extensions,
Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>controls>pages>
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this affects performance, set this value to true only during development.
<
<
<
<
<
<
</
<
<
-->compilation
debug="true">assemblies>add
assembly="System.Web.Extensions,
Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>add
assembly="System.Design,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>add
assembly="System.Web.Extensions.Design,
Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>add
assembly="System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/><add
assembly="CrystalDecisions.CrystalReports.Engine,
Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add
assembly="CrystalDecisions.ReportSource,
Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add
assembly="CrystalDecisions.Shared,
Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add
assembly="CrystalDecisions.Web,
Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add
assembly="CrystalDecisions.ReportAppServer.ClientDoc,
Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add
assembly="CrystalDecisions.Enterprise.Framework,
Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add
assembly="CrystalDecisions.Enterprise.InfoStore,
Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies>compilation>httpHandlers>remove
verb="*"
path="*.asmx"/>add
verb="*"
path="*.asmx"
validate="false"
type="System.Web.Script.Services.ScriptHandlerFactory,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>add
verb="*"
path="*_AppService.axd"
validate="false"
type="System.Web.Script.Services.ScriptHandlerFactory,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>add
verb="GET,HEAD"
path="ScriptResource.axd"
type="System.Web.Handlers.ScriptResourceHandler,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
validate="false"/>add
verb="GET"
path="CrystalImageHandler.aspx"
type="CrystalDecisions.Web.CrystalImageHandler,
CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></httpHandlers>httpModules>add
name="ScriptModule"
type="System.Web.Handlers.ScriptModule,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>httpModules>system.web>system.webServer>validation
validateIntegratedModeConfiguration="false"/>modules>add
name="ScriptModule"
preCondition="integratedMode"
type="System.Web.Handlers.ScriptModule,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>modules>handlers>remove
name="WebServiceHandlerFactory-Integrated"/>add
name="ScriptHandlerFactory"
verb="*"
path="*.asmx"
preCondition="integratedMode"
type="System.Web.Script.Services.ScriptHandlerFactory,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>add
name="ScriptHandlerFactoryAppServices"
verb="*"
path="*_AppService.axd"
preCondition="integratedMode"
type="System.Web.Script.Services.ScriptHandlerFactory,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>add
name="ScriptResource"
preCondition="integratedMode"
verb="GET,HEAD"
path="ScriptResource.axd"
type="System.Web.Handlers.ScriptResourceHandler,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>handlers>system.webServer>location
allowOverride="true"
inheritInChildApplications="true">appSettings>add
key="CrystalImageCleaner-AutoStart"
value="true"
/>add
key="CrystalImageCleaner-Sleep"
value="60000"
/>add
key="CrystalImageCleaner-Age"
value="120000"
/>appSettings>location>system.net>mailSettings>smtp
from="Lockbox@tdbanknorth.com">network
host="ME6AWMAIL01.bkng.net"
password=""
userName=""
/>smtp>mailSettings>system.net>configuration>
