If I want to distribute a VB database programm using MSDE I have to install MSDE seperately which can be a challenge for some users. It there a way I could deploy SQL Express with my VB program so the user would not have to do a seperate install? Is this possible in Visual Studio 2003 or do I need 2005?
Thanks
Have a look at the following MSDN Article, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/EmSQLExCustApp.asp
sqlCan I redistribute SQL Express?
http://blogs.msdn.com/sqlexpress/archive/2004/07/04/172952.aspx
Okay. Simple request. I have a local report in my VS2005 project. I want to embed my company logo in the header. How do I do this? When I put an image item on the page it wants me to put something in the value for this? I've tried sending through a dataset but SSRS can't load data set information into the header! Why is this so complicated? I don't want to embed a dynamic database image, just a static image that will be embedded in my program. Any help on this would be appreciated.
Thanks,
Jon
Drag and drop an image control to the page header. Select embedded image. Click New image. Select the image that you want to embed. Then click finish. Build and deploy the report. Voila!
|||This works fine for .rdl files. For me, the image wizard does not come up for .rdlc files. Does anyone know why this is?
|||I've noticed this too. That's what prompted my original question. So basically, here is what I've figured out.
1. Click on Reports > Embedded Images.
2. Add your new image, remember what you named it.
3. Add an image to your report.
4. Click on the image.
5. Change the Source property to 'Embedded'
6. Change the value property to the name of your embedded image.
That's it! I'm still not sure why the wizard doesn't work.
I am trying to create some reports that when rendered in HTML are supposed to have some interactivity built into them. I understand that there aren't any facilities in RDL itself that would help facilitate this process for me, but is there any way to embed some literal strings that will come through in the HTML?
The items I'm trying to finesse through are <script> blocks, checkboxes, and <object> tags. When I use the designer to put these items into textboxes, they get encoded with the HTML values (> instead of >, etc...) so that the code is displayed instead of interpreted.
I thought maybe there would be a VB function that I can wrap around the HTML to prevent it from being encoded so that when the report is displayed on the screen that the interactive elements are there.
Any ideas?
I think this relates to formatting text within a cell, which does not appear to be possible. Perhaps some sort of javascript which will change the innerHTML of the report document?|||Thanks for the response.
I think that I have solved the problem for my situation. Here's what I've discovered so far:
If you use a textbox control, you can set the value of it to an HTML snippet (I'm using an object tag with some param tags as well as checkbox controls). When the report is rendered to HTML, the HTML that was embedded into the report shows as source on the page. I've taken that HTML, saved it off to a file and modified it using some .NET classes. Specifically the HTTPUtility.HtmlDecode function. That function will take the HTML file and undo all of the encoding that Reporting Services has done to your HTML. I also did a small test where I inserted a "<" character somewhere else in the HTML document to simulate something that may actually occur. When I decoded the file that time, all of the encoded HTML snippets were properly decoded, and the less than sign was left alone.
If someone were rendering using the Web Service APIs for Reporting Services, this would work because you are given the stream back. In the case of using a WebForms ReportViewer though, it might be more difficult.
I hope this helps anyone who has a similar problem.
|||Sounds interesting, can you post the code or a snippet of it?Hi Ken,
i'm new with sql reporting service, may i know anyway to make my report export with html format and allow me to send to customer using the ms outlook?
my report contain chart and also table, and image.
i did trying to export using mhtml, but after i send it using the email. at my desktop i able to see it. but my manager not able to read all the image and chart.
thanks for your help.
|||Hello,
Can you please share the code or detail the approach you have taken?
Thanks
I am trying to create some reports that when rendered in HTML are supposed to have some interactivity built into them. I understand that there aren't any facilities in RDL itself that would help facilitate this process for me, but is there any way to embed some literal strings that will come through in the HTML?
The items I'm trying to finesse through are <script> blocks, checkboxes, and <object> tags. When I use the designer to put these items into textboxes, they get encoded with the HTML values (> instead of >, etc...) so that the code is displayed instead of interpreted.
I thought maybe there would be a VB function that I can wrap around the HTML to prevent it from being encoded so that when the report is displayed on the screen that the interactive elements are there.
Any ideas?
I think this relates to formatting text within a cell, which does not appear to be possible. Perhaps some sort of javascript which will change the innerHTML of the report document?|||Thanks for the response.
I think that I have solved the problem for my situation. Here's what I've discovered so far:
If you use a textbox control, you can set the value of it to an HTML snippet (I'm using an object tag with some param tags as well as checkbox controls). When the report is rendered to HTML, the HTML that was embedded into the report shows as source on the page. I've taken that HTML, saved it off to a file and modified it using some .NET classes. Specifically the HTTPUtility.HtmlDecode function. That function will take the HTML file and undo all of the encoding that Reporting Services has done to your HTML. I also did a small test where I inserted a "<" character somewhere else in the HTML document to simulate something that may actually occur. When I decoded the file that time, all of the encoded HTML snippets were properly decoded, and the less than sign was left alone.
If someone were rendering using the Web Service APIs for Reporting Services, this would work because you are given the stream back. In the case of using a WebForms ReportViewer though, it might be more difficult.
I hope this helps anyone who has a similar problem.
|||Sounds interesting, can you post the code or a snippet of it?Hi Ken,
i'm new with sql reporting service, may i know anyway to make my report export with html format and allow me to send to customer using the ms outlook?
my report contain chart and also table, and image.
i did trying to export using mhtml, but after i send it using the email. at my desktop i able to see it. but my manager not able to read all the image and chart.
thanks for your help.
|||Hello,
Can you please share the code or detail the approach you have taken?
Thanks
sqlI am trying to create some reports that when rendered in HTML are supposed to have some interactivity built into them. I understand that there aren't any facilities in RDL itself that would help facilitate this process for me, but is there any way to embed some literal strings that will come through in the HTML?
The items I'm trying to finesse through are <script> blocks, checkboxes, and <object> tags. When I use the designer to put these items into textboxes, they get encoded with the HTML values (> instead of >, etc...) so that the code is displayed instead of interpreted.
I thought maybe there would be a VB function that I can wrap around the HTML to prevent it from being encoded so that when the report is displayed on the screen that the interactive elements are there.
Any ideas?
I think this relates to formatting text within a cell, which does not appear to be possible. Perhaps some sort of javascript which will change the innerHTML of the report document?|||Thanks for the response.
I think that I have solved the problem for my situation. Here's what I've discovered so far:
If you use a textbox control, you can set the value of it to an HTML snippet (I'm using an object tag with some param tags as well as checkbox controls). When the report is rendered to HTML, the HTML that was embedded into the report shows as source on the page. I've taken that HTML, saved it off to a file and modified it using some .NET classes. Specifically the HTTPUtility.HtmlDecode function. That function will take the HTML file and undo all of the encoding that Reporting Services has done to your HTML. I also did a small test where I inserted a "<" character somewhere else in the HTML document to simulate something that may actually occur. When I decoded the file that time, all of the encoded HTML snippets were properly decoded, and the less than sign was left alone.
If someone were rendering using the Web Service APIs for Reporting Services, this would work because you are given the stream back. In the case of using a WebForms ReportViewer though, it might be more difficult.
I hope this helps anyone who has a similar problem.
|||Sounds interesting, can you post the code or a snippet of it?Hi Ken,
i'm new with sql reporting service, may i know anyway to make my report export with html format and allow me to send to customer using the ms outlook?
my report contain chart and also table, and image.
i did trying to export using mhtml, but after i send it using the email. at my desktop i able to see it. but my manager not able to read all the image and chart.
thanks for your help.
|||Hello,
Can you please share the code or detail the approach you have taken?
Thanks
Hi there,
i wanted to embed ASPNETDB into my own db, so i scripted the ASPNETDB and executed it into my db. the problem is that App Manager of my website can not connect to it,(>i've corrected the connectionstring LocalSqlServer), the problem is that, it says its schema is not as expected, i understand this problem but, is there any way to solve it?
thanks in advance
Hi,
Since you're scripting the ASPNETDB to move it to your own db, I suggest you check if there is anything missing. Because you might not scripting everything.
However, I suggest you seperate the ASPNETDB from your own db, since you might need to perform some configuration on the ASPNETDB using .NET tools, which might affect the whole database.
|||Hi,
well, as an inverse approach, i embedded (scripted) my own db into ASPNETDB, and it now works. it seems, as you said, i hadn't copied everything, although i had checked the 'copy all objects' choice.
thanks
I am trying to figure out the way to embed a plug-in (Chime for Windows)
into my report, so that I can display a certain object from a database, that
is stored there as a string. This Chime plug-in would read the input string
and convert it to video display.
This embedding is easily done in simple HTML:
<embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
hlabels2d='terminalhetero' structure= [encrypted string from the database
follows]>
I am wondering is there a way to do such embedding straight into my report
by using the report designer features or by modifying an RDL file for my
report?
If I am able to place my <embed...> string somewhere in my report and when the report is rendered as HTML this string is interpreted as an HTML tag, this would be awesome! So far I experimented with displaying <embed...> string in one of my textboxes, but HTML renderer for report obviously interprets my string as a text not as a tag, so instead of seeing plug-in in action I just see the text of my string.
Probably another approach would be to embed an HTML in a report.
That would also be an exiting idea.
I would appreciate any help on this.
Thanks in advance!
Anton.Reporting Services does not support embedded HTML or object tags. The only way you could do this is to post-process the resulting output.|||
Hello,
Can you detail the approach to be taken, please?
Thanks
I am trying to figure out the way to embed a plug-in (Chime for Windows)
into my report, so that I can display a certain object from a database, that
is stored there as a string. This Chime plug-in would read the input string
and convert it to video display.
This embedding is easily done in simple HTML:
<embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
hlabels2d='terminalhetero' structure= [encrypted string from the database
follows]>
I am wondering is there a way to do such embedding straight into my report
by using the report designer features or by modifying an RDL file for my
report?
If I am able to place my <embed...> string somewhere in my report and when the report is rendered as HTML this string is interpreted as an HTML tag, this would be awesome! So far I experimented with displaying <embed...> string in one of my textboxes, but HTML renderer for report obviously interprets my string as a text not as a tag, so instead of seeing plug-in in action I just see the text of my string.
Probably another approach would be to embed an HTML in a report.
That would also be an exiting idea.
I would appreciate any help on this.
Thanks in advance!
Anton.Reporting Services does not support embedded HTML or object tags. The only way you could do this is to post-process the resulting output.|||
Hello,
Can you detail the approach to be taken, please?
Thanks
