Linking Seperate Datasets

I am wondering if it is possible to have 2 datasets in the rdl report that
are linked together by some key.
Or do I just have to combine the information in the two datasets using a
query into one dataset. If at all possible i would like to use two datasets
that are linked.You can have as many datasets as you like in one rdl report. However,
generally you can only use one dataset in a given table, matrix, list, etc.
If you require to present things in different ways you may be best to use
one dataset with different sorting, filtering and grouping.
HTH,
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Arlyn" wrote:
> I am wondering if it is possible to have 2 datasets in the rdl report that
> are linked together by some key.
> Or do I just have to combine the information in the two datasets using a
> query into one dataset. If at all possible i would like to use two datasets
> that are linked.
>
>

Linking reports

Does anyone know if it is possible to link two reports together?
For example, if you have a report showing customers with the number of
orders they have placed, can you then link to another report showing
details of the actual orders.
Hope this makes sense.
ChrisYes possible using drill through reports.
Amarnath
"chris.j.stubbs@.gmail.com" wrote:
> Does anyone know if it is possible to link two reports together?
> For example, if you have a report showing customers with the number of
> orders they have placed, can you then link to another report showing
> details of the actual orders.
> Hope this makes sense.
> Chris
>

linking from one report to another

Hi
I've build my own report viewer app in an aspx project. This is made
up using frames - top frame for navigation, bottom frame for viewing
reports. One of my reports links to another report. I have this
working, but have 2 issues...
1. When I click on the link it loads the new report in the entire
window - overriding my frame. This also prints the entire url in the
address bar of the browser, parameters and all. I need to load it in
the correct frame in the frameset.
2. Hovering over the link to the report shows the url in the status
bar. I don't want this to happen either.
Can anybody help with a solution for either of these'
Thanks,
Gearoidok, i solved the first part of this by adding -
&rc:LinkTarget=frameName - to the url string of the report which links
to the graph. All reports which stem from the base report inherit the
same properties.
Now just to hide urls in the status bar...
ghealy@.gmail.com (Gear?id) wrote in message news:<173a60fb.0409200812.75da1f0a@.posting.google.com>...
> Hi
> I've build my own report viewer app in an aspx project. This is made
> up using frames - top frame for navigation, bottom frame for viewing
> reports. One of my reports links to another report. I have this
> working, but have 2 issues...
> 1. When I click on the link it loads the new report in the entire
> window - overriding my frame. This also prints the entire url in the
> address bar of the browser, parameters and all. I need to load it in
> the correct frame in the frameset.
> 2. Hovering over the link to the report shows the url in the status
> bar. I don't want this to happen either.
> Can anybody help with a solution for either of these'
> Thanks,
> Gearoid

Linking entities in report builder by table columns that are not primary or foriegn keys.

What is the best way to join two tables by something other than there primary or foriegn keys in report builder. I actually want a relationship between two tables based on a combination of two columns.

Thanks

Dear,

Delete the relationship and join the table as per ur criteria.But the Primary and Foregin key Relation is the best to retrieve the record and applying functions. and also on criteria basis.

HTH

From

Sufian

Linking Drill through Report based on dynamic textbox source.

I'm trying to link a drill through report based on a text box that is derived from a "Switch" function. I only want the drill through capability if the source for the textbox is a certain field from my dataset.
ex: =Switch( Parameters!SummaryBy.Value = "Division", Fields!BranchDivision.Value , Parameters!SummaryBy.Value = "Region", Fields!BranchRegion.Value, Parameters!SummaryBy.Value = "Branch", Fields!BranchNbr.Value, Parameters!SummaryBy.Value = "Satellite", Fields!BranchSatId.Value, Parameters!SummaryBy.Value = "Loan Officer", Fields!LONbr.Value)
so if I only wanted the above textbox to navigate to a subreport if it returned LONbr as the source, what expression would I put in the "Jump to Report" advanced property?Try =IIF(Parameters!SummaryBy.Value = "Loan Officer", <your subreport>,
Nothing).
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JKS" <JKS@.discussions.microsoft.com> wrote in message
news:809BE35A-3B2C-4F50-8248-2DAF1709DCF4@.microsoft.com...
> I'm trying to link a drill through report based on a text box that is
derived from a "Switch" function. I only want the drill through capability
if the source for the textbox is a certain field from my dataset.
> ex: =Switch( Parameters!SummaryBy.Value = "Division",
Fields!BranchDivision.Value , Parameters!SummaryBy.Value = "Region",
Fields!BranchRegion.Value, Parameters!SummaryBy.Value = "Branch",
Fields!BranchNbr.Value, Parameters!SummaryBy.Value = "Satellite",
Fields!BranchSatId.Value, Parameters!SummaryBy.Value = "Loan Officer",
Fields!LONbr.Value)
> so if I only wanted the above textbox to navigate to a subreport if it
returned LONbr as the source, what expression would I put in the "Jump to
Report" advanced property?

Linking Datasets

How can you link two datasets on a report that come from different databases.
I tried to create a queried parameter that pulls its value from a dataset1
field and use in the where clause of my dataset2 query. It gets an error
message indicating you cannot have a forward looking parameter. Any help for
this newbie is greatly appreciated.You should look at using subreports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rdavis104" <rdavis104@.discussions.microsoft.com> wrote in message
news:5F433F07-C1A9-4B7F-8689-890A5476D8C1@.microsoft.com...
> How can you link two datasets on a report that come from different
> databases.
> I tried to create a queried parameter that pulls its value from a dataset1
> field and use in the where clause of my dataset2 query. It gets an error
> message indicating you cannot have a forward looking parameter. Any help
> for
> this newbie is greatly appreciated.|||Subreports worked great, very easy to setup.
Thanks
"Bruce L-C [MVP]" wrote:
> You should look at using subreports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "rdavis104" <rdavis104@.discussions.microsoft.com> wrote in message
> news:5F433F07-C1A9-4B7F-8689-890A5476D8C1@.microsoft.com...
> > How can you link two datasets on a report that come from different
> > databases.
> > I tried to create a queried parameter that pulls its value from a dataset1
> > field and use in the where clause of my dataset2 query. It gets an error
> > message indicating you cannot have a forward looking parameter. Any help
> > for
> > this newbie is greatly appreciated.
>
>|||I ran across another snag. When I export the main report (with subreports)
to Excel the cells that should contain the subreport data have "Subreports
within table/matrix cells are ignored" as a value. Not sure if I missed
something or if I am doing something wrong. This report will need to output
to Excel format. Thanks in advance for the help.
"rdavis104" wrote:
> Subreports worked great, very easy to setup.
> Thanks
> "Bruce L-C [MVP]" wrote:
> > You should look at using subreports.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "rdavis104" <rdavis104@.discussions.microsoft.com> wrote in message
> > news:5F433F07-C1A9-4B7F-8689-890A5476D8C1@.microsoft.com...
> > > How can you link two datasets on a report that come from different
> > > databases.
> > > I tried to create a queried parameter that pulls its value from a dataset1
> > > field and use in the where clause of my dataset2 query. It gets an error
> > > message indicating you cannot have a forward looking parameter. Any help
> > > for
> > > this newbie is greatly appreciated.
> >
> >
> >sql

Linking and sorting multiple datasets in a single report

Hi,
I have got a report which uses two different datasets that combined
give me the required output. I am now required to combine the two
datasets into a single data region and sequence it appropriately. Is
there an easy way to do this within reporting services?
The sources of the datasets are stored proc's with about 3000 lines of
code in each. I could combine the two to give me the desired sequenced
results but this will require a lot of work and testing to ensure
everything still works correctly. Surely there must be an easy way to
achieve this without having to resort to this.
Thanks in advance.
VaughanFor a 1:1 or a 1:M you should use subreports. Subreports are really the only
way to tie two datasets together.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vorno" <vaughank@.hotmail.com> wrote in message
news:1166404556.499638.139780@.n67g2000cwd.googlegroups.com...
> Hi,
> I have got a report which uses two different datasets that combined
> give me the required output. I am now required to combine the two
> datasets into a single data region and sequence it appropriately. Is
> there an easy way to do this within reporting services?
> The sources of the datasets are stored proc's with about 3000 lines of
> code in each. I could combine the two to give me the desired sequenced
> results but this will require a lot of work and testing to ensure
> everything still works correctly. Surely there must be an easy way to
> achieve this without having to resort to this.
> Thanks in advance.
> Vaughan
>|||Thanks Bruce, I'll give it a try. Cheers
Bruce L-C [MVP] wrote:
> For a 1:1 or a 1:M you should use subreports. Subreports are really the only
> way to tie two datasets together.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Vorno" <vaughank@.hotmail.com> wrote in message
> news:1166404556.499638.139780@.n67g2000cwd.googlegroups.com...
> > Hi,
> >
> > I have got a report which uses two different datasets that combined
> > give me the required output. I am now required to combine the two
> > datasets into a single data region and sequence it appropriately. Is
> > there an easy way to do this within reporting services?
> >
> > The sources of the datasets are stored proc's with about 3000 lines of
> > code in each. I could combine the two to give me the desired sequenced
> > results but this will require a lot of work and testing to ensure
> > everything still works correctly. Surely there must be an easy way to
> > achieve this without having to resort to this.
> >
> > Thanks in advance.
> >
> > Vaughan
> >

Linking Access(urgent)

Dear all
I've a problem when I make a command button in Access's Form which open form or report the message that "error encountered with OLE ActiveX?"
Can any body help me to fix this ?
PLZ Help me urgentCould you give the exact error message, # etc. That would help.

Linking a report to a dataset

I copy a report by viewing the code and pasting into a new report. The
problem is that the fields do not display for expressions etc. It gives the
following error "report item not linked to a dataset". How do I link the
report to a dataset so I can see the list of available dataset fields?
ThanksCopy and paste the report instead. Right mouse click on report, copy. Right
mouse click on project (not report folder) and paste. Then rename to
whatever you want. That gets the whole report including the dataset.
Not very discoverable. I would expect to be able to paste into the reports
folder.
Bruce L-C
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:%23p5b5pcmEHA.952@.TK2MSFTNGP14.phx.gbl...
> I copy a report by viewing the code and pasting into a new report. The
> problem is that the fields do not display for expressions etc. It gives
the
> following error "report item not linked to a dataset". How do I link the
> report to a dataset so I can see the list of available dataset fields?
> Thanks
>|||Is there anyway to link the report to a dataset if I did it the other way?
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OXYb8HdmEHA.1672@.TK2MSFTNGP14.phx.gbl...
> Copy and paste the report instead. Right mouse click on report, copy.
> Right
> mouse click on project (not report folder) and paste. Then rename to
> whatever you want. That gets the whole report including the dataset.
> Not very discoverable. I would expect to be able to paste into the reports
> folder.
> Bruce L-C
> "Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
> news:%23p5b5pcmEHA.952@.TK2MSFTNGP14.phx.gbl...
>> I copy a report by viewing the code and pasting into a new report. The
>> problem is that the fields do not display for expressions etc. It gives
> the
>> following error "report item not linked to a dataset". How do I link the
>> report to a dataset so I can see the list of available dataset fields?
>> Thanks
>>
>|||Yes, create a dataset (I have to do this anytime I use the wizard because I
don't like the name the wizard gives and I change the name of the dataset).
Then click on the table/matrix, whatever the dataset is bound to,
properties, datasetname.
Bruce L-C
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:ebmM3HmmEHA.392@.tk2msftngp13.phx.gbl...
> Is there anyway to link the report to a dataset if I did it the other way?
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OXYb8HdmEHA.1672@.TK2MSFTNGP14.phx.gbl...
> > Copy and paste the report instead. Right mouse click on report, copy.
> > Right
> > mouse click on project (not report folder) and paste. Then rename to
> > whatever you want. That gets the whole report including the dataset.
> >
> > Not very discoverable. I would expect to be able to paste into the
reports
> > folder.
> >
> > Bruce L-C
> >
> > "Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
> > news:%23p5b5pcmEHA.952@.TK2MSFTNGP14.phx.gbl...
> >> I copy a report by viewing the code and pasting into a new report. The
> >> problem is that the fields do not display for expressions etc. It gives
> > the
> >> following error "report item not linked to a dataset". How do I link
the
> >> report to a dataset so I can see the list of available dataset fields?
> >>
> >> Thanks
> >>
> >>
> >
> >
>

Linking a number with a month name

Hi,
I have a table with a field called Period whcih has numbers from 1 - 12. Now
I want to say that if the value of the field is 1 , then the report should
display january, if its 2 , Feburary and so on... Is there a way this can be
done without having to create a table ?
--
pmudYou can change your query to add column for month name
Oracle =Monthname(Extract Month from tempdate)
SQL server=DayPart("m",tempdate)
hope it helps.
"pmud" wrote:
> Hi,
> I have a table with a field called Period whcih has numbers from 1 - 12. Now
> I want to say that if the value of the field is 1 , then the report should
> display january, if its 2 , Feburary and so on... Is there a way this can be
> done without having to create a table ?
> --
> pmud|||Go to the Code tab of the Reports Properties dialog and add the following:
function MonthValue(byval MonthInt as integer) as string
select case MonthInt
case 1
return "Jan"
case 2
return "Feb"
'...
case else
return "Bad Month"
End select
end function
Then in the text box where you want the month to display place this
expression:
=Code.MonthValue( Fields!Period.Value)
You can read more about adding code by searching the help for 'Writing
Custom Code'
"pmud" wrote:
> Hi,
> I have a table with a field called Period whcih has numbers from 1 - 12. Now
> I want to say that if the value of the field is 1 , then the report should
> display january, if its 2 , Feburary and so on... Is there a way this can be
> done without having to create a table ?
> --
> pmud|||Hi Harolds,
That was very helpful.
Thanks
--
pmud
"Harolds" wrote:
> Go to the Code tab of the Reports Properties dialog and add the following:
> function MonthValue(byval MonthInt as integer) as string
> select case MonthInt
> case 1
> return "Jan"
> case 2
> return "Feb"
> '...
> case else
> return "Bad Month"
> End select
> end function
> Then in the text box where you want the month to display place this
> expression:
> =Code.MonthValue( Fields!Period.Value)
> You can read more about adding code by searching the help for 'Writing
> Custom Code'
> "pmud" wrote:
> > Hi,
> >
> > I have a table with a field called Period whcih has numbers from 1 - 12. Now
> > I want to say that if the value of the field is 1 , then the report should
> > display january, if its 2 , Feburary and so on... Is there a way this can be
> > done without having to create a table ?
> > --
> > pmud|||Thanks Guys, this helped me out as well
"pmud" wrote:
> Hi Harolds,
> That was very helpful.
> Thanks
> --
> pmud
>
> "Harolds" wrote:
> > Go to the Code tab of the Reports Properties dialog and add the following:
> >
> > function MonthValue(byval MonthInt as integer) as string
> > select case MonthInt
> > case 1
> > return "Jan"
> > case 2
> > return "Feb"
> > '...
> > case else
> > return "Bad Month"
> > End select
> > end function
> >
> > Then in the text box where you want the month to display place this
> > expression:
> >
> > =Code.MonthValue( Fields!Period.Value)
> >
> > You can read more about adding code by searching the help for 'Writing
> > Custom Code'
> >
> > "pmud" wrote:
> >
> > > Hi,
> > >
> > > I have a table with a field called Period whcih has numbers from 1 - 12. Now
> > > I want to say that if the value of the field is 1 , then the report should
> > > display january, if its 2 , Feburary and so on... Is there a way this can be
> > > done without having to create a table ?
> > > --
> > > pmud|||There is an easier way in the cell itself. There is a VB.net function
MonthName(), so
=MonthName(Month(Fields!MyDate.Value), True)
will give "Jan", "Feb" etc. Change the True to False and you'll get
full month names. I also think it is language aware, so will return the
month in the language the client system is set to.
--
Regards
Chris
Stephen L wrote:
> Thanks Guys, this helped me out as well
> "pmud" wrote:
> > Hi Harolds,
> >
> > That was very helpful.
> >
> > Thanks
> > --
> > pmud
> >
> >
> > "Harolds" wrote:
> >
> > > Go to the Code tab of the Reports Properties dialog and add the
> > > following:
> > >
> > > function MonthValue(byval MonthInt as integer) as string
> > > select case MonthInt
> > > case 1
> > > return "Jan"
> > > case 2
> > > return "Feb"
> > > '...
> > > case else
> > > return "Bad Month"
> > > End select
> > > end function
> > >
> > > Then in the text box where you want the month to display place
> > > this expression:
> > >
> > > =Code.MonthValue( Fields!Period.Value)
> > >
> > > You can read more about adding code by searching the help for
> > > 'Writing Custom Code'
> > >
> > > "pmud" wrote:
> > >
> > > > Hi,
> > > >
> > > > I have a table with a field called Period whcih has numbers
> > > > from 1 - 12. Now I want to say that if the value of the field
> > > > is 1 , then the report should display january, if its 2 ,
> > > > Feburary and so on... Is there a way this can be done without
> > > > having to create a table ?
> > > > --
> > > > pmud