The problem for me is not calculating the pg total. The main problem is that if the table is spanning multiple pages then how do i get a report item to appear on each page below the table so that i can display the total without using the page footer. i cant use the table footer and cause it to repeat on every page because the table footer is processed only once at the end of the table

Can any one tell me if it is possible to get the page total in the body section of a report....not the footer...thanks in advance

thanks a lot.. :-D

see the prob is that...i need to format numbers such that they are aligned. -ve numbers are denoted in brackets

eg.
5000
(20)

here the nos are not aligned...so i need to print a blank space after the +ve nos so that they align properly. eg.

5000
(20)

is this possible using drawstring() ??????

I need drawstring() to print a trailing blank space but it seems to be trimming the string... does anyone know a workaround to this???

Hi, I'm working with SSRS. i need a report which will have an index page along with it. could any1 guide me through this?? Thanks,

Hi, Could some1 help me with a query which will allow me to get a list of related tables for a particular table. for eg. suppose the user selects 'Product' table , i need a list of tables that are related to the product table Thanks.

i am looking for a general solution, the report may contain a table object or a list to display the data thats not a prob. Adding textbox on the footer to display the sum and making it repeat on every page will not solve the problem, bcos the final total will be displayed on each page and not the individual page total. i'm not really sure if its possible to achieve this without using the page footer....i hope there is a change in the requirement :)

Hi, actually the requirement is that i am required to display the page total for every page without using the header or the footer section. Placing a textbox at the top of the body of the report doesnt display it on all the pages, futhermore the repeat item with dataregion on each page option doesnt work. i have read that this problem goes away when we publish the reports onto a report server. but we are not going to publish them onto a server they are going to be local reports. i wanted to know how the page break occurs to figure out if there is a way to insert the required value before it happens Thanks.

you are getting that error bcos the length that u are specifying is greater than the no of the characters in the string. make sure that you are specifying the right parameters in order to extract the name for the pic...try this strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox6.Text.Substring(11,textBox6.Text.Length-11) +"')"; i am assuming that the cr_pic name starts from the 11th position and u want it till the end. if you are still having a problem the post the format in which you are specifying the cr_pic

Check if this works out strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox6.Text.Substring(11,30) +"')";

Hi, Can any1 pls tell me if it is possible to place a textbox on the body of a report so that it appears on evry page of the report when a page break occurs, i am not supposed to use the page footer part to accomplish this & also there are no groups. i require the textbox to be in the body section itself. Please also let me know how to detect when a pg. break is going to occur in the rdl file(if it is possible) Thanks

Try this strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + substring(textBox6.Text,11,30)+"')";

Hi, I just wanted to know if there are any 3rd party tools available that provide the user with an interface similar to that of SQL Builder which can be used with a windows application to allow the end user to design his own reports. Thanks

Hi, Thanks for the reply...i'm able to do it like that the prob is that if i use that method the i need to keep another hidden field within the report so that i can get the total sum for the column...i was wondering if i could avoid that...bcos in case i have to take sum of more fields then the number of hidden fields will increase

Hi, I have the foll prob.. I need to create a report which will have an a total at the end of each page followed by a grand total at th end of the report. There are no groupings in the data. i am able to achieve individual totals by placing the sum in the page footer but the prob is that on the last page the page total appears after the grand total... any help appreciated