Showing posts with label available. Show all posts
Showing posts with label available. Show all posts

Friday, March 30, 2012

putting image on Crystal Report

Is there any Facility in Crystal Report 9 to Insert image on Crystal report Dynamically... from Database?
Is there any image/Picture control available
please reply me regarding thisHi!
Followinng is how to load picture in Cr from some path dynamically.

for that you will have to do thid

1. Include Crystal Report Designer in to VB
2. add a picture to Detail section of Report
3. double click Detail seciton and code this

Set Picture1.FormattedPicture = LoadPicture(Filepath)

i have used it with Cr8.5.

Tuesday, March 20, 2012

pulling a pdf out of a blob and displaying it in a browser window

I need to pull a PDF file out of a blob that I have uploaded it into. We
need it available on the web.
I can't think of how to utter a statement that will allow acrobat reader to
know that it needs to fire and open what is in the blob.
Ack.In your client code, create a memory stream, or byte arrray, and just write
the contents of that stream or byte array out to the web client using
Response.write...
To tell client browser to load Acrobat reader, just set the
Response.ContentType...
Don't know what you web server programming language is.. but in C#, it
would be:
Response.ContentType = "application/pdf";
"Linda Lalewicz" wrote:

> I need to pull a PDF file out of a blob that I have uploaded it into. We
> need it available on the web.
> I can't think of how to utter a statement that will allow acrobat reader t
o
> know that it needs to fire and open what is in the blob.
> Ack.|||Just like images, except you set the ContentType to application/pdf instead
of image/gif.
http://support.microsoft.com/kb/173308
However, just like images, you may consider storing them in the filesystem.
http://www.aspfaq.com/2149
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Linda Lalewicz" <LindaLalewicz@.discussions.microsoft.com> wrote in message
news:17F6237B-C408-46CE-9194-0DB528D4B255@.microsoft.com...
>I need to pull a PDF file out of a blob that I have uploaded it into. We
> need it available on the web.
> I can't think of how to utter a statement that will allow acrobat reader
> to
> know that it needs to fire and open what is in the blob.

Wednesday, March 7, 2012

Publishing a report programmatically.

Hi!

I have a rdl file and would like to publish it programmatically? Is there any API or Web Service available for this.

Hello Vivekananda:

SQL Server 2005 Reporting Services (SSRS) provides a full-featured set of APIs that you can use to integrate Reporting Services with custom business applications and extend its functionality.

The Report Server Web service provides access to the full functionality of the report server.

A Report Server Web service is an Extensible Markup Language (XML) Web service with a Simple Object Access Protocol (SOAP) API. You can use the Web service to add the functionality of Reporting Services to your business applications.

For more information of the Report Server Web Service:

http://msdn2.microsoft.com/fr-fr/library/ms152787(SQL.90).aspx

ReportingService2005 Class contains the methods and properties that can be used to call the Microsoft SQL Server 2005 Reporting Services (SSRS) Web service.

You can use the method 'ReportingService2005.CreateReport' to create new report to the report server database.

Here is a code example for this:

Code Snippet

class Sample
{
public static void Main()
{
ReportingService2005 rs = new ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

Byte[] definition = null;
Warning[] warnings = null;
string name = "MyReport";

try
{
FileStream stream = File.OpenRead("MyReport.rdl");
definition = new Byte[stream.Length];
stream.Read(definition, 0, (int) stream.Length);
stream.Close();
}

catch(IOException e)
{
Console.WriteLine(e.Message);
}

try
{
warnings = rs.CreateReport(name, "/Samples", false, definition, null);

if (warnings != null)
{
foreach (Warning warning in warnings)
{
Console.WriteLine(warning.Message);
}
}

else
Console.WriteLine("Report: {0} created successfully with no warnings", name);
}

catch (SoapException e)
{
Console.WriteLine(e.Detail.InnerXml.ToString());
}

}
}

Hope this helps.

For more information:

Report Server Web Service Features

Report Server Namespace Management Methods

Good luck.

Publishing a report programmatically.

Hi!

I have a rdl file and would like to publish it programmatically? Is there any API or Web Service available for this.

Hello Vivekananda:

SQL Server 2005 Reporting Services (SSRS) provides a full-featured set of APIs that you can use to integrate Reporting Services with custom business applications and extend its functionality.

The Report Server Web service provides access to the full functionality of the report server.

A Report Server Web service is an Extensible Markup Language (XML) Web service with a Simple Object Access Protocol (SOAP) API. You can use the Web service to add the functionality of Reporting Services to your business applications.

For more information of the Report Server Web Service:

http://msdn2.microsoft.com/fr-fr/library/ms152787(SQL.90).aspx

ReportingService2005 Class contains the methods and properties that can be used to call the Microsoft SQL Server 2005 Reporting Services (SSRS) Web service.

You can use the method 'ReportingService2005.CreateReport' to create new report to the report server database.

Here is a code example for this:

Code Snippet

class Sample
{
public static void Main()
{
ReportingService2005 rs = new ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

Byte[] definition = null;
Warning[] warnings = null;
string name = "MyReport";

try
{
FileStream stream = File.OpenRead("MyReport.rdl");
definition = new Byte[stream.Length];
stream.Read(definition, 0, (int) stream.Length);
stream.Close();
}

catch(IOException e)
{
Console.WriteLine(e.Message);
}

try
{
warnings = rs.CreateReport(name, "/Samples", false, definition, null);

if (warnings != null)
{
foreach (Warning warning in warnings)
{
Console.WriteLine(warning.Message);
}
}

else
Console.WriteLine("Report: {0} created successfully with no warnings", name);
}

catch (SoapException e)
{
Console.WriteLine(e.Detail.InnerXml.ToString());
}

}
}

Hope this helps.

For more information:

Report Server Web Service Features

Report Server Namespace Management Methods

Good luck.

Saturday, February 25, 2012

Public SS2005 newsgroups

Now that SS2005 is in public beta, are there any newsgroups available to the
public (or at least, those with the beta)?
Thanks,
Adam Machanic
online:
http://communities.microsoft.com/new...r2005&slcid=us
newsreader info is on that web page as well
Keith
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:ON%23dLKLdEHA.1048@.tk2msftngp13.phx.gbl...
> Now that SS2005 is in public beta, are there any newsgroups available to
the
> public (or at least, those with the beta)?
>
> Thanks,
> Adam Machanic
>
|||Thanks!
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:usG5rTLdEHA.1040@.TK2MSFTNGP10.phx.gbl...
> online:
>
http://communities.microsoft.com/new...r2005&slcid=us
> newsreader info is on that web page as well
> --
> Keith
>
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
> news:ON%23dLKLdEHA.1048@.tk2msftngp13.phx.gbl...
> the
>

Public SS2005 newsgroups

Now that SS2005 is in public beta, are there any newsgroups available to the
public (or at least, those with the beta)?
Thanks,
Adam Machaniconline:
" target="_blank">http://communities.microsoft.com/ne...lcid=us

newsreader info is on that web page as well
Keith
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:ON%23dLKLdEHA.1048@.tk2msftngp13.phx.gbl...
> Now that SS2005 is in public beta, are there any newsgroups available to
the
> public (or at least, those with the beta)?
>
> Thanks,
> Adam Machanic
>|||Thanks!
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:usG5rTLdEHA.1040@.TK2MSFTNGP10.phx.gbl...
> online:
>
http://communities.microsoft.com/ne...er2005&slcid=usgreen">
> newsreader info is on that web page as well
> --
> Keith
>
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
> news:ON%23dLKLdEHA.1048@.tk2msftngp13.phx.gbl...
> the
>

Public SS2005 newsgroups

Now that SS2005 is in public beta, are there any newsgroups available to the
public (or at least, those with the beta)?
Thanks,
Adam Machaniconline:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
newsreader info is on that web page as well
--
Keith
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:ON%23dLKLdEHA.1048@.tk2msftngp13.phx.gbl...
> Now that SS2005 is in public beta, are there any newsgroups available to
the
> public (or at least, those with the beta)?
>
> Thanks,
> Adam Machanic
>|||Thanks!
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:usG5rTLdEHA.1040@.TK2MSFTNGP10.phx.gbl...
> online:
>
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
> newsreader info is on that web page as well
> --
> Keith
>
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
> news:ON%23dLKLdEHA.1048@.tk2msftngp13.phx.gbl...
> > Now that SS2005 is in public beta, are there any newsgroups available to
> the
> > public (or at least, those with the beta)?
> >
> >
> > Thanks,
> > Adam Machanic
> >
> >
>