How to set the height of the report body/table dynamically

Hi
I have a report of 8.5"(W) by 11"(H).The header and footer size are fixed.
The header size is 4.75 in and footer size is 2.375in.
In the report body I have a table where the data is dynamic.
The problem is when the data is small i mean like 2 or 3 columns it doesnt touch the footer .
If we have more than 10 columns or so it goes to the next page and even then it doesnt touch the footer beacuse the data stops there.
If we have like 4 columns or so in the table then it touches the footer.
I tried to replace the table with the list but I got the same problem there also.
I tried to place the table in a rectangle and it has the same problem.
I want the table to touch the footer no matter how much the data is .
Is there any work around for this problem?

I really appreciate your help and time
Thanks
Hobbs

Hello,

The table will always grow based on its content. We do not currentlly support "Fill To Page" functionallity. Do you want the table style (borders and background color) to fill the page? Did you try settting the style on the report body?

Thank you,

Nico

|||

Hi Nico

Thanks for the reply.I tried the boderstyle of body and the table but it stops wherever the data ends.

I can send you the rdl file or the exported pdf if u want a take look at what I am talking about.And also I have a the bordstyle of the table column set to solid.even that one stops with the last data.

I was thinking if we have something like calulcating the line height or may be fill the gap after the table somehow dynamically then only fix it.

Thanks

Hobbs

|||

Did you solve it? I've got the same problem. I've got a report that needs border around it. If i use body's border then i can see the report correctly in report manager or after rendering it to pdf. But when i try to print from report manager right hand side border is missing. Printing of the report from rendered pdf file is fine. I tried few things like, created bland report with body only with border style to solid. I could see the border and print the border correctly. Then i added page header/footer and suddenly the right hand side border was missing. I think its bug. check this link http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=115351. I checked all the margin and layout setup everything is correct. Don't know how to get it working?

Regards,

Vivek

How to set the height of the report body/table dynamically

Hi
I have a report of 8.5"(W) by 11"(H).The header and footer size are fixed.
The header size is 4.75 in and footer size is 2.375in.
In the report body I have a table where the data is dynamic.
The problem is when the data is small i mean like 2 or 3 columns it doesnt touch the footer .
If we have more than 10 columns or so it goes to the next page and even then it doesnt touch the footer beacuse the data stops there.
If we have like 4 columns or so in the table then it touches the footer.
I tried to replace the table with the list but I got the same problem there also.
I tried to place the table in a rectangle and it has the same problem.
I want the table to touch the footer no matter how much the data is .
Is there any work around for this problem?

I really appreciate your help and time
Thanks
Hobbs

Hello,

The table will always grow based on its content. We do not currentlly support "Fill To Page" functionallity. Do you want the table style (borders and background color) to fill the page? Did you try settting the style on the report body?

Thank you,

Nico

|||

Hi Nico

Thanks for the reply.I tried the boderstyle of body and the table but it stops wherever the data ends.

I can send you the rdl file or the exported pdf if u want a take look at what I am talking about.And also I have a the bordstyle of the table column set to solid.even that one stops with the last data.

I was thinking if we have something like calulcating the line height or may be fill the gap after the table somehow dynamically then only fix it.

Thanks

Hobbs

|||

Did you solve it? I've got the same problem. I've got a report that needs border around it. If i use body's border then i can see the report correctly in report manager or after rendering it to pdf. But when i try to print from report manager right hand side border is missing. Printing of the report from rendered pdf file is fine. I tried few things like, created bland report with body only with border style to solid. I could see the border and print the border correctly. Then i added page header/footer and suddenly the right hand side border was missing. I think its bug. check this link http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=115351. I checked all the margin and layout setup everything is correct. Don't know how to get it working?

Regards,

Vivek

How to set report server

Hey everyone

I have a requirment here. I create a report that works fine in my local machine. But I want to keep this in a server so that every body can access it. How do I do that any clues please.How to set that what are steps to do that ?Did you install SQL Server Reporting Services? This is a server component of SQL Server that does exactly what you are asking. Are you using SQL Server 2005?|||yes I install reporting services and when I run the report it works fine but I am wondering is there any walkthrough to how to see thw report in web services.|||If you have installed Reporting Services on your server, then go to http://localhost/reports and you can upload the report (.RDL file). From there others can access the report and enter the required parameters to view the report.|||Hi,
I want to upload an rdl file programmatically. Is there anyone who can help me?
Thanks.|||You need to call the SOAP API CreateReport|||thanks but I have another question.
now I need to create subscription for a report. there is a method called createsubscription. but I don't know the values of parameters. in msdn documents, it says

extensionParams[0] = new ParameterValue();
extensionParams[0].Name = "ReplyTo";
extensionParams[0].Value = "reporting@.microsoft.com";

for example.
but how do we know that the name should be "ReplyTo". Are these names discribed somewhere? if so, where? if not, what should we write for each parameter.
I should prepare aspx pages as same as the reporting server web interface. but I do not have enough info.is there a web page that has detailed info other than msdn?
thanks for your help.

How to set Multiple Active results Sets (MARS) enable in ODBC

hello all there

can any body tell me how could i set the Multiple Active results Sets (MARS) option on/yes in case of the ODBC.

The thing is i create the connection using the SQL Native(sql sqrver-2005)wizard,

i got following when create the DNS

Microsoft SQL Native Client Version 09.00.1399

Data Source Name: DM_N
Data Source Description:
Server: vsnet1
Use Integrated Security: No
Database: DM
Language: (Default)
Data Encryption: No
Trust Server Certificate: No
Multiple Active Result Sets(MARS): No
Mirror Server:
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Regional Settings: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes

i just want to set the

Multiple Active Result Sets(MARS): YES

how could i ?

any help, solution or hint

Regards

Thanks

GSG

use this within your SQL Server connectionstring:

"Driver={SQL Native Client};Server=Aron1;Database=pubs;Trusted_Connection=yes;MARS_Connection=yes"

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

How to set Multiple Active Results Sets (MARS) enable in ODBC

hello all there

can any body tell me how could i set the Multiple Active results Sets (MARS) option on/yes in case of the ODBC.

The thing is i create the connection using the SQL Native(sql sqrver-2005)wizard,

i got following when create the DNS

Microsoft SQL Native Client Version 09.00.1399

Data Source Name: DM_N
Data Source Description:
Server: vsnet1
Use Integrated Security: No
Database: DM
Language: (Default)
Data Encryption: No
Trust Server Certificate: No
Multiple Active Result Sets(MARS): No
Mirror Server:
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Regional Settings: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes

i just want to set the

Multiple Active Result Sets(MARS): YES

how could i ?

any help, solution or hint

Regards

Thanks

Gurpreet S. Gill

use this within your SQL Server connectionstring:

"Driver={SQL Native Client};Server=Aron1;Database=pubs;Trusted_Connection=yes;MARS_Connection=yes"

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks HTH

but the problem is that i dont want to configure it using connection string as HTH said.

i want to Configure it from using SQL Native wizard(ODBC) itself

as i cant touch the application code...

So i just want to have the DNS with

Multiple Active Result Sets(MARS): YES

or any other idea?

Thanks

Regard

Gurpreet S. Gill

|||

There was a lot of careful thought that went into the decision not to expose MARS in the DSN Wizard setttings. MARS is only useful in the case of an application specifically designed to use MARS, and turning MARS on for an application not explicitly designed for it will either provide no utility or in the worst case may cause the application to work incorrectly. Given that, it made sense to require the developer to be present to make the application changes needed to work correctly with MARS, in which case they can use the connection string to turn MARS on.

One way around this might be to use a FileDSN. By creating a FileDSN and manually adding the MARS_Connection keyword you should be able to connect using MARS. But I would exercise caution and make sure the application is well tested for that case.

|||

Hi i set the File DSN as

[ODBC]
DRIVER=SQL Native Client
UID=sa
DATABASE=DM
WSID=VSNET5
APP=Microsoft Data Access Components
SERVER=VSNET1
MARS_Connection=YES

but still it doesnt make MARS enables connection, our appliction still gives error "Connection Busy...."

Any other hint or solution?

regards,

Gurpreet S. Gill

|||

Add this before you call SQLDriverConnect

SQLSetConnectAttr(hdbc, SQL_COPT_SS_MARS_ENABLED, SQL_MARS_ENABLED_YES, SQL_IS_UINTEGER);

|||

If you need to use MARS, you need to set the connection attribute in your application explicitly. It is not possible to enable it in DSN.

This is because that MARS is only useful if an application acutally uses the functionality provided by MARS. In this case, it should not be a problem for the application to set the MARS attribute in code.

It sounds weird to me an application uses MARS but connects to database without enabling it...

|||Where could i write this

SQLSetConnectAttr(hdbc, SQL_COPT_SS_MARS_ENABLED, SQL_MARS_ENABLED_YES, SQL_IS_UINTEGER);

?