Reporting Services Count: release

Showing posts with label release. Show all posts

Wednesday, March 28, 2012

Reporting Services sp2 Client Printing Problem

Hi, I've been using SQL Server 2K Reporting Services since its SP 1 release,
and because the client side printing capability was introduced with SP2 beta,
I jumped right into the beta program and tried it out. It did work well, and
the cabability got the load off my shoulder of having to create my own
printing application. I just had to wait for the SP2 release. Yesterday I got
a mail from the beta program team that SP2 is now ready, so I went ahead and
installed it so that I could now use it in the production enviornment,
thinking this new print button would dramattically increase the reporting
service usage. The client printing is there, but to my surprise, when I
pressed the print icon from the report tool bar from a client, I get the
following message "Error loading resource string. (0x00000000)." I tried it
on another client and on the server itself, I got the same result. I can
still print after hitting "OK" button many times to get to the print dialog
box, and at this stage things work fine, but it seems that printer
information is not passed correctly from the client machine to the print
dialog box, since most of its entries are missing. Since this SP is just
released, I could not find any KB or other articals to troubleshoot this
issue. To complicate the issue further, I am not sure whether this is
happening because I installed it on SP2 beta machine. Anybody please help
me!!You need to clean out any older versions of the controls from your
C:\WINDOWS\Downloaded Program Files directory. See if that solves your
problem.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"RabbitBike" <RabbitBike@.discussions.microsoft.com> wrote in message
news:D5468C0D-5D4B-4096-B76B-BE62F1ADE3F2@.microsoft.com...
> Hi, I've been using SQL Server 2K Reporting Services since its SP 1
> release,
> and because the client side printing capability was introduced with SP2
> beta,
> I jumped right into the beta program and tried it out. It did work well,
> and
> the cabability got the load off my shoulder of having to create my own
> printing application. I just had to wait for the SP2 release. Yesterday I
> got
> a mail from the beta program team that SP2 is now ready, so I went ahead
> and
> installed it so that I could now use it in the production enviornment,
> thinking this new print button would dramattically increase the reporting
> service usage. The client printing is there, but to my surprise, when I
> pressed the print icon from the report tool bar from a client, I get the
> following message "Error loading resource string. (0x00000000)." I tried
> it
> on another client and on the server itself, I got the same result. I can
> still print after hitting "OK" button many times to get to the print
> dialog
> box, and at this stage things work fine, but it seems that printer
> information is not passed correctly from the client machine to the print
> dialog box, since most of its entries are missing. Since this SP is just
> released, I could not find any KB or other articals to troubleshoot this
> issue. To complicate the issue further, I am not sure whether this is
> happening because I installed it on SP2 beta machine. Anybody please help
> me!!|||Thank you!! After I deleted the "RSClientPrint Class" activeX control, things
worked as expected. A new file with the same name was downloaded into the
directory, and I remember a client has been asked for the first time they
downloaded it just like any other ActiveX control (and you are asked whether
or not to download the file depending on your IE security setting, right?)
Thank you again, and I apologize for the initial post being that long. I got
too excited in writing about this SP2 release and its printing capability
which I think will make a lot of people happy. And I guess my post applies
only to the beta testers, but I hope your answer will help them when they see
the same problem.
"Brian Welcker" wrote:
> You need to clean out any older versions of the controls from your
> C:\WINDOWS\Downloaded Program Files directory. See if that solves your
> problem.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "RabbitBike" <RabbitBike@.discussions.microsoft.com> wrote in message
> news:D5468C0D-5D4B-4096-B76B-BE62F1ADE3F2@.microsoft.com...
> > Hi, I've been using SQL Server 2K Reporting Services since its SP 1
> > release,
> > and because the client side printing capability was introduced with SP2
> > beta,
> > I jumped right into the beta program and tried it out. It did work well,
> > and
> > the cabability got the load off my shoulder of having to create my own
> > printing application. I just had to wait for the SP2 release. Yesterday I
> > got
> > a mail from the beta program team that SP2 is now ready, so I went ahead
> > and
> > installed it so that I could now use it in the production enviornment,
> > thinking this new print button would dramattically increase the reporting
> > service usage. The client printing is there, but to my surprise, when I
> > pressed the print icon from the report tool bar from a client, I get the
> > following message "Error loading resource string. (0x00000000)." I tried
> > it
> > on another client and on the server itself, I got the same result. I can
> > still print after hitting "OK" button many times to get to the print
> > dialog
> > box, and at this stage things work fine, but it seems that printer
> > information is not passed correctly from the client machine to the print
> > dialog box, since most of its entries are missing. Since this SP is just
> > released, I could not find any KB or other articals to troubleshoot this
> > issue. To complicate the issue further, I am not sure whether this is
> > happening because I installed it on SP2 beta machine. Anybody please help
> > me!!
>
>

Monday, March 26, 2012

Reporting Services Questions

First of all, I like to thank Microsoft for providing Reporting Services with End User Tool.

I am working with CTP release on SQL Server 2005 Reporting Service using SQL Server 2000 as data source in Report Model Project.
I was working with RS2000 earlier, since we are interested in "End user tool" for reporting building, I started working on RS2005.

I have created a model and trying build a Report using Report builder. I have more than 75 fields to select on single report.

My questions are,
1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?

2. How to change print orientation of my report in to "landscape"? All of my reports will be printed on "landscape".

3. I am using "Report Builder" using keyboard and without mouse which makes it very difficult to work. Any shortcuts will be available for Report Manager (e.g. Menu Items: New Folder, New Data Source, Upload File, Report Builder etc.) or Report Builder (Explorer, Fields, Run Report, Design Report, Filter, selecting fields etc.)?

4. When will RS2005 will support export to Microsoft Word format?

5. I assume that database structure and Report Model are two separate things, and I can create my own relationship between existing entities in report Model. Is this correct?

6. I assume that RS 2005 Report Manager is accessible via web without any upgrades of Internet Explorer etc. is this correct? At present, I am not able to see all contents of Report Manager.

Above queries are influenced by my client who is using our customised tool as a Report Engine which is tightly coupled with development team and often changing requirements.Comments inline:

1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?

For your report to make sense, you have to have a path between the entities in your report. You should be able to navigate between entities by clicking on them. You can also use the find button (not sure how well that was working in CTP June).

2. How to change print orientation of my report in to "landscape"? All of my reports will be printed on "landscape".

In Report Builder, it is in the page properties dialog (not sure if that was fully implemented in CTP June). In Report Designer, make your page width greater than your page height.

Shortcuts will be added for the released product.

4. When will RS2005 will support export to Microsoft Word format?

Unfortunately, we were not able to get it into RS 2005. This is high on the list for a future release.

5. I assume that database structure and Report Model are two separate things, and I can create my own relationship between existing entities in report Model. Is this correct?

Sort of. The relationship has to be defined in the DSV so that we can generate the SQL. You never have to modify the database schema itself.

6. I assume that RS 2005 Report Manager is accessible via web without any upgrades of Internet Explorer etc. is this correct? At present, I am not able to see all contents of Report Manager.

Report Manager works with IE 5.5 and later. Not sure what you are running into.|||

-->>For your report to make sense, you have to have a path between the entities in your report. You should be able to navigate between entities by clicking on them. You can also use the find button (not sure how well that was working in CTP June).

This couldn't be more wrong , if you have 2 fact table sales and customer, and dimension time and product , you can't do a report that show sales , customers that make that purchases by product and time .

This is a very basic feature that report builder can't do......

Plase give us a beter tool

sql