Report with Multiple Data sources: Can I do this?

Okay, so I have this ADO.NET dataset defined in my project. I created
an RDLC report and from the menu Report->Data Sources... I chose two
different tables that exist in my ADO dataset. So far so good. At this
point I can drag specific columns into various text boxes I have in my
report (I'm not using tables) and I end up with entries like
"=First(Fields!ContactName.Value)". That's all well and good, but what
I was hoping to do, in addition to that, is something where I can
specify a particular record from one of the tables. Basically what I
have is a table that has two different links to another table. Now
each of those links may be to the same record, or to two different
records. I have a "Job" table and a "Company" table. The Job table has
a link to a "Dealer" and an "Installer" (both of which are records--or
the same record--in the Company table). I was hoping to be able to
display the installer name in one text box and the dealer name in
another. I have two issues: I don't know how to refer to a specific
table when referring to a particular field (both the Job and Company
tables have a "ContactName" column), nor does there appear to be a way
to pick a particular record. I can't seem to be able to do something
like "=Fields!Job.ContactName.Value" when I want to refer to the
ContactName in the Job table as opposed to the Company table. Further,
I can't figure out how to do something like (kinda pseudo code here)
"=Fields!Company.ContactName WHERE Company.ID == First(Fields!
Job.InstallerID.Value)"
So it comes down to this: Can I do anything like what I have described
above? If I can't, my next thought it to create a stored procedure
that gets every value I need and stores it in a custom named field so
I have JobContactName, InstallerContactName, etc to refer to, but then
my next question is can I define a stored procedure that will let me
grab the data I'm looking for from my in-memory ADO.NET Dataset?So I discovered that using subreports would solve my immediate
problem, but I'm still curious if there is a way to do some of what I
describe above, which is: access each different datasource via Fields,
and access specific rows in that source. Right now we can access First/
Last and what ever is chosen as the default when you don't specify
First or Last, but why can't we access a specific record based on the
value of a field in that record? I just want to know if any/all of the
above is possible or not, and if not, what are the patterns people
follow to get around these limitations?
Thanks!

Report Viewer language

Does Reporting services supports Turkish language

I am using reporting services in my asp.net project and I want to change "view report","export" buttons text to turkish words, is this possible, if possible how? thanks

I find something about IReportViewerMessages,

I crate class library project "SampViewMessages", I add "messsages.cs" class which implements IReportViewerMessages.

I create strong key GACkey.snk (c:\GACDemo\GACkey.snk)

and changed AssemblyInfo.cs like

[assembly: AssemblyTitle("")]

[assembly: AssemblyDescription("")]

[assembly: AssemblyConfiguration("")]

[assembly: AssemblyCompany("")]

[assembly: AssemblyProduct("")]

[assembly: AssemblyCopyright("")]

[assembly: AssemblyTrademark("")]

[assembly: AssemblyCulture("")]

[assembly: AssemblyVersion("1.0.0.0")]

[assembly: AssemblyDelaySign(false)]

[assembly: AssemblyKeyFile("c:\\GACDemo\\GACKey.snk")]

[assembly: AssemblyKeyName("")]

then build and added to gac with command "gacutil /i SampViewMessages.dll"

In my asp.net project web congif file I added

<appSettings>

<add key="ReportViewerMessages" value="SampViewMessages.messsages, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1f30458ddbfa42d1"/>

</appSettings>

when ? run aspx page it gives error:

The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)

what is wrong?

Report viewer and Visual Studio 2005

Hi, I developed ASP.Net web site project with Report Viewer,and i published the project and put it another system in my LAN, after creating the virtual directory in IIS i tried to browse. I am getting the following error:

[WebException: The request failed with HTTP status 401: Access Denied.] Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +211

The report server of my machine can be accessed thru http://sys40/reportserver from that system. But the published website is showing the above mentioned error, so i created the a new project, same as the one created in my system, in the other system. While debugging the project i am able to access the report server and view the report but wen the website is published and then browsed the above mentioned error is displayed.

Even the identity impersonate = true condition was made in web config file..

How can this issue be solved...

Thanks in advance.. Somu

HI,radmoorthy ：

You can give it a try with these following steps:

1. Verify your NTFS permissions for the users on the folder C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer.

He should have ("Read & Execute", "List Folder Content" and "Read").

2.In IIS for Reports and ReportServer app set Authenication method to "Basic authentication" from "Integrated Windows authentication".

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

HI,radmoorthy ：

We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

Report viewer - White Space on the right of the report

Hi,
I'm working on some reports in my project, for which I've used Reporting
services Report Viewer(RV).
Everything seems to be fine ( not actually, IE crashes as soon as I click on
the PRINT icon for the second time), but, the report viewer leaves in huge
white space on the right hand side of the report ( 4-5 inches or more). I
couldn't find any reason why it's coming up.
Tried reducing the width of the report in the layout wizard, didn't help.
Placed the RV in a table to restrict this, didn't help.
Has anyone come across this? Any suggestion / solution to this would be
greatly appreciated.
Thanks in advance
srinivasHere are some things to try...
1. Make sure that the vertical line to the right is as far to the left
as possible. Note the position ... say 7.5"
2. now select the WHOLE report ... click the uppermost top left
portion in layout mode
3. change the borders to say .5"
4. change the report width to 8.5"
You will not see the results in the preview panel ... only when you hit
the "preview" button ... or alternatively, when you export it to pdf
Hope this helps...

Report Syntax help !!

Hello,
I was wondering if some one can direct me to a link where code samples are
posted or syntax checkers.
I've taken on this report project using stored procedures, the request is
base on inventory commission for sales reps.
The rep will be paid commission on a $ amt base on the invoice date. if the
invoice date is lets say prior to 4/10/04, the commission needs to be set to
2%, after that date commission is 3%. there's also a TargetAmt if they reach
the target amt commission percent is 4% and tally the AmtPaid to see when
they've reach the TargetAmt . I would a link to a place with reports simila
r
to this one I have to do for ideas.
Thanks in advance.There are a few ways you could do it...
If you want to have a date range indicating the commission, why not have a
table that you join to. Like this:
DateRangeCommission
(datefrom datetime,
dateto datetime,
commissionrate int)
Use dates that are sufficiently early/late to indicate "from the beginning
of time" or "until the end of time", such as '1-jan-1900' and '31-dec-2099'.
I've put commission as an int, but you call it whatever you want.
Then join like this:
select *
from orders o
join
daterangecommission c
on o.invoicedate between c.datefrom and c.dateto
As for checking the totals... that's a litle more complicated. My suggestion
would be to have a calculated field (persisted if possible) in the table
which gets populated with the running total. Then you can easily look at tha
t
field to see if the bonus commission is due.
But I don't know of sites with sample code to do all this, sorry.
Rob
"ITDUDE27" wrote:

> Hello,
> I was wondering if some one can direct me to a link where code samples are
> posted or syntax checkers.
> I've taken on this report project using stored procedures, the request is
> base on inventory commission for sales reps.
> The rep will be paid commission on a $ amt base on the invoice date. if th
e
> invoice date is lets say prior to 4/10/04, the commission needs to be set
to
> 2%, after that date commission is 3%. there's also a TargetAmt if they rea
ch
> the target amt commission percent is 4% and tally the AmtPaid to see whe
n
> they've reach the TargetAmt . I would a link to a place with reports simi
lar
> to this one I have to do for ideas.
> Thanks in advance.

Report subfolders

Within a single project, is there a way to move reports to subfolders without deleting and moving?

Thanks!

BobP

Hi Bob,

You can create Linked reports from the properties page of the report on the report server.

There is a button named create linked report, which creates a copy of the report on the target report folder.

After the report has been created you can change parameters, etc and use it. You can implement reports for various sites from one report by creating more of them by Linked reports and run from different datasources, etc.

Eralper

http://www.kodyaz.com

Report solution does not open anymore after conversion to Visual Studio 2005

Hi,
we have a VS solution containing one SQL Server report project only, created with VS 2003 that was free of problems so far. We have uninstalled VS 2003 and installed VS 2005. VS 2005 converts/updates this solution without errors.
When opening the solution in VS 2005 an error message says:
"The application for project ....rptproj is not installed.
Make sure the application for the project (.rptproj) is installed."
What application is meant here? Where do we install it from?
Thanks for your help!

I assume that you are working with a RS 2000 report server. RS 2000 report projects can only be edited with VS 2003. You can install both VS 2003 and VS 2005 side-by-side on the same machine.

If you have upgraded to RS 2005, you need to install the Business Intelligence Development Studio witch comes with SQL 2005. It is an add on that works with VS 2005 and can edit RS 2005 report projects.

-Albert

Report Service 2005 with VS.NET 2003 ASP.NET application

I am very new to reporting services.

Can anyone kindly summarise the ways you can access report services report in a VS.NET 2003 web project? I can only find crystal report components

Thanks in advance

Hi,

the easiest way is to create a proxy class for RS. You don′t have to do this on your own, simply create a web reference to Reporting Services. In the background the WSDL from the ReportServer is consumed and a proxy class generated. Now, you can use every SOAP API that Report Server offers for rendering the reports, more on that can be found in the tutorials of the BOL.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks very much for your reply.

What I need to do is build up a website which can show Reporting Service Reports, ideally I can add the Report Viewer and Report Explorer onto the web page. I have to use web services to realise this (in VS.NET 2003), don't I?

Thanks in advance if anyone can reply.

Report Server Project Template missing

Hi - I have installed VS 2005 Professional Edition and SQL 2005 Developer Edition with all the options(Reporting Services etc...). When I try to create new project, there is no "Report Server Project Template" under "Business Intelligence Projects". How to get that tempalte? Can any one help on this?

mail to : sugunsg@.yahoo.com

thanks in advance
sugu

Try reinstalling the client tools from reporting services again, there might have been a problem that could take longer to investigate than reinstalling the client components.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Report Renderiring in EXCEL ..

I am using Reporting Services 2000 Service Pack 2, on a .NET 2003
Plateform. - ASP .NET in a VB .NET Project.
I have disabled the EXCEL from my default renedering formats by placing
Visible="false" in RSReportServer.config file for EXCEL.
Now the problem is that I want one report to export to excel. How can I
achieve this without changing the above line?
If anyone could tell me about an article or example implementation of the
same. I will realy appreciate.Are you using SSRS in a custom application. Disabling visiblity on the config
file is for the whole reports and not for individual reports. In that case if
you are in a custome app. then you can use URL access for generating excel or
you can use render method of the rs web serives.
Amarnath
"Tanveer Malik" wrote:
> I am using Reporting Services 2000 Service Pack 2, on a .NET 2003
> Plateform. - ASP .NET in a VB .NET Project.
> I have disabled the EXCEL from my default renedering formats by placing
> Visible="false" in RSReportServer.config file for EXCEL.
> Now the problem is that I want one report to export to excel. How can I
> achieve this without changing the above line?
> If anyone could tell me about an article or example implementation of the
> same. I will realy appreciate.
>
>