I have a report that has images etc. (company logo) at the top which works
fine when rendering to pdf. However I'd like to elimiate this stuff when
rendering to xls. Is that possible?
Thanks.
--CoryTry CSV ASCII instead. Much faster and it will do what you want.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Cory" <Cory@.discussions.microsoft.com> wrote in message
news:3CA7586B-D025-4561-9D32-6BD9A63303C3@.microsoft.com...
>I have a report that has images etc. (company logo) at the top which works
> fine when rendering to pdf. However I'd like to elimiate this stuff when
> rendering to xls. Is that possible?
> Thanks.
> --Cory
Showing posts with label header. Show all posts
Showing posts with label header. Show all posts
Friday, February 24, 2012
Sunday, February 19, 2012
Excel to SQL 2000
I have an excel spread sheet that contains a header and three different
sections (delineated by text statements on separate lines between the data).
Header One Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
Header Two Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
Header Three Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
I need to import the data from each section and import it into a different
SQL 2000 file for each section of the excel spreadsheet. I also need to
perform some data manipulation during the import.
I am a beginner so I would appreciate your advice on how to do this as well
as article, samples, links etc. that I might be able to learn from. Thank
you.Hi Mike
Check out sqldts.com for lots of information on how to do things using DTS!
The safest option would be if you can make each section a named range then
they could be imported separately. Another option, if all sections have the
same format would be to import the data into a staging table (with an
identity column) and then split it off from there (although I don't know if
the row order will be guaranteed!!!)
John
"Mike" wrote:
> I have an excel spread sheet that contains a header and three different
> sections (delineated by text statements on separate lines between the data
).
> Header One Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> Header Two Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> Header Three Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> I need to import the data from each section and import it into a different
> SQL 2000 file for each section of the excel spreadsheet. I also need to
> perform some data manipulation during the import.
> I am a beginner so I would appreciate your advice on how to do this as wel
l
> as article, samples, links etc. that I might be able to learn from. Thank
> you.
>
>
sections (delineated by text statements on separate lines between the data).
Header One Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
Header Two Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
Header Three Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
I need to import the data from each section and import it into a different
SQL 2000 file for each section of the excel spreadsheet. I also need to
perform some data manipulation during the import.
I am a beginner so I would appreciate your advice on how to do this as well
as article, samples, links etc. that I might be able to learn from. Thank
you.Hi Mike
Check out sqldts.com for lots of information on how to do things using DTS!
The safest option would be if you can make each section a named range then
they could be imported separately. Another option, if all sections have the
same format would be to import the data into a staging table (with an
identity column) and then split it off from there (although I don't know if
the row order will be guaranteed!!!)
John
"Mike" wrote:
> I have an excel spread sheet that contains a header and three different
> sections (delineated by text statements on separate lines between the data
).
> Header One Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> Header Two Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> Header Three Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> I need to import the data from each section and import it into a different
> SQL 2000 file for each section of the excel spreadsheet. I also need to
> perform some data manipulation during the import.
> I am a beginner so I would appreciate your advice on how to do this as wel
l
> as article, samples, links etc. that I might be able to learn from. Thank
> you.
>
>
Excel to SQL 2000
I have an excel spread sheet that contains a header and three different
sections (delineated by text statements on separate lines between the data).
Header One Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
Header Two Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
Header Three Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
I need to import the data from each section and import it into a different
SQL 2000 file for each section of the excel spreadsheet. I also need to
perform some data manipulation during the import.
I am a beginner so I would appreciate your advice on how to do this as well
as article, samples, links etc. that I might be able to learn from. Thank
you.Hi Mike
Check out sqldts.com for lots of information on how to do things using DTS!
The safest option would be if you can make each section a named range then
they could be imported separately. Another option, if all sections have the
same format would be to import the data into a staging table (with an
identity column) and then split it off from there (although I don't know if
the row order will be guaranteed!!!)
John
"Mike" wrote:
> I have an excel spread sheet that contains a header and three different
> sections (delineated by text statements on separate lines between the data).
> Header One Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> Header Two Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> Header Three Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> I need to import the data from each section and import it into a different
> SQL 2000 file for each section of the excel spreadsheet. I also need to
> perform some data manipulation during the import.
> I am a beginner so I would appreciate your advice on how to do this as well
> as article, samples, links etc. that I might be able to learn from. Thank
> you.
>
>
sections (delineated by text statements on separate lines between the data).
Header One Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
Header Two Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
Header Three Some Data by Name
$23,598.00 $23,598.00 $23,598.00 $23,598.00
$23,598.00 $23,598.00 $23,598.00 $23,598.00
I need to import the data from each section and import it into a different
SQL 2000 file for each section of the excel spreadsheet. I also need to
perform some data manipulation during the import.
I am a beginner so I would appreciate your advice on how to do this as well
as article, samples, links etc. that I might be able to learn from. Thank
you.Hi Mike
Check out sqldts.com for lots of information on how to do things using DTS!
The safest option would be if you can make each section a named range then
they could be imported separately. Another option, if all sections have the
same format would be to import the data into a staging table (with an
identity column) and then split it off from there (although I don't know if
the row order will be guaranteed!!!)
John
"Mike" wrote:
> I have an excel spread sheet that contains a header and three different
> sections (delineated by text statements on separate lines between the data).
> Header One Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> Header Two Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> Header Three Some Data by Name
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> $23,598.00 $23,598.00 $23,598.00 $23,598.00
> I need to import the data from each section and import it into a different
> SQL 2000 file for each section of the excel spreadsheet. I also need to
> perform some data manipulation during the import.
> I am a beginner so I would appreciate your advice on how to do this as well
> as article, samples, links etc. that I might be able to learn from. Thank
> you.
>
>
Excel Sheet name and Sorting Problem...
Hai,
Is it possible to give another name that "Sheet1" when I export my
report to Excel ?
Also
When i make report header it is not allowing me to sort?
Any solutions/Samples ?
Thanks in advance
Aravind.SNot sure about the Sheet1 name, but when you create a report header, make
sure that the end of the header text box lines up with the end of a text box
in your detail.
Hope that helps!
"aravindsabapathy@.gmail.com" wrote:
> Hai,
> Is it possible to give another name that "Sheet1" when I export my
> report to Excel ?
> Also
> When i make report header it is not allowing me to sort?
> Any solutions/Samples ?
> Thanks in advance
> Aravind.S
>
Is it possible to give another name that "Sheet1" when I export my
report to Excel ?
Also
When i make report header it is not allowing me to sort?
Any solutions/Samples ?
Thanks in advance
Aravind.SNot sure about the Sheet1 name, but when you create a report header, make
sure that the end of the header text box lines up with the end of a text box
in your detail.
Hope that helps!
"aravindsabapathy@.gmail.com" wrote:
> Hai,
> Is it possible to give another name that "Sheet1" when I export my
> report to Excel ?
> Also
> When i make report header it is not allowing me to sort?
> Any solutions/Samples ?
> Thanks in advance
> Aravind.S
>
Friday, February 17, 2012
Excel Render - Print Header on Each Page
Hello Microsoft or Forum Members:
This seems like a simple Microsoft Based Reporting System 101 feature...But I can not find out how to do it (among other things that seem like it should work with Microsoft rendering to Microsoft).
How do I make the SSRS 2005 Header for the Report print on each of the pages in excel once it is rendered from SSRS?
All I want is an answer by MSFT that says "YES" it can be done and how or "No" it is not currently available.
I noticed I am not the only one with this type of simple question:
(see this unanswered post)
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1281464&SiteID=1
Thank You guys!
goodguy1974 wrote:
"No" it is not currently available.
I believe that would be the answer. It seems to me that the Excel export renders only the content of the report, not so much the layout of the page. A page rendered in an internet browser is not quite the same as a page rendered in excel.
|||Thank you...
I wish you had a MSFT after your name so I could tell my boss that Microsoft says it can't be done with this version....
Still hoping...
Thanks Again!
|||How many pages are your reports?
|||
The reports range from 14-200 pages...
excel problem
hi I have an excel sheet with no header row.
so I used DTS package to transfer data to the table,
however, transform data task think my first row is the header column,
as the result, I can never transfer my first row data to the table.
is there a way to do this? maybe I have to use activex?
regardsI'm trying to leave work, but
HDR=Yes;IMEX=1
is something I remember about hte header row.
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AAAA9CB5-206D-4721-B033-09EBD825100F@.microsoft.com...
> hi I have an excel sheet with no header row.
> so I used DTS package to transfer data to the table,
> however, transform data task think my first row is the header column,
> as the result, I can never transfer my first row data to the table.
> is there a way to do this? maybe I have to use activex?
> regards
>|||where do I put this code?
I tried to put the code in activex,
nothing happen. still same problem..
thanks for helping
"sloan" wrote:
> I'm trying to leave work, but
>
> HDR=Yes;IMEX=1
> is something I remember about hte header row.
>
>
>
> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
> news:AAAA9CB5-206D-4721-B033-09EBD825100F@.microsoft.com...
>
>|||Refer this link
http://www.sqldts.com/default.aspx?254
Regards
Sudarshan Selvaraja
"Kevin" wrote:
> where do I put this code?
> I tried to put the code in activex,
> nothing happen. still same problem..
> thanks for helping
>
> "sloan" wrote:
>
so I used DTS package to transfer data to the table,
however, transform data task think my first row is the header column,
as the result, I can never transfer my first row data to the table.
is there a way to do this? maybe I have to use activex?
regardsI'm trying to leave work, but
HDR=Yes;IMEX=1
is something I remember about hte header row.
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AAAA9CB5-206D-4721-B033-09EBD825100F@.microsoft.com...
> hi I have an excel sheet with no header row.
> so I used DTS package to transfer data to the table,
> however, transform data task think my first row is the header column,
> as the result, I can never transfer my first row data to the table.
> is there a way to do this? maybe I have to use activex?
> regards
>|||where do I put this code?
I tried to put the code in activex,
nothing happen. still same problem..
thanks for helping
"sloan" wrote:
> I'm trying to leave work, but
>
> HDR=Yes;IMEX=1
> is something I remember about hte header row.
>
>
>
> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
> news:AAAA9CB5-206D-4721-B033-09EBD825100F@.microsoft.com...
>
>|||Refer this link
http://www.sqldts.com/default.aspx?254
Regards
Sudarshan Selvaraja
"Kevin" wrote:
> where do I put this code?
> I tried to put the code in activex,
> nothing happen. still same problem..
> thanks for helping
>
> "sloan" wrote:
>
Wednesday, February 15, 2012
Excel Margins
Hello
Now with SP2 the page margins works fine. Exists a method to set the Footer
and Header margin in the Excel Rendering Extension?
Thanks...Hello Trace,
Can you pls share how the page margin works for excel. I want to define L/R
margin as 0.2 in but excel takes its default settings for .75 inche. What
setting do we need to make change for making it work on Excel with our page
margin.
Thanks in advance
Jasvinder
"Trace" wrote:
> Hello
> Now with SP2 the page margins works fine. Exists a method to set the Footer
> and Header margin in the Excel Rendering Extension?
> Thanks...|||Hello Jasvinder
I set the Margins with the Properties of the Report, but i set to 0.2cm. In
the Page preview of the Excel document the Margins are set to 0.2.
When i set the Margins to 0.2in then the Page preview display 0.5.
"Jasvinder" wrote:
> Hello Trace,
> Can you pls share how the page margin works for excel. I want to define L/R
> margin as 0.2 in but excel takes its default settings for .75 inche. What
> setting do we need to make change for making it work on Excel with our page
> margin.
> Thanks in advance
> Jasvinder
>
> "Trace" wrote:
> > Hello
> >
> > Now with SP2 the page margins works fine. Exists a method to set the Footer
> > and Header margin in the Excel Rendering Extension?
> >
> > Thanks...
Now with SP2 the page margins works fine. Exists a method to set the Footer
and Header margin in the Excel Rendering Extension?
Thanks...Hello Trace,
Can you pls share how the page margin works for excel. I want to define L/R
margin as 0.2 in but excel takes its default settings for .75 inche. What
setting do we need to make change for making it work on Excel with our page
margin.
Thanks in advance
Jasvinder
"Trace" wrote:
> Hello
> Now with SP2 the page margins works fine. Exists a method to set the Footer
> and Header margin in the Excel Rendering Extension?
> Thanks...|||Hello Jasvinder
I set the Margins with the Properties of the Report, but i set to 0.2cm. In
the Page preview of the Excel document the Margins are set to 0.2.
When i set the Margins to 0.2in then the Page preview display 0.5.
"Jasvinder" wrote:
> Hello Trace,
> Can you pls share how the page margin works for excel. I want to define L/R
> margin as 0.2 in but excel takes its default settings for .75 inche. What
> setting do we need to make change for making it work on Excel with our page
> margin.
> Thanks in advance
> Jasvinder
>
> "Trace" wrote:
> > Hello
> >
> > Now with SP2 the page margins works fine. Exists a method to set the Footer
> > and Header margin in the Excel Rendering Extension?
> >
> > Thanks...
Excel headers - using SimplePageHeaders deviceinfo setting
I want to try out placing the report header in the Excel page header instead of the worksheet. I have seen forum references to updating the config files to switch on SimplePageHeaders deviceinfo setting, but I can find no reference to this in the documentation and it appears to be ignored when I try it out. Is this in RS 2005 only? (I'm using 2000 SP2).
Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.
I am pretty sure this is new in 2005. and yes, it would help you get past your merged cell problem.Excel headers - using SimplePageHeaders deviceinfo setting
I want to try out placing the report header in the Excel page header instead of the worksheet. I have seen forum references to updating the config files to switch on SimplePageHeaders deviceinfo setting, but I can find no reference to this in the documentation and it appears to be ignored when I try it out. Is this in RS 2005 only? (I'm using 2000 SP2).
Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.
I am pretty sure this is new in 2005. and yes, it would help you get past your merged cell problem.
Subscribe to:
Posts (Atom)