Re: ReportViewer LocalReport does not render correctly - ASP.NET Discussion Boards

Jerry Evans wrote:
web based SQL server backed calendars with access control?

I know I've seen adds for Calendar Controls or libraries.

Jerry Evans wrote:
which is OK but written in Javascript

It's unlikely you will find modern Web controls that don't have a pile of javascript as part of the library. Javascript is the magic beans don't you know. Wink | ;)

led mike

Hi,

I created a printer friendly page which renders the report as an "image" into a memory stream. On the printer friendly page I have an image button which displays the image. Some of the columns did not render and not all rows are included. Can anyone assist me with this issue. Also, how do I reference the memory stream without saving it in session (see *****************)

Thanks

Code:
protected void btPrint_Click1(object sender, EventArgs e)
{
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;

byte[] bytes = ReportViewer.LocalReport.Render("Image", null, out mimeType, out encoding, out extension, out streamids, out warnings);
MemoryStream s = new MemoryStream(bytes);
Session["MemStream"] = s; *****************

Response.Redirect("PrinterFriendly.aspx");
}

PrinterFriendly.aspx
<asp:image id="preview" runat="server" imageurl="~/Imager.aspx" style="position: relative">

Imager.aspx.cs:
protected void Page_Load(object sender, EventArgs e)
{
Response.ContentType = "image/gif";
System.Drawing.Image img = System.Drawing.Image.FromStream(Session["MemStream"]); ******
img.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Gif);
}

Have you solved this?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

No, I wish I had!

What I have added to the above code:

string deviceInfo =
"<deviceinfo>" +
"<outputformat>EMF" +
"<pagewidth>10in" +
"<pageheight>100in" +
"<margintop>0.0in" +
"<marginleft>0.0in" +
"<marginright>0.0in" +
"<marginbottom>0.0in" +
"<deviceinfo>";

The pagewidth in the rdlc is 8.5in but for some reason it cuts of when rendered. The pagewidth setting above solves the columns being cut off (and still fits on a portrait pagesetup. Now, if I increase the pageheight it also includes the entire report vertically, BUT how do I calculate what the correct height must be, what happens with the above code is that it includes all rows of data plus a number of empty pages to make up for the 100inches, which is not what I want. Another problem that comes from this settings is that the first page is blank and the report starts printing on the second page. please give ideas.

Thanx

Sorry the code did not paste corectly:

string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>EMF</OutputFormat>" +
" <PageWidth>10in</PageWidth>" +
" <PageHeight>100in</PageHeight>" +
" <MarginTop>0.0in</MarginTop>" +
" <MarginLeft>0.0in</MarginLeft>" +
" <MarginRight>0.0in</MarginRight>" +
" <MarginBottom>0.0in</MarginBottom>" +
"</DeviceInfo>";

Hi,

I have tried a different aproach: Every page is saved in the stream object. List<stream> consists of all pages.

print_click(...)
{
m_streams = new List<Stream>();
ReportViewer.LocalReport.Render("Image", deviceInfo, CreateStream, out warnings);
foreach (Stream stream in m_streams)
stream.Position = 0;
Session["MemStreamList"] = (List<Stream>)m_streams;

Response.Redirect("PrinterFriendly.aspx");
}

imager.aspx.cs:
page_load(..)
{
Response.ContentType = "image/gif";
List<Stream> memList = new List<Stream>();
memList = Session["MemStreamList"];
for (int i = 1; i < memList.Count; i++)
{
System.Drawing.Image img = System.Drawing.Image.FromStream(memList[i]);
}
img.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Gif);
}

Problem is that now I only have the last page.
Question:
How do I create one image in response.outputstream for all images in list<stream>?

Please help
Thanx

Finally!

I have used different sources to get my solutions, some of which I got from codeproject.

Here goes:

default.aspx.cs:

protected void btPrint_Click(object sender, EventArgs e)
{
RenderReport();
Response.Redirect("PrinterFriendly.aspx");
}

private void RenderReport()
{
Warning[] warnings;

string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>EMF</OutputFormat>" +
" <PageWidth>10in</PageWidth>" +
" <PageHeight>13in</PageHeight>" +
" <MarginTop>0.0in</MarginTop>" +
" <MarginLeft>0.0in</MarginLeft>" +
" <MarginRight>0.0in</MarginRight>" +
" <MarginBottom>0.0in</MarginBottom>" +
"</DeviceInfo>";

m_streams = new List<Stream>();
ReportViewer.LocalReport.Render("Image", deviceInfo, CreateStream, out warnings);

Session["MemStreamList"] = (List<Stream>)m_streams;
}
private Stream CreateStream(string name, string fileNameExtension, Encoding encoding, string mimeType, bool willSeek)
{
Guid newid = Guid.NewGuid();
Stream stream = new FileStream(name + newid + "." + fileNameExtension, FileMode.Create);
m_streams.Add(stream);
return stream;
}

printerfriendly.aspx.cs:
protected void Page_Load(object sender, EventArgs e)
{
List<Stream> memList = (List<Stream>)Session["MemStreamList"];

for (int i = 0; i < memList.Count; i++)
{
string imgString = "<img src=\"MultipleImaging.aspx?Index=" + i + "\">";
this.Controls.Add(new LiteralControl(imgString));
}
}

multipleimaging.aspx.cs:

protected void Page_Load(object sender, EventArgs e)
{
if ((Session["MemStreamList"] != null) && Session["MemStreamList"].GetType().Equals(typeof(List<Stream>)))
{
List<Stream> images = (List<Stream>)Session["MemStreamList"];
int index = Int32.Parse(Request.Params.Get(0).ToString());
if (images[index].Length > 0)
{
try
{
System.Drawing.Image image = System.Drawing.Image.FromStream(images[index]);
image.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Gif);
}
catch (Exception ex)
{//Parameter not valid error, ANY HELP HERE WILL BE APPRECIATED, THANKS Smile | :)

//If the same code is executed again it works, please help
System.Drawing.Image image = System.Drawing.Image.FromStream(images[index]);
image.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Gif);
}
}
else
{
//send a default image
}

}
}

Okay, so the above code renders a local report into images, which is saved in a list<stream>. Each stream is a page of the report. Then is redirects it to a printer friendly page which creates an literal image for every item in list<stream> using multipleimaging.aspx. The printerfriendly page contains a print button with btPrint.Attributes.Add("onclick", "javascript:location.reload(true);window.print();"); in page_load.

Hope some one else can find this helpful, please let me know if there is a better/faster way to accomplish client-side printing of a localreport. By the way, does the .net 2008 reportviewer control which does include a printer icon, prints on the server-side or on the client-side?

what is an exception?
what is diff type of exception?

raja

Um an exception may be an error in the code if this is the context you are talking about
can you explain a bit more

Member 4708077 wrote:
what is an exception?

What is Google[^] and How to use it[^]

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

wt is the diff b/w web application and web application?
how it is executed with iss?

raja

Member 4708077 wrote:
wt is the diff b/w web application and web application?

Am I the only one who sees these two things as the same

By any chance are you trying to preparing for an interview and throwing silly questions onto a public discussion framework.

I really pity your poor potential employer who is going to be associated with you. WTF | :WTF:

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

* Please note i have also posted this in SQL forum as i dont know which is most appropriate. If a mod feel it is wrongly placed here i appologise, feel free to delete.

Problem:

Hi,

I need help with an sql query please.

I wish to insert a new record into a table, and instantly retreive the new records id. Is it possible to do this in one sql statement rather than an INSERT followed by the SELECT statement?

My INSERT looks like this:

string conn = System.Configuration.ConfigurationManager.ConnectionStrings["artisanConnectionString"].ConnectionString;
SqlConnection uniqueCon = new SqlConnection(conn);
//set SQL statement
SqlCommand cmd = new SqlCommand("INSERT INTO [tbl_Additional] (add_Item, add_Price) VALUES ('" + TextBox10.Text + "', '" + TextBox11.Text + "') ", uniqueCon);
cmd.Connection.Open();
try
{//insert/ add new record
//commit to database
cmd.ExecuteNonQuery();
//clear form add/edit
TextBox10.Text = null;
TextBox11.Text = null;
//confirm to user
ShowMessageBox("New unique Item Added!");
//update dataset
GridView2.DataBind();
}
catch
{
ShowMessageBox("Unable to add record!!! Please try again later.");
}
cmd.Connection.Close();

Any help would be greatly appreciated.
Thanks & Happy Easter!

Before you attempt resolving this problem on hand, seriously consider a re-design of your database query approach. Your application is vulnerable for SQL Injection attacks.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

how to get columns of table in order of their ordinal position instead of
alphabetical order of column name?

cn.GetSchema("Columns", restrictions)

output: column_name ordinal_position
...........ambit...............3
...........noise...............1
...........z...................2

required output: column_name ordinal_position
....................noise...............1
....................z...................2
....................ambit...............3

IS IT POSSIBLE?

hmm
try sort by ordinal_position in the query
unless I have mistaken your post

Hi,

I am using Ajaxcalendar control for dates as inputs value.
my requirement, i have validated the dates, that is i am using Rangevalidator control and compare validator for validation.
its working fine, if the date format is mm/dd/yyyy.
In my Application i have mulitple language selection,when i selected Germam,then the date format will be changed to dd.mm.yyyy, then i am unable to validate the textboxes.

please help me.

thanks & regards,
Mohan

its very urgent*****************************************

I'm sure it is to you but its annoying and will just get your ignored

only two letters away from being an asset

Well If i understand your post correctly you just need to find a validator which will compare all types of date formats correctly
I'm sure if you search the Internet you will find one which validates all the correct formats

hope this makes sense Smile | :)

can u given Example?

no trying searching yourself and then provide what you have found so far then we can help you

I think it will solve your problem?

<asp:regularexpressionvalidator id="RegularExpressionValidator2" runat="server" controltovalidate="txttodate" errormessage="Enter Correct Date">
ValidationExpression="(0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d">

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

First learn to post queries in discussion forums. That assumes an top priority urgency for you than this.

Read this: http://www.codeproject.com/kb/scrapbook/forumguidelines.aspx[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson