Customize Report Filters
Dec 12, 2007
Can I customize the report filters?
I need to use the data from another table (in a Drop Down control) to filter the data of my report instead of having a simple textbox.
How can I do this?
ADVERTISEMENT
Customize Report Manager
Apr 30, 2008Hi,
Is it possible to customize the report manager web site so that I can set the report output format to excel by default.
Currently, to get the excel report user has to first select the report criteria and then click the "view report" button which renders the report in HTML format and then only the export to excel option appears.
Is there a way we can get the report exported to excel in one go.
Thanks,
Rajiv
Customize Report Manager
Sep 17, 2007I would like to use Report Managers interface for choosing reports.
But all of the reports uses different dsu(datasourceuser) and dsp(datasourcepassword) depending on which user that is logon.
I would like to call the interface from a webapplication(where they have the current dsu & dsp).
Is there a way to customize Report Manager to save the dsu & dsp so users don't have to login for each report?
Or could I make a clever transformation from the Windows userid?
Or any other ideas??
Customize Report Parameter Layout?
Nov 7, 2007Hi,
I'm trying to deal with a way to change the report parameter's default layout.
currently it seems to default to two columns, that's fine until you have a large screen and the "View Report" button is all the way to the right and you have a big chunk of whitespace.
For Example:
Parameter 1 Parameter 2 <View Report>
Parameter 3
I'd like it to show up instead as:
Parameter 1 Parameter 2 Parameter 3 <View Report>
anyone ever tried this before?
Reporting Services :: How To Customize SSRS Bar Chart Report
Jul 23, 2015I have a requirement associated with SSRS bar chart.
Data in my DB is like shown below:
A
B
C
Opt1
Data1
10
Data2
20
Opt2
Data1
30
Data2
40
Opt3
Data3
50
Now I would like to build up a bat chart which should have:
Legends: Opt1, Opt2, and Opt3
Categories:
Data1(showing bars with scores as 10 and 30),
Data2 (showing bars with score 20 and 40),
Data3 (showing bar with scores 50 only)
SSRS How To Customize The Report Models Created For Specific Users
Jan 3, 2008hi,
I am new to SSRS. I am doing some report models for Ad-hoc reports. Im my database i have some users and their roles according to my requirement. User should only see the particular reports if he have privilege. how to customize...
User will access Report Builder to do adhoc report.
For example
I have 5 report Models
rptModel1
rptModel2
rptModel3
rptModel4
rptModel5
In my data base there are 3 users.
user1 have privilege to view rptModel1, rptModel3
user2 have privilege to view rptModel4, rptModel5
user3 have privilege to view rptModel2, rptModel5
When Particular user access the report builder, There i want to show only that particular Report models...
is there any posibilities to do this please Help me.
Thanks in Advance...
-Kannan
kannan1017@gmail.com
SSRS Report Filters
Aug 10, 2007Hi,
I have applied two filters for table in the SSRS report, one is StartDate and another is EndDate. But I was unable to choose the Boolean operator (And/Or) to use to combine this expression.
I came to know that the Boolean operator cell activates after we begin to enter an expression in the next row. But by default it is set as "And" operator. Now i want to cahnge that to "Or" operator it is in disable. Is there any way to enable this cell to choose the operator from the cell.
Any help would be appreciated.
Thanks
Dinesh
Filters - Report Builder
Oct 15, 2007I have created a report showing both first name and last names with the following filters. Both of them are prompted parametres
Last Name Contains ------------------
First Name Contains ------------------
When users enters both then we get the results back. I want the first name to be optional such that if user enters something for the first name then take it into the search criteria else show all the first names which matches the last name criteria.
Example: Last Name = "SMITH", First Name = (user has not entered and NULL check box is checked). I don't get any results since this filter translates to find all the records which has the last name SMITH and First Name IS NULL),
Instead I want this to be select all the records which has the last name SMITH and First Name <> EMPTY. Is there a way I can do this using the fiter magic?
Thanks.
Filters - Report Builder
Oct 17, 2007I have created a report showing both first name and last names with the following filters. Both of them are prompted parametres
Last Name Contains ------------------
First Name Contains ------------------
When users enters both then we get the results back. I want the first name to be optional such that if user enters something for the first name then take it into the search criteria else show all the first names which matches the last name criteria.
Example: Last Name = "SMITH", First Name = (user has not entered and NULL check box is checked). I don't get any results since this filter translates to find all the records which has the last name SMITH and First Name IS NULL),
Instead I want this to be select all the records which has the last name SMITH and First Name <> EMPTY. Is there a way I can do this using the fiter magic?
Thanks.
Reporting Services :: SSRS 2014 Report Manager - Customize Standard Title And Change Background Colors?
Jul 30, 2015I have 3 SSRS 2014 (Dev, UAT and Prod). I would like to change background colors of each environment and customize the title 'SQL Server Reporting Services' to ' SSRS Development'.
I prefer to implement both, a background color change and a title change. The reason for this is to clarify to end users which environment they are working with.
Where can I make those minimal changes in SSRS 2014.
Analysis :: Browsing Cube In Excel With Report Filters
Apr 29, 2015I am built the cube and processed. The fact table has 2 keys from the same dimension table.
My customers asked me that they want to browse the cube with report filters. The scenario is very strange.
They want to filter on same dimension with different conditions.
For example, they want to use the condition as ProductCode IN (...) and ProductName NOT IN (...)
How can I do this when browsing the cube in excel or any where?
Problem With Date Filters In SQL 2005 Report Builder
Jul 6, 2007Hi,
I'm having a hard time getting date filters to work properly in Report Builder 2005. One of my model entites contains a datetime field called Date Opened, which corresponds to a datetime field in my database table. This is how the data looks like: 6/27/2007 11:31:52 AM, 6/27/2007 11:33:33 AM, 7/3/2007 9:24:07 AM.
1. I created an ad-hoc report and added a filter on Date Opened field, setting condition to PROMPT where Date Opened EQUALS some value. Next to EQUALS I get a dropdown list with the following values: 6/27/2007 11:31:52 AM, 6/27/2007 11:33:33 AM, 7/3/2007 9:24:07 AM. It looks like this list was generated by pulling all Date Opened values (including a time stamp) from the database. The problem comes up when I run this report and Date Opened filter limits me to choosing exact date time, when I want to see all rows for the specific date (the entire day). Is there any way to make EQUALS list not include the time stamps and show only dates, or give me a calendar control instead so I can choose the date (no time) to filter on? I noticed that if database had no existing values for Date Opened, the Equals list lets me choose a date with a calendar. I need to accomplish the same even if there are some values in the database.
2. The same setup as above. This time I choose to see all rows where Date Opened is AFTER specific date and set it to PROMPT the user. If I actually choose a default value on Filter Date dialog, run the report having picked some new value in a filter, it behaves as expected giving me all rows AFTER the date I specified. If I leave default value unspecified, run the report having picked some new value in a filter, it returns all rows on the date I specified and AFTER. In other words, it behaves like ON or AFTER. Is this a bug?
3. Same as scenario #2 above just using On or BEFORE. If I leave the default value unspecified on Filter Date dialog, run the report having picked some new value in a filter, it returns all rows before the date I specified, behaving like BEFORE rather than On or BEFORE. Is this a bug?
Any help is greately appreciated. I know we'll be getting customer calls about these issues.
Zhenia
Reporting Services :: Report Builder Filters Not Working
May 28, 2015I am using SSRS 2008. I have 3 applications specific reports deployed to reporting manager..AAA , BBB and CCC - be my Applications for example.i have 3 different application users. i want to grant access the respective application users to access respective reports.i mean application user A should not be able to access/view reports from BBB and CCC. similarly for B and C application users.HOw this can be implemented ?
View 2 Replies View RelatedReporting Services :: How To Write Report Builder 3.0 Query Filters Formula
Jun 25, 2015I have to create a filter on a dataset that accepts a parameter value which in turn,
1. If i check 'NULL' for that parameter, it has to accept all values,
2. If i give value to that parameter, data depends on that value.
My previous developer has written OR(FIND(Parameter: Param1,Param1)<>0, Parameter: Param1 = EMPTY).how to write this formula in my formula builder..
How To Customize The Primary Key Id
Jan 10, 2008
Hi to everyone,
By the way, I'm not sure if, I am in the right related forum to address this questions.
My problem is how to customize a primary key id of the table.
Example. I have a two tables customer and product, and my customer table has a customer id. I want to customize my customer id, which for example the starting id will starts CUS-0001...CUS-002 and so on.
And same also to my product table, product id will starts PROD-001..PROD-002 and so on. the digits of my id's is auto incremented.
Thank you for the time of reading my questions.
Your response is highly appreciated..
Sendmail Task - How To Customize ?
May 15, 2007I have a sendmail task following a data flow task. How can I set "To" attribute on the sendmail task before running it ? for example, read a config table and detemrine who the mail should be sent to...
View 1 Replies View RelatedUsing InScope() For Customize Subtotal
Jan 22, 2008Hello All:
I have the following data:
2000 2001
Child Teen Adult Child Teen Adult
Region1 25 40 35 33 55 12
Region2 50 10 40 20 10 70
Total 75 50 75 53 65 82
and I need the following data
2000
Child Teen Adult Child%
Region1 25 40 35 25/(25+40+35)
Region2 50 10 40 50/(50+10+40)
Total 75 50 75 75/(75+50+75)
I was able to get the Child% column and Total row, except for the cell (75/(75+50+75) ) using InScope() operator.
Can any one help me in this regard.
Thanks,
Vishnu
How To Customize Auto Generated Userid?
Feb 3, 2008Hello everyone,i have a web form to take user details.as soon as the submit button is clicked the form is submitting and the new row is being added into the sqldatabase.its fine ..but in the newly added row, i want the user id(primary key and auto generating) to display in different manner.in mytable column(userid),instead of userid auto displaying 1,2,3,4 ...i want it to display in this way.these are all primary keys of rows added.todaydate-username-1 eg(2.2.2008-jack-1)todaydate-usernaem-2 eg(2.2.2008-zak-2)todaydate-usernaem-3 eg(2.3.2008-leme-2)any idea how to achieve this.?thanks.jack.
View 9 Replies View RelatedTransact SQL :: How To Customize Where Statement Based On UDT
May 20, 2015Display customized data based on customized where statement from UDT.
The UDT is a parameter inside of a stored procedure.
Problem:
A parameter from a stored procedure is
@communication communications readonly
This parameter is a User-Defined Table Types (UDT) It contains criteria based on end-user's selection from a filtration functionality from a webpage.
Four example of filtration critera based on four end-users' selection that is located inside of a table below.
Each UDT table contains different criteria:
Number Criteria
------ --------
1 Phone
3 Email
Number Criteria
------ --------
1 Phone
2 Cellphone
3 email
Number Criteria
------ --------
4 None
Number Criteria
------ --------
2 Cellphone
1 Phone
Is it somehow possible to use the criteria's value as a column name in the where statement? I want to filtrate the data of the table datatable based on id, name and the UDT's criteria.
I was enable to apply the criteria inside of a variable by looping the UDT's table but the next thing is to paste it in the where statement after "id=1 and name" below
select *
from datatable
where id = 1 and name = 'Cost'
How should I do it?
[URL] .....
create table datatable (id int,
name varchar(100),
email varchar(10),
phone varchar(10),
cellphone varchar(10),
none varchar(10)
);
[Code] .....
Specifying Different Stylesheet In URL To Customize ReportManager Interface
May 7, 2007Thanks in advance to anyone who can provide insight into this...
I am trying to specify a different stylesheet (other than ReportingServices.css) in the URL for running the ReportManager application; I am using the "rstylesheet=<stylesheetname>" parameter in the URL. However, it seems that no matter which format of stylesheetname I use (i. e, just the stylesheet file name with no extension, stylesheetname + ".css" extension, "/reports/styles/<stylesheetname>", etc.), the ReportManager application only uses the built-in ReportingServices.css stylesheet.
Is there some "magic" to specifying the name of an alternate stylesheet with the "rstylesheet" URL parameter, or does this just not work?
Thanks again!
Customize The SQL Reporting Services Page
May 5, 2008Is it possible to customize the SQL Server Reporting services home page to add our company Logo and custom title etc...?
Thank you,
Customize Prompt Message For Stored Procudure
Jul 23, 2005Hello all,I have a stored procedure that prompts the user for beginning date andending date to run a monthly report. The prompt saysEnter_Beginning_Date and Enter_Ending_Date. I want the prompt to sayEnter Beginning Date (Example:1-1-2003) or something like that. Isthere a way to do this?CREATE PROCEDURE dbo.MonthlyReport(@Enter_Beginning_Date datetime,@Enter_Ending_Date datetime)AS SELECT incident, @Enter_Beginning_Date AS BeginningDate,@Enter_Ending_Date AS EndingDate, COUNT(*) AS OccurancesFROM dbo.IncidentWHERE (DateOccured BETWEEN @Enter_Beginning_Date AND@Enter_Ending_Date)GROUP BY incidentGO
View 6 Replies View RelatedReporting Services :: Customize Column Grouping
Jul 6, 2015I am working on one of the report. where I need to move the amount across column group.
My data is like this
Project Amount CurrentFiscalMonth DelaybyMonth
A 10 Jul 0
B 20 Aug 2
C 10 Sep 0
Report will be sum up the amount at CurrentFicalMonth grouping on column
But, if the Project is being delayed say by as per the example its 2 months than the amount should be moved from Sep to Oct column for the particular project. User has done it using the Offset function in excel.
Fiscal month starts at July and ends at June. and data source is SSAS cube.
How To Customize View Of SQL Server Enterprise Manager On Startup?
Jul 23, 2005Hi,I've managed to get a couple of shortcuts on my desktop that log meright into SQL Query Analyzer for whichever particular database I want(using the isql.exe command line options). Now, I want to do a similarcustomization for the SQL Server Enterprise Manager. I want to be ableto open SQL Server Enterprise Manager and have it pop me all the waydown into my particular database/tables view -> e.g. "Microsoft SQLServersSQL Server Group(LOCAL) (WindowsNT)DatabasesmyDatabaseName". I'm hitting a local db server...I've tried saving new consoles (.msc files), but that just doesn't seemto do anything. I've tried using bookmarks, also, and they just don'tdo anything at all when I select them.Any ideas??
View 1 Replies View RelatedCustomize Template.ini To Upgrade From Msde To Express Edition?
Jan 29, 2007I need to create the script to upgrade the current named instance of sql 2000 desktop engine to sql server 2005 express edition. I am having difficulty preparing the template.ini and would appreciate help.
[Options]
INSTANCENAME=MY_INSTANCE
SQLBROWSERACCOUNT=NT AUTHORITYNETWORK SERVICE
SECURITYMODE=SQL
SAPWD=music
UPGRADE=SQL_Engine
SQLBROWSERAUTOSTART=1
RSCANINSTALLDEFAULT=0
RSCONFIGURATION=FilesOnly
RSSQLLOCAL=0
I get an error that this file is invalid..Any clues? I am trying to upgrade existing instance of msde 2k to sql express 2005 and uses sql authentication
Problem : Can't Customize Style Sheets For HTML Viewer
Mar 15, 2007 Hi ,
Yesterday I Customize Style Sheets for the report manager. Today I tried to customize Style Sheets for HTML Viewer but it doesn't works. I have done all that steps :
- I include the <HTMLViewerStyleSheet> setting into the <Configuration> selection of the rsreportserver.config file and then specify the style sheet I want to use : <HTMLViewerStyleSheet>HtmlViewer2</HTMLViewerStyleSheet>
- My rsreportserver.config file is into the C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServer folder.
- The style sheet HtmlViewer2.css is located in the C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerStyles folder.
I'm using SQL Server 2005.
Can someone Help me ? I have been trying change the style of the toolbar all the day and i start to be desperate !
Thank you.
Customize Database Admin Activities By Creating New User Group?
Aug 17, 2012The requirement is to customize database admin activities by creating new user group.
Need to create a group of user / dbauser1 which will have restriction in seeing the data but they should be able to alter database - add / remove the data file , increase or decrease the data file space when required.
This requirement came we wanted to create a new dba group they should not be able to any user data / any table but increase / decrease / add / modify space etc.
Customize Database Maintenance Using SSIS (Select Databases Based On Status)?
Mar 7, 2008I want to customize database maintenance to run only on selected databases based on their status in sys.databases, without having to statically select them in the GUI.
I'm trying to write an SSIS package that will do the following:
1. Query for a list of databases that are not read-only or recovering, etc.
2. Perform database maintenance tasks (e.g., rebuild indexes) on those databases.
I'm doing this because the database maintenance tasks do not provide a way to select databases based on criteria or a SQL query filter.
My package includes an Execute SQL task to get the list of databases, a Foreach loop container to loop through the databases, and then...this is where I get stuck. I can't use the existing maintenance tasks (Rebuild Index, Update Statistics, etc.) because I don't know how to provide an input variable for the list of databases. I'd rather not write dynamic SQL to generate commands for each database object.
Does anyone know how to do this?
Thanks much.
David
How To Customize SSRS 2000 HTML Viewer Without Affecting Other Folders Or Clients?
Apr 17, 2007Hi all,
Got a good question to ask. At the moment, I do not have any control over the reporting server webserver. This is due to the company's policy. The webhosting is controled by antoher department.
Anyways, the question is the following:- Is there a way to customize the config file for the htmlviewer (css style sheet, rendering and others) for a specific client without affecting the rest ?
There are about 20 clients on a server, and I am responsible for one of them. I had customized my config file to render or allow only two formats for this particular client. Since I don't have any control over the websever, I just can't replace the config file without affecting the others. How do i do this ? I just want th config file to ONLY affect a certain client's HTMLViewer and not the others. I tried to do some research on this, but came up empty handed.
Thanks !
Bernard
Do Filters Have To Use IDs?
May 7, 2008Hi all,
I'm using SSAS 2005 with Excel 2007. My data store is very poor at the moment and most of the tables for the dimensions get rebuilt every night. The current result is as follows;
User selects product "Issue May 2008" as a filter from the product dimension, saves and closes the report.
User opens the report after the data has refreshed, the data is different, the filter shows Issue May 2008 but when you click on it the item above it is displayed - this is because the IDs have changed in the source table.
Is there a way to make it so the text/description of the dimension is used rather than the ID?
In my head that explanation makes sense, but I can understand how it might not so please let me know if it doesn't
Regards,
Phil
Per User Filters
Jun 21, 2007I was wondering if it's possible to set filters per user. For example we have a client who has offices in 10 different states, we want an admin of an office to only be able to run reports on their state. Is this possible without creating 10 different models/views?
Thanks
Working With Filters
Nov 18, 2007Hello.
Is there a good article on the net for working with filters?
Also, I have a report with 10 parameters.
Each parameter get his default values from a dataset.
The problem is that the report ake a lot of time to load since it need to run all 10 datasets to load the parameters values.
Is there a way to speed things up?
Thanks.
MDX Query Filters
Nov 10, 2006Hi,
I am creating report using reporting service and datasource is SQL Server 2005 Cube.
I am using query builder and i am creating query parameters in the query builder but when i run the report is showing the filters but data is not filtering based on which i selected from the list.
How do i create filters?? Please help out on this.
Thanks