New to reporting service

I am new to reporting service but has used VS 2005 beta to develop winform app for a long time. I have the following questions:

1. Are the report object and report viewer in VS2005(winform) related to those of SQL server reporting service? If yes, what are the relationship?
2. If I just want to create/view report with report viewer of VS2005 in my app which connect to SQL Server Express, do I need reporting service?
3. I can see there are options to install reporting service while installing SQL Server Express(free of charge), can I develop app for my client which use reporting service with SQL Server Express?

Thank a lot!Any idea?|||

Okay, here we go.

Reporting Services
Reporting Services is a component of SQL Server 2000 and SQL Server 2005. Basically the Reporting Services acts as a Report Repository and supports such features as:
* Server-Side Rendering = The server does the work
* Subscriptions - Reports can be generated at scheduled times and be automatically distributed to email or file shares.
* Report Snapshots - Report output can be rendered and stored on the server, for instance a monthly report can have a monthly snapshot. This way you never to need to print and store common reports, the server has the old copy even if the orginial report data is gone.

ReportViewer Control
Okay, so Reporting Services basically rocks because it solved the majority of your reporting issues and comes free with most versions of SQL Server. Now, in with SQL Server 2005 and Visual Studio 2005 there are 2 new controls that make reporting services even better. There is a Windows forms and asp.net ReportViewer control. The control can work in 2 modes, Remote and Local. In Remote mode it can be used to integrate with Reporting Services as users can view reports stored on the server. In local mode (what you want) it can displayed reports that have been embedded within your application. In this mode Reporting Services is not required, which makes it ideal to use with SQL Express. There are only 2 minor disadvantages to running in local mode. The first is that the client computer has to do all the work and report rendering, but its not bad for smaller applications. The second is that the client must have this ReportViewer pack installed. Basically, it contains all of the rendering pieces needed to render a report on the client machine. The great news is that if you deploy your application using the new ClickOnce, you can automatically deploy the ReportViewerPack (also it is very small like only a couple of MB!).

|||Thanks

New to reporting service

I am new to reporting service but has used VS 2005 beta to develop winform app for a long time. I have the following questions:

1. Are the report object and report viewer in VS2005(winform) related to those of SQL server reporting service? If yes, what are the relationship?
2. If I just want to create/view report with report viewer of VS2005 in my app which connect to SQL Server Express, do I need reporting service?
3. I can see there are options to install reporting service while installing SQL Server Express(free of charge), can I develop app for my client which use reporting service with SQL Server Express?

Thank a lot!

Any idea?|||

Okay, here we go.

Reporting Services
Reporting Services is a component of SQL Server 2000 and SQL Server 2005. Basically the Reporting Services acts as a Report Repository and supports such features as:
* Server-Side Rendering = The server does the work
* Subscriptions - Reports can be generated at scheduled times and be automatically distributed to email or file shares.
* Report Snapshots - Report output can be rendered and stored on the server, for instance a monthly report can have a monthly snapshot. This way you never to need to print and store common reports, the server has the old copy even if the orginial report data is gone.

ReportViewer Control
Okay, so Reporting Services basically rocks because it solved the majority of your reporting issues and comes free with most versions of SQL Server. Now, in with SQL Server 2005 and Visual Studio 2005 there are 2 new controls that make reporting services even better. There is a Windows forms and asp.net ReportViewer control. The control can work in 2 modes, Remote and Local. In Remote mode it can be used to integrate with Reporting Services as users can view reports stored on the server. In local mode (what you want) it can displayed reports that have been embedded within your application. In this mode Reporting Services is not required, which makes it ideal to use with SQL Express. There are only 2 minor disadvantages to running in local mode. The first is that the client computer has to do all the work and report rendering, but its not bad for smaller applications. The second is that the client must have this ReportViewer pack installed. Basically, it contains all of the rendering pieces needed to render a report on the client machine. The great news is that if you deploy your application using the new ClickOnce, you can automatically deploy the ReportViewerPack (also it is very small like only a couple of MB!).

|||Thanks

New to Report Services

This is going to be a strange question but when I'm in Report Services all I get is

New|My Subscriptions|Help

Actaully it's called Report Manager on my link. Where do I go to create a report. This seems like the spot to go just for viewing.

Card Gunner

Report manager is just for managing reports (viewing, subscribing, etc). Report Builder can create ad-hoc reports through the report manager. To create reports, you can do this using Visual Studio Business Intelligence projects or create a report directly in an application itself or use BIDS (Business Intelligence Development System).

Hope this helps.

sql

new to put the parameter in report

Have a report with two datasets. One has the list for the parameter
(salesperson_list). The other is a grouped by age / count result that
populates the table in the report.
Age Group Count
0 - 9 2344
10 - 19 588
etc...
How do I put the parameter into the report itself? Such as putting
SalesPerson John Smith
then the results of the dataset.
Probably an easy fix, new to Reporting Services.
Thanks="Sales Person " + Parameters!SalesPerson.Value
Put that in a text box. You can do the same in the table or matrix,
but you need to use & to concatenate instead of +.|||It works, but shows the actual parameter ID (ie... 66), rather than showing
the name.
So changed the .Value to .Label and it worked. Thanks for the direction.
Much appreciated. Books don't go deep enough to get into the details of
Reporting Services.
"John" wrote:
> ="Sales Person " + Parameters!SalesPerson.Value
> Put that in a text box. You can do the same in the table or matrix,
> but you need to use & to concatenate instead of +.
>

new to crystal report

hi friends,
i'm new to crystal report. i'd like to know which method is better to make report in crystal report. i developing programes using vb. could anyone help me pls
thankx for ur helpWhat version of Crystal are you using and what version of VB? Also, what kind of data are you going to use? From a database?

If you do a search on this forum for 'CDO', I have posted many examples. I use CR 8.5 using RDC and VB 6. CDO is Crystal Reports version of a recordset. It leaves all the data gathering up to VB so that Crystal never has to touch the database. VB loads all the data into an array, then stuffs the array into a CDO rowset (similar to an ADO recordset or an RDO resultset), then VB passes the CDO rowset to Crystal to display the data.|||Hi im totally new to crystal reports as well.. im using crystal reports 9 and vb .net. I want to pass parameters to a crystal report using vb.. what i exactly want is that the info the user has entered to a field will be passed to a certain portion in the crystal report.. after entering the required fields, i want to see the whole report in the next page.. how should i do this? help!|||If you do a search on this forum for 'CDO', I have posted many examples. I use CR 8.5 using RDC and VB 6. CDO is Crystal Reports version of a recordset. It leaves all the data gathering up to VB so that Crystal never has to touch the database. VB loads all the data into an array, then stuffs the array into a CDO rowset (similar to an ADO recordset or an RDO resultset), then VB passes the CDO rowset to Crystal to display the data.

thankx for the kind help. it's really a great help.

New Subscriptions

When I go to the "My Subscriptions" screem in the Report Manager, I don't get a "New Subscription" option.

I am running SQL Server 2005 Developer's version, as a domain administrator with every role function enabled.

How do I get access to this functionality?

The option is not within "My Subscriptions". You have to have clicked on a report and you will see the option to create a new subscription there.

|||Thanks. Your reply was very helpful. I could have wandered around for hours looking for that.|||I am glad that I was able to help and save you some time!sql

New Subscription - Report Server Email Delivery Method

When I try to create a new subscription no 'Report Server Email Delivery
Method' shows up.
'Report Server Email' does exist in RSReportServer.config and is configured
with a value for <smtpserver> and a value for <from>.
What is required for 'Report Server Email' to show up?When I set this up I had trouble using a name for the server
(servername.blah.com), I had to put in the IP address for it to work for me.
Don't know why.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:59D811E2-233E-45C4-BEFD-F313C9713E34@.microsoft.com...
> When I try to create a new subscription no 'Report Server Email Delivery
> Method' shows up.
> 'Report Server Email' does exist in RSReportServer.config and is
configured
> with a value for <smtpserver> and a value for <from>.
> What is required for 'Report Server Email' to show up?
>|||Was using an IP address.
"Bruce L-C [MVP]" wrote:
> When I set this up I had trouble using a name for the server
> (servername.blah.com), I had to put in the IP address for it to work for me.
> Don't know why.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:59D811E2-233E-45C4-BEFD-F313C9713E34@.microsoft.com...
> > When I try to create a new subscription no 'Report Server Email Delivery
> > Method' shows up.
> >
> > 'Report Server Email' does exist in RSReportServer.config and is
> configured
> > with a value for <smtpserver> and a value for <from>.
> >
> > What is required for 'Report Server Email' to show up?
> >
> >
>
>

New Subscription

We are getting the following error when trying to create a new subscription:
An internal error occurred on the report server. See the error log for more
details.
(rsInternalError) Get Online Help EXECUTE permission denied on object
'xp_sqlagent_is_starting', database 'master', owner 'dbo'.
I can't seem to find what's causing it.
Help'I'm having the same problem...any resolution to this?
"Bob Sherman" wrote:
> We are getting the following error when trying to create a new subscription:
> An internal error occurred on the report server. See the error log for more
> details.
> (rsInternalError) Get Online Help EXECUTE permission denied on object
> 'xp_sqlagent_is_starting', database 'master', owner 'dbo'.
> I can't seem to find what's causing it.
> Help'

New SQL Server 2000 Reporting Services Report Pack

There is a new Report Pack for Reporting Services 2000 at
http://www.microsoft.com/downloads/details.aspx?FamilyId=2805D337-14C7-40E3-820B-E7EE653C68C0&displaylang=en.
Further Report Packs, which provide useful sample reports, are can be
downloaded using links on
http://www.microsoft.com/sql/reporting/downloads/default.asp.
Report Packs are not to be confused with the long-awaited Service Pack
2.
Andrew Watt
MVP - InfoPathAndrew ,
Thank you very much.
It is hard to keep track of what is out there. you made life easier here.
:)
John
--
Message posted via http://www.sqlmonster.com|||A full list is at
http://www.microsoft.com/sql/reporting/downloads/default.asp.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:u55251hhdcejo3cde1ue56q4o65dijblcu@.4ax.com...
> There is a new Report Pack for Reporting Services 2000 at
> http://www.microsoft.com/downloads/details.aspx?FamilyId=2805D337-14C7-40E3-820B-E7EE653C68C0&displaylang=en.
> Further Report Packs, which provide useful sample reports, are can be
> downloaded using links on
> http://www.microsoft.com/sql/reporting/downloads/default.asp.
> Report Packs are not to be confused with the long-awaited Service Pack
> 2.
> Andrew Watt
> MVP - InfoPath|||This is a multipart message in MIME format.
--=_alternative 004630FB86256FDA_=Content-Type: text/plain; charset="us-ascii"
Anyone have a similar thing for reports that describe Reporting Service
usage (such as execution times, users running reports, etc.)?
--=_alternative 004630FB86256FDA_=Content-Type: text/html; charset="us-ascii"
<br><font size=1 face="sans-serif">Anyone have a similar thing for reports that describe Reporting Service usage (such as execution times, users running reports, etc.)?</font>
--=_alternative 004630FB86256FDA_=--|||This exists, I found it and downloaded it, but I can't find it :(
There is a nasty DTS package that comes with it to make it readable, as
well as a few reports. I'll keep looking...|||Acutally there is a DTS package and report pack for execution times and
what not...I believe they are both on the Reporting Services CD.
Otherwise you can find them on microsofts website somewhere.|||were you able to run this DTS package succesfully ? It fails for me at
different
steps - not able to open a connection etc --
is this feature integrated into rs2005 ?
"John" wrote:
> This exists, I found it and downloaded it, but I can't find it :(
> There is a nasty DTS package that comes with it to make it readable, as
> well as a few reports. I'll keep looking...
>|||Yes, I was able to run the DTS package. I think I had to make some
changes ...I don't remember exactly. There is a document on how to get
this to work also...again not sure where that is. I run the DTS package
once a week and view stats on my reports. It's fairly handy.|||Sorry, I forgot the link.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp
"ranga" wrote:
> were you able to run this DTS package succesfully ? It fails for me at
> different
> steps - not able to open a connection etc --
> is this feature integrated into rs2005 ?
> "John" wrote:
> > This exists, I found it and downloaded it, but I can't find it :(
> > There is a nasty DTS package that comes with it to make it readable, as
> > well as a few reports. I'll keep looking...
> >
> >|||This article explains how to set up the DTS package, and deploy the reports.
"ranga" wrote:
> were you able to run this DTS package succesfully ? It fails for me at
> different
> steps - not able to open a connection etc --
> is this feature integrated into rs2005 ?
> "John" wrote:
> > This exists, I found it and downloaded it, but I can't find it :(
> > There is a nasty DTS package that comes with it to make it readable, as
> > well as a few reports. I'll keep looking...
> >
> >

New SP2 Excel Render Bug (Excel Formulas)

Hi,
I have a report that converts expression to Excel formulas. The Excel
formulas in a table are incorrectly rendered in a way that the references
are all off by 6 or so cells. When I set the "Omit Formulas" device setting
to true the values are correct, though there are no formulas. I don't
remember this failure in SP1.
Thanks,
Bryan
PS. Is there a way to make "OmitFormulas=true" static when the request is
made from the report manager?BTW, This bug only happens when requesting the render from the report
server. It doesn't happen in VS.NET.
"BDB" <reply@.to.group.com> wrote in message
news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a report that converts expression to Excel formulas. The Excel
> formulas in a table are incorrectly rendered in a way that the references
> are all off by 6 or so cells. When I set the "Omit Formulas" device
> setting to true the values are correct, though there are no formulas. I
> don't remember this failure in SP1.
> Thanks,
> Bryan
> PS. Is there a way to make "OmitFormulas=true" static when the request is
> made from the report manager?
>|||Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
available with SQL 2000. As for the bug, nothing has changed in this area so
I would imagine it happened with SP1 as well.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"BDB" <reply@.to.group.com> wrote in message
news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
> BTW, This bug only happens when requesting the render from the report
> server. It doesn't happen in VS.NET.
> "BDB" <reply@.to.group.com> wrote in message
> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the references
>> are all off by 6 or so cells. When I set the "Omit Formulas" device
>> setting to true the values are correct, though there are no formulas. I
>> don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the request
>> is made from the report manager?
>|||No, I've tested both ways. This bug was introduced in SP2.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
> available with SQL 2000. As for the bug, nothing has changed in this area
> so I would imagine it happened with SP1 as well.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "BDB" <reply@.to.group.com> wrote in message
> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit Formulas"
>> device setting to true the values are correct, though there are no
>> formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the request
>> is made from the report manager?
>>
>|||Can you post or send me your RDL (remove the online. part in my e-mail
address)?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"BDB" <reply@.to.group.com> wrote in message
news:uFBYKQqSFHA.3552@.TK2MSFTNGP10.phx.gbl...
> No, I've tested both ways. This bug was introduced in SP2.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
>> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
>> available with SQL 2000. As for the bug, nothing has changed in this area
>> so I would imagine it happened with SP1 as well.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit
>> Formulas" device setting to true the values are correct, though there
>> are no formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the request
>> is made from the report manager?
>>
>>
>|||Sure. Thank you.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%2376cRJrSFHA.3300@.TK2MSFTNGP10.phx.gbl...
> Can you post or send me your RDL (remove the online. part in my e-mail
> address)?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "BDB" <reply@.to.group.com> wrote in message
> news:uFBYKQqSFHA.3552@.TK2MSFTNGP10.phx.gbl...
>> No, I've tested both ways. This bug was introduced in SP2.
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
>> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
>> available with SQL 2000. As for the bug, nothing has changed in this
>> area so I would imagine it happened with SP1 as well.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit
>> Formulas" device setting to true the values are correct, though there
>> are no formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the
>> request is made from the report manager?
>>
>>
>>
>|||This issue was resolved by rebuilding and redeploying the RDL.
Much thinks to Brian Welcker for his help.
Bryan
"BDB" <reply@.to.group.com> wrote in message
news:OZrPaFzSFHA.3308@.TK2MSFTNGP14.phx.gbl...
> Sure. Thank you.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%2376cRJrSFHA.3300@.TK2MSFTNGP10.phx.gbl...
>> Can you post or send me your RDL (remove the online. part in my e-mail
>> address)?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:uFBYKQqSFHA.3552@.TK2MSFTNGP10.phx.gbl...
>> No, I've tested both ways. This bug was introduced in SP2.
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
>> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is
>> not available with SQL 2000. As for the bug, nothing has changed in
>> this area so I would imagine it happened with SP1 as well.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The
>> Excel formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit
>> Formulas" device setting to true the values are correct, though there
>> are no formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the
>> request is made from the report manager?
>>
>>
>>
>>
>

New RS server TimeProcessing very large

We just installed a new server dedicated to Reporting Services. I uploaded
our report definitions and ran a test. The TimeProcessing value is huge
compared to our old server.
Old server: RS 2005 as part of database cluster on an instances that also
hosts data, 32-bit OS and SQL (SP2), 2.79GHz, 16GB RAM with 7.5GB dedicated
to SQL, Xeon 2.80GHz, PAE
New server: Dedicated to Reporting Services 2005, 64-bit OS and SQL (SP2),
2.66GHz, 16GB RAM, min server memory and max server memory configuration
values are still the defaults, Xeon X5355@.2.66 GHz
Do you have any suggestions on where I can look to begin troubleshooting
this performance issue?
StephanieStephanie, I am also facing the same issue in the same kind of 64-bit OS,
RS2005.
Have you got any solution to this issue?
Kavitha
url:http://www.ureader.com/msg/115713370.aspx|||The volume of data being brought back in our case was too large (we were
trying to bring back data files, not reports) and we were using Excel, which
consumes a tremendous amount of memory. Microsoft's answer was that we
should not be using RS to deliver files, only reports of a printable size,
i.e. not 300 page reports.
"Kavitha" wrote:
> Stephanie, I am also facing the same issue in the same kind of 64-bit OS,
> RS2005.
> Have you got any solution to this issue?
> Kavitha
> url:http://www.ureader.com/msg/115713370.aspx
>|||Keep in mind that if you want to bring over data try CSV ASCII instead of
Excel for large data amounts of data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
> The volume of data being brought back in our case was too large (we were
> trying to bring back data files, not reports) and we were using Excel,
> which
> consumes a tremendous amount of memory. Microsoft's answer was that we
> should not be using RS to deliver files, only reports of a printable size,
> i.e. not 300 page reports.
>
> "Kavitha" wrote:
>> Stephanie, I am also facing the same issue in the same kind of 64-bit OS,
>> RS2005.
>> Have you got any solution to this issue?
>> Kavitha
>> url:http://www.ureader.com/msg/115713370.aspx|||Thanks, Bruce. I think that is exactly the direction that we are going in.
Stephanie
"Bruce L-C [MVP]" wrote:
> Keep in mind that if you want to bring over data try CSV ASCII instead of
> Excel for large data amounts of data.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
> > The volume of data being brought back in our case was too large (we were
> > trying to bring back data files, not reports) and we were using Excel,
> > which
> > consumes a tremendous amount of memory. Microsoft's answer was that we
> > should not be using RS to deliver files, only reports of a printable size,
> > i.e. not 300 page reports.
> >
> >
> > "Kavitha" wrote:
> >
> >> Stephanie, I am also facing the same issue in the same kind of 64-bit OS,
> >> RS2005.
> >>
> >> Have you got any solution to this issue?
> >>
> >> Kavitha
> >>
> >> url:http://www.ureader.com/msg/115713370.aspx
> >>
>
>|||One other point then (that is obscure) there is a server setting that will
default CSV to ascii so that Excel brings up the data properly split between
cells. Otherwise the default is unicode that Excel doesn't know what to do
with so it puts it all into one column that the user then has to split
(there is a menu in Excel to do this).
Let me know if you need the config setting for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:C7FD6C07-7965-4D15-AA73-F2DBC217559C@.microsoft.com...
> Thanks, Bruce. I think that is exactly the direction that we are going
> in.
> Stephanie
>
> "Bruce L-C [MVP]" wrote:
>> Keep in mind that if you want to bring over data try CSV ASCII instead of
>> Excel for large data amounts of data.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
>> > The volume of data being brought back in our case was too large (we
>> > were
>> > trying to bring back data files, not reports) and we were using Excel,
>> > which
>> > consumes a tremendous amount of memory. Microsoft's answer was that
>> > we
>> > should not be using RS to deliver files, only reports of a printable
>> > size,
>> > i.e. not 300 page reports.
>> >
>> >
>> > "Kavitha" wrote:
>> >
>> >> Stephanie, I am also facing the same issue in the same kind of 64-bit
>> >> OS,
>> >> RS2005.
>> >>
>> >> Have you got any solution to this issue?
>> >>
>> >> Kavitha
>> >>
>> >> url:http://www.ureader.com/msg/115713370.aspx
>> >>
>>|||Really? That would be GREAT! I'm always having to break it up into the
multiple columns manually. I didn't know that you could have this done
automatically. This is a RS configuration setting? Or RS server setting?
How do I update that setting?
Stephanie
"Bruce L-C [MVP]" wrote:
> One other point then (that is obscure) there is a server setting that will
> default CSV to ascii so that Excel brings up the data properly split between
> cells. Otherwise the default is unicode that Excel doesn't know what to do
> with so it puts it all into one column that the user then has to split
> (there is a menu in Excel to do this).
> Let me know if you need the config setting for this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:C7FD6C07-7965-4D15-AA73-F2DBC217559C@.microsoft.com...
> > Thanks, Bruce. I think that is exactly the direction that we are going
> > in.
> >
> > Stephanie
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Keep in mind that if you want to bring over data try CSV ASCII instead of
> >> Excel for large data amounts of data.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> >> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
> >> > The volume of data being brought back in our case was too large (we
> >> > were
> >> > trying to bring back data files, not reports) and we were using Excel,
> >> > which
> >> > consumes a tremendous amount of memory. Microsoft's answer was that
> >> > we
> >> > should not be using RS to deliver files, only reports of a printable
> >> > size,
> >> > i.e. not 300 page reports.
> >> >
> >> >
> >> > "Kavitha" wrote:
> >> >
> >> >> Stephanie, I am also facing the same issue in the same kind of 64-bit
> >> >> OS,
> >> >> RS2005.
> >> >>
> >> >> Have you got any solution to this issue?
> >> >>
> >> >> Kavitha
> >> >>
> >> >> url:http://www.ureader.com/msg/115713370.aspx
> >> >>
> >>
> >>
> >>
>
>|||You only need to change in one place, rsreportserver.config. Reboot after
the change. The below shows commenting out the existing entry and putting in
the needed change to have CSV export as ASCII. I can understand this being a
default for MS because they are so international oriented but seeing as how
Excel doesn't understand Unicode CSV (at least through Excel 2003) , I don't
know about the most recent version. Anyway, this works great.
<!--
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
-->
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
The other option is to use Jump to URL. 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'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
I configure my server to export CSV in ASCII. Much handier.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:F3F00888-F052-4EFD-9079-29E829EB63F3@.microsoft.com...
> Really? That would be GREAT! I'm always having to break it up into the
> multiple columns manually. I didn't know that you could have this done
> automatically. This is a RS configuration setting? Or RS server setting?
> How do I update that setting?
> Stephanie
>
> "Bruce L-C [MVP]" wrote:
>> One other point then (that is obscure) there is a server setting that
>> will
>> default CSV to ascii so that Excel brings up the data properly split
>> between
>> cells. Otherwise the default is unicode that Excel doesn't know what to
>> do
>> with so it puts it all into one column that the user then has to split
>> (there is a menu in Excel to do this).
>> Let me know if you need the config setting for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:C7FD6C07-7965-4D15-AA73-F2DBC217559C@.microsoft.com...
>> > Thanks, Bruce. I think that is exactly the direction that we are going
>> > in.
>> >
>> > Stephanie
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Keep in mind that if you want to bring over data try CSV ASCII instead
>> >> of
>> >> Excel for large data amounts of data.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> >> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
>> >> > The volume of data being brought back in our case was too large (we
>> >> > were
>> >> > trying to bring back data files, not reports) and we were using
>> >> > Excel,
>> >> > which
>> >> > consumes a tremendous amount of memory. Microsoft's answer was
>> >> > that
>> >> > we
>> >> > should not be using RS to deliver files, only reports of a printable
>> >> > size,
>> >> > i.e. not 300 page reports.
>> >> >
>> >> >
>> >> > "Kavitha" wrote:
>> >> >
>> >> >> Stephanie, I am also facing the same issue in the same kind of
>> >> >> 64-bit
>> >> >> OS,
>> >> >> RS2005.
>> >> >>
>> >> >> Have you got any solution to this issue?
>> >> >>
>> >> >> Kavitha
>> >> >>
>> >> >> url:http://www.ureader.com/msg/115713370.aspx
>> >> >>
>> >>
>> >>
>> >>
>>|||Bruce,
Great. I'll try the config change. I'm going to do some testing in my
development environment. Do I have to reboot the RS server or can I just
restart RS?
Stephanie
"Bruce L-C [MVP]" wrote:
> You only need to change in one place, rsreportserver.config. Reboot after
> the change. The below shows commenting out the existing entry and putting in
> the needed change to have CSV export as ASCII. I can understand this being a
> default for MS because they are so international oriented but seeing as how
> Excel doesn't understand Unicode CSV (at least through Excel 2003) , I don't
> know about the most recent version. Anyway, this works great.
> <!--
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
> -->
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
> <Configuration>
> <DeviceInfo>
> <Encoding>ASCII</Encoding>
> </DeviceInfo>
> </Configuration>
> </Extension>
> The other option is to use Jump to URL. 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'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
> I configure my server to export CSV in ASCII. Much handier.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:F3F00888-F052-4EFD-9079-29E829EB63F3@.microsoft.com...
> > Really? That would be GREAT! I'm always having to break it up into the
> > multiple columns manually. I didn't know that you could have this done
> > automatically. This is a RS configuration setting? Or RS server setting?
> >
> > How do I update that setting?
> >
> > Stephanie
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> One other point then (that is obscure) there is a server setting that
> >> will
> >> default CSV to ascii so that Excel brings up the data properly split
> >> between
> >> cells. Otherwise the default is unicode that Excel doesn't know what to
> >> do
> >> with so it puts it all into one column that the user then has to split
> >> (there is a menu in Excel to do this).
> >>
> >> Let me know if you need the config setting for this.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> >> news:C7FD6C07-7965-4D15-AA73-F2DBC217559C@.microsoft.com...
> >> > Thanks, Bruce. I think that is exactly the direction that we are going
> >> > in.
> >> >
> >> > Stephanie
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Keep in mind that if you want to bring over data try CSV ASCII instead
> >> >> of
> >> >> Excel for large data amounts of data.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> >> >> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
> >> >> > The volume of data being brought back in our case was too large (we
> >> >> > were
> >> >> > trying to bring back data files, not reports) and we were using
> >> >> > Excel,
> >> >> > which
> >> >> > consumes a tremendous amount of memory. Microsoft's answer was
> >> >> > that
> >> >> > we
> >> >> > should not be using RS to deliver files, only reports of a printable
> >> >> > size,
> >> >> > i.e. not 300 page reports.
> >> >> >
> >> >> >
> >> >> > "Kavitha" wrote:
> >> >> >
> >> >> >> Stephanie, I am also facing the same issue in the same kind of
> >> >> >> 64-bit
> >> >> >> OS,
> >> >> >> RS2005.
> >> >> >>
> >> >> >> Have you got any solution to this issue?
> >> >> >>
> >> >> >> Kavitha
> >> >> >>
> >> >> >> url:http://www.ureader.com/msg/115713370.aspx
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I would assume restart will do it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:8A028412-E210-4A2D-8CC5-E395E5BD3474@.microsoft.com...
> Bruce,
> Great. I'll try the config change. I'm going to do some testing in my
> development environment. Do I have to reboot the RS server or can I just
> restart RS?
> Stephanie
>
> "Bruce L-C [MVP]" wrote:
>> You only need to change in one place, rsreportserver.config. Reboot after
>> the change. The below shows commenting out the existing entry and putting
>> in
>> the needed change to have CSV export as ASCII. I can understand this
>> being a
>> default for MS because they are so international oriented but seeing as
>> how
>> Excel doesn't understand Unicode CSV (at least through Excel 2003) , I
>> don't
>> know about the most recent version. Anyway, this works great.
>> <!--
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
>> -->
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
>> <Configuration>
>> <DeviceInfo>
>> <Encoding>ASCII</Encoding>
>> </DeviceInfo>
>> </Configuration>
>> </Extension>
>> The other option is to use Jump to URL. 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'))"
>> If you don't want to have it appear in a new window then do this in jump
>> to
>> URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>> I configure my server to export CSV in ASCII. Much handier.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:F3F00888-F052-4EFD-9079-29E829EB63F3@.microsoft.com...
>> > Really? That would be GREAT! I'm always having to break it up into
>> > the
>> > multiple columns manually. I didn't know that you could have this done
>> > automatically. This is a RS configuration setting? Or RS server
>> > setting?
>> >
>> > How do I update that setting?
>> >
>> > Stephanie
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> One other point then (that is obscure) there is a server setting that
>> >> will
>> >> default CSV to ascii so that Excel brings up the data properly split
>> >> between
>> >> cells. Otherwise the default is unicode that Excel doesn't know what
>> >> to
>> >> do
>> >> with so it puts it all into one column that the user then has to split
>> >> (there is a menu in Excel to do this).
>> >>
>> >> Let me know if you need the config setting for this.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> >> news:C7FD6C07-7965-4D15-AA73-F2DBC217559C@.microsoft.com...
>> >> > Thanks, Bruce. I think that is exactly the direction that we are
>> >> > going
>> >> > in.
>> >> >
>> >> > Stephanie
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Keep in mind that if you want to bring over data try CSV ASCII
>> >> >> instead
>> >> >> of
>> >> >> Excel for large data amounts of data.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> >> >> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
>> >> >> > The volume of data being brought back in our case was too large
>> >> >> > (we
>> >> >> > were
>> >> >> > trying to bring back data files, not reports) and we were using
>> >> >> > Excel,
>> >> >> > which
>> >> >> > consumes a tremendous amount of memory. Microsoft's answer was
>> >> >> > that
>> >> >> > we
>> >> >> > should not be using RS to deliver files, only reports of a
>> >> >> > printable
>> >> >> > size,
>> >> >> > i.e. not 300 page reports.
>> >> >> >
>> >> >> >
>> >> >> > "Kavitha" wrote:
>> >> >> >
>> >> >> >> Stephanie, I am also facing the same issue in the same kind of
>> >> >> >> 64-bit
>> >> >> >> OS,
>> >> >> >> RS2005.
>> >> >> >>
>> >> >> >> Have you got any solution to this issue?
>> >> >> >>
>> >> >> >> Kavitha
>> >> >> >>
>> >> >> >> url:http://www.ureader.com/msg/115713370.aspx
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

New Reporting Control

Does the new report control for vs 2005 utilize SOAP or the URL method
to access the report server?
I need to utilize a pure SOAP based solution to get reports from the
report server. Just curious if the new solution is used that way or if
rolling my own is the only option.
ThanksThe new controls use soap (web services). They are a much more complete
solution that the old way.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vivaldi" <ZachMattson@.gmail.com> wrote in message
news:1131634098.219113.321000@.g49g2000cwa.googlegroups.com...
> Does the new report control for vs 2005 utilize SOAP or the URL method
> to access the report server?
> I need to utilize a pure SOAP based solution to get reports from the
> report server. Just curious if the new solution is used that way or if
> rolling my own is the only option.
> Thanks
>

New report controls

I've read that RDL is extensible. Is it possible to write a new control that will go into your toolbox for a report?
IE - Different types of charts or listing view or something?
ThanksNot in v1. However this is on our wishlist for Yukon. (SQL Server 2005).
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:erDhLkgWEHA.500@.TK2MSFTNGP09.phx.gbl...
> I've read that RDL is extensible. Is it possible to write a new control
> that will go into your toolbox for a report?
> IE - Different types of charts or listing view or something?
> Thanks
>

New Line in a TextBox

In a report, I have a textbox... and I want to make a new line in the
expression builder...
I tried that
=Fields!ShipToName.Value & "\n" & Fields!ShipToAddress.Value
but the \n is not recognized
I have tried without the quote, with singles quotes, ... but no way...
It is a really stupid question and I haven't found an answer
Thanks for the one who answersYou could try this:
=Fields!ShipToName.Value & vbcrlf & Fields!ShipToAddress.Value
or
=Fields!ShipToName.Value & ControlChars.CrLf &
Fields!ShipToAddress.Value
I haven't verified how these will behave with different rendering.
This page has some info on the control characters:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vamscmiscellaneousconstants.asp
Good Luck,
Dan|||I always use Environment.NewLine which will work no matter what the viewer
is.
Craig
"Hasan Ozdil" <hasan.ozdil@.gmail.com> wrote in message
news:1141206171.555868.323910@.i40g2000cwc.googlegroups.com...
> In a report, I have a textbox... and I want to make a new line in the
> expression builder...
> I tried that
> =Fields!ShipToName.Value & "\n" & Fields!ShipToAddress.Value
> but the \n is not recognized
> I have tried without the quote, with singles quotes, ... but no way...
> It is a really stupid question and I haven't found an answer
> Thanks for the one who answers
>|||Environment.NewLine works perfectly !!
Thank you Craig|||Craig, that was a great tip! I have fields in a database that have line
feeds between lines and your tip with a function fixed it right up.
=Replace(Fields!fieldname.Value, vbLf, Environment.NewLine)
Worked like a champ, thanks a million.
Larry

new IE instance opening periodically when SSRS report open

Hi All.
Few people is receiving this strange issue and I cannot find any
resolution for this.
Issue is exactly with subject. It's happening only when SSRS report is
opened.
So it's opening a new window with this url:
https://website/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=ui2iiomxhroymbrzv5p5aymx&ControlID=5b14ab22-5967-43af-a9bf-ab75feea60ba&Culture=1033&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&Interval=1139000
Any idea what setting may be causing this strang behaviour'
Thanks,
Maciej ChojnackiOn 18 Sty, 10:33, MacChojna...@.googlemail.com wrote:
I forgot to add that report is displayed in ASP.net site and is
embedded in IFrame.

New hidden parameters question

I can see (and have read a little about it here) in Report Manager where you can hide parameters. Why isn't this exposed in the
API? Why can't I set them to be hidden in VS?
Did my service pack maybe not install okay.
ThanksIf you clear the prompt string in the Report Designer parameters dialog, the
parameter automatically becomes hidden. See the SP1 readme for more details.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:O92Ik9tWEHA.3476@.tk2msftngp13.phx.gbl...
> I can see (and have read a little about it here) in Report Manager where
you can hide parameters. Why isn't this exposed in the
> API? Why can't I set them to be hidden in VS?
> Did my service pack maybe not install okay.
> Thanks
>|||You have to set the "Prompt User" check box to checked, and the "Prompt
String" textbox to empty.
"vrodkar" <vrodkar@.discussions.microsoft.com> wrote in message
news:BB9DDE10-B40E-4B5F-AF94-E395FE85D593@.microsoft.com...
> I am using stored procedure which needs user_id as a parameter. I am also
using url access methode to pass this user_id parameter. I have applied SP1.
When I make this parameter non-prompting. I get an error that the parameter
is read only and cannot be set. If I make it promptable, it shows as a
parameter and user can then may enter another Id to see other records. How
can I resolve this. My URL looks like this.
> http://d9sql02/reportserver?/reports/report1&rs:Command=Render&user_id=h5
> "Bryan Keller [MSFT]" wrote:
> > If you clear the prompt string in the Report Designer parameters dialog,
the
> > parameter automatically becomes hidden. See the SP1 readme for more
details.
> >
> > --
> > Bryan Keller
> > Developer Documentation
> > SQL Server Reporting Services
> >
> > A friendly reminder that this posting is provided "AS IS" with no
> > warranties, and confers no rights.
> >
> >
> > "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in
message
> > news:O92Ik9tWEHA.3476@.tk2msftngp13.phx.gbl...
> > > I can see (and have read a little about it here) in Report Manager
where
> > you can hide parameters. Why isn't this exposed in the
> > > API? Why can't I set them to be hidden in VS?
> > >
> > > Did my service pack maybe not install okay.
> > >
> > > Thanks
> > >
> > >
> >
> >
> >|||You can clear the prompt string from the properties page of the report in
Report Manager after the report is published.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Chrissie" <Chrissie@.discussions.microsoft.com> wrote in message
news:95FCBC69-90BE-44A8-9801-701CBD15BB38@.microsoft.com...
> If I clear the prompt string in the Report Designer, the parameter becomes
> Hidden and read-only. How do I set the parameter in Report Designer to be
> Hidden but not Read-only.
> If I insert a space in the prompt box, the parameter becomes Hidden but
not
> Read-only, but once I close and repopen the project, the prompt box is
> automatically cleared and my parameter is back to being read-only.
> Chrissie
> "Bryan Keller [MSFT]" wrote:
> > If you clear the prompt string in the Report Designer parameters dialog,
the
> > parameter automatically becomes hidden. See the SP1 readme for more
details.
> >
> > --
> > Bryan Keller
> > Developer Documentation
> > SQL Server Reporting Services
> >
> > A friendly reminder that this posting is provided "AS IS" with no
> > warranties, and confers no rights.
> >
> >
> > "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in
message
> > news:O92Ik9tWEHA.3476@.tk2msftngp13.phx.gbl...
> > > I can see (and have read a little about it here) in Report Manager
where
> > you can hide parameters. Why isn't this exposed in the
> > > API? Why can't I set them to be hidden in VS?
> > >
> > > Did my service pack maybe not install okay.
> > >
> > > Thanks
> > >
> > >
> >
> >
> >|||Obviously. But that is not a very practical suggestion as I will have a fair
number of reports and an even fairer number of parameters to reset every time
after installing at a client.
"Brian Hartman [MSFT]" wrote:
> You can clear the prompt string from the properties page of the report in
> Report Manager after the report is published.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Chrissie" <Chrissie@.discussions.microsoft.com> wrote in message
> news:95FCBC69-90BE-44A8-9801-701CBD15BB38@.microsoft.com...
> > If I clear the prompt string in the Report Designer, the parameter becomes
> > Hidden and read-only. How do I set the parameter in Report Designer to be
> > Hidden but not Read-only.
> >
> > If I insert a space in the prompt box, the parameter becomes Hidden but
> not
> > Read-only, but once I close and repopen the project, the prompt box is
> > automatically cleared and my parameter is back to being read-only.
> >
> > Chrissie
> >
> > "Bryan Keller [MSFT]" wrote:
> >
> > > If you clear the prompt string in the Report Designer parameters dialog,
> the
> > > parameter automatically becomes hidden. See the SP1 readme for more
> details.
> > >
> > > --
> > > Bryan Keller
> > > Developer Documentation
> > > SQL Server Reporting Services
> > >
> > > A friendly reminder that this posting is provided "AS IS" with no
> > > warranties, and confers no rights.
> > >
> > >
> > > "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in
> message
> > > news:O92Ik9tWEHA.3476@.tk2msftngp13.phx.gbl...
> > > > I can see (and have read a little about it here) in Report Manager
> where
> > > you can hide parameters. Why isn't this exposed in the
> > > > API? Why can't I set them to be hidden in VS?
> > > >
> > > > Did my service pack maybe not install okay.
> > > >
> > > > Thanks
> > > >
> > > >
> > >
> > >
> > >
>
>

New Folder link not doing anything

Ive just installed Reporting Services onto Window 2003. I have Visual studio
2003 installed and IIS 6
When I go to the report manager the 'New folder' link does not work nor can
i create a new data source or upload a file. I click on these and nothing
happens.
When I go to a different machine other than the one where the server is
installed and go to the Report manager URL these links work, however this is
problematic as the datasource and reports etc sit on the server.
Anyone have any similar problems?.. what i do notice is on the server i am
prompted for a username and password each time i start report manager and am
thinking this might have something to do with it, on a different machine i am
prompted once and then not again.
thanksAdd the URL to your report server to Local Intranet Sites in your browser.
That should take care of the username prompting, and might solve the
problems with the links not working.
Add http://myreportserver/ , not http://myreportserver/reports.
Kaisa M. Lindahl Lervik
"Charlie" <Charlie@.discussions.microsoft.com> wrote in message
news:5202B8BA-910D-4B66-A87F-7149FAC3CED3@.microsoft.com...
> Ive just installed Reporting Services onto Window 2003. I have Visual
> studio
> 2003 installed and IIS 6
> When I go to the report manager the 'New folder' link does not work nor
> can
> i create a new data source or upload a file. I click on these and nothing
> happens.
> When I go to a different machine other than the one where the server is
> installed and go to the Report manager URL these links work, however this
> is
> problematic as the datasource and reports etc sit on the server.
> Anyone have any similar problems?.. what i do notice is on the server i am
> prompted for a username and password each time i start report manager and
> am
> thinking this might have something to do with it, on a different machine i
> am
> prompted once and then not again.
> thanks|||If this is Reporting Services 1.1, then you may need to edit the config
files. I recall that something like http://machinename is stored in some
values by the isntallation routine. If you access SRS with a name other
than the machine name, the buttons stop working. Look in both config files
for Reports and ReportServer.
- Chris
"Charlie" <Charlie@.discussions.microsoft.com> wrote in message
news:5202B8BA-910D-4B66-A87F-7149FAC3CED3@.microsoft.com...
> Ive just installed Reporting Services onto Window 2003. I have Visual
> studio
> 2003 installed and IIS 6
> When I go to the report manager the 'New folder' link does not work nor
> can
> i create a new data source or upload a file. I click on these and nothing
> happens.
> When I go to a different machine other than the one where the server is
> installed and go to the Report manager URL these links work, however this
> is
> problematic as the datasource and reports etc sit on the server.
> Anyone have any similar problems?.. what i do notice is on the server i am
> prompted for a username and password each time i start report manager and
> am
> thinking this might have something to do with it, on a different machine i
> am
> prompted once and then not again.
> thanks

New export option

Hello Fellow RS
Has anyone ever heard of or tried adding to the report export list?
I've read through the BOL for report export options and searched the
web for advice. There is quite a bit of information folks have shared
on ways to export stored procedure results to a fixed length text
file. But I haven't found anything on exporting from a report to a
text file.
Is it was possible to export a report into a fixed length text file
from a Reporting Services website report?The only text based export that Reporting Services does is CSV (Comma
Delimited). On adding a type to the export list you would have to write
your own rendering extension to transform the data in the report and that
isn't an easy task. If you look in the rsreportserver.config file you'll
see a <Render> section that contains all of the various rendering
extensions available to Reporting Services.
You can find more information about creating a rendering extension here:
http://msdn2.microsoft.com/en-us/library/ms153624.aspx
One last question. When you say "Fixed length text file" do you mean a
"fixed width" text file or an actual fixed size of the text file being
produced?
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: asflp <fpetrivelli@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: New export option
> Date: Fri, 26 Oct 2007 17:12:18 -0000
> Organization: http://groups.google.com
> Hello Fellow RS
> Has anyone ever heard of or tried adding to the report export list?
> I've read through the BOL for report export options and searched the
> web for advice. There is quite a bit of information folks have shared
> on ways to export stored procedure results to a fixed length text
> file. But I haven't found anything on exporting from a report to a
> text file.
> Is it was possible to export a report into a fixed length text file
> from a Reporting Services website report?
>|||On Oct 26, 10:46 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> The only text based export that Reporting Services does is CSV (Comma
> Delimited). On adding a type to the export list you would have to write
> your own rendering extension to transform the data in the report and that
> isn't an easy task. If you look in the rsreportserver.config file you'll
> see a <Render> section that contains all of the various rendering
> extensions available to Reporting Services.
> You can find more information about creating a rendering extension here:
> http://msdn2.microsoft.com/en-us/library/ms153624.aspx
> One last question. When you say "Fixed length text file" do you mean a
> "fixed width" text file or an actual fixed size of the text file being
> produced?
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: asflp <fpetrive...@.gmail.com>
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: New export option
> > Date: Fri, 26 Oct 2007 17:12:18 -0000
> > Organization:http://groups.google.com
> > Hello Fellow RS
> > Has anyone ever heard of or tried adding to the report export list?
> > I've read through the BOL for report export options and searched the
> > web for advice. There is quite a bit of information folks have shared
> > on ways to export stored procedure results to a fixed length text
> > file. But I haven't found anything on exporting from a report to a
> > text file.
> > Is it was possible to export a report into a fixed length text file
> > from a Reporting Services website report... Hide quoted text -
> - Show quoted text -
Thanks for your response.
I'm beginning to think that SS Integration Services would be the best
bet to accomplish this task.
(And I did mean fixed width columns in the text file.)
Thanks again!|||On Oct 26, 12:09 pm, asflp <fpetrive...@.gmail.com> wrote:
> On Oct 26, 10:46 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
>
>
> > The only text based export that Reporting Services does is CSV (Comma
> > Delimited). On adding a type to the export list you would have to write
> > your own rendering extension to transform the data in the report and that
> > isn't an easy task. If you look in the rsreportserver.config file you'll
> > see a <Render> section that contains all of the various rendering
> > extensions available to Reporting Services.
> > You can find more information about creating a rendering extension here:
> >http://msdn2.microsoft.com/en-us/library/ms153624.aspx
> > One last question. When you say "Fixed length text file" do you mean a
> > "fixed width" text file or an actual fixed size of the text file being
> > produced?
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> > --
> > > From: asflp <fpetrive...@.gmail.com>
> > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > Subject: New export option
> > > Date: Fri, 26 Oct 2007 17:12:18 -0000
> > > Organization:http://groups.google.com
> > > Hello Fellow RS
> > > Has anyone ever heard of or tried adding to the report export list?
> > > I've read through the BOL for report export options and searched the
> > > web for advice. There is quite a bit of information folks have shared
> > > on ways to export stored procedure results to a fixed length text
> > > file. But I haven't found anything on exporting from a report to a
> > > text file.
> > > Is it was possible to export a report into a fixed length text file
> > > from a Reporting Services website report... Hide quoted text -
> > - Show quoted text -
> Thanks for your response.
> I'm beginning to think that SS Integration Services would be the best
> bet to accomplish this task.
> (And I did mean fixed width columns in the text file.)
> Thanks again!- Hide quoted text -
> - Show quoted text -
Just an add-on comment, I followed the link and I really can't tell
you why I didn't get to that part of BOL when I was reading about the
export options. BOL certainly is vast and interesting to navigate.|||You have to know the secret code word and hand shake to be able to really
search books online :)
It's always easy to find things when you know exactly what you are looking
for. If you search for "custom rendering extension" then you'll find that
section as the first result. If you have no clue that is what it is that
you are trying to do then searching for that stuff can be quite difficult.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: asflp <fpetrivelli@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: New export option
> Date: Fri, 26 Oct 2007 19:25:57 -0000
> Organization: http://groups.google.com
> Lines: 65
> On Oct 26, 12:09 pm, asflp <fpetrive...@.gmail.com> wrote:
> > On Oct 26, 10:46 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> > wrote:
> >
> >
> >
> >
> >
> > > The only text based export that Reporting Services does is CSV (Comma
> > > Delimited). On adding a type to the export list you would have to
write
> > > your own rendering extension to transform the data in the report and
that
> > > isn't an easy task. If you look in the rsreportserver.config file
you'll
> > > see a <Render> section that contains all of the various rendering
> > > extensions available to Reporting Services.
> >
> > > You can find more information about creating a rendering extension
here:
> >
> > >http://msdn2.microsoft.com/en-us/library/ms153624.aspx
> >
> > > One last question. When you say "Fixed length text file" do you mean a
> > > "fixed width" text file or an actual fixed size of the text file being
> > > produced?
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > > --
> >
> > > > From: asflp <fpetrive...@.gmail.com>
> > > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > > Subject: New export option
> > > > Date: Fri, 26 Oct 2007 17:12:18 -0000
> > > > Organization:http://groups.google.com
> >
> > > > Hello Fellow RS
> >
> > > > Has anyone ever heard of or tried adding to the report export list?
> >
> > > > I've read through the BOL for report export options and searched the
> > > > web for advice. There is quite a bit of information folks have
shared
> > > > on ways to export stored procedure results to a fixed length text
> > > > file. But I haven't found anything on exporting from a report to a
> > > > text file.
> >
> > > > Is it was possible to export a report into a fixed length text file
> > > > from a Reporting Services website report... Hide quoted text -
> >
> > > - Show quoted text -
> >
> > Thanks for your response.
> >
> > I'm beginning to think that SS Integration Services would be the best
> > bet to accomplish this task.
> >
> > (And I did mean fixed width columns in the text file.)
> >
> > Thanks again!- Hide quoted text -
> >
> > - Show quoted text -
> Just an add-on comment, I followed the link and I really can't tell
> you why I didn't get to that part of BOL when I was reading about the
> export options. BOL certainly is vast and interesting to navigate.
>
>

New Data for the same report

Hello!
I have a question - i hope some one can help me...
I have a report that gets an id as a parameter and get the data for this ID.
In the same Stored Procedure where i get this data - i also update the data
(change status...).
Now when i do "view report" again on the same ID - i don't see the changes...
Only when i go and put other ID ,press "view report" and then go back to the
first ID - then i see the changes.
It seems that the reporting does not go and bring the data every time i
press on "View Report" unless i change the parameter (which means that i
force the action of going again to the Data Base and bringing data)
Do you know how i make the report go and bring the data every time i press
on "view report" ?
Please HELP!
ThanksThis is definitely true from the development environment. That is a feature
of the IDE (I suppose so you can develop with long running reports without
having it have to run the query over and over again. Have you tried this
with a deployed report?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Penker" <Penker@.discussions.microsoft.com> wrote in message
news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> Hello!
> I have a question - i hope some one can help me...
> I have a report that gets an id as a parameter and get the data for this
> ID.
> In the same Stored Procedure where i get this data - i also update the
> data
> (change status...).
> Now when i do "view report" again on the same ID - i don't see the
> changes...
> Only when i go and put other ID ,press "view report" and then go back to
> the
> first ID - then i see the changes.
> It seems that the reporting does not go and bring the data every time i
> press on "View Report" unless i change the parameter (which means that i
> force the action of going again to the Data Base and bringing data)
> Do you know how i make the report go and bring the data every time i press
> on "view report" ?
> Please HELP!
> Thanks|||Yes - The reports i use (from an application) are all deployed.
I have an application that on a link "click" it open a report from the
Reporting Service
while sending it his parameters. Now when i send the same parameter twice it
returns the same data (even it already changed after the first time)...
Can you help me?
"Bruce L-C [MVP]" wrote:
> This is definitely true from the development environment. That is a feature
> of the IDE (I suppose so you can develop with long running reports without
> having it have to run the query over and over again. Have you tried this
> with a deployed report?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Penker" <Penker@.discussions.microsoft.com> wrote in message
> news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> > Hello!
> > I have a question - i hope some one can help me...
> > I have a report that gets an id as a parameter and get the data for this
> > ID.
> > In the same Stored Procedure where i get this data - i also update the
> > data
> > (change status...).
> > Now when i do "view report" again on the same ID - i don't see the
> > changes...
> > Only when i go and put other ID ,press "view report" and then go back to
> > the
> > first ID - then i see the changes.
> > It seems that the reporting does not go and bring the data every time i
> > press on "View Report" unless i change the parameter (which means that i
> > force the action of going again to the Data Base and bringing data)
> > Do you know how i make the report go and bring the data every time i press
> > on "view report" ?
> > Please HELP!
> > Thanks
>
>|||Caching is set at the server. The default is for it not to be cached. I
think what is happening is you are coming up against your web page doing
caching. One way you can test this is to do the following. Open up your
report using reporting manager.Click on the View Report button. Click on it
a second time, I bet it works the way you want it to.
For the web page you are hosting the report in make sure it is not being
cached. I forget the line you put in the page but there is a html tag you
can put that tell ASP to not cache the web page.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Penker" <Penker@.discussions.microsoft.com> wrote in message
news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
> Yes - The reports i use (from an application) are all deployed.
> I have an application that on a link "click" it open a report from the
> Reporting Service
> while sending it his parameters. Now when i send the same parameter twice
it
> returns the same data (even it already changed after the first time)...
> Can you help me?
> "Bruce L-C [MVP]" wrote:
> > This is definitely true from the development environment. That is a
feature
> > of the IDE (I suppose so you can develop with long running reports
without
> > having it have to run the query over and over again. Have you tried this
> > with a deployed report?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Penker" <Penker@.discussions.microsoft.com> wrote in message
> > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> > > Hello!
> > > I have a question - i hope some one can help me...
> > > I have a report that gets an id as a parameter and get the data for
this
> > > ID.
> > > In the same Stored Procedure where i get this data - i also update
the
> > > data
> > > (change status...).
> > > Now when i do "view report" again on the same ID - i don't see the
> > > changes...
> > > Only when i go and put other ID ,press "view report" and then go back
to
> > > the
> > > first ID - then i see the changes.
> > > It seems that the reporting does not go and bring the data every time
i
> > > press on "View Report" unless i change the parameter (which means that
i
> > > force the action of going again to the Data Base and bringing data)
> > > Do you know how i make the report go and bring the data every time i
press
> > > on "view report" ?
> > > Please HELP!
> > > Thanks
> >
> >
> >|||Hi!
I know that caching is set at the server - been there tried that...
Also tried to open the report using reporting manager and click on the View
Report button - it doesn't work
but - about this Tag you are talking about - is there any way to pass this
tag in the url that 'call' the report?
i use "window.open(...)" in Java Script...
Thanks!!!
"Bruce L-C [MVP]" wrote:
> Caching is set at the server. The default is for it not to be cached. I
> think what is happening is you are coming up against your web page doing
> caching. One way you can test this is to do the following. Open up your
> report using reporting manager.Click on the View Report button. Click on it
> a second time, I bet it works the way you want it to.
> For the web page you are hosting the report in make sure it is not being
> cached. I forget the line you put in the page but there is a html tag you
> can put that tell ASP to not cache the web page.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Penker" <Penker@.discussions.microsoft.com> wrote in message
> news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
> > Yes - The reports i use (from an application) are all deployed.
> > I have an application that on a link "click" it open a report from the
> > Reporting Service
> > while sending it his parameters. Now when i send the same parameter twice
> it
> > returns the same data (even it already changed after the first time)...
> > Can you help me?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > This is definitely true from the development environment. That is a
> feature
> > > of the IDE (I suppose so you can develop with long running reports
> without
> > > having it have to run the query over and over again. Have you tried this
> > > with a deployed report?
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Penker" <Penker@.discussions.microsoft.com> wrote in message
> > > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> > > > Hello!
> > > > I have a question - i hope some one can help me...
> > > > I have a report that gets an id as a parameter and get the data for
> this
> > > > ID.
> > > > In the same Stored Procedure where i get this data - i also update
> the
> > > > data
> > > > (change status...).
> > > > Now when i do "view report" again on the same ID - i don't see the
> > > > changes...
> > > > Only when i go and put other ID ,press "view report" and then go back
> to
> > > > the
> > > > first ID - then i see the changes.
> > > > It seems that the reporting does not go and bring the data every time
> i
> > > > press on "View Report" unless i change the parameter (which means that
> i
> > > > force the action of going again to the Data Base and bringing data)
> > > > Do you know how i make the report go and bring the data every time i
> press
> > > > on "view report" ?
> > > > Please HELP!
> > > > Thanks
> > >
> > >
> > >
>
>|||Are you saying that when you click on the View Report button, it too is not
showing the data? Because if that doesn't work then no need to worry about
anything else until that is resolved. View Report button should always show
the most recent data.
I know of no way to set the html tag on the url.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Penker" <Penker@.discussions.microsoft.com> wrote in message
news:5D7088B9-F337-4C0F-B2B9-073761CC5994@.microsoft.com...
> Hi!
> I know that caching is set at the server - been there tried that...
> Also tried to open the report using reporting manager and click on the
View
> Report button - it doesn't work
> but - about this Tag you are talking about - is there any way to pass this
> tag in the url that 'call' the report?
> i use "window.open(...)" in Java Script...
> Thanks!!!
> "Bruce L-C [MVP]" wrote:
> > Caching is set at the server. The default is for it not to be cached. I
> > think what is happening is you are coming up against your web page doing
> > caching. One way you can test this is to do the following. Open up your
> > report using reporting manager.Click on the View Report button. Click on
it
> > a second time, I bet it works the way you want it to.
> >
> > For the web page you are hosting the report in make sure it is not being
> > cached. I forget the line you put in the page but there is a html tag
you
> > can put that tell ASP to not cache the web page.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Penker" <Penker@.discussions.microsoft.com> wrote in message
> > news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
> > > Yes - The reports i use (from an application) are all deployed.
> > > I have an application that on a link "click" it open a report from
the
> > > Reporting Service
> > > while sending it his parameters. Now when i send the same parameter
twice
> > it
> > > returns the same data (even it already changed after the first
time)...
> > > Can you help me?
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > This is definitely true from the development environment. That is a
> > feature
> > > > of the IDE (I suppose so you can develop with long running reports
> > without
> > > > having it have to run the query over and over again. Have you tried
this
> > > > with a deployed report?
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Penker" <Penker@.discussions.microsoft.com> wrote in message
> > > > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> > > > > Hello!
> > > > > I have a question - i hope some one can help me...
> > > > > I have a report that gets an id as a parameter and get the data
for
> > this
> > > > > ID.
> > > > > In the same Stored Procedure where i get this data - i also
update
> > the
> > > > > data
> > > > > (change status...).
> > > > > Now when i do "view report" again on the same ID - i don't see the
> > > > > changes...
> > > > > Only when i go and put other ID ,press "view report" and then go
back
> > to
> > > > > the
> > > > > first ID - then i see the changes.
> > > > > It seems that the reporting does not go and bring the data every
time
> > i
> > > > > press on "View Report" unless i change the parameter (which means
that
> > i
> > > > > force the action of going again to the Data Base and bringing
data)
> > > > > Do you know how i make the report go and bring the data every time
i
> > press
> > > > > on "view report" ?
> > > > > Please HELP!
> > > > > Thanks
> > > >
> > > >
> > > >
> >
> >
> >|||Ctrl+F5 is the way to force a refresh in IE. What happens then?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Penker" <Penker@.discussions.microsoft.com> wrote in message
news:5D7088B9-F337-4C0F-B2B9-073761CC5994@.microsoft.com...
> Hi!
> I know that caching is set at the server - been there tried that...
> Also tried to open the report using reporting manager and click on the
> View
> Report button - it doesn't work
> but - about this Tag you are talking about - is there any way to pass this
> tag in the url that 'call' the report?
> i use "window.open(...)" in Java Script...
> Thanks!!!
> "Bruce L-C [MVP]" wrote:
>> Caching is set at the server. The default is for it not to be cached. I
>> think what is happening is you are coming up against your web page doing
>> caching. One way you can test this is to do the following. Open up your
>> report using reporting manager.Click on the View Report button. Click on
>> it
>> a second time, I bet it works the way you want it to.
>> For the web page you are hosting the report in make sure it is not being
>> cached. I forget the line you put in the page but there is a html tag you
>> can put that tell ASP to not cache the web page.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Penker" <Penker@.discussions.microsoft.com> wrote in message
>> news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
>> > Yes - The reports i use (from an application) are all deployed.
>> > I have an application that on a link "click" it open a report from
>> > the
>> > Reporting Service
>> > while sending it his parameters. Now when i send the same parameter
>> > twice
>> it
>> > returns the same data (even it already changed after the first
>> > time)...
>> > Can you help me?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> > > This is definitely true from the development environment. That is a
>> feature
>> > > of the IDE (I suppose so you can develop with long running reports
>> without
>> > > having it have to run the query over and over again. Have you tried
>> > > this
>> > > with a deployed report?
>> > >
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > >
>> > > "Penker" <Penker@.discussions.microsoft.com> wrote in message
>> > > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
>> > > > Hello!
>> > > > I have a question - i hope some one can help me...
>> > > > I have a report that gets an id as a parameter and get the data for
>> this
>> > > > ID.
>> > > > In the same Stored Procedure where i get this data - i also update
>> the
>> > > > data
>> > > > (change status...).
>> > > > Now when i do "view report" again on the same ID - i don't see the
>> > > > changes...
>> > > > Only when i go and put other ID ,press "view report" and then go
>> > > > back
>> to
>> > > > the
>> > > > first ID - then i see the changes.
>> > > > It seems that the reporting does not go and bring the data every
>> > > > time
>> i
>> > > > press on "View Report" unless i change the parameter (which means
>> > > > that
>> i
>> > > > force the action of going again to the Data Base and bringing data)
>> > > > Do you know how i make the report go and bring the data every time
>> > > > i
>> press
>> > > > on "view report" ?
>> > > > Please HELP!
>> > > > Thanks
>> > >
>> > >
>> > >
>>|||<meta HTTP-EQUIV="cache-directive" CONTENT="no-cache">
How do I get this into the report HTML page?
Jeff A. Stucker wrote:
> Ctrl+F5 is the way to force a refresh in IE. What happens then?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Penker" <Penker@.discussions.microsoft.com> wrote in message
> news:5D7088B9-F337-4C0F-B2B9-073761CC5994@.microsoft.com...
> > Hi!
> > I know that caching is set at the server - been there tried
that...
> > Also tried to open the report using reporting manager and click on
the
> > View
> > Report button - it doesn't work
> > but - about this Tag you are talking about - is there any way to
pass this
> > tag in the url that 'call' the report?
> > i use "window.open(...)" in Java Script...
> > Thanks!!!
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Caching is set at the server. The default is for it not to be
cached. I
> >> think what is happening is you are coming up against your web page
doing
> >> caching. One way you can test this is to do the following. Open up
your
> >> report using reporting manager.Click on the View Report button.
Click on
> >> it
> >> a second time, I bet it works the way you want it to.
> >>
> >> For the web page you are hosting the report in make sure it is not
being
> >> cached. I forget the line you put in the page but there is a html
tag you
> >> can put that tell ASP to not cache the web page.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Penker" <Penker@.discussions.microsoft.com> wrote in message
> >> news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
> >> > Yes - The reports i use (from an application) are all deployed.
> >> > I have an application that on a link "click" it open a report
from
> >> > the
> >> > Reporting Service
> >> > while sending it his parameters. Now when i send the same
parameter
> >> > twice
> >> it
> >> > returns the same data (even it already changed after the first
> >> > time)...
> >> > Can you help me?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> > > This is definitely true from the development environment. That
is a
> >> feature
> >> > > of the IDE (I suppose so you can develop with long running
reports
> >> without
> >> > > having it have to run the query over and over again. Have you
tried
> >> > > this
> >> > > with a deployed report?
> >> > >
> >> > > --
> >> > > Bruce Loehle-Conger
> >> > > MVP SQL Server Reporting Services
> >> > >
> >> > > "Penker" <Penker@.discussions.microsoft.com> wrote in message
> >> > > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
> >> > > > Hello!
> >> > > > I have a question - i hope some one can help me...
> >> > > > I have a report that gets an id as a parameter and get the
data for
> >> this
> >> > > > ID.
> >> > > > In the same Stored Procedure where i get this data - i also
update
> >> the
> >> > > > data
> >> > > > (change status...).
> >> > > > Now when i do "view report" again on the same ID - i don't
see the
> >> > > > changes...
> >> > > > Only when i go and put other ID ,press "view report" and
then go
> >> > > > back
> >> to
> >> > > > the
> >> > > > first ID - then i see the changes.
> >> > > > It seems that the reporting does not go and bring the data
every
> >> > > > time
> >> i
> >> > > > press on "View Report" unless i change the parameter (which
means
> >> > > > that
> >> i
> >> > > > force the action of going again to the Data Base and
bringing data)
> >> > > > Do you know how i make the report go and bring the data
every time
> >> > > > i
> >> press
> >> > > > on "view report" ?
> >> > > > Please HELP!
> >> > > > Thanks
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>|||Try adding this to the report URL:
&rs:ClearSession=true
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Raj" <RajeevRamesh7207@.gmail.com> wrote in message
news:1105129321.910500.285100@.c13g2000cwb.googlegroups.com...
> <meta HTTP-EQUIV="cache-directive" CONTENT="no-cache">
> How do I get this into the report HTML page?
> Jeff A. Stucker wrote:
>> Ctrl+F5 is the way to force a refresh in IE. What happens then?
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Penker" <Penker@.discussions.microsoft.com> wrote in message
>> news:5D7088B9-F337-4C0F-B2B9-073761CC5994@.microsoft.com...
>> > Hi!
>> > I know that caching is set at the server - been there tried
> that...
>> > Also tried to open the report using reporting manager and click on
> the
>> > View
>> > Report button - it doesn't work
>> > but - about this Tag you are talking about - is there any way to
> pass this
>> > tag in the url that 'call' the report?
>> > i use "window.open(...)" in Java Script...
>> > Thanks!!!
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Caching is set at the server. The default is for it not to be
> cached. I
>> >> think what is happening is you are coming up against your web page
> doing
>> >> caching. One way you can test this is to do the following. Open up
> your
>> >> report using reporting manager.Click on the View Report button.
> Click on
>> >> it
>> >> a second time, I bet it works the way you want it to.
>> >>
>> >> For the web page you are hosting the report in make sure it is not
> being
>> >> cached. I forget the line you put in the page but there is a html
> tag you
>> >> can put that tell ASP to not cache the web page.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Penker" <Penker@.discussions.microsoft.com> wrote in message
>> >> news:56D6EDC3-2B97-45F0-B580-535BCCB54E1C@.microsoft.com...
>> >> > Yes - The reports i use (from an application) are all deployed.
>> >> > I have an application that on a link "click" it open a report
> from
>> >> > the
>> >> > Reporting Service
>> >> > while sending it his parameters. Now when i send the same
> parameter
>> >> > twice
>> >> it
>> >> > returns the same data (even it already changed after the first
>> >> > time)...
>> >> > Can you help me?
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> > > This is definitely true from the development environment. That
> is a
>> >> feature
>> >> > > of the IDE (I suppose so you can develop with long running
> reports
>> >> without
>> >> > > having it have to run the query over and over again. Have you
> tried
>> >> > > this
>> >> > > with a deployed report?
>> >> > >
>> >> > > --
>> >> > > Bruce Loehle-Conger
>> >> > > MVP SQL Server Reporting Services
>> >> > >
>> >> > > "Penker" <Penker@.discussions.microsoft.com> wrote in message
>> >> > > news:776626FA-4CFF-4DA7-B004-031CFAB338B8@.microsoft.com...
>> >> > > > Hello!
>> >> > > > I have a question - i hope some one can help me...
>> >> > > > I have a report that gets an id as a parameter and get the
> data for
>> >> this
>> >> > > > ID.
>> >> > > > In the same Stored Procedure where i get this data - i also
> update
>> >> the
>> >> > > > data
>> >> > > > (change status...).
>> >> > > > Now when i do "view report" again on the same ID - i don't
> see the
>> >> > > > changes...
>> >> > > > Only when i go and put other ID ,press "view report" and
> then go
>> >> > > > back
>> >> to
>> >> > > > the
>> >> > > > first ID - then i see the changes.
>> >> > > > It seems that the reporting does not go and bring the data
> every
>> >> > > > time
>> >> i
>> >> > > > press on "View Report" unless i change the parameter (which
> means
>> >> > > > that
>> >> i
>> >> > > > force the action of going again to the Data Base and
> bringing data)
>> >> > > > Do you know how i make the report go and bring the data
> every time
>> >> > > > i
>> >> press
>> >> > > > on "view report" ?
>> >> > > > Please HELP!
>> >> > > > Thanks
>> >> > >
>> >> > >
>> >> > >
>> >>
>> >>
>> >>
>