Friday, February 24, 2012
Browser time out: when executing a DTS package
I am am having a strange problem. I am trying to execute a DTS package
from VB .NET (.aspx) page. The DTS package takes 21 minutes to execute.
When the aspx page sends a command to MS SQL server to execute this DTS
package it starts executing. After 8 minutes the .aspx page shows error
"Cannot Find Server" and errors out with a white screen. The
inetresting thing is the DTS package is still being executed in backend
and completes execution successfully.
I have no clue why this is happening because there are other DTS
packages that I am executing through the same .aspx page that takes
about 3 minutes to complete execution and are working absolutely fine.
By the way I have a stored procedure wrapper over every DTS package. So
when i have to execute a DTS package I execute a stored which inturn
executes a DTS package.
Thanks for reading my query. If you have any suggestions please let me
know.
Thank you in advance.The aspx page (or the command object, or whatever you are using to execute
the stored procedure) has a timeout property. When the timeout value is
reached the web page times out.
Can you increase the timeout for that one database call?
Keith Kratochvil
"Al-Pacino" <dipenshahis@.yahoo.com> wrote in message
news:1142435924.265991.289090@.e56g2000cwe.googlegroups.com...
> Hello All,
> I am am having a strange problem. I am trying to execute a DTS package
> from VB .NET (.aspx) page. The DTS package takes 21 minutes to execute.
> When the aspx page sends a command to MS SQL server to execute this DTS
> package it starts executing. After 8 minutes the .aspx page shows error
> "Cannot Find Server" and errors out with a white screen. The
> inetresting thing is the DTS package is still being executed in backend
> and completes execution successfully.
> I have no clue why this is happening because there are other DTS
> packages that I am executing through the same .aspx page that takes
> about 3 minutes to complete execution and are working absolutely fine.
> By the way I have a stored procedure wrapper over every DTS package. So
> when i have to execute a DTS package I execute a stored which inturn
> executes a DTS package.
> Thanks for reading my query. If you have any suggestions please let me
> know.
> Thank you in advance.
>|||Hi Keith,
I tried setting the time out for the command object but it still does
not work right.
It has the exact same behaviour.
Keith Kratochvil wrote:
> The aspx page (or the command object, or whatever you are using to execute
> the stored procedure) has a timeout property. When the timeout value is
> reached the web page times out.
> Can you increase the timeout for that one database call?
> --
> Keith Kratochvil
>
> "Al-Pacino" <dipenshahis@.yahoo.com> wrote in message
> news:1142435924.265991.289090@.e56g2000cwe.googlegroups.com...
Browser Time Out: when executing a DTS package
I am am having a strange problem. I am trying to execute a DTS package
from VB .NET (.aspx) page. The DTS package takes 21 minutes to execute.
When the aspx page sends a command to MS SQL server to execute this DTS
package it starts executing. After 8 minutes the .aspx page shows error
"Cannot Find Server" and errors out with a white screen. The
inetresting thing is the DTS package is still being executed in backend
and completes execution successfully.
I have no clue why this is happening because there are other DTS
packages that I am executing through the same .aspx page that takes
about 3 minutes to complete execution and are working absolutely fine.
By the way I have a stored procedure wrapper over every DTS package. So
when i have to execute a DTS package I execute a stored which inturn
executes a DTS package.
Thanks for reading my query. If you have any suggestions please let me
know.
Thank you in advance.Hi
Have you though about doing this through a job and not waiting?
John
"Al-Pacino" <dipenshahis@.yahoo.com> wrote in message
news:1142436273.071208.313680@.e56g2000cwe.googlegr oups.com...
> Hello All,
> I am am having a strange problem. I am trying to execute a DTS package
> from VB .NET (.aspx) page. The DTS package takes 21 minutes to execute.
> When the aspx page sends a command to MS SQL server to execute this DTS
> package it starts executing. After 8 minutes the .aspx page shows error
> "Cannot Find Server" and errors out with a white screen. The
> inetresting thing is the DTS package is still being executed in backend
> and completes execution successfully.
>
> I have no clue why this is happening because there are other DTS
> packages that I am executing through the same .aspx page that takes
> about 3 minutes to complete execution and are working absolutely fine.
>
> By the way I have a stored procedure wrapper over every DTS package. So
> when i have to execute a DTS package I execute a stored which inturn
> executes a DTS package.
>
> Thanks for reading my query. If you have any suggestions please let me
> know.
>
> Thank you in advance.
Browser tab error/crash in BIDS when I want to browse data
I just a newbie , for SQL Analysis service 2005
I followed Analyasis Service Tutorial to create Analysis Project when I done everything after create data source , DSV , create cube and processing cube. I click deploy project and when I click browser tab it's crash and BIDS(Business Intelligence Development Studio) hang not response.
What should I do ? Any suggestion. While after deploy I can use other tab near browser tab properly.
What kind of error you are getting?
See what happens if you wait a little bit. The deployment is sending command to Analysis Server that needs to process a cube and then executes a query to show your results in BIDS. This all might take some time. So wait till deplyment finishes and then go and browse your data.
See if installing SP2 helps you getting better performace out of your cube.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Browser similar to SSAS required for SSRS
Hi,
How to import analysis browser in SSRS. I need features similar to SSAS Cube browser and SSAS dimention browser.
Regards
Spandan
As you probably know, SSRS has an MDX Designer which you can use if you target SSAS 2005. It is possible to host your own query designer although this feature is currently not documented. You need to contact the RS product group for more details.Browser similar to SSAS required for SSRS
Hi,
How to import analysis browser in SSRS. I need features similar to SSAS Cube browser and SSAS dimention browser.
Regards
Spandan
As you probably know, SSRS has an MDX Designer which you can use if you target SSAS 2005. It is possible to host your own query designer although this feature is currently not documented. You need to contact the RS product group for more details.Browser Role get Admin Tools... why?
We're trying to set up a Browser Role on a Server for Reporting Services. We
have created the NT User, and then added a Browser role for them in RS. But
for some reason, even though when we access Reports and type in the Browser's
Credentials, all of the Admin Tools are still there and usable.
I've done the exact same thing previously and had no complications like
this. What could be causing this to happen?
Thanks
AndreThe Answer is...
the report web apps in IIS has anom access selected!
"Arkiliknam" wrote:
> Hi there,
> We're trying to set up a Browser Role on a Server for Reporting Services. We
> have created the NT User, and then added a Browser role for them in RS. But
> for some reason, even though when we access Reports and type in the Browser's
> Credentials, all of the Admin Tools are still there and usable.
> I've done the exact same thing previously and had no complications like
> this. What could be causing this to happen?
> Thanks
> Andre
Browser Role - Deletes
reports. Using the Browser Role ( View Folders, View Reports ) still
allows them to get to the "Show Details" page with full access to delete my
reports. What am I missing?
TIA
TinaThe Show Details will still show the check box to delete the report. But
the user does not have permissions to do it and will receive an error. If
this is not the case, please let me know.
Make sure you apply permissions at the folder level as well.
| From: "Tina Smith" <tb.smith@.earthlink.net>
| Subject: Browser Role - Deletes
| Date: Tue, 18 Jan 2005 11:31:20 -0500
| Lines: 9
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
| Message-ID: <O1QclsX$EHA.2076@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: user-10ibco9.biz.mindspring.com 65.37.179.9
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40126
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I'm trying to restrict my users from being able to delete or move any of
the
| reports. Using the Browser Role ( View Folders, View Reports ) still
| allows them to get to the "Show Details" page with full access to delete
my
| reports. What am I missing?
|
| TIA
| Tina
|
|
||||Yes, they do receive an error stating they don't have the permissions.
I'd rather not show them the option to delete the reports when they don't
have the permissions to. Is there anyway to eliminate the "ShowDetails"
for the browser role?
Thanks
Tina
""Brad Syputa - MS"" <bradsy@.Online.Microsoft.com> wrote in message
news:tR6$y7X$EHA.3360@.cpmsftngxa10.phx.gbl...
> The Show Details will still show the check box to delete the report. But
> the user does not have permissions to do it and will receive an error. If
> this is not the case, please let me know.
> Make sure you apply permissions at the folder level as well.
>
> --
> | From: "Tina Smith" <tb.smith@.earthlink.net>
> | Subject: Browser Role - Deletes
> | Date: Tue, 18 Jan 2005 11:31:20 -0500
> | Lines: 9
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
> | Message-ID: <O1QclsX$EHA.2076@.TK2MSFTNGP15.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: user-10ibco9.biz.mindspring.com 65.37.179.9
> | Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:40126
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I'm trying to restrict my users from being able to delete or move any of
> the
> | reports. Using the Browser Role ( View Folders, View Reports ) still
> | allows them to get to the "Show Details" page with full access to delete
> my
> | reports. What am I missing?
> |
> | TIA
> | Tina
> |
> |
> |
>
Browser Refresh
"Render this report with the most recent data"->"Cache a temporary *" is
selected.
It also refreshes around every 30 seconds when nothing is selected. Has
anyone had an similar issue, I've done a little searching, is their a way to
disable auto-browser refresh entierly?Check if AutoRefresh is selected in the 'Report Properties'.. may be it is
set to 2 seconds..
"Sean Edwards" <Sean Edwards@.discussions.microsoft.com> wrote in message
news:DA2C5B96-DF80-4887-99AF-D87B573EBC00@.microsoft.com...
> The browser refreshes every 2 seconds when
> "Render this report with the most recent data"->"Cache a temporary *" is
> selected.
> It also refreshes around every 30 seconds when nothing is selected. Has
> anyone had an similar issue, I've done a little searching, is their a way
to
> disable auto-browser refresh entierly?|||Thanks, I didn't even realize you could set the reports cache inside of
Visual.net
"RK Balaji" wrote:
> Check if AutoRefresh is selected in the 'Report Properties'.. may be it is
> set to 2 seconds..
>
> "Sean Edwards" <Sean Edwards@.discussions.microsoft.com> wrote in message
> news:DA2C5B96-DF80-4887-99AF-D87B573EBC00@.microsoft.com...
> > The browser refreshes every 2 seconds when
> > "Render this report with the most recent data"->"Cache a temporary *" is
> > selected.
> >
> > It also refreshes around every 30 seconds when nothing is selected. Has
> > anyone had an similar issue, I've done a little searching, is their a way
> to
> > disable auto-browser refresh entierly?
>
>
Browser realignment
I was curious, we have built a reporting services backend for DotNetNuke which displays reports in an IFRAME, but as you drill through the report the browser and iframe realign down to the top of the item clicked, here i show you,... This is before i click on a toggle item,...

Everything seems normal, browser and iframe all at the top,...
Then, as you can see the browser needlessly dives down the page, and the report rolls down as well,

Anyone know of a remedy for this, is there a property which can be set in RS or is it all in my frame configuration??
It is annoying enough for me to scroll back up, so i know the customer wont be jazzed about it either.
I thank in advance anyone for their help,...
Good Morning:
There may be a number of issues (postback's, IIS, etc.) and I have deployed DNN in a similar way to your above example. This "thread" from the DNN forum may lead you in a direction that may help.
http://forums.asp.net/781505/ShowPost.aspx - Persistent Scrolling!
Best Reagrds,
Joe
This link may also help as well - From DNN
http://forums.asp.net/search/SearchResults.aspx?q=IFrame%20&f=OTA=&u=
Best Regards,
Joe
Browser problem?
tcp/ip for remote connections. I also have SQL Server 7 on the same server.
I can connect to the SQL Server Express instance remotely if I specify the
dynamic port:
sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
I've started SQL Server Browser and tried to connect without specifying the
dynamic port but it doesn't work?
What am I doing wrong?
What are the specific error messages, numbers when you can't
connect?
-Sue
On Tue, 17 Oct 2006 05:11:02 -0700, Axel
<Axel@.discussions.microsoft.com> wrote:
>I've installed SQL Server 2005 Express on Windows 2000 server. I've enabled
>tcp/ip for remote connections. I also have SQL Server 7 on the same server.
>I can connect to the SQL Server Express instance remotely if I specify the
>dynamic port:
>sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
>I've started SQL Server Browser and tried to connect without specifying the
>dynamic port but it doesn't work?
>What am I doing wrong?
Browser problem?
tcp/ip for remote connections. I also have SQL Server 7 on the same server.
I can connect to the SQL Server Express instance remotely if I specify the
dynamic port:
sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
I've started SQL Server Browser and tried to connect without specifying the
dynamic port but it doesn't work?
What am I doing wrong?What are the specific error messages, numbers when you can't
connect?
-Sue
On Tue, 17 Oct 2006 05:11:02 -0700, Axel
<Axel@.discussions.microsoft.com> wrote:
>I've installed SQL Server 2005 Express on Windows 2000 server. I've enabled
>tcp/ip for remote connections. I also have SQL Server 7 on the same server.
>I can connect to the SQL Server Express instance remotely if I specify the
>dynamic port:
>sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
>I've started SQL Server Browser and tried to connect without specifying the
>dynamic port but it doesn't work?
>What am I doing wrong?
Browser Compatibility in SSRS 2005
The report displays squished to the left side of the browser as it did in SSRS 2000.
Is it the viewer that does this or a setting I need to set?
I am running my report from a URL.
Also seems to open ok if I export to PDF.
Does not work in HTML view.Check sizes of report items in your report and CanShrink/CanGrow properties. If they are set incorrectly in most cases IE will still show them right. Firefox is picky.|||Thanks that was it
|||
I need suggestions regarding the report being viewed in firefox:
Problem:
In Matrix reports the "sub Total" Columnm is getting wrapped to .0001 in (Probably!!!!! not to that accuracy), But i can see the remaining part like Row and Column Cells r displaying properly.
only the Last Column is being truncated..
This happens only in FireFox But not in IE.
Required Result:
"Sub Total" column also has to be seen clearly as other cells.
Any Suggestions?
Regards,
Sri Harsha Kasi
Browser Compatibility in SSRS 2005
The report displays squished to the left side of the browser as it did in SSRS 2000.
Is it the viewer that does this or a setting I need to set?
I am running my report from a URL.
Also seems to open ok if I export to PDF.
Does not work in HTML view.Check sizes of report items in your report and CanShrink/CanGrow properties. If they are set incorrectly in most cases IE will still show them right. Firefox is picky.|||Thanks that was it|||
I need suggestions regarding the report being viewed in firefox:
Problem:
In Matrix reports the "sub Total" Columnm is getting wrapped to .0001 in (Probably!!!!! not to that accuracy), But i can see the remaining part like Row and Column Cells r displaying properly.
only the Last Column is being truncated..
This happens only in FireFox But not in IE.
Required Result:
"Sub Total" column also has to be seen clearly as other cells.
Any Suggestions?
Regards,
Sri Harsha Kasi
Browser Compatibility in SSRS 2005
The report displays squished to the left side of the browser as it did in SSRS 2000.
Is it the viewer that does this or a setting I need to set?
I am running my report from a URL.
Also seems to open ok if I export to PDF.
Does not work in HTML view.Check sizes of report items in your report and CanShrink/CanGrow properties. If they are set incorrectly in most cases IE will still show them right. Firefox is picky.|||Thanks that was it
|||
I need suggestions regarding the report being viewed in firefox:
Problem:
In Matrix reports the "sub Total" Columnm is getting wrapped to .0001 in (Probably!!!!! not to that accuracy), But i can see the remaining part like Row and Column Cells r displaying properly.
only the Last Column is being truncated..
This happens only in FireFox But not in IE.
Required Result:
"Sub Total" column also has to be seen clearly as other cells.
Any Suggestions?
Regards,
Sri Harsha Kasi
Browser compatibility for Reporting Services
web-based reporting application. However, we hear that using Reporting
Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
Services be used with other web browsers besides I.E.?
Thank you,
Morgan StricklandJust my 2 cents. I use IE and FireFox. The Report Manager and Report
Server webs and the web service rendering work just fine in IE. It doesn't
work correctly in Firefox 1.0.4. I would be curious to test Mozilla and
some of the others...
--
Adrian M.
MCP
"Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
> We are considering using Reporting Services along with Dundas charts for
> our
> web-based reporting application. However, we hear that using Reporting
> Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
> Services be used with other web browsers besides I.E.?
> Thank you,
> Morgan Strickland
>|||I just disable the top toolbar with anything but IE.
The actual reports do work for me, but not all the functionality.
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:%23sLt3y$VFHA.3532@.TK2MSFTNGP09.phx.gbl...
> Just my 2 cents. I use IE and FireFox. The Report Manager and Report
> Server webs and the web service rendering work just fine in IE. It
doesn't
> work correctly in Firefox 1.0.4. I would be curious to test Mozilla and
> some of the others...
> --
> Adrian M.
> MCP
>
> "Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
> message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
> > We are considering using Reporting Services along with Dundas charts for
> > our
> > web-based reporting application. However, we hear that using Reporting
> > Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
> > Services be used with other web browsers besides I.E.?
> >
> > Thank you,
> > Morgan Strickland
> >
>|||There were several bugs in the SQL 2000 version of Reporting Services around
support for other browsers. We are working on addressing these for SQL 2005
Reporting Services. We plan to support Firefox and Safari in addition to IE.
Every single feature might not work, but most things should.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
> We are considering using Reporting Services along with Dundas charts for
> our
> web-based reporting application. However, we hear that using Reporting
> Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
> Services be used with other web browsers besides I.E.?
> Thank you,
> Morgan Strickland
>|||Brian,
We are just now planning on upgrading from SQL 2000 to SQL 2003 (and begin
using Reporting Services). Does SQL 2003 support browsers other than IE? If
not, when is SQL 2005 due for release?
Thank you
Morgan Strickland
"Brian Welcker [MS]" wrote:
> There were several bugs in the SQL 2000 version of Reporting Services around
> support for other browsers. We are working on addressing these for SQL 2005
> Reporting Services. We plan to support Firefox and Safari in addition to IE.
> Every single feature might not work, but most things should.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
> message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
> > We are considering using Reporting Services along with Dundas charts for
> > our
> > web-based reporting application. However, we hear that using Reporting
> > Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
> > Services be used with other web browsers besides I.E.?
> >
> > Thank you,
> > Morgan Strickland
> >
>
>|||There is not a SQL Server 2003. There is a Service Pack 3a but there is not
a SQL Server 2003. MS has said that SQL Server 2005 will be released this
year.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
message news:A9A29692-0499-40FC-8EC0-7A594BA5797A@.microsoft.com...
> Brian,
> We are just now planning on upgrading from SQL 2000 to SQL 2003 (and begin
> using Reporting Services). Does SQL 2003 support browsers other than IE?
> If
> not, when is SQL 2005 due for release?
> Thank you
> Morgan Strickland
> "Brian Welcker [MS]" wrote:
>> There were several bugs in the SQL 2000 version of Reporting Services
>> around
>> support for other browsers. We are working on addressing these for SQL
>> 2005
>> Reporting Services. We plan to support Firefox and Safari in addition to
>> IE.
>> Every single feature might not work, but most things should.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote
>> in
>> message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
>> > We are considering using Reporting Services along with Dundas charts
>> > for
>> > our
>> > web-based reporting application. However, we hear that using Reporting
>> > Services will LIMIT us to only I.E. browser. Is this true? Can
>> > Reporting
>> > Services be used with other web browsers besides I.E.?
>> >
>> > Thank you,
>> > Morgan Strickland
>> >
>>|||wow...new browsers popping up all the time. Never even heard of Safari...
--
Adrian M.
MCP
"Brian Welcker [MS]" <bwelcker@.online.microsoft.com> wrote in message
news:OOoKP5KWFHA.1796@.TK2MSFTNGP15.phx.gbl...
> There were several bugs in the SQL 2000 version of Reporting Services
> around support for other browsers. We are working on addressing these for
> SQL 2005 Reporting Services. We plan to support Firefox and Safari in
> addition to IE. Every single feature might not work, but most things
> should.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
> message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
>> We are considering using Reporting Services along with Dundas charts for
>> our
>> web-based reporting application. However, we hear that using Reporting
>> Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
>> Services be used with other web browsers besides I.E.?
>> Thank you,
>> Morgan Strickland
>|||As far as you are not related with Mac, you won´t get in touch with that.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Adrian M." <absolutelynospam@.nodomain_.com> schrieb im Newsbeitrag
news:O6h6Z%23iWFHA.3464@.TK2MSFTNGP10.phx.gbl...
> wow...new browsers popping up all the time. Never even heard of Safari...
> --
> Adrian M.
> MCP
>
> "Brian Welcker [MS]" <bwelcker@.online.microsoft.com> wrote in message
> news:OOoKP5KWFHA.1796@.TK2MSFTNGP15.phx.gbl...
>> There were several bugs in the SQL 2000 version of Reporting Services
>> around support for other browsers. We are working on addressing these for
>> SQL 2005 Reporting Services. We plan to support Firefox and Safari in
>> addition to IE. Every single feature might not work, but most things
>> should.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote
>> in message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
>> We are considering using Reporting Services along with Dundas charts for
>> our
>> web-based reporting application. However, we hear that using Reporting
>> Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
>> Services be used with other web browsers besides I.E.?
>> Thank you,
>> Morgan Strickland
>>
>
Browser Based Report Builder
I am looking at building a simple browser based report builder. I would like
to provide options to move fields and add text\captions to exsisting reports
using a browser(IE)
To startwith I am looking at displaying the fields(those are present in
report) in a grid(where the user could change the order of them) and have a
report preview pane(where the user could preview the report.
Could someone please let me know how I could have a preview pane in web page
and how I could make changes to the report as soon as a user changes the
fields order in grid.
Any help\suggestions on this would be greatly appreciated.
Thanks
PonnuIf you have SS2005 then dont reinvent the wheel, it is already there as
Report Model / Report Builder which i browser based.
Amarnath
"Ponnu" wrote:
> Hi,
> I am looking at building a simple browser based report builder. I would like
> to provide options to move fields and add text\captions to exsisting reports
> using a browser(IE)
> To startwith I am looking at displaying the fields(those are present in
> report) in a grid(where the user could change the order of them) and have a
> report preview pane(where the user could preview the report.
> Could someone please let me know how I could have a preview pane in web page
> and how I could make changes to the report as soon as a user changes the
> fields order in grid.
> Any help\suggestions on this would be greatly appreciated.
> Thanks
> Ponnu
>
>|||Hi Amarnath,
I am planning to do in SSRS 2005.
I could use ReportViewer for previewing reports but I need to change the
order of columns in the reoprt once the user changes the order in the grid.
Any ideas how I could programatically change the report from vb.net to
change the order of columns?
Thanks
Ponnu
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:8A4339DA-1E37-4959-8B3C-7DED2DDE4272@.microsoft.com...
> If you have SS2005 then dont reinvent the wheel, it is already there as
> Report Model / Report Builder which i browser based.
> Amarnath
> "Ponnu" wrote:
>> Hi,
>> I am looking at building a simple browser based report builder. I would
>> like
>> to provide options to move fields and add text\captions to exsisting
>> reports
>> using a browser(IE)
>> To startwith I am looking at displaying the fields(those are present in
>> report) in a grid(where the user could change the order of them) and have
>> a
>> report preview pane(where the user could preview the report.
>> Could someone please let me know how I could have a preview pane in web
>> page
>> and how I could make changes to the report as soon as a user changes the
>> fields order in grid.
>> Any help\suggestions on this would be greatly appreciated.
>> Thanks
>> Ponnu
>>
Browser as Front-End
I'm trying to build an app. for my parents' office. They have a small
office (5 PCs), and they currently work with a very old program that's
based on DOS. The program doesn't work well under XP, so they still use
Win 98. They had their network upgraded about a year ago. They had
Microsoft SBS 2000 installed, it includes SQL Server. I've written a
few DB's in Access before, and now I'm just learning how to use SQL.
Before I start work on their app., I have a question:
I know it's possible to create an interface that can be put on their
network and accessed via a browser. How is this done exactly?
It would be very beneficial for me, because it would mean that the new
app. would be platform independent, so that they can upgrade to XP
easily. It would also save us the cost of licensing front-end software
(e.g. Access) for each machine.
Any comments would be appreciated.
Noam Nelke, Israel.When you meant place the SQL Server on a network, you meant placing it
on a central server?
If that is the case, you can have one dedicated server for the SQL
Server and an application server where you can develop your web
application to create an Interface for this DB.
How to create the Interface?
- You can have a Web Server installed on the application server (IIS or
java based web servers) and then write your web code in any of the tons
of languages.
Hope that helps.|||Noam Nelke (NoamNelke@.gmail.com) writes:
> I'm trying to build an app. for my parents' office. They have a small
> office (5 PCs), and they currently work with a very old program that's
> based on DOS. The program doesn't work well under XP, so they still use
> Win 98. They had their network upgraded about a year ago. They had
> Microsoft SBS 2000 installed, it includes SQL Server. I've written a
> few DB's in Access before, and now I'm just learning how to use SQL.
> Before I start work on their app., I have a question:
> I know it's possible to create an interface that can be put on their
> network and accessed via a browser. How is this done exactly?
That's a question that does not have much to do with SQL Server. Most
people seem to use ASP or ASP .Net. There is also Cold Fusion out there,
and probably a few more possibilities.
> It would be very beneficial for me, because it would mean that the new
> app. would be platform independent, so that they can upgrade to XP
> easily. It would also save us the cost of licensing front-end software
> (e.g. Access) for each machine.
On the other hand, browser-based interfaces are often painful to use.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
browser
moment to go to IE6, they have IE5.
Any chance of getting (parts of) svcs working?
Thanks a lotFor the Report Manager they will need IE 6.0 SP1. For report rendering IE
5.0 with SP2 will do the job. Please review the following topics in the
product documentation:
Software Requirements for Reporting Services
Browser Types Supported by Reporting Services
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"jos" <jos@.discussions.microsoft.com> wrote in message
news:3EC51AC7-70D1-41DF-998E-9BF345935BD2@.microsoft.com...
> I have a customer who wants to start using repsvcs but is unable at the
> moment to go to IE6, they have IE5.
> Any chance of getting (parts of) svcs working?
> Thanks a lot