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 Viewer Image Control

Hi all,

I can't figure out how to display a dynamic image using the Image control. I've a database table that holds image information, including an address to the image on the server. ex:\\ServerName\x$\ImageDir\Header.jpg

I've tried to set the Source to External and the Value to Fields!vcPictureLocation.Value (field for the address above) in the Properties panel, but the images appear as broken symbols. Does anyone know how to accomplish this?

As always any help is greatly appreciated. Thanks!

msnyder,

The way i have done it..

Drag the image control to your report.. when the wizard pops up.

Select database as the option ,, Specify ur fields in the database and the mime type associated with in... and

Once that is done.. select the image and set its source to external and then it should work...

while ur saving the link to the database make sure its set as http://servername/Applicationname/anyfolders/filename

hope it helps

Regards

KAren

|||

KAren, thx for the reply. I was able to get the image working locally using your method. However, when I deploy the report onto the server the images are still not displaying. I viewed the source of the report viewer and it says IMG src="http://pics.10026.com/?src=" for all of the images.

As a test, I dragged an image object onto the report, set it equal to a web source, put in the same URL as what's being pulled from the database. Worked fine locally when I previewed the report, but it would not display once deployed.

I followed your steps exactly and also changed the link thats being stored in the database to your format. Any ideas? Thanks a lot!

|||

ok.. where are ur images located?

|||

Very sorry for the delay...

I actually made a new directory called 'Pictures" located in my website project directory. I am storing the images there. The URL I'm storing in the database looks like this...

http://SERVER/safetyforms/Pictures/0d8a3ee0-ee01-48d4-baba-b408a573e1b3.jpg

The image displays in the report viewer when I click the preview tab, but won't display when I publish it. Shows IMG src="http://pics.10026.com/?src=" in the cource code.

|||

are u reports stored in a report server or are they local reports

|||

they are on a report server.

i actually found the solution. there were 2 important details, the first was the steps you outlined about how to set up the image in the report viewer. that solved problem #1. problem #2 was that anonymous access needed to be enabled. the option to enable it was in iis in the project properties.

thanks for the help!

|||

I have the same problem!

but i do not solve the problem!

can you detail the solution to me?

|||

Nanim,

FollowKarenros instructions for setting up the image in the report viewer. Make sure the pictures are being stored in a subdirectory of your main project (ex. root/Pictures) Then, go into IIS and set the permissions for the Pictures folder to anoymous. The option should be in the project properties.

The one mistake I made was setting the entire project to anoymous. We just want the pictures directory to be anoymous.

Report Services can't connect to remote DB

I have 2 servers. The first with SBS 2003 and SQL 2005 (Workgroup edition).
The full install was done for SQL 2005 (all features). My report server DB's
are running on the SBS server. The second is a W2k3 R2 server with an app DB
running on SQL 2000.
I have created a report that extracts data from the remote SQL2000 DB. The
report runs fine through Business Intelligence. When I build and deploy
the report, the report can't connect to the DB. I get an error message "
Impossible to create a connection to the DB. This fonction is not supported
in this version of reporting services.(This is a translation since message is
in French).
I have tried using a Windows authentication connection and also with sa.
Do I really need to get SQL 2005 Standard Ed.?
--
Eric Simonneau
Hotel Logistics specialistFound the answer. SQL 2005 Workgroup edition will only permit connection to
the local machine. Remote queries are not permitted.
--
Eric Simonneau
Hotel Logistics specialist
"eric simonneau" wrote:
> I have 2 servers. The first with SBS 2003 and SQL 2005 (Workgroup edition).
> The full install was done for SQL 2005 (all features). My report server DB's
> are running on the SBS server. The second is a W2k3 R2 server with an app DB
> running on SQL 2000.
> I have created a report that extracts data from the remote SQL2000 DB. The
> report runs fine through Business Intelligence. When I build and deploy
> the report, the report can't connect to the DB. I get an error message "
> Impossible to create a connection to the DB. This fonction is not supported
> in this version of reporting services.(This is a translation since message is
> in French).
> I have tried using a Windows authentication connection and also with sa.
> Do I really need to get SQL 2005 Standard Ed.?
> --
> Eric Simonneau
> Hotel Logistics specialist

report services

hi all I'm in the Microsoft Visual Studio creating a report and I noticed I cant bring a function over, am I doing something wrong. I wanted to make a report based on a function. its a table valued function

ALTER FUNCTION [dbo].[Beginning_EndingFinals](@.StartFINALSUITDONE datetime,
@.EndFINALSUITDONE datetime)
RETURNS TABLE
AS
RETURN ( SELECT TM#, LASTNAME, FIRSTNAME, CONDITIONAL, DATEOFCONDITIONAL, FINALSUITDONE
FROM dbo.EmployeeGamingLicense
WHERE (FINALSUITDONE BETWEEN @.StartFINALSUITDONE AND @.EndFINALSUITDONE) )why not make it a sproc?

I don't know if that matters or not|||Are you attempting to execute the ALTER FUNCTION code within text of the dataset?

Or are you making the call to the function within the text (ie, SELECT * from dbo.MyFunction(MyParameter)).

You might consider setting up a stored procedure instead (just set the command type in the Data Set to StoredProcedure).

Regards,

hmscott|||You might consider setting up a stored procedure instead (just set the command type in the Data Set to StoredProcedure).

Brilliant!|||this is the message I'm getting inside the Sql Server business intelligence studio|||this is the message I'm getting inside the Sql Server business intelligence studio

Ummmmm..what message|||Ummmmm..what message

My Bad, hope this helps

Report server SQL 2005

For some reason I can't configure that Report server on a SQL 2005
(workgroup) that is part of the Windows 2003 SBS R2 software.
In the REPORTING SERVICE CONFIGURTOR the "REPORT MANAGER VITUAL DIRECTORY
is greyed out.
I tried uninstalling it and reinstalling and applied the patches. Not I
can't even open the CONFIGURE REPORT SERVER program. I get "NO report
servers were found on the machince" Detail, "Invaild namespace"
All I am tring to do get perpare SQL so I can install CRM 3.0.
Did you apply SP2 to your Reporting Services service? This SP solves most
problem.
Ekrem ?nsoy
"support at Marin" <supportatMarin@.discussions.microsoft.com> wrote in
message news:7A0756F0-F3AF-469A-A61C-B9C1C37603E8@.microsoft.com...
> For some reason I can't configure that Report server on a SQL 2005
> (workgroup) that is part of the Windows 2003 SBS R2 software.
> In the REPORTING SERVICE CONFIGURTOR the "REPORT MANAGER VITUAL DIRECTORY
> is greyed out.
> I tried uninstalling it and reinstalling and applied the patches. Not I
> can't even open the CONFIGURE REPORT SERVER program. I get "NO report
> servers were found on the machince" Detail, "Invaild namespace"
> All I am tring to do get perpare SQL so I can install CRM 3.0.

Report Security: CAnt view report

Hi,
We have some websites. We want to attch a link on each wrbsite which would
take the users to a different reports. Please suggest what will be the best
security mechansism for this scenario..
Also, I was trying to implement the simplest security mechansim,i.e I craetd
a user called User1 and created a Group called Group1. I added the User1 to
be a member of Group1. Now from Reports Manager, I assigned the Browser role
to the Group1. Also, in the virtual directory for Reports & Report Server, I
enabled Integrated Windows Authentication. Now, when I try to view the
report, I get a prompt for username & passowrd. So when I type User1 as
username & the password asscoated with the user, i cant view the report. I
get the error : The Page cant be dispalyed. Also when i click a the link
Reports.com because that is the domain we are using for our Reports.I
get...You are not authorized to viw the reports...
Plz help with this issue.
--
pmudHi,
I still need your suggestion about which security mechansim should be used
in our scenario but I figured out the second question of my previous post,
which is the basic sercuirty mechansim for a report. It was not displaying
the report coz for the user account in Local Users I had checked the check
box, "User should change password on next logon". When I cleared that check
boz and didnt check any of the check boxes, i was able to view the reports.
Any suggestion would be helpful about which security mechansim should be
used.
Thanks
"pmud" wrote:
> Hi,
> We have some websites. We want to attch a link on each wrbsite which would
> take the users to a different reports. Please suggest what will be the best
> security mechansism for this scenario..
> Also, I was trying to implement the simplest security mechansim,i.e I craetd
> a user called User1 and created a Group called Group1. I added the User1 to
> be a member of Group1. Now from Reports Manager, I assigned the Browser role
> to the Group1. Also, in the virtual directory for Reports & Report Server, I
> enabled Integrated Windows Authentication. Now, when I try to view the
> report, I get a prompt for username & passowrd. So when I type User1 as
> username & the password asscoated with the user, i cant view the report. I
> get the error : The Page cant be dispalyed. Also when i click a the link
> Reports.com because that is the domain we are using for our Reports.I
> get...You are not authorized to viw the reports...
> Plz help with this issue.
> --
> pmud