change the sheet name while exporting sql data to excel

i have designed a rdl form which contains 3 tables .. i gave page break for each table. when exporting the file to excel it generates 3 sheets .. three sheets name comes like sheet 1, sheet2 ,sheet3.. i dont want it to be like these.. instead of that i have to give my own name while generating reports from rdl form like this (s1,s2,s3)...

it is not possible to change the sheet name but have a label (Label property) for each table and that will give you document map in the excel sheet.

Shyam

|||

T hank you brother...

|||

Hi,

Thank you for the Tip.

Another question in the Document Map it creates an entry for the report Name and adds all the labels for that report.

Is it possible to change the report name in the document map without chainging it for the file?

Thank you,

Paul

Just found That http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=207848&SiteID=17

change the sheet name while exporting sql data to excel

i have designed a rdl form which contains 3 tables .. i gave page break for each table. when exporting the file to excel it generates 3 sheets .. three sheets name comes like sheet 1, sheet2 ,sheet3.. i dont want it to be like these.. instead of that i have to give my own name while generating reports from rdl form like this (s1,s2,s3)...

Sorry, but this isn't supported yet.

Jarret

change the sheet name while exporting sql data to excel

i have designed a rdl form which contains 3 tables .. i gave page break for each table. when exporting the file to excel it generates 3 sheets .. three sheets name comes like sheet 1, sheet2 ,sheet3.. i dont want it to be like these.. instead of that i have to give my own name while generating reports from rdl form like this (s1,s2,s3)...

it is not possible to change the sheet name but have a label (Label property) for each table and that will give you document map in the excel sheet.

Shyam

|||

T hank you brother...

|||

Hi,

Thank you for the Tip.

Another question in the Document Map it creates an entry for the report Name and adds all the labels for that report.

Is it possible to change the report name in the document map without chainging it for the file?

Thank you,

Paul

Just found That http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=207848&SiteID=17

Change the Parameter in an query

I have a report "Clearance Summary Report:
Each page summarized the total sales for one agency.
Everything works great except for one total "Adjustments:"
An agency can have one order but have 50 adjustments to that order.
That is why the Adjustments can not be included in the "dsReport" query.
For that reason the Adjustments number is calculate with its own query
(dsAdjustments). but gets two parameters ClearanceID and MagazineID.
NOW the problem.
The help file says to create two parameters. ClearanceID and MagazineID.
Declear them internal.
Link them to the fields: ClearanceID and MagazineID.
Then the dsAdjustments query can refreance the paramters ClearanceID and
MagazineID.
When the report is run the dsAjustments query gets it value from the
parameters ClearanceID and MagazineID and then returns a number. That is how
I get the adjusments.
This works if I lookup only one Agency. But if there are two or more
agencies in the report the parameters ClearanceID and MagazineID are only
fill in at the begining of the report. All the other Agencies reports ty to
use the first agency adjustmets numbers.
Question: How do I get the parameters ClearanceID and MagzineID to update
for every new Agency''
Thank you
Scott BurkeRead up on subreports. Subreports are exactly for this sort of this.
Master-detail type reports pretty much must be done using subreports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott Burke" <ScottBurke@.discussions.microsoft.com> wrote in message
news:A7930198-0781-4DB7-A25E-9EDFBE434C6A@.microsoft.com...
>I have a report "Clearance Summary Report:
> Each page summarized the total sales for one agency.
> Everything works great except for one total "Adjustments:"
> An agency can have one order but have 50 adjustments to that order.
> That is why the Adjustments can not be included in the "dsReport" query.
> For that reason the Adjustments number is calculate with its own query
> (dsAdjustments). but gets two parameters ClearanceID and MagazineID.
> NOW the problem.
> The help file says to create two parameters. ClearanceID and MagazineID.
> Declear them internal.
> Link them to the fields: ClearanceID and MagazineID.
> Then the dsAdjustments query can refreance the paramters ClearanceID and
> MagazineID.
> When the report is run the dsAjustments query gets it value from the
> parameters ClearanceID and MagazineID and then returns a number. That is
> how
> I get the adjusments.
> This works if I lookup only one Agency. But if there are two or more
> agencies in the report the parameters ClearanceID and MagazineID are only
> fill in at the begining of the report. All the other Agencies reports ty
> to
> use the first agency adjustmets numbers.
> Question: How do I get the parameters ClearanceID and MagzineID to update
> for every new Agency''
> Thank you
> Scott Burke
>|||Hi Bruce, This report org used a subreport to produce the totals. HOWEVER;
For some reason unknow to everyone I talked to the Report server tends to
lose/ can't find the subreport!!!!!
The last time it happed I had to redeploy the main report. That did not
work this time.
We only had the report server for four months! I dont look forward to
redeploying the CommisionSummaryReport every two months!
my solution is to replace the subreport. Besides running faster the only
problem I am having is getting the right values to the dsAdjustment query.
My only problem is getting the right ClearanceID and MagazineID value to the
query.
Is it possible to load a value into the parameters?
I am trying this in the textbox:
=Parameters!MagazineID.Value = Fields!MagazineID.Value
=(Fields!Adjustment.Value, "dsAdjustment")
The problem here is that "=Parameters!MagazineID.Value =Fields!MagazineID.Value" is being treaded like a comparason. The textbox
displays "True" or "False".
Any Ideals?
Scott Burke
"Bruce L-C [MVP]" wrote:
> Read up on subreports. Subreports are exactly for this sort of this.
> Master-detail type reports pretty much must be done using subreports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Scott Burke" <ScottBurke@.discussions.microsoft.com> wrote in message
> news:A7930198-0781-4DB7-A25E-9EDFBE434C6A@.microsoft.com...
> >I have a report "Clearance Summary Report:
> > Each page summarized the total sales for one agency.
> >
> > Everything works great except for one total "Adjustments:"
> >
> > An agency can have one order but have 50 adjustments to that order.
> > That is why the Adjustments can not be included in the "dsReport" query.
> >
> > For that reason the Adjustments number is calculate with its own query
> > (dsAdjustments). but gets two parameters ClearanceID and MagazineID.
> >
> > NOW the problem.
> > The help file says to create two parameters. ClearanceID and MagazineID.
> > Declear them internal.
> > Link them to the fields: ClearanceID and MagazineID.
> > Then the dsAdjustments query can refreance the paramters ClearanceID and
> > MagazineID.
> >
> > When the report is run the dsAjustments query gets it value from the
> > parameters ClearanceID and MagazineID and then returns a number. That is
> > how
> > I get the adjusments.
> >
> > This works if I lookup only one Agency. But if there are two or more
> > agencies in the report the parameters ClearanceID and MagazineID are only
> > fill in at the begining of the report. All the other Agencies reports ty
> > to
> > use the first agency adjustmets numbers.
> >
> > Question: How do I get the parameters ClearanceID and MagzineID to update
> > for every new Agency''
> >
> > Thank you
> > Scott Burke
> >
>
>|||Don't know why you are losing subreports. I have lots and lots and lots of
subreports. Not only have I never seen this but I have not seen any posting
about losing subreports. Makes me wonder what is unusual about your
environment.
Read up on drill-down (not drill through). Basically you have a single query
that contains all your information. The master information is repeated for
every row. Then you design your report to drill-down (click on a + sign to
see more) OR if you don't want to use drill down UI then you just hide the
master information when it is in the above row.
What you are trying to do will not work.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott Burke" <ScottBurke@.discussions.microsoft.com> wrote in message
news:D302FB3A-8351-4C5E-AD1E-0011FCFC6634@.microsoft.com...
> Hi Bruce, This report org used a subreport to produce the totals.
> HOWEVER;
> For some reason unknow to everyone I talked to the Report server tends to
> lose/ can't find the subreport!!!!!
> The last time it happed I had to redeploy the main report. That did not
> work this time.
> We only had the report server for four months! I dont look forward to
> redeploying the CommisionSummaryReport every two months!
> my solution is to replace the subreport. Besides running faster the only
> problem I am having is getting the right values to the dsAdjustment query.
> My only problem is getting the right ClearanceID and MagazineID value to
> the
> query.
> Is it possible to load a value into the parameters?
> I am trying this in the textbox:
> =Parameters!MagazineID.Value = Fields!MagazineID.Value
> =(Fields!Adjustment.Value, "dsAdjustment")
>
> The problem here is that "=Parameters!MagazineID.Value => Fields!MagazineID.Value" is being treaded like a comparason. The textbox
> displays "True" or "False".
> Any Ideals?
> Scott Burke
>
>
> "Bruce L-C [MVP]" wrote:
>> Read up on subreports. Subreports are exactly for this sort of this.
>> Master-detail type reports pretty much must be done using subreports.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Scott Burke" <ScottBurke@.discussions.microsoft.com> wrote in message
>> news:A7930198-0781-4DB7-A25E-9EDFBE434C6A@.microsoft.com...
>> >I have a report "Clearance Summary Report:
>> > Each page summarized the total sales for one agency.
>> >
>> > Everything works great except for one total "Adjustments:"
>> >
>> > An agency can have one order but have 50 adjustments to that order.
>> > That is why the Adjustments can not be included in the "dsReport"
>> > query.
>> >
>> > For that reason the Adjustments number is calculate with its own query
>> > (dsAdjustments). but gets two parameters ClearanceID and MagazineID.
>> >
>> > NOW the problem.
>> > The help file says to create two parameters. ClearanceID and
>> > MagazineID.
>> > Declear them internal.
>> > Link them to the fields: ClearanceID and MagazineID.
>> > Then the dsAdjustments query can refreance the paramters ClearanceID
>> > and
>> > MagazineID.
>> >
>> > When the report is run the dsAjustments query gets it value from the
>> > parameters ClearanceID and MagazineID and then returns a number. That
>> > is
>> > how
>> > I get the adjusments.
>> >
>> > This works if I lookup only one Agency. But if there are two or more
>> > agencies in the report the parameters ClearanceID and MagazineID are
>> > only
>> > fill in at the begining of the report. All the other Agencies reports
>> > ty
>> > to
>> > use the first agency adjustmets numbers.
>> >
>> > Question: How do I get the parameters ClearanceID and MagzineID to
>> > update
>> > for every new Agency''
>> >
>> > Thank you
>> > Scott Burke
>> >
>>

change the default navigation bar

Is it possible to change the default navigation bar that appears in
Reporting Services?
The Navigation bar that allows, page movement, viewing size, Export
etc.Sorry for the double posting..... :-(

Change the default navigation bar

Is it possible to change the default navigation bar that appears in
Reporting Services?
The Navigation bar that allows, page movement, viewing size, Export
etc.&rc:Toolbar=false in the url, removes it
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1112798064.597189.163980@.z14g2000cwz.googlegroups.com...
> Is it possible to change the default navigation bar that appears in
> Reporting Services?
> The Navigation bar that allows, page movement, viewing size, Export
> etc.
>|||Thanks for the tip, but I need to create my own now, any ideas?|||I don't think there's a way. There could be a way to change the colors and
fonts, but I don't think you can change the structure.
And it's all messed up for firefox, or netscape. I check the browser before
I call the reports, and turn the toolbar off, if it's not IE.
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1112871211.962325.310910@.l41g2000cwc.googlegroups.com...
> Thanks for the tip, but I need to create my own now, any ideas?
>|||"Cindy Lee" wrote:
> &rc:Toolbar=false in the url, removes it
hmm... that doesn't seem to work for me. my url reads:
http://MyServer/Reports/Pages/Report.aspx?ItemPath=%2fMy+Report&rc:Toolbar=False&rc:Parameters=false
but both the toolbar and the parameters pane show up just the same... what
am I doing wrong? also, how can I specify that the toolbar not be displayed
after the user presses the "View Report" button (since I obviously don't have
control over the URL at that point)?|||but I just want to remove the navigation bar, and keep the parameters bar ...
the URL:
..?&rc:toolbar=false&rc:parameters=true
doesnt work ...
How do it ?...
"Cindy Lee" wrote:
> &rc:Toolbar=false in the url, removes it
> "Bryan Avery" <b_avery@.yahoo.com> wrote in message
> news:1112798064.597189.163980@.z14g2000cwz.googlegroups.com...
> > Is it possible to change the default navigation bar that appears in
> > Reporting Services?
> >
> > The Navigation bar that allows, page movement, viewing size, Export
> > etc.
> >
>
>

Change query of report in reportviewer

Hi,

I have a reporting services report that i show in an asp.net page by a reportviewer control.

Is there a property that i can set in my asp.net page, to change the query for changing the data in my report.

The number and names of the columns will be the same.

I should work with parameters, but the query changes more than just a few where-clauses. So i think working with parameters looks impossible.

Thanks,

Dennis

Hi,

using parameters is the only way to accomplish it. You can use a stored procedure in conjunction with a parameter which decicde within your stored procedue code which query to execute.

Jens K. Suessmeyer.

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

Excuse me

How Can I do a clr routine with a call to crystal report?

Thanks

Change query of report in reportviewer

Hi,

I have a reporting services report that i show in an asp.net page by a reportviewer control.

Is there a property that i can set in my asp.net page, to change the query for changing the data in my report.

The number and names of the columns will be the same.

I should work with parameters, but the query changes more than just a few where-clauses. So i think working with parameters looks impossible.

Thanks,

Dennis

Hi,

using parameters is the only way to accomplish it. You can use a stored procedure in conjunction with a parameter which decicde within your stored procedue code which query to execute.

Jens K. Suessmeyer.

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

Excuse me

How Can I do a clr routine with a call to crystal report?

Thanks

Change page title from "Report Viewer/Manager" to the actual report name?

Can a person change the page title from "Report Viewer/Manager" to the actual report name?

Yes, but it is not quite as simple as you would probably think it would be.

You will need to use Visual Studio to create a windows application or web application and set the page title there.

|||Yea, that's a possibility, but not do-able for 50 separate reports :/
Maybe there's some hack to set the page name that's shown by default?|||Actually it is possible for 50 separate reports using Visual Studio. You create links to the reports and each "report page" that is linked to has its own title.

change Page Header Size

Hi,
Is there any way to have different Sizes of Page Header in different pages
PonnurangamNo. There is only one page header per report.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
news:eXsFsEWpEHA.3688@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any way to have different Sizes of Page Header in different pages
> Ponnurangam
>