Monday, March 26, 2012
radio button in Reporting Services 2000
I am using SQL Reporting Services 2000. In a report I need to have
radio buttons to give the input into query for a report. Does anybody
have idea about how to use the radio buttons into reports.
Thanx
~kHey SSRS doesn't have an option of placing radio buttons. check ut in the
toolbar of SSRS.
Amarnath
"kuls" wrote:
> Hi all,
> I am using SQL Reporting Services 2000. In a report I need to have
> radio buttons to give the input into query for a report. Does anybody
> have idea about how to use the radio buttons into reports.
> Thanx
> ~k
>
Friday, March 23, 2012
Radio button
Hi,
I have one report,in my report i need to display parameters like this:
one radio button :Age and another radio button is Age Ranges
For the Age,I have to dispaly like two text boxes named 'From' and 'To'
For the Age Ranges,I have to display one drop down list contains values :20s,30s ..
In Reporting Services,Putting the Radio button is not possible,i think,If possible how to achive this.
Other workaround is i think Multivalued parameter which displays the Age and Age ranges
When we click on Age we need to display 2 textboxes
When we select Age Ranges we have to display Drop down list
If we select both :both 2 text boxes and drop down list.
Putting multi valued parameters for this requirement is not good and this is not the multi valued parameter concept.Please clarify me whether iam correct or not.
Thanks in advance
Your requirements go beyound the standard parameter prompts. Consider implementing a custom application to handle the parameters and use the ReportViewer controls to render reports.|||Hi,
How to implement the custuom application,Please provide me the links.
Thanks in advance
|||http://www.devx.com/dotnet/Article/30424/0|||Hi,
The article describing about the WinForms Report Viewer control. not the creation of custom application.
Thanks
|||By custom applications I meant WinForms or web-based applications you write. You can use the ReportViewers controls to render reports in custom .NET-based applications.radar component ...
It's me again, i'm searching a radar component for my report (for MS SQL
reporting services) but i can't find it; where can i find this kind of
chart ?
Thanks in advance
aVrNormally I don´t like making ads for a company, but perhaps that´ll help
you:
http://www.dundas.com/products/chartrs/index.aspx?Section=ChartRS&Body=screenshots.htm
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"avrama" <avrama@.free.fr> schrieb im Newsbeitrag
news:42ae0ef9$0$2111$626a14ce@.news.free.fr...
> hi,
> It's me again, i'm searching a radar component for my report (for MS SQL
> reporting services) but i can't find it; where can i find this kind of
> chart ?
> Thanks in advance
> aVr
R
Are you using filters on the pie chart?
Rather than using percentage values could you convert them to real values out of 100?
You may want to look at Dundas software's charting solutions as they could be more flexible than the out-of-the-box charts.
cheers,
Andrew
sqlR
and i need to make a report as shown below:
Male
I'm assuming i need to use a matrix, but how can i get a total and a % column
You can use a standard table for this. To get the total just use an expression to add male and female together. To get the percentage, once again use an expression to evaluate (male/total)*100.
|||Hi sluggyI am new to reporting services and about to start creating some (matrix) reports. I am interested in your comment that the example above can be created using a tabular report.
I wonder if you could help me out on this scenario:
Say I have a db table with sales for a particular year. (i.e 2003 and 2004). Sol the database table is: field1 = Sales, field2 = Date ( assume the years are static )
Using a tabular report is it possible to calculate the sums for each...? This effectivly what a matrix report would do very well as it allows grouping by columns.
Any response would be greatly appreciated.
Regards,
Neil
|||You could still use a tabular report for eachyear. Matrix reports are when you have information for rows, columns, details (and page header which is optional). In your case, you just have Rows (which will be Date) and Sales (which is column name) and SUM(Sales) group by year (which will be your table details)|||
NeilSt wrote:
Using a tabular report is it possible to calculate the sums for each...?
It sure is - there are many posts on this forum explaining how to do a total row on a table. Totalling is done at the group level, so you can have subtotals within grand totals.
NeilSt wrote:
This effectivly what a matrix report would do very well as it allows grouping by columns.
A matrix is more for when you have a dynamic number of columns. In your prior example, you could use a matrix if Male, Female, Male percentage and Total were on the rows and you had a column grouping on state. But it is just as easy to do it as a table, with Male/Female/etc being the columns and the states being the rows.
|||HiThe answer to my post seems to assume that the Years field would be a row. I am saying... Row = sales and column = 2003 and 2004. Its more a column group that is required no ? if so how are they done in tabular reports ?
Maybe im missing something...
thanks for the help again.
Neil
Example:
2003 | 2004 | Total
Sales 100 | 50 | 150
now to get the total is fine i guess.. but sales is made up of a number of sales within the year. So its effectivly a sum of all sales in 2003... thats what im trying to work out how to do.
|||
Neil,
You can sum up your sales for all available years in the database in the SQL query itself like this:
(if you have stored the year in a separate column in the table)
SELECT SUM(Sales) AS Sales, Year
FROM SalesTable
GROUP BY Year
(if you have not stored the year in a separate column in the table but in a datetime column, us this)
SELECT SUM(Sales) AS Sales, YEAR(SalesDate) AS Year
FROM SalesTable
GROUP BY YEAR(SalesDate)
and in your matrix, add a row group on Sales field and column group on Year field.
Shyam
|||Shyam,Yes that is possible, I think when I first responded to this thread, I was mor einterested to know if its possible to do column grouping in tabular reports...? It seems that is what all this comes down to..
Thanks for your help.
Neil
|||Maybe someone can help me decide which style of report makes sense for this mockup of a report:
Columns: Jan - Dec
Rows: City
So lets say we can to find the number of sales for a city form Jan to Dec...
So looking something like,
Jan | Feb | March | April | May | June | Mid Totals | July |August etc... | Totals for full year
nyc: 1 2 3 3 3 3 15 3 4 x
nj: 1 1 1 1 1 1 6 1 1 x
la: 2 2 2 2 2 2 12 2 5 x
So which is the best report type to use.. ? Matrix supports column grouping ... tabular only supports row grouping from what I can tell...
each record in the db contains a month , sale value and city...
I leave it up to you all to let me know which one is best suited (tabular/matrix)
Neil
|||
Of course Matrix is suitable. But your report layout woulc make more sense if you could have an additional ROW grouping on Year besides City .
Shyam
|||Hey man.Thanks again, maybe you can explain to me how one can work out the Total for years column...
which calculates the sum of each row.. This is a limitation of the tabular report (no column grouping) ?
Maybe you could point me in the right direction for this situation: Say i have under each row group, subtotals. But for every detail textbox I check the month of that record and only display it in the appropriate column (jan or feb etc..) how can I get the row group sub total to produce a result for each month.. and not a subtotal of the row group (city), I guess this can be done using a SQL query but im wondering if RS can provide some support for it...
I require this table to have static columns and therefore using a matrix seems too limited.. And there are these small issues stopping me from knowing if its possible to implement using a tabular report...
Neil
|||
- Removed -
|||WOAH!that is one heck of a thread jack. so anyone have an answer for my original question?
|||
I'm sorry, I didn't intend to thread-jack... I thought we were talking about similar things.
My apologies.
|||sorryWednesday, March 21, 2012
R
Hello -
I have a report based on a query that currently uses the = operator and I'd like to change it to the LIKE operator and allow a wildcard...using the %.
So...from something like, "....WHERE zipcode = @.ZipCode" to "...WHERE zipCode = @.zipCode plus the wildcard character.
Is this possible?
Thanks,
- will
You cannot do it direcly from query , You can write procedure and then call this procedure from report.
alter procedure TestReport(
@.param varchar(20)
)
as
declare @.SQLstring as nvarchar(200)
set @.SQLstring='select getdate() where zipcode like ''%'+@.zipcode+'%'''
exec sp_executesql @.SQLstring;
|||Will Durning wrote:
Hello -
I have a report based on a query that currently uses the = operator and I'd like to change it to the LIKE operator and allow a wildcard...using the %.
So...from something like, "....WHERE zipcode = @.ZipCode" to "...WHERE zipCode = @.zipCode plus the wildcard character.
Is this possible?
Thanks,
- will
You can very well achieve this in the query itself. Eg: select * from <table-name> where <column-name> like '%' + @.column-name + '%'
|||Thanks for the replies.
I ended up using a stored procedure and just concatenate the '%' to the incoming parameter. I could not get it to work with an inline sql query in my report....and besides, I was planning on using stored procs anyway.
qyering data from two databases on different servers
Hello-
I am trying to write a report that combines data from two different databases on two different servers. Wherther I run the query in SQL Server 2005 management studio or reporting services, I get the same error:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'King_County_SWD.dbo.vwDriver_Out_Gate'.
There is an error in the query. Invalid object name 'King_County_SWD.dbo.vwDriver_Out_Gate'.
I have written queries that access two different databases on the same server and they work just fine, so I am guessing that I am not providing enough of a fully qualified path to the second server. We have not implemented linked server.
Any ideas on how to properly identify the second server/database/object would be appreciated.
Whenever I had to access data from 2 different servers, I had to setup a Linked Server. Without going into too much detail, here's an example:
Server1(where the sql statement will be run) Server2(other data)
ON Server1 create a linked server to Server2. On Server1, run your sql statement, BUT for the data on Server2 you need to add the qualifier Server2, i.e.,
Select * from DB1.dbo.table1 inner join Server2.DB2.dbo.table2 on ..............
|||You could also use an SSIS package as data source for your report.
Sounds weird but works:
http://www.fits-consulting.de/blog/PermaLink,guid,0e3316ae-c9e7-426e-9e6b-30dab0ea2ed2.aspx
cheers,
Markus
Qury regarding SQl Reporting services 2005(Authentication Problem)
I have some questions on Sql server reporting services 2005.
First one is that on my report server there are some reports for which
i want to remove authentication
i.e. Any body can run those reports without giving any user name and
password, How i can do this please tell me.
Second thing is
For multiple selection, how to implement it because previously i was
working on SSRS 2000
I can show now multipple selection check list boxes now but in quert
how i can implement that
in query i wrote like this
Select * from Table where
City like @.Dataset2
But when i select multiple parameters for city it is giving error
if i select one parameter then it is running fine
So please tell me how to do these.
Thanks & Regards
DineshOn Mar 18, 2:51 pm, "Dinesh" <dinesh...@.gmail.com> wrote:
> Hi experts,
> I have some questions on Sql server reporting services 2005.
> First one is that on my report server there are some reports for which
> i want to remove authentication
> i.e. Any body can run those reports without giving any user name and
> password, How i can do this please tell me.
> Second thing is
> For multiple selection, how to implement it because previously i was
> working on SSRS 2000
> I can show now multipple selection check list boxes now but in quert
> how i can implement that
> in query i wrote like this
> Select * from Table where
> City like @.Dataset2
> But when i select multiple parameters for city it is giving error
> if i select one parameter then it is running fine
> So please tell me how to do these.
> Thanks & Regards
> Dinesh
To remove report authentication (on a report-by-report basis), select
a report in the Report Manager, then select the Properties tab and
select the very bottom radio button that says 'Credentials are not
required' and then 'Apply.'
Something like the below query should work for the multi-select
parameter:
--CREATE PROC SomeProc
DECLARE
@.CityList VARCHAR(MAX)
--AS
DECLARE @.CityListBuffer VARCHAR(MAX),
@.END_POSITION INT;
--TEST DATA--
SET @.CityList = 'Chicago, New York, Miami, San Diego, Los Angeles,
Nashville';
--TEST DATA--
CREATE TABLE #CityList (City INT);
SET @.CityListBuffer = @.CityList;
WHILE (LEN(@.CityListBuffer) > 0)
BEGIN
IF (CHARINDEX(',', @.CityListBuffer) > 0)
BEGIN
SET @.END_POSITION = CHARINDEX(',', @.CityListBuffer);
INSERT INTO #CityList VALUES (SUBSTRING(@.CityListBuffer, 1,
(@.END_POSITION - 1)));
END
IF (CHARINDEX(',', @.CityListBuffer) = 0)
BEGIN
SET @.END_POSITION = LEN(@.CityListBuffer);
INSERT INTO #CityList VALUES (SUBSTRING(@.CityListBuffer, 1,
(@.END_POSITION + 1)));
END
SET @.CityListBuffer = RIGHT(@.CityListBuffer, (LEN(@.CityListBuffer)
- @.END_POSITION));
END
SELECT * FROM TABLE WHERE CITY IN (SELECT City FROM #CityList)
DROP TABLE #CityList;
You may have to change the charindexes above for a different delimiter
(i.e., ''',''' for strings, etc); but it should work.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||On Mar 19, 4:25 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Mar 18, 2:51 pm, "Dinesh" <dinesh...@.gmail.com> wrote:
>
>
> > Hi experts,
> > I have some questions on Sql server reporting services 2005.
> > First one is that on my report server there are some reports for which
> > i want to remove authentication
> > i.e. Any body can run those reports without giving any user name and
> > password, How i can do this please tell me.
> > Second thing is
> > For multiple selection, how to implement it because previously i was
> > working on SSRS 2000
> > I can show now multipple selection check list boxes now but in quert
> > how i can implement that
> > in query i wrote like this
> > Select * from Table where
> > City like @.Dataset2
> > But when i select multiple parameters for city it is giving error
> > if i select one parameter then it is running fine
> > So please tell me how to do these.
> > Thanks & Regards
> > Dinesh
> To remove report authentication (on a report-by-report basis), select
> a report in the Report Manager, then select the Properties tab and
> select the very bottom radio button that says 'Credentials are not
> required' and then 'Apply.'
> Something like the below query should work for the multi-select
> parameter:
> --CREATE PROC SomeProc
> DECLARE
> @.CityList VARCHAR(MAX)
> --AS
> DECLARE @.CityListBuffer VARCHAR(MAX),
> @.END_POSITION INT;
> --TEST DATA--
> SET @.CityList = 'Chicago, New York, Miami, San Diego, Los Angeles,
> Nashville';
> --TEST DATA--
> CREATE TABLE #CityList (City INT);
> SET @.CityListBuffer = @.CityList;
> WHILE (LEN(@.CityListBuffer) > 0)
> BEGIN
> IF (CHARINDEX(',', @.CityListBuffer) > 0)
> BEGIN
> SET @.END_POSITION = CHARINDEX(',', @.CityListBuffer);
> INSERT INTO #CityList VALUES (SUBSTRING(@.CityListBuffer, 1,
> (@.END_POSITION - 1)));
> END
> IF (CHARINDEX(',', @.CityListBuffer) = 0)
> BEGIN
> SET @.END_POSITION = LEN(@.CityListBuffer);
> INSERT INTO #CityList VALUES (SUBSTRING(@.CityListBuffer, 1,
> (@.END_POSITION + 1)));
> END
> SET @.CityListBuffer = RIGHT(@.CityListBuffer, (LEN(@.CityListBuffer)
> - @.END_POSITION));
> END
> SELECT * FROM TABLE WHERE CITY IN (SELECT City FROM #CityList)
> DROP TABLE #CityList;
> You may have to change the charindexes above for a different delimiter
> (i.e., ''',''' for strings, etc); but it should work.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer- Hide quoted text -
> - Show quoted text -
Hi Enrique,
I have tried what you suggested for removing the authentication but
after doing like that report is not rendring it is showng error that
credential is not set.
So please tell what to do... This i done for a single report only
suppoese if i want to remove authentication from my report server it
self then what to do, how i can implement that.
Regards
Dinesh
quraterly report
I
need to find out the orderid for the order placed during the quarter, the
order date field is order date.
This report will run in the early morning of first day of the quarter before
any new order is entered.
Can you tell me how to program it?
Thanks,> This report will run in the early morning of first day of the quarter
> before
> any new order is entered.
How are you going to prevent that, set the database to single_user?
Try using a calendar table. Then you can query for data in any quarter,
regardless of whether the quarter ended yesterday or 645 days ago.
http://www.aspfaq.com/2519|||You could use something like this (as example):
USE NORTHWIND
GO
SELECT ORDERID,
CASE DATEPART(Q,ORDERDATE)
WHEN 1 THEN 'QUARTER 1'
WHEN 2 THEN 'QUARTER 2'
WHEN 3 THEN 'QUARTER 3'
ELSE 'QUARTER 4' END AS 'Quarter'
FROM ORDERS
ORDER BY QUARTER
You could also break it out into columns using CASE as well if you prefer.
HTH
Jerry
"qjlee" <qjlee@.discussions.microsoft.com> wrote in message
news:BC95898E-EDA6-40F2-87DB-60E0467EB5FA@.microsoft.com...
>I am designing a quarterly report for summary of order received quarterly.
>I
> need to find out the orderid for the order placed during the quarter, the
> order date field is order date.
> This report will run in the early morning of first day of the quarter
> before
> any new order is entered.
> Can you tell me how to program it?
> Thanks,
>
>|||How could I break into columns by using case?
Thanks,
Li
"Jerry Spivey" wrote:
> You could use something like this (as example):
> USE NORTHWIND
> GO
> SELECT ORDERID,
> CASE DATEPART(Q,ORDERDATE)
> WHEN 1 THEN 'QUARTER 1'
> WHEN 2 THEN 'QUARTER 2'
> WHEN 3 THEN 'QUARTER 3'
> ELSE 'QUARTER 4' END AS 'Quarter'
> FROM ORDERS
> ORDER BY QUARTER
> You could also break it out into columns using CASE as well if you prefer.
> HTH
> Jerry
>
> "qjlee" <qjlee@.discussions.microsoft.com> wrote in message
> news:BC95898E-EDA6-40F2-87DB-60E0467EB5FA@.microsoft.com...
>
>|||qjlee (qjlee@.discussions.microsoft.com) writes:
> How could I break into columns by using case?
SELECT CASE DATEPART(Q,ORDERDATE) WHEN 1 THEN ORDERID ELSE NULL AS Q1,
CASE DATEPART(Q,ORDERDATE) WHEN 2 THEN ORDERID ELSE NULL AS Q2,
CASE DATEPART(Q,ORDERDATE) WHEN 3 THEN ORDERID ELSE NULL AS Q3,
CASE DATEPART(Q,ORDERDATE) WHEN 4 THEN ORDERID ELSE NULL AS Q4
FROM Orders
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.aspsql
Tuesday, March 20, 2012
Quicky : Views of views of views
Hello,
to make a report easier I'm developing it using a view of joined views of joined views.
Is there any significant performance penalty as opposed to just having one big select?
Cheers.
I think there is because running a view on more than one table need more processing power than running a view n a single table. So if you are concerned about performance issues, you might certainly not run a view of joined views of joined views. Try the big select rather. Hope it Helps...
Quicky : Views of views of views
Hello,
to make a report easier I'm developing it using a view of joined views of joined views.
Is there any significant performance penalty as opposed to just having one big select?
Cheers.
I think there is because running a view on more than one table need more processing power than running a view n a single table. So if you are concerned about performance issues, you might certainly not run a view of joined views of joined views. Try the big select rather. Hope it Helps...
Quickie: SMTP config for attachments
sending only the LINK to a report but not if I attach the report to the
e-mail in say excel or xml format.
Any suggestions?
Thanks
TravisSomeone must have an idea... please! :-)
I have tested using a command line SMTP utility and have been able to send
both a plain text message and a plain text message wth and attachment so I
know the Mail server will accept it.
Someone, Anyone?
Thanks
Travis
"REM7600" <rem7600@.hotmail.com> wrote in message
news:eumyP3OdEHA.1692@.tk2msftngp13.phx.gbl...
> I can configure a working subscription to e-mail through my SMTP server
when
> sending only the LINK to a report but not if I attach the report to the
> e-mail in say excel or xml format.
> Any suggestions?
> Thanks
> Travis
>|||Here's the error from the log... I can't make much of it... Other than the
part that says please see the log files...
ReportingServicesService!emailextension!728!07/29/2004-07:32:05:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(CatalogItemContext reportContext, String historyID, Boolean
forRendering, Guid& reportID, Int32& executionOption, String&
savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot&
snapshotData, Guid& linkID, DateTime& historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS
Service rs, CatalogItemContext reportContext, ClientRequest session,
JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
Wednesday, March 7, 2012
Quick method to move reports to production
development while retaining the settings within the report manager?with RS2005, you can use the scripting capability of the management studio.
and there is this tool:
http://www.sqldbatips.com/showarticle.asp?ID=62
"Doris" <Doris@.discussions.microsoft.com> wrote in message
news:E690A5AA-F2F2-45DA-BA9A-E2B4C39D1DF5@.microsoft.com...
> Is there a quick method of moving multiple reports to production from
> development while retaining the settings within the report manager?
Quick DB change possible?
We've had to rename the DB and it's broken the report (obviously). Id rather not have to delete the current connection (and lose all the fields we've setup).
It's still using the same SQL stored procedure (same name), just the DB name has changed.
Thanks,
SteveGo up to Database, then set database location
Quick custom security question
report, and what parameters the are supplying.
So lets say that I have a report called "Salary Report" that shows
employees salary and bonus data. The people who can run the report
with Department = 1 are not allowed to run the report as Department = 2.
Previously I believe the answer was to use the "UserId" in my reports,
which would be populated with the current users Username, but we
already have a very complex system for determining peoples rights to
different things on our intranet site.
People can delegate rights to others, people get rights based on their
project assignments, people get rights based on their position in the
company, people get rights based on who they report to, and who reports
to them, and on and on.
So all I need to know to validate is username (or userID), what report
they are running, and what parameters they are supplying.
Is there any way to do this?Would a query based parameter work for you where you use a stored procedure
to return a list of valid parameters that they can use for that report based
on who they are and what rights they have inherrited?
Steve MunLeeuw
"cmay" <cmay@.walshgroup.com> wrote in message
news:1161293948.030847.304270@.m73g2000cwd.googlegroups.com...
>I am trying to implement some type of security based on the user, the
> report, and what parameters the are supplying.
> So lets say that I have a report called "Salary Report" that shows
> employees salary and bonus data. The people who can run the report
> with Department = 1 are not allowed to run the report as Department => 2.
> Previously I believe the answer was to use the "UserId" in my reports,
> which would be populated with the current users Username, but we
> already have a very complex system for determining peoples rights to
> different things on our intranet site.
> People can delegate rights to others, people get rights based on their
> project assignments, people get rights based on their position in the
> company, people get rights based on who they report to, and who reports
> to them, and on and on.
> So all I need to know to validate is username (or userID), what report
> they are running, and what parameters they are supplying.
> Is there any way to do this?
>
Monday, February 20, 2012
Questions to the Microsoft guys about the custom assembly
Hi Guys,
I created a custom assemy and added a reference to it in my report, but when I built the report, it told me that the system could not find the file. I followed the steps in the MSDN when I did the above steps. Can anybody tell me why?
Another question is about the location of the assmbly that I should copy. In the Debugging Custom Assemblie chapter on MSDN, it tells to copy my assembly to
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE.
But in Deploying a Custom Assembly chapter, it tells me to copy it to
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.
Can Microsoft guys tell me which is correct?
Thanks in advance.
Danny
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies is the correct location for the report designer in BI Development Studio.
-- Robert
|||Hi Robert,
Thank you very much for your answer. My another question is I can only refer to my custom assembly when I use strong name for the assembly and put it into GAC. Or else, the report designer just told me that the file or its dependecies counld not be found. But put the assembly into the GAC means I cannot debug my assembly. Could you give me some tips on this? (I followed all the steps I could find on the MSDN)
Thanks in advance.
Danny
Questions regarding Reporting Service SOAP
I using reporting service SOAP in my application. I would like to know..
- what is the method for delete a report
- there is list children method for listing reports from certain folder but how to get list of catalog or list of folders from reporting service, but method to use.
Thanks and best regards!
Delete a report: DeleteItem( itempath )
List folders: Call ListChildren(parentpath) and filter the resulting CatalogItem collection for folders. There is no way to only return folders from ListChildren.
List catalog: This is not meaningful because any given Report Server has one and only one catalog.
Questions on Report Delivery
with Report Delivery to have a report run with different parameters each
time and then emailed to a remote office?
ex. A batch listing of all deposits. In January it prints a listing of all
deposits for the month of January. In February, March etc. Can a report be
used for Report Delivery, be based on different parameters each time it is
printed? Or to have a report for January sent to the Houston showing all
deposits for the Office "HN" and a report sent to the Detroit office showing
all deposits for the Office "DT' etc?
Billhave a default parameter with query based on current month,
Go to Parameters, Default value > Query or Nonqueried > Month(Now)
On Apr 20, 1:14 am, "BillG" <billgo...@.charter.net> wrote:
> I am currently moving a client from Crystal Reports to SSRS. Is it possible
> with Report Delivery to have a report run with different parameters each
> time and then emailed to a remote office?
> ex. A batch listing of all deposits. In January it prints a listing of all
> deposits for the month of January. In February, March etc. Can a report be
> used for Report Delivery, be based on different parameters each time it is
> printed? Or to have a report for January sent to the Houston showing all
> deposits for the Office "HN" and a report sent to the Detroit office showing
> all deposits for the Office "DT' etc?
> Bill