Report: same

Hi There

We created a report from an Informix database stored procedure (with parameters). When we execute the stored procedure in the data page, it returns correct result set with column headings blank. In the datasets page, the field names are: ID, ID_1, ID_2, …

When I preview a report created from the dataset, all the fields shows the same value as field1 (ID). I have no idea on what happened, why it happened, and how to resolve it? Could you please help?

Thanks in advance.

Jane

It's been awhile since I have run into this, so apologies if this isn't exactly right. I believe this occurs when Reporting Services can't get the column metadata from the database, or when all the columns have the same base name (the table.column name may be unique, but the column name is not). So the mapping of values to columns doesn't work correctly.

The workaround for us was to make sure the database query aliased all columns to a unique name.

|||

Thanks for your reply.

You are right, our problem is Reporting Services can't get the column metadata from the stored procedure return result. In the data page, we select Text, and type:

execute procedure proc_name (?)

Because we use stored procedures instead of queries, not sure how to set the column names. Any ideas? Thanks a lot.

Cheers

Jane

Report wizard question

is it possible to rerun the wizard after report creation?

during the report creation page and group items are set I want to be able to rerun the wizard to be able to change these,

is it possibl?

If you are in the report wizard, you should be able to press the back button until you get back to where you set the page and group items.

I don't believe that you can rerun the wizard if you have finished the wizard. However, if you have already finished the report wizard, the report should have generated a list (or set of lists depending on how many items you wanted in the page grouping) with a table in the innermost list. The table should contain the values of the group items in the table's grouping rows. If you want to change any of these, right click where you see a page or grouping item (should be in a textbox and looks something like =Fields!NameOfField.Value), select Expression..., expand Fields (name of data source) and replace the current expression with one of the other fields available.

Hope this helps.

Mark

Report with x items per page. Can't get this to work.

I have a very simple design that is causing a very large headache, and
I was hoping you could point me in the right direction.
All I need is for my report to have some information at the top, a
list of 5 items, and then some information at the bottom. But there
maybe more then 5 items, say 10. So I would need to generate 2 pages
with all the same information at the top and the bottom but the first
page would contain the first 5 lines and the second the next 5 lines.
The number of items would vary anywhere from 1 to 100, so it needs to
start a new page every 5 items.
I'm actually not using a database connection instead I'm using .net
object that contains all the information I need, including the list of
items. Now when I use a table or list and grouping so I can group the
items into chunks of 5, and then use a page break on group end I can
generate the next page, but the next set of items start at the top of
the page not where the list is on layout, and none of my other
information repeats. Now I've also tried using headers and footers
but for some reason it says I can't use "Fields" in the header and
footer sections so the additional information I need to display cant
be put in the header and foot.
This seems like a very very simple report yet I can't get the report
to do what I need.
Any help would be appreciated, Thanx.On Mar 30, 10:31 am, Edgey.Er...@.gmail.com wrote:
> I have a very simple design that is causing a very large headache, and
> I was hoping you could point me in the right direction.
> All I need is for my report to have some information at the top, a
> list of 5 items, and then some information at the bottom. But there
> maybe more then 5 items, say 10. So I would need to generate 2 pages
> with all the same information at the top and the bottom but the first
> page would contain the first 5 lines and the second the next 5 lines.
> The number of items would vary anywhere from 1 to 100, so it needs to
> start a new page every 5 items.
> I'm actually not using a database connection instead I'm using .net
> object that contains all the information I need, including the list of
> items. Now when I use a table or list and grouping so I can group the
> items into chunks of 5, and then use a page break on group end I can
> generate the next page, but the next set of items start at the top of
> the page not where the list is on layout, and none of my other
> information repeats. Now I've also tried using headers and footers
> but for some reason it says I can't use "Fields" in the header and
> footer sections so the additional information I need to display cant
> be put in the header and foot.
> This seems like a very very simple report yet I can't get the report
> to do what I need.
> Any help would be appreciated, Thanx.
Have you tried adding the header and footer information in the
grouping rows (top and bottom rows of the table control (if you're
using any))?
Enrique Martinez
Sr. Software Consultant

Report with multiple columns won't print in portrait

I have a report that has 6 columns and won't print in potrait mode. I have
set the page width to 8.5in and the page height to 5in. If I set the page
height to 11in it prints OK (but I need to limit the height to 5in.
Also, can I use this report as the report source for a subreport control?
Thanks,On Sep 11, 1:59 pm, "Tim Kelley" <tkel...@.company.com> wrote:
> I have a report that has 6 columns and won't print in potrait mode. I have
> set the page width to 8.5in and the page height to 5in. If I set the page
> height to 11in it prints OK (but I need to limit the height to 5in.
> Also, can I use this report as the report source for a subreport control?
> Thanks,
You might try modifying the Report Properties Layout, if you haven't
already: via: Layout view -> Report drop-down -> Report Properties... -
> Layout tab -> Page height:, Top margin:, Bottom margin:. If you are
using columns, reduce the Spacing: property. For the subreport
control, you can use the report; however, it it has report columns,
once it is exported it will remove the columns automatically. This is
evidently a flaw in the export functionality. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Report with a frame

Hi,
I need to put a frame around all my report include the page header. I
tried to use a list or a rectangle in the body of the report but I
couldn't write the page No. in the body part. On the other hand, I
couldn't put a rectangle that in includes the body and the header
parts.
Any ideas?
Thank you.
AviI haven't tried this, but can you set the Body border left,right properties,
then set the header and footer border properties to give the effect of a
report border or frame?
Steve MunLeeuw
"AB" <savi176@.yahoo.com> wrote in message
news:1161471963.293489.166440@.b28g2000cwb.googlegroups.com...
> Hi,
> I need to put a frame around all my report include the page header. I
> tried to use a list or a rectangle in the body of the report but I
> couldn't write the page No. in the body part. On the other hand, I
> couldn't put a rectangle that in includes the body and the header
> parts.
> Any ideas?
> Thank you.
> Avi
>sql

Report Web Viewer Control Error - SQL2005 September CTP

I am trying to use the Report Viewer Control in an ASPX page but getting the following error :- "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. ". This is with the SQL Server 2005 September CTP. Is there any option that i should turn on or off?...

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrowsql

Report Web Viewer Control Error - SQL2005 September CTP

I am trying to use the Report Viewer Control in an ASPX page but getting the following error :- "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. ". This is with the SQL Server 2005 September CTP. Is there any option that i should turn on or off?...

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrow

Report Viewer XHTML compliant?

Is the report viewer xhtml compliant? I have a report viewer in a xhtml page and i'm getting javascript errors from the multi-select drop down list. If I put the viewer a html 4.0 page, the mult-select drop list works. Any ideas of what could be causing this?

Hi,

I can confirm that report viewer does not work as expected in XHTML pages. I did not try to solve the problem, I switched to HMTL 4.0.

-yuriy

Report Viewer webpart did not work in wss 3.0

Hi,

I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Thanks,

Dan

I also ran into this and I reported it as an issue on connect.microsoft.com. However, according to the feedback, it is by design and it won't be fixed.|||

Thanks Teo,

I hope it will be solved at some point. Until then, I am using RS in integration mode. It works very nice.

Dan

|||

Take a look at this;

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx

When I try to add a Web Part to a SharePoint page, I get the following error message: "A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe."

Make sure you have followed all of the steps in the Installing the Web Parts section, Installation Process subsection of this paper, including using the –url option to stsadm. If you used the –globalinstall option, try leaving it out so the Web Part package is installed to the bin directory of the virtual server. Manually verify that the bin directory under your SharePoint Web root contains a file called RSWebParts.dll. If you installed SharePoint in the default Web root, this directory would be C:\Inetpub\wwwroot\bin. A copy of this DLL may be found in C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab (assuming that Reporting Services is installed in the default location).

|||He has the web parts working allright. It's just that the RS 2005 web parts are coded against the WSS 2.0 object model and don't support connections. Based on what I've heard they won't be enhanced to support the WSS 3.0 connections feature.sql

Report Viewer webpart did not work in wss 3.0

Hi,

I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Thanks,

Dan

I also ran into this and I reported it as an issue on connect.microsoft.com. However, according to the feedback, it is by design and it won't be fixed.|||

Thanks Teo,

I hope it will be solved at some point. Until then, I am using RS in integration mode. It works very nice.

Dan

|||

Take a look at this;

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx

When I try to add a Web Part to a SharePoint page, I get the following error message: "A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe."

Make sure you have followed all of the steps in the Installing the Web Parts section, Installation Process subsection of this paper, including using the –url option to stsadm. If you used the –globalinstall option, try leaving it out so the Web Part package is installed to the bin directory of the virtual server. Manually verify that the bin directory under your SharePoint Web root contains a file called RSWebParts.dll. If you installed SharePoint in the default Web root, this directory would be C:\Inetpub\wwwroot\bin. A copy of this DLL may be found in C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab (assuming that Reporting Services is installed in the default location).

|||He has the web parts working allright. It's just that the RS 2005 web parts are coded against the WSS 2.0 object model and don't support connections. Based on what I've heard they won't be enhanced to support the WSS 3.0 connections feature.

Report Viewer Web Part Title wont save

In shared view when i save a report viewer web part title & then go & select
another report viewer web part title on the same page the title then defaults
back to report viewer [1] & report viewer [2].
the same happens when i clock off the page & back to it.
thanksAny ideas Microsoft '
Thanks
"Tango" wrote:
> In shared view when i save a report viewer web part title & then go & select
> another report viewer web part title on the same page the title then defaults
> back to report viewer [1] & report viewer [2].
> the same happens when i clock off the page & back to it.
> thanks

Report Viewer web part in Sharepoint 2.0 site

Hello:
I'm running the SSRS 2005 web parts in a Sharepoint 2.0 site. I want
to display a report when a page loads using just the page viewer web
part.
In the properties of the web part, I have http://portal:81/Reports/Pages/Report.aspx?
in the Report Manager URL field and itempath=%2fRepVendorPortal%2fTop
+Sellers in the Report Path field.
When I hit apply, the web part displays "A required argument is
missing from the URL that opens this page: ItemPath".
What am I doing wrong here?
Any assistance is appreciated.
Thanks in advance.
-JoeNever mind. I had the report server URL incorrect (it should have
been just http://portal:81/reports) and the report path should have
just been /repvendorportal/Top Sellers. The + was causing a problem
too.
Thanks.
-Joe
On Nov 8, 1:14 pm, Joe <j...@.josephmarkovich.com> wrote:
> Hello:
> I'm running the SSRS 2005 web parts in a Sharepoint 2.0 site. I want
> to display a report when a page loads using just the page viewer web
> part.
> In the properties of the web part, I havehttp://portal:81/Reports/Pages/Report.aspx?
> in the Report Manager URL field and itempath=%2fRepVendorPortal%2fTop
> +Sellers in the Report Path field.
> When I hit apply, the web part displays "A required argument is
> missing from the URL that opens this page: ItemPath".
> What am I doing wrong here?
> Any assistance is appreciated.
> Thanks in advance.
> -Joe

Report Viewer toolbar problem

In my web page I have a report viewer with the print button turned on in properties, however when it is displayed I only get the navigation and export part. Would there be a reason for this?
Thanks for the help.

Hi

Install MSSRS Service Pack 2. That will solve your problem.

|||Adonis,
Thanks for the reply. Now I am using Report Services through SQL 2005 Standard and the Report Viewer through VS 2005 Standard if that matters any.
Where do I find the service pack for this that you mention?
Thanks for the information.|||

I think -

What CTP version of 2005 are you using? If July - upgrade

|||I have the full version of SQL 2005 Standard and Visual Studio 2005 Standard. These are the full release versions.|||

Good Evening!

Since I am on the other side of the world so to speak -

You have the "full" version - AND WITH ALL DUE RESPECT - did you purchase this - because if so - I would like to as well --

I can only get a CTP download here in BKK -

Give me some help here in that is this a general first release of 2005?

thank you

|||

I do have the "full" version of Standard (not Professional) for both Visual Studio 2005 and SQL Server 2005. These were offered at the Launch Parties. You can get the "full" version of the Express versions for free here:http://msdn.microsoft.com/vstudio/express/. These are free for one year so if you download them now, there is no cost to you at all.

Hope this helps.

|||

I have researched the "full version" as you have claimed - and SORRY - there is not a FULL version of 2005 other than the CTP release

or

a possible "full" -- BS --- if your company has a relationship - which every company has a relationship!

So in your request please provide a mod and release # then we can help - but do not say to this forum you have a "FULL" release of a "standard" version of 2005...

Watch your words!

|||

Huh? So what, the November 7 launch never happened and the beta is still out there?

I do not know what you are talking about.

But thanks for the great help you have provided.

|||

Sorry about my post about the "FULl" version - please take no personal offense!

I modified the toolbar one time to change the background color and font... I lost the print button on some reports and on others I lost the export button... I never could figure out why - so I reverted back....

I just recently read something on Microsoft's www site about RS 2005 behavioral changes - and the first paragrap indicated problems with headers - maybe there is something in that article - I will go back and look up and post the link to the article -- maybe a small "glitch" in the initial release

Best regards

|||Not sure if you are still working on this. If you are running reports in local mode, the print icons will not be available. Client-side printing is only available in remote mode when you are calling an actual Report Server. Not sure if that applies to your setup or not. You can supposedly get printing to work by writing your own code, but we are just trying this now so not sure if it works or not.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=76294&SiteID=1|||

Actually, I still am having the problem, but I do see what you are saying because I changed the processing mode to remote and the print button displays. So what I did is import the report to the SQL Reporting Server (I hope I did this right) by using the SQL Management Console.

Now though when I run the app, I am getting the following error:

"The path of the item "\Reports\report.rdlc" is not valid. The path must be less than 260 characters long and restrictions apply. (rsIndalidItemPath)"

What did I do wrong here?

Report Viewer shrinking and shows scrollbar

I am using Crystal Report Viewer in ASP.NET page. In some of my reports, the viewer seem to be shrinking to about one third of the page. I have set all properties including width etc properly.
Have anybody seen this behaviour before?I have also faced same problem..If you get any solve pls. post in this forum.|||We found that this problem happens when we install some specific printer drivers. If I uninstall all printers from my server, all reports are working fine. Please post your updates too..|||I was reading something on Crystal KB the other day about print drivers. I can't remember the exact scenario but the gist of it was that the report was misbehaving in the production environment.

The solution was to set the report to "No Printer" in the design environment so that it didn't carry over the print driver settings. Everytime a user prints with a different printer and those settings conflict with the design print settings, it creates havoc.

Just wondering if setting your report to "No Print" would alleviate this problem too?

Linda|||We tried that. And it worked fine until I try to print the report. When I print, it returns to the smaller size.

- Tony|||Sounds like a bug to me!

report viewer problem

I found a few topics about that problem but I'm not sure it solves my
problem.
I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
Each report view is running a diffrent report.
in the code behinde I'm adding each report a parameter from my page.
Now, my site is configure to send me errors to my mail.
I've noticed that every time that I leave the page with the 4 report
viewer open, after about 10-12 minutes (without toucing anything and
without any refresh or postback) I get an error mail with this error:
Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
(rsExecutionNotFound)
The page itself stay OK with the 4 viewer and the user don't know that
there was a problem but I do.
Any thing know way is that?
I saw some thing about session of the report viewer but I'm not sure
about that.
B.T.W
I'm still with sp1on my sql server, Does any body know if it realted
to my problem?
Thanks!On Jan 7, 8:51 am, nicknack <roezo...@.gmail.com> wrote:
> I found a few topics about that problem but I'm not sure it solves my
> problem.
> I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
> Each report view is running a diffrent report.
> in the code behinde I'm adding each report a parameter from my page.
> Now, my site is configure to send me errors to my mail.
> I've noticed that every time that I leave the page with the 4 report
> viewer open, after about 10-12 minutes (without toucing anything and
> without any refresh or postback) I get an error mail with this error:
> Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
> (rsExecutionNotFound)
> The page itself stay OK with the 4 viewer and the user don't know that
> there was a problem but I do.
> Any thing know way is that?
> I saw some thing about session of the report viewer but I'm not sure
> about that.
> B.T.W
> I'm still with sp1on my sql server, Does any body know if it realted
> to my problem?
> Thanks!
Actually, it sounds like the session is timing out. You might be able
to tweak the session timeout variable in the web.config file. Also, I
would suggest using fewer report viewer controls to improve
performance and streamline the application. You should be able to
dynamically set the report associated with the report viewer control.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Martinez,
Well, I need those 4 report viewer 'coz I need to display 4 graphs at
the same time for comparison but that not so bad.
The problem is the error I'm getting (actully - its 4 errors. one for
each viewer).
In my web.config of the asp.net appliction I have <sessionState
timeout=3D60> so it souldn't drop my seesion after 10 minuts (Maybe
there is a session configuration in the sqlserver as well').
Any way, The page does not refresh after the report are loaded so
isn't there a way to tell the viewer not to try and refresh him self?
Thanks again, hope to get more ideas,
Roy.
On 8 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:43, EMartinez <emartinez...@.gmail.c=om> wrote:
> On Jan 7, 8:51 am, nicknack <roezo...@.gmail.com> wrote:
>
> > I found a few topics about that problem but I'm not sure it solves my
> > problem.
> > I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
> > Each report view is running a diffrent report.
> > in the code behinde I'm adding each report a parameter from my page.
> > Now, my site is configure to send me errors to my mail.
> > I've noticed that every time that I leave the page with the 4 report
> > viewer open, after about 10-12 minutes (without toucing anything and
> > without any refresh or postback) I get an error mail with this error:
> > Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
> > (rsExecutionNotFound)
> > The page itself stay OK with the 4 viewer and the user don't know that
> > there was a problem but I do.
> > Any thing know way is that?
> > I saw some thing about session of the report viewer but I'm not sure
> > about that.
> > B.T.W
> > I'm still with sp1on my sql server, Does any body know if it realted
> > to my problem?
> > Thanks!
> Actually, it sounds like the session is timing out. You might be able
> to tweak the session timeout variable in the web.config file. Also, I
> would suggest using fewer report viewer controls to improve
> performance and streamline the application. You should be able to
> dynamically set the report associated with the report viewer control.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Jan 8, 2:13 am, nicknack <roezo...@.gmail.com> wrote:
> Hi Martinez,
> Well, I need those 4 report viewer 'coz I need to display 4 graphs at
> the same time for comparison but that not so bad.
> The problem is the error I'm getting (actully - its 4 errors. one for
> each viewer).
> In my web.config of the asp.net appliction I have <sessionState
> timeout=3D60> so it souldn't drop my seesion after 10 minuts (Maybe
> there is a session configuration in the sqlserver as well').
> Any way, The page does not refresh after the report are loaded so
> isn't there a way to tell the viewer not to try and refresh him self?
> Thanks again, hope to get more ideas,
> Roy.
> On 8 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:43, EMartinez <emartinez...@.gmail=.com> wrote:
> > On Jan 7, 8:51 am, nicknack <roezo...@.gmail.com> wrote:
> > > I found a few topics about that problem but I'm not sure it solves my
> > > problem.
> > > I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
> > > Each report view is running a diffrent report.
> > > in the code behinde I'm adding each report a parameter from my page.
> > > Now, my site is configure to send me errors to my mail.
> > > I've noticed that every time that I leave the page with the 4 report
> > > viewer open, after about 10-12 minutes (without toucing anything and
> > > without any refresh or postback) I get an error mail with this error:
> > > Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
> > > (rsExecutionNotFound)
> > > The page itself stay OK with the 4 viewer and the user don't know that=
> > > there was a problem but I do.
> > > Any thing know way is that?
> > > I saw some thing about session of the report viewer but I'm not sure
> > > about that.
> > > B.T.W
> > > I'm still with sp1on my sql server, Does any body know if it realted
> > > to my problem?
> > > Thanks!
> > Actually, it sounds like the session is timing out. You might be able
> > to tweak the session timeout variable in the web.config file. Also, I
> > would suggest using fewer report viewer controls to improve
> > performance and streamline the application. You should be able to
> > dynamically set the report associated with the report viewer control.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
If you are using local mode, you might want to switch to server mode.
Hope this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi,
I'm already useing server mode to load my report from the sqlserver to
my asp.net server where I'm running my application.
Its look like a session problem but I don't know way it need to
refresh the report after 10 minuts and look for the session again.
Thanks.
On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> If you are using local mode, you might want to switch to server mode.
> Hope this helps further.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Jan 9, 2:34 am, nicknack <roezo...@.gmail.com> wrote:
> Hi,
> I'm already useing server mode to load my report from the sqlserver to
> my asp.net server where I'm running my application.
> Its look like a session problem but I don't know way it need to
> refresh the report after 10 minuts and look for the session again.
> Thanks.
> On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> > If you are using local mode, you might want to switch to server mode.
> > Hope this helps further.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You might want to expand the session state in the web.config file a
little more. Also, you might try to see if there is a timeout set
somewhere for the virtual directory of your website -and/or- in IIS.
Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||I'll try to find another options.
Thank for your help Martinez!
Roy.
On 10 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 03:11, EMartinez <emartinez...@.gmail.=com> wrote:
> On Jan 9, 2:34 am, nicknack <roezo...@.gmail.com> wrote:
>
> > Hi,
> > I'm already useing server mode to load my report from the sqlserver to
> > my asp.net server where I'm running my application.
> > Its look like a session problem but I don't know way it need to
> > refresh the report after 10 minuts and look for the session again.
> > Thanks.
> > On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> > > If you are using local mode, you might want to switch to server mode.
> > > Hope this helps further.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant
> You might want to expand the session state in the web.config file a
> little more. Also, you might try to see if there is a timeout set
> somewhere for the virtual directory of your website -and/or- in IIS.
> Sorry that I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Jan 10, 12:58 am, nicknack <roezo...@.gmail.com> wrote:
> I'll try to find another options.
> Thank for your help Martinez!
> Roy.
> On 10 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 03:11, EMartinez <emartinez...@.gmai=l.com> wrote:
> > On Jan 9, 2:34 am, nicknack <roezo...@.gmail.com> wrote:
> > > Hi,
> > > I'm already useing server mode to load my report from the sqlserver to=
> > > my asp.net server where I'm running my application.
> > > Its look like a session problem but I don't know way it need to
> > > refresh the report after 10 minuts and look for the session again.
> > > Thanks.
> > > On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> > > > If you are using local mode, you might want to switch to server mode=.
> > > > Hope this helps further.
> > > > Regards,
> > > > Enrique Martinez
> > > > Sr. Software Consultant
> > You might want to expand the session state in the web.config file a
> > little more. Also, you might try to see if there is a timeout set
> > somewhere for the virtual directory of your website -and/or- in IIS.
> > Sorry that I could not be of greater assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Report Viewer Jump to URL error after drilldown

Hello,

I'm using an ASPX page + ReportViewer + remote report with drilldown and Jump to Url (target _blank) in IE 6.

The ReportViewer's property AsyncRendering is set to true.

After drilldown, if i click on the text with the navigation action "Jump to Url", i have this error message in IE : Javascript Error : can't execute code from a freed script.

The jump to URL "works", but not in a "blank" page (in the same page of the ReportViewer).

If the the ReportViewer's property AsyncRendering is set to false, "Jump to Url" works fine (in a new IE page). But my report is very large, and i need the AsyncRendering set to true.

The only solution i found is to use IFrame with direct URL access to ReportServer, instead of ReportViewer.

I would prefer to use ReportViewer, so if someone as an idea of this problem, many thanks for is help !

Thanks,

Frederic

I am having the same error that Frederic is having. not only that my web page is loading within the report viewer I am getting the same script error. When I set AsyncRendering =false, the script error goes away and web page loads correctly( in the same browser); however, my report is centered in the report viewer and I have to scroll to the right to see it. Everytime I expland or collapse the focus changes and I can't see the report unless I scroll to the right(that's annoying)

I am working with local reports since the data for my report come from class objects. I am not publishing my reports to the report server. Is there a way to accomplish this with Frames without the report viewer? If so please let me know. I have been having this problem for 2 weeks now and I am not finding any resolution for it.

I will appreciate any help I coul get with this.

Thanks in advance,

Mini

|||

Frederic,

Can you tell me how you got it to work with IFrame. I cant't get it to open an external link.

thanks

Mini

|||

Hi Mini,

I'm using a Report Server, not a local report, that's why instead of using ReportViewer i can use an IFrame with an URL to my ReportServer.

In the ASPX page i have declared :

<iframeid="frameRS"runat="server"src="http://localhost/ReportServer?/ReportFolder/Report1&rs:Command=Render&rc:LinkTarget=blank"width="100%"height="100%"></iframe>

In this exemple, the Report Server is local (localhost/ReportServer).

It's possible to change the value of the src property (C# exemple in the .aspx.cs file) :

protected

void Page_Load(object sender,EventArgs e)

{

this.frameRS.Attributes["src"] ="http://localhost/ReportServer?/ReportFolder/Report2&rs:Command=Render&rc:LinkTarget=blank";

}

Unfortunately, i'm not sure that you can use this solution with a local report.

Bests regards,

Frederic

|||

I managed to get my report loaded into the Frame and executed the hyperlink. However I am encountered with a new problem

My report is pretty wide and the report is not showing all of it to the right. I know my frame width is 100% thus I am not getting the scrollbar but some how part of the report on the right is missing. I am thinking it is not being returned from the report server. Howerver if I directly go to the server and run it, I see it all

Any idea what is going on

Thanks

Mini

|||

Hi Mini,

Did you manage with the example i sent you last week ?

Best regards,

Frederic

report viewer in new window

I'm executing report server from my aspx page as follows:
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
taSource=c:\temp\mydataset.xml)
this seems the easiest way.
Is there any way I can get the report to display in a new window so that my
aspx page still shows?
Thanks,
GDean,
In your ASP.NET page, you can generate script to run in the window onload
event. In your case, this script would call window.open passing the report
URL. Just make sure that you put in window onload to prevent cookie lost if
you are using Forms Authentication. This will guarantee that the script will
run when the page and cookies are loaded.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.manning.com/lachev
Home page and blog http://www.prologika.com
---
"G. Dean Blake" <Dean@.nospam.com> wrote in message
news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> I'm executing report server from my aspx page as follows:
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> taSource=c:\temp\mydataset.xml)
> this seems the easiest way.
> Is there any way I can get the report to display in a new window so that
my
> aspx page still shows?
> Thanks,
> G
>|||if you mean when my aspx page is just loading, I don't have the information
yet to generate the report. A purpose of my aspx page is to develop a
dataset to generate the report. My response.redirect is in answer to a
button click event.
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:uylD6E4hEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Dean,
> In your ASP.NET page, you can generate script to run in the window onload
> event. In your case, this script would call window.open passing the report
> URL. Just make sure that you put in window onload to prevent cookie lost
if
> you are using Forms Authentication. This will guarantee that the script
will
> run when the page and cookies are loaded.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.manning.com/lachev
> Home page and blog http://www.prologika.com
> ---
> "G. Dean Blake" <Dean@.nospam.com> wrote in message
> news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > I'm executing report server from my aspx page as follows:
> >
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> > taSource=c:\temp\mydataset.xml)
> >
> > this seems the easiest way.
> >
> > Is there any way I can get the report to display in a new window so that
> my
> > aspx page still shows?
> > Thanks,
> > G
> >
> >
>|||No, I meant using Page.RegisterClientScriptBlock in your ASP.NET page to
generate dynamically the browser window.onload call instead of using
Response.Redirect, e.g.
StringBuilder sb=new StringBuilder();
sb.Append("<script language=\"javascript\">");
sb.Append("function requestReport");
sb.Append("{");
sb.Append("window.open (<'your report URL'>");
sb.Append("}");
sb.Append("</script>");
this.Page.RegisterClientScriptBlock("script",sb.ToString());
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.manning.com/lachev
Home page and blog http://www.prologika.com
---
"G. Dean Blake" <Dean@.nospam.com> wrote in message
news:u$8xE%237hEHA.632@.TK2MSFTNGP12.phx.gbl...
> if you mean when my aspx page is just loading, I don't have the
information
> yet to generate the report. A purpose of my aspx page is to develop a
> dataset to generate the report. My response.redirect is in answer to a
> button click event.
> "Teo Lachev" <teo@.nospam.prologika.com> wrote in message
> news:uylD6E4hEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > Dean,
> >
> > In your ASP.NET page, you can generate script to run in the window
onload
> > event. In your case, this script would call window.open passing the
report
> > URL. Just make sure that you put in window onload to prevent cookie lost
> if
> > you are using Forms Authentication. This will guarantee that the script
> will
> > run when the page and cookies are loaded.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > http://www.manning.com/lachev
> > Home page and blog http://www.prologika.com
> > ---
> >
> > "G. Dean Blake" <Dean@.nospam.com> wrote in message
> > news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > > I'm executing report server from my aspx page as follows:
> > >
> >
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> > > taSource=c:\temp\mydataset.xml)
> > >
> > > this seems the easiest way.
> > >
> > > Is there any way I can get the report to display in a new window so
that
> > my
> > > aspx page still shows?
> > > Thanks,
> > > G
> > >
> > >
> >
> >
>

Report Viewer display problem

Hi,
I use reportviewer.dll in my aspx page, and everything works fine on my
development pc where sqlserver, reporting service and visual studio
installed. But when i try to access this page from another pc, iframe which
holds reportviewer gives me "The page cannot be displayed. The page you are
looking for is currently unavailable.....". Other stuff like ascx,
menus,gif are working well. Any suggestions?
Thanks.Ever find a solution to this?
"saglamtimur" wrote:
> Hi,
> I use reportviewer.dll in my aspx page, and everything works fine on my
> development pc where sqlserver, reporting service and visual studio
> installed. But when i try to access this page from another pc, iframe which
> holds reportviewer gives me "The page cannot be displayed. The page you are
> looking for is currently unavailable.....". Other stuff like ascx,
> menus,gif are working well. Any suggestions?
> Thanks.
>
>

Report Viewer Date Format..

Hi,

I have done a report using the reportviewer page, and placed it in my web application and the last thing i need to do is sort out the date formats, primarily to a UK time..

1. I want to display todays date on the page, but in the format "Wednesday, 4 April 2007". I seem to be able to get the various parts needed, but not put them together in the same textbox, could someone help me with the concatonation?

=WeekdayName(Weekday(DateValue(DateString)))

2. All the dates extracted from the database are in the format MM/dd/yyyy, and i need them to be in dd/MM/yyyy, i am completely lost on how to do this...

any help will be much appreciated, even if you could tell me where i can go look up the syntax for this markup

regards

Chris

check this for all posible date formats:http://msdn2.microsoft.com/en-us/library/8kb3ddd4.aspx

|||

cheers for the link, don't know why i was having such a hard time finding it..

anyway, all sorted now, in the end i didn't do any sort of concatenation, but instead just used =FormatDateTime(Now(), 1)

and the other days were as easy as putting dd/MM/yyyy HH:mm in the fomrat field, nice

cheers!

sql

Report Viewer control ignores parameters

I have a Report Viewer control on an asp.net page. The report shows the
parameters. When I choose a value from the drop down and then click on "View
report", the screen gets refreshed and the parameters are reset. It's like
no parameters have been selected from the drop down and no data is shown. If
I run the same report from report manager, or from VS, everything works. Has
anybody had this issue?
Thanks,
GilgameshOn Aug 28, 4:27 pm, "Gilgamesh" <gilgamesh4e...@.aol.com> wrote:
> I have a Report Viewer control on an asp.net page. The report shows the
> parameters. When I choose a value from the drop down and then click on "View
> report", the screen gets refreshed and the parameters are reset. It's like
> no parameters have been selected from the drop down and no data is shown. If
> I run the same report from report manager, or from VS, everything works. Has
> anybody had this issue?
> Thanks,
> Gilgamesh
You might want to check your parameter mappings to the main
datasource. It sounds like there's a breakdown there somewhere. Also,
make sure that you are not receiving an error in the database
connection string, etc. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql