Hi,
I have 4 subreports in a report and adjust thier position well on layout
tag.
Preview on the report designer everything is fine.
But deploy to report server and browse on IE the subreports all on the wrong
position!
How can I resolve this problem?
Thanks for help!
AngiI had the same problem with some of my reports I found out the only way
ot get the layout right is to enter the location for each item on the
report in the location property and " measure/space" so nothing is over
laping. One can begin where one ends but if they overlap the location
it will be moved to onther page. It still looks a little funny on the
browser but it prints perfectly.sql
Showing posts with label layout. Show all posts
Showing posts with label layout. Show all posts
Friday, March 30, 2012
Layout problem
Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comIf you click on the header in the designer and then look at the properties
there is a property that is PrintOnFirstPage. This defaults to True, I think
if you set this to False the report will behave the way you want.
Stuart
"roy mm" wrote:
> Layout problem -
> I've created a report with the wizard and it looks fine.
> It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
> Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
> I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
> Can anybody help me with the title part to make it visible in all pages?
> Thank alot in advance,
> Roy.
>
> From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comIf you click on the header in the designer and then look at the properties
there is a property that is PrintOnFirstPage. This defaults to True, I think
if you set this to False the report will behave the way you want.
Stuart
"roy mm" wrote:
> Layout problem -
> I've created a report with the wizard and it looks fine.
> It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
> Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
> I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
> Can anybody help me with the title part to make it visible in all pages?
> Thank alot in advance,
> Roy.
>
> From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>
Layout problem
Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.Are you using a true page header or just a couple of test fields at the top of the page. Click the Report menu and see if you have a Page Header selected.
layout problem
hi all,
i got a table which shows me the number of transfers of a store on everyday day together with the summed amount the store gained. my table looks like this:
store day transfers amount
1 1 1 2.50
1 2 5 3.50
2 1 2 1
and i want to put it in a report like this
store monday tuesday
1 1 / 2.50 5 / 3.50
2 2 / 1
i tried with a matrix but the the result wasnt satisifiying. the best one looked like this:
store monday tuesday
1 1 / 2.50
1 5 / 3.50
2 2 / 1
anyone can give a solution or atleast some hints?
drop store to the row group and day to the column group should satisfy your need.Layout problem
Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.
Firstly, there is no way to specify that an item should appear on all pages.
However, you do have a few options:
Can you change the textbox contents so it doesn't refrence a field but a parameter instead?|||Hi.
1) the first solution is no good since i can't (I'm getting one value as parameter and need to get his match value from the db)
2) I didn't quit get that part, can you please explain me again?
3) ok, this look like a solution, but it realy not that nice.
To make the header look like he is now i'll need a table with only header for my first header line and another tabke with just a header a 5 cells for each value i want to show.
meanwhile it look like the only solution i have.
I wrote to myself your comment about the display in the exporting! Its importent.
Thank,
Roy.|||
A list control allows you to define grouping in your data. It also has the option of adding a page break before/after each group. For export to Excel this forces each group onto a separate tab.
If you drop a table or matrix into a list control then you can control how the data is groupped and hence paged by setting the attibutes of the list control.
So as an example imagine I have a query with 5 fields (or dimensions) country, sales person, month, product and sales amount. My target audience aim to export to Excel. I can configure the report so that in excel it will end up having a tab per country, on each tab have a grid per sales person and in the grid have month and product on the rows and columns. This can be achieved using a matrix nested inside 2 list controls. List 1 groupped by country with a page break, list 2 groupped by sales person with no page break and the other 2 fileds in the matrix.
The point is, you can then include textboxes within the lists and they will repeat in a similar fassion.
Once again, paging in the web will potentially break certain pages up further if they are too long. 400 pages in the web doesn't mean there will be 400 tabs in Excel.
|||Thanks heaps ! this post did help me with finding a solution for another problem of exporting data to multiple worksheets in Excel.
Nadeem
Layout problem
Layout problem -
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
I've created a report with the wizard and it looks fine.
It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table.
Whan I run ut it look fine (In the first page there is the header and underneath there is the table) but I've noticed that whan the report have more then one page, all of my header (e.g. TITLE,SUBTITLE,BUTTON) is not showen in the second page and above and only the table is.
I've tried to move the title to the header part but it give me an error the the value of the textbox in the header refers to a field and field can't be use in a page header.
Can anybody help me with the title part to make it visible in all pages?
Thank alot in advance,
Roy.
Firstly, there is no way to specify that an item should appear on all pages.
However, you do have a few options:
Can you change the textbox contents so it doesn't refrence a field but a parameter instead?|||Hi.
1) the first solution is no good since i can't (I'm getting one value as parameter and need to get his match value from the db)
2) I didn't quit get that part, can you please explain me again?
3) ok, this look like a solution, but it realy not that nice.
To make the header look like he is now i'll need a table with only header for my first header line and another tabke with just a header a 5 cells for each value i want to show.
meanwhile it look like the only solution i have.
I wrote to myself your comment about the display in the exporting! Its importent.
Thank,
Roy.|||
A list control allows you to define grouping in your data. It also has the option of adding a page break before/after each group. For export to Excel this forces each group onto a separate tab.
If you drop a table or matrix into a list control then you can control how the data is groupped and hence paged by setting the attibutes of the list control.
So as an example imagine I have a query with 5 fields (or dimensions) country, sales person, month, product and sales amount. My target audience aim to export to Excel. I can configure the report so that in excel it will end up having a tab per country, on each tab have a grid per sales person and in the grid have month and product on the rows and columns. This can be achieved using a matrix nested inside 2 list controls. List 1 groupped by country with a page break, list 2 groupped by sales person with no page break and the other 2 fileds in the matrix.
The point is, you can then include textboxes within the lists and they will repeat in a similar fassion.
Once again, paging in the web will potentially break certain pages up further if they are too long. 400 pages in the web doesn't mean there will be 400 tabs in Excel.
|||Thanks heaps ! this post did help me with finding a solution for another problem of exporting data to multiple worksheets in Excel.
Nadeem
sqlLayout of report parameters
Hi all
Is there any way to change the way the report parameters are displayed?
Presently they are just in a tabular format. I am after displaying them as follows:
- - -
__
- -
The horizontal line is there to group the parameters. Is that possible?
Thanks heaps
This is not natively supported. You would need to construct your own prompting area.
Layout margins in cm
Some how layout margins are appearing in cm on report design layout.
I would like them to be setup in inches.
Layout margins come up as inches on other developers machines.
How can I set it up so that I get margins as inches and not cm.
Please help.
TIA..Hi sqlster,
You should be able to simply type in 0.5in for a margin.
Is your language set to "English (United States) in the report properties?
IT may be defaulting to metric based on that, but in any case, you should be
able to type "in" after your numbers and it should be in inches.
I hope that helps!
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> Some how layout margins are appearing in cm on report design layout.
> I would like them to be setup in inches.
> Layout margins come up as inches on other developers machines.
> How can I set it up so that I get margins as inches and not cm.
> Please help.
> TIA..|||Hi sqlster,
You should be able to simply type in 0.5in for a margin.
Is your language set to "English (United States) in the report properties?
IT may be defaulting to metric based on that, but in any case, you should be
able to type "in" after your numbers and it should be in inches.
I hope that helps!
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> Some how layout margins are appearing in cm on report design layout.
> I would like them to be setup in inches.
> Layout margins come up as inches on other developers machines.
> How can I set it up so that I get margins as inches and not cm.
> Please help.
> TIA..|||I tried typing inches. But it reverts back to inches after I save, close and
reopen the report.
"Chris Hastings" wrote:
> Hi sqlster,
> You should be able to simply type in 0.5in for a margin.
> Is your language set to "English (United States) in the report properties?
> IT may be defaulting to metric based on that, but in any case, you should be
> able to type "in" after your numbers and it should be in inches.
> I hope that helps!
> Chris
> "sqlster" <nospam@.nospam.com> wrote in message
> news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> > Some how layout margins are appearing in cm on report design layout.
> >
> > I would like them to be setup in inches.
> >
> > Layout margins come up as inches on other developers machines.
> >
> > How can I set it up so that I get margins as inches and not cm.
> >
> > Please help.
> >
> > TIA..
>
>|||I meant to say that even if I type inches, it reverts back to cm after I save
and close the report.
TIA...
"sqlster" wrote:
> I tried typing inches. But it reverts back to inches after I save, close and
> reopen the report.
> "Chris Hastings" wrote:
> > Hi sqlster,
> > You should be able to simply type in 0.5in for a margin.
> > Is your language set to "English (United States) in the report properties?
> > IT may be defaulting to metric based on that, but in any case, you should be
> > able to type "in" after your numbers and it should be in inches.
> > I hope that helps!
> > Chris
> >
> > "sqlster" <nospam@.nospam.com> wrote in message
> > news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> > > Some how layout margins are appearing in cm on report design layout.
> > >
> > > I would like them to be setup in inches.
> > >
> > > Layout margins come up as inches on other developers machines.
> > >
> > > How can I set it up so that I get margins as inches and not cm.
> > >
> > > Please help.
> > >
> > > TIA..
> >
> >
> >
> >|||Hi Tia,
I'm sorry, I haven't got a clue. The only thing I can think of is that your
regional options are set to metric on that computer. Have you checked that?
If you go into control panel, regional and Language Options, then
customize, there is a measurement system at the bottom that should be US and
not Metric.
Other than that, make sure the properties of the report have the right
language selected, and if it still happens, I'm at a loss.
I'm sorry I couldn't be of more help...
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:A7D197C8-6223-43A2-AE7D-46D9C1F9F5F4@.microsoft.com...
>I meant to say that even if I type inches, it reverts back to cm after I
>save
> and close the report.
> TIA...
> "sqlster" wrote:
>> I tried typing inches. But it reverts back to inches after I save, close
>> and
>> reopen the report.
>> "Chris Hastings" wrote:
>> > Hi sqlster,
>> > You should be able to simply type in 0.5in for a margin.
>> > Is your language set to "English (United States) in the report
>> > properties?
>> > IT may be defaulting to metric based on that, but in any case, you
>> > should be
>> > able to type "in" after your numbers and it should be in inches.
>> > I hope that helps!
>> > Chris
>> >
>> > "sqlster" <nospam@.nospam.com> wrote in message
>> > news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
>> > > Some how layout margins are appearing in cm on report design layout.
>> > >
>> > > I would like them to be setup in inches.
>> > >
>> > > Layout margins come up as inches on other developers machines.
>> > >
>> > > How can I set it up so that I get margins as inches and not cm.
>> > >
>> > > Please help.
>> > >
>> > > TIA..
>> >
>> >
>> >
>> >
I would like them to be setup in inches.
Layout margins come up as inches on other developers machines.
How can I set it up so that I get margins as inches and not cm.
Please help.
TIA..Hi sqlster,
You should be able to simply type in 0.5in for a margin.
Is your language set to "English (United States) in the report properties?
IT may be defaulting to metric based on that, but in any case, you should be
able to type "in" after your numbers and it should be in inches.
I hope that helps!
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> Some how layout margins are appearing in cm on report design layout.
> I would like them to be setup in inches.
> Layout margins come up as inches on other developers machines.
> How can I set it up so that I get margins as inches and not cm.
> Please help.
> TIA..|||Hi sqlster,
You should be able to simply type in 0.5in for a margin.
Is your language set to "English (United States) in the report properties?
IT may be defaulting to metric based on that, but in any case, you should be
able to type "in" after your numbers and it should be in inches.
I hope that helps!
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> Some how layout margins are appearing in cm on report design layout.
> I would like them to be setup in inches.
> Layout margins come up as inches on other developers machines.
> How can I set it up so that I get margins as inches and not cm.
> Please help.
> TIA..|||I tried typing inches. But it reverts back to inches after I save, close and
reopen the report.
"Chris Hastings" wrote:
> Hi sqlster,
> You should be able to simply type in 0.5in for a margin.
> Is your language set to "English (United States) in the report properties?
> IT may be defaulting to metric based on that, but in any case, you should be
> able to type "in" after your numbers and it should be in inches.
> I hope that helps!
> Chris
> "sqlster" <nospam@.nospam.com> wrote in message
> news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> > Some how layout margins are appearing in cm on report design layout.
> >
> > I would like them to be setup in inches.
> >
> > Layout margins come up as inches on other developers machines.
> >
> > How can I set it up so that I get margins as inches and not cm.
> >
> > Please help.
> >
> > TIA..
>
>|||I meant to say that even if I type inches, it reverts back to cm after I save
and close the report.
TIA...
"sqlster" wrote:
> I tried typing inches. But it reverts back to inches after I save, close and
> reopen the report.
> "Chris Hastings" wrote:
> > Hi sqlster,
> > You should be able to simply type in 0.5in for a margin.
> > Is your language set to "English (United States) in the report properties?
> > IT may be defaulting to metric based on that, but in any case, you should be
> > able to type "in" after your numbers and it should be in inches.
> > I hope that helps!
> > Chris
> >
> > "sqlster" <nospam@.nospam.com> wrote in message
> > news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
> > > Some how layout margins are appearing in cm on report design layout.
> > >
> > > I would like them to be setup in inches.
> > >
> > > Layout margins come up as inches on other developers machines.
> > >
> > > How can I set it up so that I get margins as inches and not cm.
> > >
> > > Please help.
> > >
> > > TIA..
> >
> >
> >
> >|||Hi Tia,
I'm sorry, I haven't got a clue. The only thing I can think of is that your
regional options are set to metric on that computer. Have you checked that?
If you go into control panel, regional and Language Options, then
customize, there is a measurement system at the bottom that should be US and
not Metric.
Other than that, make sure the properties of the report have the right
language selected, and if it still happens, I'm at a loss.
I'm sorry I couldn't be of more help...
Chris
"sqlster" <nospam@.nospam.com> wrote in message
news:A7D197C8-6223-43A2-AE7D-46D9C1F9F5F4@.microsoft.com...
>I meant to say that even if I type inches, it reverts back to cm after I
>save
> and close the report.
> TIA...
> "sqlster" wrote:
>> I tried typing inches. But it reverts back to inches after I save, close
>> and
>> reopen the report.
>> "Chris Hastings" wrote:
>> > Hi sqlster,
>> > You should be able to simply type in 0.5in for a margin.
>> > Is your language set to "English (United States) in the report
>> > properties?
>> > IT may be defaulting to metric based on that, but in any case, you
>> > should be
>> > able to type "in" after your numbers and it should be in inches.
>> > I hope that helps!
>> > Chris
>> >
>> > "sqlster" <nospam@.nospam.com> wrote in message
>> > news:D00CBBE8-DDF1-4D4E-AA29-90B653F728F4@.microsoft.com...
>> > > Some how layout margins are appearing in cm on report design layout.
>> > >
>> > > I would like them to be setup in inches.
>> > >
>> > > Layout margins come up as inches on other developers machines.
>> > >
>> > > How can I set it up so that I get margins as inches and not cm.
>> > >
>> > > Please help.
>> > >
>> > > TIA..
>> >
>> >
>> >
>> >
Layout Issue
I have a dataset that goes like this
1
2
3
4
5
6
Using a table control, report preview appears as above.
I want the report to look like
1 2 3
4 5 6
How can I generate a report like this ?
Thanks
Is there any other control I can use to get the desired output.
Thanks !!
Layout incorrect when using ReportViewer
Please can someone help me with this.
I have created a very simple SQL report which has a title, Image, 3 subtitles and some data fields.
When I view it is my VS designer and preview it looks perfect, however when I deploy and view the the report through my ReportViewer control all the labels get moved around and the entire thing is a mess.
If I then export it to PDF it looks perfect again... I am sure I am missing something obvious but I can't find it.
I have done absolutely no expression formatting or coding at all. It's a plain SQL query and plain result textboxes.
Could be that something is overlapping in your report. Make sure that none of the components or fields are overlapping even slightly with each other. Overlapping items usually do not get rendered correctly when viewed on HTML.
-Aayush
|||
Aayush Goyal wrote:
Could be that something is overlapping in your report. Make sure that none of the components or fields are overlapping even slightly with each other. Overlapping items usually do not get rendered correctly when viewed on HTML.
-Aayush
It actually turned out to be a combination of two things, I had some overlapping but it still failed after I fixed that. I then checked it in IE and it worked this time.
Now I need to find out why it is not working in Firefox?
Layout for Parameters in Menu Bar
I want to change the layout for the parameters in my menu bar.
I understand that with SP1, I can use style sheets.
1.
I want to group three on top and then but a horizontal bar <hr>
and then I want to put four in the middle - and agin a <hr>
and then three at the bottom.
2.
Also - can I convert the drop down menu to a 'scrolling text box' solme how?
I attempted to edit the MyStyle... but with limited luck.
Any suggestion is appreciated.The customizations that SP1 adds will not let you make these changes. You
can, however, implement your own parameters area and hide the default one.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407211153.48c4e7e0@.posting.google.com...
> I want to change the layout for the parameters in my menu bar.
> I understand that with SP1, I can use style sheets.
> 1.
> I want to group three on top and then but a horizontal bar <hr>
> and then I want to put four in the middle - and agin a <hr>
> and then three at the bottom.
> 2.
> Also - can I convert the drop down menu to a 'scrolling text box' solme
how?
> I attempted to edit the MyStyle... but with limited luck.
> Any suggestion is appreciated.|||Implementing my own parameter area -
- Would SOAP be the preferred way to do that? (Besides URL calls)
- Can I use "Infopath" for making such SOAP calls and redisigning the
parameter forms?
Thxsql
I understand that with SP1, I can use style sheets.
1.
I want to group three on top and then but a horizontal bar <hr>
and then I want to put four in the middle - and agin a <hr>
and then three at the bottom.
2.
Also - can I convert the drop down menu to a 'scrolling text box' solme how?
I attempted to edit the MyStyle... but with limited luck.
Any suggestion is appreciated.The customizations that SP1 adds will not let you make these changes. You
can, however, implement your own parameters area and hide the default one.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407211153.48c4e7e0@.posting.google.com...
> I want to change the layout for the parameters in my menu bar.
> I understand that with SP1, I can use style sheets.
> 1.
> I want to group three on top and then but a horizontal bar <hr>
> and then I want to put four in the middle - and agin a <hr>
> and then three at the bottom.
> 2.
> Also - can I convert the drop down menu to a 'scrolling text box' solme
how?
> I attempted to edit the MyStyle... but with limited luck.
> Any suggestion is appreciated.|||Implementing my own parameter area -
- Would SOAP be the preferred way to do that? (Besides URL calls)
- Can I use "Infopath" for making such SOAP calls and redisigning the
parameter forms?
Thxsql
Layout File for a Fixed-Length Flat File
Hi,
Does the flat file connection format (Fixed Width) have anyway to include a file layout to define the columns. We have different files which contain over a hundred columns.
Or is there any other way to do this. Script Component?
Thanks,
ShantiThe one option is to have a template package and copy the flat file connection from that package to your new package|||If I understand the question, you want to have something like a format file that the flat file connection manager UI can read to create the files.
We don't have a way to do that though we wanted to get it in. If you have hundreds of columns, I suggest writing a quick program that creates such a flat file connection manager using the runtime object model. There's a sample installed that helps you create a package, connection managers, data flow, etc. which might be a good place to start.
regards,
ash|||Yep, Ash you understood correctly. Thanks for the feedback.
Layout
Just a general note. I'm a .NET developer and enjoy the setup that visual
studio gives me when editing and working with my projects. I have a dual
screen setup and like to build my environment around it to increase my
productivity. I noticed that in the release of the new SQL 2005 Management
Studio there are a number of enhancements but one that I'd like is that when
I'm working with a specific table or view or anything, I should be able to
split up the components onto my different screens so that I can maximize my
space. So perhaps to have the query on one dockable window, the table in
another and the SQL in another. If I switch to another query or stored
procedure then all of those windows should be maintained but for the new
information.
Thanks.Send an e-mail to:
sqlwish@.microsoft.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Andrew Middleton" <Andrew Middleton@.discussions.microsoft.com> wrote in
message news:BB7ADCA7-E3CC-4CF9-A779-6ECD2E2EA741@.microsoft.com...
> Just a general note. I'm a .NET developer and enjoy the setup that visual
> studio gives me when editing and working with my projects. I have a dual
> screen setup and like to build my environment around it to increase my
> productivity. I noticed that in the release of the new SQL 2005
Management
> Studio there are a number of enhancements but one that I'd like is that
when
> I'm working with a specific table or view or anything, I should be able to
> split up the components onto my different screens so that I can maximize
my
> space. So perhaps to have the query on one dockable window, the table in
> another and the SQL in another. If I switch to another query or stored
> procedure then all of those windows should be maintained but for the new
> information.
> Thanks.|||> productivity. I noticed that in the release of the new SQL 2005
> Management
> Studio there are a number of enhancements but one that I'd like
Please use the SQL Server 2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
studio gives me when editing and working with my projects. I have a dual
screen setup and like to build my environment around it to increase my
productivity. I noticed that in the release of the new SQL 2005 Management
Studio there are a number of enhancements but one that I'd like is that when
I'm working with a specific table or view or anything, I should be able to
split up the components onto my different screens so that I can maximize my
space. So perhaps to have the query on one dockable window, the table in
another and the SQL in another. If I switch to another query or stored
procedure then all of those windows should be maintained but for the new
information.
Thanks.Send an e-mail to:
sqlwish@.microsoft.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Andrew Middleton" <Andrew Middleton@.discussions.microsoft.com> wrote in
message news:BB7ADCA7-E3CC-4CF9-A779-6ECD2E2EA741@.microsoft.com...
> Just a general note. I'm a .NET developer and enjoy the setup that visual
> studio gives me when editing and working with my projects. I have a dual
> screen setup and like to build my environment around it to increase my
> productivity. I noticed that in the release of the new SQL 2005
Management
> Studio there are a number of enhancements but one that I'd like is that
when
> I'm working with a specific table or view or anything, I should be able to
> split up the components onto my different screens so that I can maximize
my
> space. So perhaps to have the query on one dockable window, the table in
> another and the SQL in another. If I switch to another query or stored
> procedure then all of those windows should be maintained but for the new
> information.
> Thanks.|||> productivity. I noticed that in the release of the new SQL 2005
> Management
> Studio there are a number of enhancements but one that I'd like
Please use the SQL Server 2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
Subscribe to:
Posts (Atom)