Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts

Friday, March 30, 2012

Problem with long running report timing out

I have a 'YTD' report that is timing out after 30 minutes, where do I go to
change the default timeout period for reports?
TIA,
Bill Youngman
AnexinetIn SSRS2000, you open the Execution property for the report and select
the "Limit report execution to the following number of seconds:" option
under Report Execution Timeout. Then just set the number of SECONDS to
whatever amount will cover the proc run time.
I don't know if this is the same method used in SSRS2005 but I think
there'd be something similar. Hope this helps.
Bill Youngman wrote:
> I have a 'YTD' report that is timing out after 30 minutes, where do I go to
> change the default timeout period for reports?
> TIA,
> Bill Youngman
> Anexinet

Problem with LoadReport web method

Hi,

I'm working on a reporting client for Reporting Services 2005 using SOAP. The problem I'm having is that for reports with multiple pages or a document map, the LoadReport web method, always says they have 0 pages or no document map.

To simplify the problem, i created a simple console app that just calls LoadReport on the /AdventureWorks Sample Reports/Product Catalog report to see if HasDocumentMap is true (it should be but isn't).

Any suggestions?

Kwan

I figured it out and it makes sense. The information is available only after you call Render.

So call, Render, then GetExecutionInfo to get the correct values for HasDocumentMap and NumPages.

Friday, March 23, 2012

problem with images on the report

Hello All,
I am using Image control with database sourced images on my reports. The
images are stored in WMF format.
There is no problem when the report is viewed in web browser but when I
export it as a PDF or TIFF, the images are not shown and a cross (X) is
shown instead of the image.
Has anyone faced the same problem? Any help is solving this?
Regards,
AtifHave you tried converting your WMF files into one of the supported formats?
The supported formats are bmp, jpg, gif, png and jpeg.
Charles Kangai, MCT, MCDBA
"Abdus Salam Atif" wrote:
> Hello All,
> I am using Image control with database sourced images on my reports. The
> images are stored in WMF format.
> There is no problem when the report is viewed in web browser but when I
> export it as a PDF or TIFF, the images are not shown and a cross (X) is
> shown instead of the image.
> Has anyone faced the same problem? Any help is solving this?
> Regards,
> Atif
>
>|||I have also tried to convert the WMF files to PNG, which is the only
accepted format for my application and web, this gives me a different
behavior. The reports look fine in the preview and I am also able to
generate a correct PDF from the preview window but not showing images when I
open the report in the web browser.
Regards,
Atif
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:ABD7F597-8056-4BDA-B4B9-7D5E7A9DA017@.microsoft.com...
> Have you tried converting your WMF files into one of the supported
formats?
> The supported formats are bmp, jpg, gif, png and jpeg.
> Charles Kangai, MCT, MCDBA
> "Abdus Salam Atif" wrote:
> > Hello All,
> >
> > I am using Image control with database sourced images on my reports. The
> > images are stored in WMF format.
> >
> > There is no problem when the report is viewed in web browser but when I
> > export it as a PDF or TIFF, the images are not shown and a cross (X) is
> > shown instead of the image.
> >
> > Has anyone faced the same problem? Any help is solving this?
> >
> > Regards,
> > Atif
> >
> >
> >|||Just to explain how am I converting the images, images are still in WMF
format in the DB, I am using a C# assembly to convert the images using a
function at runtime. The function takes image field from DB as parameter and
returns the converted PNG image. This is written as an expression in the
value property of image control.
Regards,
Atif
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:ABD7F597-8056-4BDA-B4B9-7D5E7A9DA017@.microsoft.com...
> Have you tried converting your WMF files into one of the supported
formats?
> The supported formats are bmp, jpg, gif, png and jpeg.
> Charles Kangai, MCT, MCDBA
> "Abdus Salam Atif" wrote:
> > Hello All,
> >
> > I am using Image control with database sourced images on my reports. The
> > images are stored in WMF format.
> >
> > There is no problem when the report is viewed in web browser but when I
> > export it as a PDF or TIFF, the images are not shown and a cross (X) is
> > shown instead of the image.
> >
> > Has anyone faced the same problem? Any help is solving this?
> >
> > Regards,
> > Atif
> >
> >
> >|||I have a similar situation, but rather than convert the images on the fly, I
convert the images in a batch and put back into the database. In my case the
images show correctly (PNG) in preview but not in HTML. If I export to PDF
they show ok. There seem to be others with this problem as well. I hope
someone from MS will address this issue because it is stopping me from
deploying RS is several situations.
Thanks.
"Abdus Salam Atif" <asalam@.xavor.com> wrote in message
news:eMS0MA60EHA.1408@.TK2MSFTNGP10.phx.gbl...
>I have also tried to convert the WMF files to PNG, which is the only
> accepted format for my application and web, this gives me a different
> behavior. The reports look fine in the preview and I am also able to
> generate a correct PDF from the preview window but not showing images when
> I
> open the report in the web browser.
> Regards,
> Atif
> "Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in
> message
> news:ABD7F597-8056-4BDA-B4B9-7D5E7A9DA017@.microsoft.com...
>> Have you tried converting your WMF files into one of the supported
> formats?
>> The supported formats are bmp, jpg, gif, png and jpeg.
>> Charles Kangai, MCT, MCDBA
>> "Abdus Salam Atif" wrote:
>> > Hello All,
>> >
>> > I am using Image control with database sourced images on my reports.
>> > The
>> > images are stored in WMF format.
>> >
>> > There is no problem when the report is viewed in web browser but when I
>> > export it as a PDF or TIFF, the images are not shown and a cross (X) is
>> > shown instead of the image.
>> >
>> > Has anyone faced the same problem? Any help is solving this?
>> >
>> > Regards,
>> > Atif
>> >
>> >
>> >
>

Wednesday, March 21, 2012

Problem with high Reproting Services 100% Usage

Currently I am running SQL Server 2005 and Reporting Services 2005 on
the same machine. When no reports are being run the CPU usage stays at
100% it is split between sql server and report services 10%/90%. If
anyone can help me, as this seems like some sort of bug with reporting
services, if there is a path I would greatly appreciate it.
Kind Regards
Nilesh ChauhanOn Mar 14, 6:05 am, nilesh.k.chau...@.googlemail.com wrote:
> Currently I am running SQL Server 2005 and Reporting Services 2005 on
> the same machine. When no reports are being run the CPU usage stays at
> 100% it is split between sql server and report services 10%/90%. If
> anyone can help me, as this seems like some sort of bug with reporting
> services, if there is a path I would greatly appreciate it.
> Kind Regards
> Nilesh Chauhan
I have worked w/the same setup recently without problems. Have you
tried rebooting the machine? That may resolve the problem. How long
have you been seeing this CPU usage?
Regards,
Enrique Martinez
Sr. SQL Server Developer

Tuesday, March 20, 2012

Problem with Forms Security Extension Sample - RS 2005

I am attempting to deploy the sample Security Extensions. When I navigate to <machinename>/reports in IE, it works fine and I am able to register the administrator. The user exists in the table correctly, but I am unable to login as the user. It keeps going back to the same uilogon.aspx redirect page.

It appears to be a similar error as http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=289636&SiteID=17

However, I am using the machine name the entire name, never referring to it as localhost. Any ideas? Thanks!

*bump* Any help would be much appreciated. I've gone through all of the config code changes time and time again and everything is as it should be from the sample code.

Problem with Forms Security Extension Sample - RS 2005

I am attempting to deploy the sample Security Extensions. When I navigate to <machinename>/reports in IE, it works fine and I am able to register the administrator. The user exists in the table correctly, but I am unable to login as the user. It keeps going back to the same uilogon.aspx redirect page.

It appears to be a similar error as http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=289636&SiteID=17

However, I am using the machine name the entire name, never referring to it as localhost. Any ideas? Thanks!

*bump* Any help would be much appreciated. I've gone through all of the config code changes time and time again and everything is as it should be from the sample code.

Monday, March 12, 2012

Problem with Excel Pivot Table

I am facing problem like;

We generate reports thru Excel Pivot table. The data is coming from sales
cube. Let?s assume that there are 2 products A and B. The user wants to
filter for each product and view ?stock in hand? and ?total sales? for
particular month (as two columns).

From the Pivot table filtering, when we choose product A and month ?Jan?,
it is showing values for ?stock in hand? and ?total sales? columns for that
month.

But when we choose product B and month ?Jan?, it is only showing ?stock in
hand? value and the ?total sales? column was suppressed/unseen. We know
that there is no sales transaction for ?Jan? month. But we still want to
show the column title even if there are no records in the database / cube.

I am not using any scripting, this pivot table was generated just thru
Pivot table wizard.

Any way to achieve this, please advise me.

Advanced thanks for u r help.

--
Message posted via http://www.sqlmonster.comBajal Mohamed via SQLMonster.com (forum@.SQLMonster.com) writes:
> I am facing problem like;
> We generate reports thru Excel Pivot table. The data is coming from sales
> cube. Let?s assume that there are 2 products A and B. The user wants to
> filter for each product and view ?stock in hand? and ?total sales? for
> particular month (as two columns).
> From the Pivot table filtering, when we choose product A and month
> ?Jan?, it is showing values for ?stock in hand? and ?total sales?
> columns for that month.
> But when we choose product B and month ?Jan?, it is only showing ?stock in
> hand? value and the ?total sales? column was suppressed/unseen. We know
> that there is no sales transaction for ?Jan? month. But we still want to
> show the column title even if there are no records in the database / cube.
> I am not using any scripting, this pivot table was generated just thru
> Pivot table wizard.

I'm not really sure why you are asking this in a newsgroup for
SQL Server. It sonds like an Excel issue to me.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Friday, March 9, 2012

problem with dynamically created RDL files and reports

Hello,

I have a strange problem with a dynamic created RDL resp. dynamic created report.

I have followed the programming tipps on the microsoft site to create programmatically a RDL file and this RDL file is accepted by the reporting server. But when the report is rendered out of that RDL some fields are somehow modified. In one field after the first line (which holds the correct value) all values in the following rows are cut after the fifth character. Other fields contain every now and then strange signs like a caret...

My report items in the RDL e.g. look like this:

- <TableCell>
- <ReportItems>
- <Textbox Name="Details_PBN">
- <Style>
<TextAlign>Left</TextAlign>
<FontFamily>Courier New</FontFamily>
- <BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Value>=Fields!PBN.Value</Value>
</Textbox>
</ReportItems>
</TableCell>

Do I have to do some datatype conversion in my RDL when I create it or how could this be possible?

Any help appreciated!!

I solved it myself. I write the solution down here, perhaps someone else has the same problem.

The data I that is in included in the report is queried from an oracle database. I also created the datasource for the report dynamically and there I used the provider "Oracle". This seemed to cause the problems, because after I changed it to OleDB and uses Provider="MSDAORA.1" as provider in the connection string, it worked like intended.

so... Code on, folks!!!

Wednesday, March 7, 2012

Problem with Deploying Reports

Hi
When i try to deploy a report from VS, it asks me for a user name and
password to connect to Report Services.
I am the administrator on the machine.
Any help would be appreciated.
--
Gerry ConnollyI am assuming your report server is on another machine? When I deploy
reports to our report server from a remote PC, I am also prompted to log in.
If I deploy reports from the same machine that my report server is on, I'm
not prompted to log in.
"GerryC" <GerryC@.discussions.microsoft.com> wrote in message
news:82C10A8E-35CB-4FC3-8520-9FBD2B5D60A8@.microsoft.com...
> Hi
> When i try to deploy a report from VS, it asks me for a user name and
> password to connect to Report Services.
> I am the administrator on the machine.
> Any help would be appreciated.
> --
> Gerry Connolly