Hello All,
When I restore a backup on a different Server, It automatically creartes the
records in sysfulltextcatalogs which refers the Catelogue path of old
database.
How to come out of this Proble?
If I remove the records from sysfulltextcatalogs, then while enabling the
Database for Fulltext indexing, the below error occured.
" Full-text catalog '' has been lost. Use sp_fulltext_catalog to
rebuild and to repopulate this full-text catalog. "
Is there a way that we can remove the old catelogue references and re-create
and populate the Catelogues?
Warm Regards
Sahian
Hi
This may help:
http://support.microsoft.com/default...b;en-us;240867
John
"Sathian" wrote:
> Hello All,
> When I restore a backup on a different Server, It automatically creartes the
> records in sysfulltextcatalogs which refers the Catelogue path of old
> database.
> How to come out of this Proble?
> If I remove the records from sysfulltextcatalogs, then while enabling the
> Database for Fulltext indexing, the below error occured.
> " Full-text catalog '' has been lost. Use sp_fulltext_catalog to
> rebuild and to repopulate this full-text catalog. "
> Is there a way that we can remove the old catelogue references and re-create
> and populate the Catelogues?
> Warm Regards
> Sahian
>
>
|||John,
While that KB article talks about moving or copying FT Catalogs it does not
directly address the issue that Sathian is encountering relative to the
"Full-text Catalog has been lost" (due to deleting the entry in
sysfulltextcatalogs). Sathian, you can run the following T-SQL system stored
proc to 'clean up' or remove any FT Catalogs that are referenced in
sysfulltextcatalog, but not actually present on the server or in the
registry keys:
sp_fulltext_service 'Clean_Up'
This should "clean up" the registry keys and allow you to proceed. See
http://msdn.microsoft.com/library/de...ullad_2gtv.asp
for more details.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:B792F9EB-983E-4E7E-84E0-17A0126167BF@.microsoft.com...[vbcol=seagreen]
> Hi
> This may help:
> http://support.microsoft.com/default...b;en-us;240867
> John
> "Sathian" wrote:
the[vbcol=seagreen]
the[vbcol=seagreen]
re-create[vbcol=seagreen]
|||Hi John
The removal of the record was by the OP,
"If I remove the records from sysfulltextcatalogs, then while enabling the
Database for Fulltext indexing, the below error occured."
He required:
"Is there a way that we can remove the old catelogue references and re-create
and populate the Catelogues?"
If he follows the article he can transfer the Full Text indexing correctly.
John
"John Kane" wrote:
> John,
> While that KB article talks about moving or copying FT Catalogs it does not
> directly address the issue that Sathian is encountering relative to the
> "Full-text Catalog has been lost" (due to deleting the entry in
> sysfulltextcatalogs). Sathian, you can run the following T-SQL system stored
> proc to 'clean up' or remove any FT Catalogs that are referenced in
> sysfulltextcatalog, but not actually present on the server or in the
> registry keys:
> sp_fulltext_service 'Clean_Up'
> This should "clean up" the registry keys and allow you to proceed. See
> http://msdn.microsoft.com/library/de...ullad_2gtv.asp
> for more details.
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:B792F9EB-983E-4E7E-84E0-17A0126167BF@.microsoft.com...
> the
> the
> re-create
>
>
|||Hi John,
True. My only point is that the OP should not be manually removing records
from a system table as it is generally not recommended by Microsoft or by
MVP's to manually delete rows from any systems tables... However, the
"clean_up" parameter of sp_fulltext_service does - "Remove from the file
system all full-text catalogs that no longer have meta data for them in SQL
Server by executing this stored procedure". Note, the meta data includes the
entries in sysfulltextcatalogs as well as the FT Catalog registry keys that
are maintained by the MSSearch service.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:A2BA13CF-D2AE-4557-AE46-C3D10D2CD188@.microsoft.com...
> Hi John
> The removal of the record was by the OP,
> "If I remove the records from sysfulltextcatalogs, then while enabling the
> Database for Fulltext indexing, the below error occured."
> He required:
> "Is there a way that we can remove the old catelogue references and
re-create
> and populate the Catelogues?"
> If he follows the article he can transfer the Full Text indexing
correctly.[vbcol=seagreen]
> John
> "John Kane" wrote:
not[vbcol=seagreen]
stored[vbcol=seagreen]
http://msdn.microsoft.com/library/de...ullad_2gtv.asp[vbcol=seagreen]
creartes[vbcol=seagreen]
old[vbcol=seagreen]
enabling[vbcol=seagreen]
sp_fulltext_catalog to[vbcol=seagreen]
Showing posts with label path. Show all posts
Showing posts with label path. Show all posts
Friday, March 30, 2012
Friday, March 23, 2012
Image rendering with IIS Virtual Directory
Iâ'm trying to show images in my report using a url path since I the pics are
many and ever changing. Iâ've set the image source=external;
Image value= http://<webserver>/<IISVirtualDirectoryName>/filename.jpg
If I set the IIS Directory security to â'Anonymous Accessâ' with a proper
Account name/pass, the image renders properly.
If I try to set the IIS Directory security to â'Windows authenticationâ', the
image does not render-- even though all the other report fields are populated.
So it appears to me the credentials are not being passed to IIS for the
virtual directory authentication when the report is rendered.
How can I pass the report credentials to IIS?
Btw-Iâ'm running SP1 on Win2K, and have set the unattended user/pass, and
have tried various datasource options in Report Manager without success.Tony,
I am not sure if this is what you are looking for but this is what we did.
We generated the image in an aspx page that only contains the image. We then
set the image value = to the URL of that aspx page and works without a hitch.
In our case we were generating Trend graphs in a third party graphing tool
and exporting them as bitmaps and having Reporting Services display the
image. We had to do this because Reporting Services graphing ability is
rather lacking and we are in the process of moving all of the companies
reports to reporting services.
Hope this helps
"Tony Ballman" wrote:
> Iâ'm trying to show images in my report using a url path since I the pics are
> many and ever changing. Iâ've set the image source=external;
> Image value= http://<webserver>/<IISVirtualDirectoryName>/filename.jpg
> If I set the IIS Directory security to â'Anonymous Accessâ' with a proper
> Account name/pass, the image renders properly.
> If I try to set the IIS Directory security to â'Windows authenticationâ', the
> image does not render-- even though all the other report fields are populated.
> So it appears to me the credentials are not being passed to IIS for the
> virtual directory authentication when the report is rendered.
> How can I pass the report credentials to IIS?
> Btw-Iâ'm running SP1 on Win2K, and have set the unattended user/pass, and
> have tried various datasource options in Report Manager without success.
>|||Thanks that's a great idea. I suppose you're also able to thumbnail or reduce
the image size that way too.
My thought was to create an IIS web site set to localhost of the box running
the report server, and then placing the IIS Virtual directory there with
anonymous access- so the virtual directory access is at least limited to
inside the firewall.
"KBurnell" wrote:
> Tony,
> I am not sure if this is what you are looking for but this is what we did.
> We generated the image in an aspx page that only contains the image. We then
> set the image value = to the URL of that aspx page and works without a hitch.
> In our case we were generating Trend graphs in a third party graphing tool
> and exporting them as bitmaps and having Reporting Services display the
> image. We had to do this because Reporting Services graphing ability is
> rather lacking and we are in the process of moving all of the companies
> reports to reporting services.
> Hope this helps
> "Tony Ballman" wrote:
> > Iâ'm trying to show images in my report using a url path since I the pics are
> > many and ever changing. Iâ've set the image source=external;
> > Image value= http://<webserver>/<IISVirtualDirectoryName>/filename.jpg
> > If I set the IIS Directory security to â'Anonymous Accessâ' with a proper
> > Account name/pass, the image renders properly.
> > If I try to set the IIS Directory security to â'Windows authenticationâ', the
> > image does not render-- even though all the other report fields are populated.
> > So it appears to me the credentials are not being passed to IIS for the
> > virtual directory authentication when the report is rendered.
> >
> > How can I pass the report credentials to IIS?
> >
> > Btw-Iâ'm running SP1 on Win2K, and have set the unattended user/pass, and
> > have tried various datasource options in Report Manager without success.
> >
many and ever changing. Iâ've set the image source=external;
Image value= http://<webserver>/<IISVirtualDirectoryName>/filename.jpg
If I set the IIS Directory security to â'Anonymous Accessâ' with a proper
Account name/pass, the image renders properly.
If I try to set the IIS Directory security to â'Windows authenticationâ', the
image does not render-- even though all the other report fields are populated.
So it appears to me the credentials are not being passed to IIS for the
virtual directory authentication when the report is rendered.
How can I pass the report credentials to IIS?
Btw-Iâ'm running SP1 on Win2K, and have set the unattended user/pass, and
have tried various datasource options in Report Manager without success.Tony,
I am not sure if this is what you are looking for but this is what we did.
We generated the image in an aspx page that only contains the image. We then
set the image value = to the URL of that aspx page and works without a hitch.
In our case we were generating Trend graphs in a third party graphing tool
and exporting them as bitmaps and having Reporting Services display the
image. We had to do this because Reporting Services graphing ability is
rather lacking and we are in the process of moving all of the companies
reports to reporting services.
Hope this helps
"Tony Ballman" wrote:
> Iâ'm trying to show images in my report using a url path since I the pics are
> many and ever changing. Iâ've set the image source=external;
> Image value= http://<webserver>/<IISVirtualDirectoryName>/filename.jpg
> If I set the IIS Directory security to â'Anonymous Accessâ' with a proper
> Account name/pass, the image renders properly.
> If I try to set the IIS Directory security to â'Windows authenticationâ', the
> image does not render-- even though all the other report fields are populated.
> So it appears to me the credentials are not being passed to IIS for the
> virtual directory authentication when the report is rendered.
> How can I pass the report credentials to IIS?
> Btw-Iâ'm running SP1 on Win2K, and have set the unattended user/pass, and
> have tried various datasource options in Report Manager without success.
>|||Thanks that's a great idea. I suppose you're also able to thumbnail or reduce
the image size that way too.
My thought was to create an IIS web site set to localhost of the box running
the report server, and then placing the IIS Virtual directory there with
anonymous access- so the virtual directory access is at least limited to
inside the firewall.
"KBurnell" wrote:
> Tony,
> I am not sure if this is what you are looking for but this is what we did.
> We generated the image in an aspx page that only contains the image. We then
> set the image value = to the URL of that aspx page and works without a hitch.
> In our case we were generating Trend graphs in a third party graphing tool
> and exporting them as bitmaps and having Reporting Services display the
> image. We had to do this because Reporting Services graphing ability is
> rather lacking and we are in the process of moving all of the companies
> reports to reporting services.
> Hope this helps
> "Tony Ballman" wrote:
> > Iâ'm trying to show images in my report using a url path since I the pics are
> > many and ever changing. Iâ've set the image source=external;
> > Image value= http://<webserver>/<IISVirtualDirectoryName>/filename.jpg
> > If I set the IIS Directory security to â'Anonymous Accessâ' with a proper
> > Account name/pass, the image renders properly.
> > If I try to set the IIS Directory security to â'Windows authenticationâ', the
> > image does not render-- even though all the other report fields are populated.
> > So it appears to me the credentials are not being passed to IIS for the
> > virtual directory authentication when the report is rendered.
> >
> > How can I pass the report credentials to IIS?
> >
> > Btw-Iâ'm running SP1 on Win2K, and have set the unattended user/pass, and
> > have tried various datasource options in Report Manager without success.
> >
Image path/not an actual image on an rdl
I put together an invoice report in RS which will be given to multiple
clients. I would like their logo to show up on the report. Instead of
embedding 1 logo on the .rdl and then giving it to one client, then
embedding a different logo on the .rdl and giving that to a different
client, so on and so on, can I just put a path to an image on the file and
make sure that each logo is placed in the same folder in the same drive,
ie.. "C:\[logofolder]".
Thank you for the help.
--You will need RS 2000 SP1. Details are in the SP1 readme file:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
The file: protocol is supported to fetch images from local or network paths.
Make sure to follow the instructions in RS BOL for "Configuring an Account
for Unattended Report Processing" on the report server, as indicated in the
SP1 readme file.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Cranium" <mgreco40@.hotmail.com> wrote in message
news:OnxfRk7pEHA.3716@.TK2MSFTNGP10.phx.gbl...
> I put together an invoice report in RS which will be given to multiple
> clients. I would like their logo to show up on the report. Instead of
> embedding 1 logo on the .rdl and then giving it to one client, then
> embedding a different logo on the .rdl and giving that to a different
> client, so on and so on, can I just put a path to an image on the file and
> make sure that each logo is placed in the same folder in the same drive,
> ie.. "C:\[logofolder]".
> Thank you for the help.
> --
>
>|||Hi,
I followed all instructions in the Rs BOL but the problem isn't resolved.
Do you know if some other things can cause the problem?
"Robert Bruckner [MSFT]" wrote:
> You will need RS 2000 SP1. Details are in the SP1 readme file:
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
> The file: protocol is supported to fetch images from local or network paths.
> Make sure to follow the instructions in RS BOL for "Configuring an Account
> for Unattended Report Processing" on the report server, as indicated in the
> SP1 readme file.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Richard Cranium" <mgreco40@.hotmail.com> wrote in message
> news:OnxfRk7pEHA.3716@.TK2MSFTNGP10.phx.gbl...
> > I put together an invoice report in RS which will be given to multiple
> > clients. I would like their logo to show up on the report. Instead of
> > embedding 1 logo on the .rdl and then giving it to one client, then
> > embedding a different logo on the .rdl and giving that to a different
> > client, so on and so on, can I just put a path to an image on the file and
> > make sure that each logo is placed in the same folder in the same drive,
> > ie.. "C:\[logofolder]".
> >
> > Thank you for the help.
> >
> > --
> >
> >
> >
>
>
clients. I would like their logo to show up on the report. Instead of
embedding 1 logo on the .rdl and then giving it to one client, then
embedding a different logo on the .rdl and giving that to a different
client, so on and so on, can I just put a path to an image on the file and
make sure that each logo is placed in the same folder in the same drive,
ie.. "C:\[logofolder]".
Thank you for the help.
--You will need RS 2000 SP1. Details are in the SP1 readme file:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
The file: protocol is supported to fetch images from local or network paths.
Make sure to follow the instructions in RS BOL for "Configuring an Account
for Unattended Report Processing" on the report server, as indicated in the
SP1 readme file.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Cranium" <mgreco40@.hotmail.com> wrote in message
news:OnxfRk7pEHA.3716@.TK2MSFTNGP10.phx.gbl...
> I put together an invoice report in RS which will be given to multiple
> clients. I would like their logo to show up on the report. Instead of
> embedding 1 logo on the .rdl and then giving it to one client, then
> embedding a different logo on the .rdl and giving that to a different
> client, so on and so on, can I just put a path to an image on the file and
> make sure that each logo is placed in the same folder in the same drive,
> ie.. "C:\[logofolder]".
> Thank you for the help.
> --
>
>|||Hi,
I followed all instructions in the Rs BOL but the problem isn't resolved.
Do you know if some other things can cause the problem?
"Robert Bruckner [MSFT]" wrote:
> You will need RS 2000 SP1. Details are in the SP1 readme file:
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
> The file: protocol is supported to fetch images from local or network paths.
> Make sure to follow the instructions in RS BOL for "Configuring an Account
> for Unattended Report Processing" on the report server, as indicated in the
> SP1 readme file.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Richard Cranium" <mgreco40@.hotmail.com> wrote in message
> news:OnxfRk7pEHA.3716@.TK2MSFTNGP10.phx.gbl...
> > I put together an invoice report in RS which will be given to multiple
> > clients. I would like their logo to show up on the report. Instead of
> > embedding 1 logo on the .rdl and then giving it to one client, then
> > embedding a different logo on the .rdl and giving that to a different
> > client, so on and so on, can I just put a path to an image on the file and
> > make sure that each logo is placed in the same folder in the same drive,
> > ie.. "C:\[logofolder]".
> >
> > Thank you for the help.
> >
> > --
> >
> >
> >
>
>
Image not displayed in report
I am creating a very simple report in VS 2005. I dragged an image
control to the report surface and set it's value property to the
virtual path of my image (like "~/SubPage/Trademark.jpg"). However,
the image is never displayed - either at design time, when the report
viewer runs, or when the report is exported to PDF. I just get the
standard "No image" (red X) icon.
I have read other posts about this but most of them were trying to do
something more complicated than me. At this point, I am not trying to
do any logic for the visibility or the value it is trying to display.
I read about a bug that might be related here:
http://support.microsoft.com/kb/842537/
...but I am not sure if this pertains to me (as I am not pointing to a
URL, but rather a virtual path). I am leery of applying this SP2
patch, as there is no way to uninstall it, and I am not sure if it
will "break" anything that is currently working.
I would appreciate any suggestions that anyone could give me.
Thank you!Kirk,
Try embedding the image into the report instead of using the URL.
MM
"Kirk" wrote:
> I am creating a very simple report in VS 2005. I dragged an image
> control to the report surface and set it's value property to the
> virtual path of my image (like "~/SubPage/Trademark.jpg"). However,
> the image is never displayed - either at design time, when the report
> viewer runs, or when the report is exported to PDF. I just get the
> standard "No image" (red X) icon.
> I have read other posts about this but most of them were trying to do
> something more complicated than me. At this point, I am not trying to
> do any logic for the visibility or the value it is trying to display.
> I read about a bug that might be related here:
> http://support.microsoft.com/kb/842537/
> ...but I am not sure if this pertains to me (as I am not pointing to a
> URL, but rather a virtual path). I am leery of applying this SP2
> patch, as there is no way to uninstall it, and I am not sure if it
> will "break" anything that is currently working.
> I would appreciate any suggestions that anyone could give me.
> Thank you!
>|||I´ve also tested what you say and it does not work with relative path.
To make it work, do what Marie says or use absolute URL
(http://www.yourpage.com/Subpage/Trademark.jpg)
"Kirk" <loki70@.hotmail.com> escribió en el mensaje
news:1193753651.198915.166370@.k79g2000hse.googlegroups.com...
>I am creating a very simple report in VS 2005. I dragged an image
> control to the report surface and set it's value property to the
> virtual path of my image (like "~/SubPage/Trademark.jpg"). However,
> the image is never displayed - either at design time, when the report
> viewer runs, or when the report is exported to PDF. I just get the
> standard "No image" (red X) icon.
> I have read other posts about this but most of them were trying to do
> something more complicated than me. At this point, I am not trying to
> do any logic for the visibility or the value it is trying to display.
> I read about a bug that might be related here:
> http://support.microsoft.com/kb/842537/
> ...but I am not sure if this pertains to me (as I am not pointing to a
> URL, but rather a virtual path). I am leery of applying this SP2
> patch, as there is no way to uninstall it, and I am not sure if it
> will "break" anything that is currently working.
> I would appreciate any suggestions that anyone could give me.
> Thank you!
>|||On Oct 31, 12:21 pm, "M=F3nica" <monica.d...@.augure.com> wrote:
> I=B4ve also tested what you say and it does not work with relative path.
> To make it work, do what Marie says or use absolute URL
> (http://www.yourpage.com/Subpage/Trademark.jpg)
> "Kirk" <lok...@.hotmail.com> escribi=F3 en el mensajenews:1193753651.19891=5=2E166370@.k79g2000hse.googlegroups.com...
>
> >I am creating a very simple report in VS 2005. I dragged an image
> > control to the report surface and set it's value property to the
> > virtual path of my image (like "~/SubPage/Trademark.jpg"). However,
> > the image is never displayed - either at design time, when the report
> > viewer runs, or when the report is exported to PDF. I just get the
> > standard "No image" (red X) icon.
> > I have read other posts about this but most of them were trying to do
> > something more complicated than me. At this point, I am not trying to
> > do any logic for the visibility or the value it is trying to display.
> > I read about a bug that might be related here:
> >http://support.microsoft.com/kb/842537/
> > ...but I am not sure if this pertains to me (as I am not pointing to a
> > URL, but rather a virtual path). I am leery of applying this SP2
> > patch, as there is no way to uninstall it, and I am not sure if it
> > will "break" anything that is currently working.
> > I would appreciate any suggestions that anyone could give me.
> > Thank you!- Hide quoted text -
> - Show quoted text -
Thanks for the replies. I used the absolute URL and that worked.
It's unfortunate that this does not work with a relative path.
Obviously, thing change (and move around on servers) and having to
update the application just to update absolute URL's is goofy. I
know, I know, you can add this as a configuration setting so that you
don't have to rebuild the site - I was just whining.
Thanks again!
control to the report surface and set it's value property to the
virtual path of my image (like "~/SubPage/Trademark.jpg"). However,
the image is never displayed - either at design time, when the report
viewer runs, or when the report is exported to PDF. I just get the
standard "No image" (red X) icon.
I have read other posts about this but most of them were trying to do
something more complicated than me. At this point, I am not trying to
do any logic for the visibility or the value it is trying to display.
I read about a bug that might be related here:
http://support.microsoft.com/kb/842537/
...but I am not sure if this pertains to me (as I am not pointing to a
URL, but rather a virtual path). I am leery of applying this SP2
patch, as there is no way to uninstall it, and I am not sure if it
will "break" anything that is currently working.
I would appreciate any suggestions that anyone could give me.
Thank you!Kirk,
Try embedding the image into the report instead of using the URL.
MM
"Kirk" wrote:
> I am creating a very simple report in VS 2005. I dragged an image
> control to the report surface and set it's value property to the
> virtual path of my image (like "~/SubPage/Trademark.jpg"). However,
> the image is never displayed - either at design time, when the report
> viewer runs, or when the report is exported to PDF. I just get the
> standard "No image" (red X) icon.
> I have read other posts about this but most of them were trying to do
> something more complicated than me. At this point, I am not trying to
> do any logic for the visibility or the value it is trying to display.
> I read about a bug that might be related here:
> http://support.microsoft.com/kb/842537/
> ...but I am not sure if this pertains to me (as I am not pointing to a
> URL, but rather a virtual path). I am leery of applying this SP2
> patch, as there is no way to uninstall it, and I am not sure if it
> will "break" anything that is currently working.
> I would appreciate any suggestions that anyone could give me.
> Thank you!
>|||I´ve also tested what you say and it does not work with relative path.
To make it work, do what Marie says or use absolute URL
(http://www.yourpage.com/Subpage/Trademark.jpg)
"Kirk" <loki70@.hotmail.com> escribió en el mensaje
news:1193753651.198915.166370@.k79g2000hse.googlegroups.com...
>I am creating a very simple report in VS 2005. I dragged an image
> control to the report surface and set it's value property to the
> virtual path of my image (like "~/SubPage/Trademark.jpg"). However,
> the image is never displayed - either at design time, when the report
> viewer runs, or when the report is exported to PDF. I just get the
> standard "No image" (red X) icon.
> I have read other posts about this but most of them were trying to do
> something more complicated than me. At this point, I am not trying to
> do any logic for the visibility or the value it is trying to display.
> I read about a bug that might be related here:
> http://support.microsoft.com/kb/842537/
> ...but I am not sure if this pertains to me (as I am not pointing to a
> URL, but rather a virtual path). I am leery of applying this SP2
> patch, as there is no way to uninstall it, and I am not sure if it
> will "break" anything that is currently working.
> I would appreciate any suggestions that anyone could give me.
> Thank you!
>|||On Oct 31, 12:21 pm, "M=F3nica" <monica.d...@.augure.com> wrote:
> I=B4ve also tested what you say and it does not work with relative path.
> To make it work, do what Marie says or use absolute URL
> (http://www.yourpage.com/Subpage/Trademark.jpg)
> "Kirk" <lok...@.hotmail.com> escribi=F3 en el mensajenews:1193753651.19891=5=2E166370@.k79g2000hse.googlegroups.com...
>
> >I am creating a very simple report in VS 2005. I dragged an image
> > control to the report surface and set it's value property to the
> > virtual path of my image (like "~/SubPage/Trademark.jpg"). However,
> > the image is never displayed - either at design time, when the report
> > viewer runs, or when the report is exported to PDF. I just get the
> > standard "No image" (red X) icon.
> > I have read other posts about this but most of them were trying to do
> > something more complicated than me. At this point, I am not trying to
> > do any logic for the visibility or the value it is trying to display.
> > I read about a bug that might be related here:
> >http://support.microsoft.com/kb/842537/
> > ...but I am not sure if this pertains to me (as I am not pointing to a
> > URL, but rather a virtual path). I am leery of applying this SP2
> > patch, as there is no way to uninstall it, and I am not sure if it
> > will "break" anything that is currently working.
> > I would appreciate any suggestions that anyone could give me.
> > Thank you!- Hide quoted text -
> - Show quoted text -
Thanks for the replies. I used the absolute URL and that worked.
It's unfortunate that this does not work with a relative path.
Obviously, thing change (and move around on servers) and having to
update the application just to update absolute URL's is goofy. I
know, I know, you can add this as a configuration setting so that you
don't have to rebuild the site - I was just whining.
Thanks again!
Wednesday, March 21, 2012
Image for path returned by Query in RDLC & ReportViewer
Anyone know how to add an image to report whose path is returned by
the query?
JasonOn Mar 10, 3:05=A0pm, Jason Wilson <wils...@.ausrad.com> wrote:
> Anyone know how to add an image to report whose path is returned by
> the query?
> Jason
I figured this out, but now I would like to show a tif image. Anyone
know how to do this?sql
the query?
JasonOn Mar 10, 3:05=A0pm, Jason Wilson <wils...@.ausrad.com> wrote:
> Anyone know how to add an image to report whose path is returned by
> the query?
> Jason
I figured this out, but now I would like to show a tif image. Anyone
know how to do this?sql
Image Filepath in sql
Hi in my table i have a field which would store the file path of an image, the datatype is a varchar, and i wrote the following filepath in it but it didnt work, when i tried to call it up in the browser it didnt show, is the way i saved it below the right format?
C:\Millio\Documents\Project\Images\car.jpg
That's fine, but you will have to post some of your code so we can see why it might not be diplaying.
|||Hi thanks for responding this is the part where i am calling the image from;
<ItemTemplate>
<span><spanstyle="font-size: 14pt">
<asp:ImageID="Image1"ImageUrl='<%# Eval("Images") %>'runat="server"/>
<br/>
|||
You should store the virtual path of your image in the database rather than the physical path.
If you use a physical path like the one you are showing, you will need to use an HttpHandler to stream the image to the browser. The img tag takes a url value for the src attribute, so you could move the images to a folder within your web site, and reference them with a virtual path. Or if Project is already your virtual directory (the root folder for your web site), the path that you should store in the database is "images/car.jpg" or "~/images/car.jpg". Both will work, but the second one is ASP.NET specific, and can only be used when setting the ImageURL property of an asp server control. I would opt for the first one, just in case I decided to convert the site to PHP.
Or more realistically, decide to use the value to build up the src attribute of an <img> tag in code, and don't bother with a server control.
Hi Mike the reason i did it that way is because i am using a user control to load up my pages, and i didnt want to have to make a page for each category, i will show you what i mean;
<%@.ControlLanguage="C#"AutoEventWireup="true"CodeFile="CategoryList.ascx.cs"Inherits="CategoryList" %>
<scriptrunat="server">
string _Category = "washing machines";
public string Category
{
get { return _Category; }
set { _Category = value; }
}
protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
{
Label ID = (Label)DataList1.SelectedItem.FindControl("categoryIDLabel");
// Label AD = (Label)DataList1.SelectedItem.FindControl("PriceLabel");
Label MD = (Label)DataList1.SelectedItem.FindControl("categoryNameLabel");
Trace.Write("category " + ID.Text);
//Trace.Write("Price " + AD.Text);
Trace.Write("categoryName " + MD.Text);
Session["scategoryID"] = ID.Text;
//Session["scategorydescription"] = AD.Text;
Session["scategoryName"] = MD.Text;
}
protected void Page_Load(object sender, EventArgs e)
{
SqlDataSource1.SelectParameters["categoryName"].DefaultValue = _Category;
}
</script><asp:DataListID="DataList1"runat="server"BackColor="White"BorderColor="Transparent"
BorderStyle="None"BorderWidth="1px"CellPadding="4"DataSourceID="SqlDataSource1"
ForeColor="Black"GridLines="Horizontal"OnSelectedIndexChanged="DataList1_SelectedIndexChanged">
<FooterStyleBackColor="#CCCC99"ForeColor="Black"/>
<SelectedItemStyleBackColor="White"Font-Bold="True"ForeColor="White"Font-Italic="False"Font-Overline="False"Font-Strikeout="False"Font-Underline="False"/>
<HeaderStyleBackColor="#333333"Font-Bold="True"ForeColor="White"/>
<SeparatorStyleBackColor="Black"BorderColor="Black"BorderStyle="Solid"BorderWidth="2px"/>
<AlternatingItemStyleBackColor="White"Font-Bold="False"Font-Italic="False"Font-Overline="False"
Font-Strikeout="False"Font-Underline="False"/>
<ItemTemplate>
<span><spanstyle="font-size: 14pt">
<asp:ImageID="Image1"ImageUrl='<%# Eval("categoryImage") %>'runat="server"/>
<br/>
<asp:LabelID="categoryNameLabel"runat="server"Text='<%# Eval("categoryName") %>'ForeColor="DimGray"Font-Size="11pt"Font-Names="Trebuchet MS"></asp:Label><br/>
<br/>
<spanstyle="color: black"></span>
<asp:LabelID="CategoryIDLabel"runat="server"Visible="False"Text='<%# Eval("categoryID") %>'ForeColor="DimGray"Font-Size="11pt"></asp:Label><br/>
<br/>
<asp:LabelID="categoryDescriptionLabel"runat="server"Visible="True"Text='<%# Eval("categoryDescription") %>'ForeColor="DimGray"Font-Size="11pt"></asp:Label><br/>
<br/>
<br/>
</ItemTemplate></asp:DataList>
<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:streamConnectionString %>"
SelectCommand="SELECT [categoryID], [categoryImage], [categoryName], [categoryDescription] FROM [Categories] WHERE ([categoryName] = @.categoryName)">
<SelectParameters>
<asp:ParameterName="categoryName"Type="string"/>
</SelectParameters></asp:SqlDataSource>
Image control in RDLC report page.
Using RDLC report file, How can i set the image path on image control to the image in my folder \images.
I don't see any ImageURL property in such control.
thanks,
Hi,
From your description, it seems that you want to add a image in your report, right?
You can include stored images in a report by specifying a URL to the image. When you use an external image in a report, the image source is set to External and the value for the image is the URL address to the image. For a report published to a report server configured for native mode, use a full or relative path. For example,http://<servername>/images/image1.jpg. For a report published to a report server configured in SharePoint integrated mode, use a fully qualified URL. For example,http://<SharePointservername>/<site>/Documents/images/image1.jpg.
For more information, see:
http://msdn2.microsoft.com/en-us/library/ms156482.aspx
Thanks.
Monday, March 19, 2012
image control file share
I need to add an image in a report, the images are stored on a file share, i
get the path to the image from a database.
How do I set the image control properties to read from the file share. I
tried setting the Source as External and then put the unc path in the Value
property. But that did not work.
MikeHave you considered storing the images in your database? You could use a
varbinary field. It's easier to manage pictures that way IMOHO. And it works
really well in SSRS.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike Read" <mread@.brunsco.net> wrote in message
news:OovejNEOIHA.2064@.TK2MSFTNGP06.phx.gbl...
>I need to add an image in a report, the images are stored on a file share,
>i get the path to the image from a database.
> How do I set the image control properties to read from the file share. I
> tried setting the Source as External and then put the unc path in the
> Value property. But that did not work.
> Mike
>|||This is not possible since the program that controls the images is a 3rd
party program that I have no control over.
Mike
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:%23zVGlUEOIHA.5472@.TK2MSFTNGP04.phx.gbl...
> Have you considered storing the images in your database? You could use a
> varbinary field. It's easier to manage pictures that way IMOHO. And it
> works really well in SSRS.
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Mike Read" <mread@.brunsco.net> wrote in message
> news:OovejNEOIHA.2064@.TK2MSFTNGP06.phx.gbl...
>>I need to add an image in a report, the images are stored on a file share,
>>i get the path to the image from a database.
>> How do I set the image control properties to read from the file share. I
>> tried setting the Source as External and then put the unc path in the
>> Value property. But that did not work.
>> Mike
>|||On Dec 6, 3:04 pm, "Mike Read" <mr...@.brunsco.net> wrote:
> I need to add an image in a report, the images are stored on a file share, i
> get the path to the image from a database.
> How do I set the image control properties to read from the file share. I
> tried setting the Source as External and then put the unc path in the Value
> property. But that did not work.
> Mike
I believe that you have to use the "file:///" prefix in the URL in
order to tell the browser to pull from the local drives.
-- Scott|||Thanks, that did it.
Mike
"Orne" <polysillycon@.yahoo.com> wrote in message
news:7c55daf5-2958-4c82-a961-462e9f35746c@.i12g2000prf.googlegroups.com...
> On Dec 6, 3:04 pm, "Mike Read" <mr...@.brunsco.net> wrote:
>> I need to add an image in a report, the images are stored on a file
>> share, i
>> get the path to the image from a database.
>> How do I set the image control properties to read from the file share. I
>> tried setting the Source as External and then put the unc path in the
>> Value
>> property. But that did not work.
>> Mike
> I believe that you have to use the "file:///" prefix in the URL in
> order to tell the browser to pull from the local drives.
> -- Scott
get the path to the image from a database.
How do I set the image control properties to read from the file share. I
tried setting the Source as External and then put the unc path in the Value
property. But that did not work.
MikeHave you considered storing the images in your database? You could use a
varbinary field. It's easier to manage pictures that way IMOHO. And it works
really well in SSRS.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike Read" <mread@.brunsco.net> wrote in message
news:OovejNEOIHA.2064@.TK2MSFTNGP06.phx.gbl...
>I need to add an image in a report, the images are stored on a file share,
>i get the path to the image from a database.
> How do I set the image control properties to read from the file share. I
> tried setting the Source as External and then put the unc path in the
> Value property. But that did not work.
> Mike
>|||This is not possible since the program that controls the images is a 3rd
party program that I have no control over.
Mike
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:%23zVGlUEOIHA.5472@.TK2MSFTNGP04.phx.gbl...
> Have you considered storing the images in your database? You could use a
> varbinary field. It's easier to manage pictures that way IMOHO. And it
> works really well in SSRS.
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Mike Read" <mread@.brunsco.net> wrote in message
> news:OovejNEOIHA.2064@.TK2MSFTNGP06.phx.gbl...
>>I need to add an image in a report, the images are stored on a file share,
>>i get the path to the image from a database.
>> How do I set the image control properties to read from the file share. I
>> tried setting the Source as External and then put the unc path in the
>> Value property. But that did not work.
>> Mike
>|||On Dec 6, 3:04 pm, "Mike Read" <mr...@.brunsco.net> wrote:
> I need to add an image in a report, the images are stored on a file share, i
> get the path to the image from a database.
> How do I set the image control properties to read from the file share. I
> tried setting the Source as External and then put the unc path in the Value
> property. But that did not work.
> Mike
I believe that you have to use the "file:///" prefix in the URL in
order to tell the browser to pull from the local drives.
-- Scott|||Thanks, that did it.
Mike
"Orne" <polysillycon@.yahoo.com> wrote in message
news:7c55daf5-2958-4c82-a961-462e9f35746c@.i12g2000prf.googlegroups.com...
> On Dec 6, 3:04 pm, "Mike Read" <mr...@.brunsco.net> wrote:
>> I need to add an image in a report, the images are stored on a file
>> share, i
>> get the path to the image from a database.
>> How do I set the image control properties to read from the file share. I
>> tried setting the Source as External and then put the unc path in the
>> Value
>> property. But that did not work.
>> Mike
> I believe that you have to use the "file:///" prefix in the URL in
> order to tell the browser to pull from the local drives.
> -- Scott
Subscribe to:
Posts (Atom)