I need to produce a dynamic report using a database in vs.net (vb).
Up until now I have used Crystal Reports, but in my particular case it is not working as I need it to and I am beginning to get frustrated.
The report includes multiple images held in a database as well as utilising multiple tables from various databases.
I have found from various reseach that the only way to get an image into cr.net (the version I have anyway) is to connect a database and use a blob field.
I would prefer to design the report in advance with textboxes, tables, etc and then control the data transfer myself. ie. in textbox1 put this text using this font. display this picture in picturebox1 and this picture in picturebox2.
You CAN do this with text in cr.net but I have never found a method to do this with graphics (perhaps someone can help?). I also have many times where a report can become disfunctional and no amount of reconnecting databases or clearing fields can save it. The only alternative is to start the report from scratch.
My question is...can anyone suggest an alternative method or product that would help me achieve such a report? The report needs to be printed onto A4 or A5 (preset) and I do not wish to use Word, etc. I would prefer it to be intergrated with visual studio.
Any help would be appreciated.
Up until now I have used Crystal Reports, but in my particular case it is not working as I need it to and I am beginning to get frustrated.
The report includes multiple images held in a database as well as utilising multiple tables from various databases.
I have found from various reseach that the only way to get an image into cr.net (the version I have anyway) is to connect a database and use a blob field.
I would prefer to design the report in advance with textboxes, tables, etc and then control the data transfer myself. ie. in textbox1 put this text using this font. display this picture in picturebox1 and this picture in picturebox2.
You CAN do this with text in cr.net but I have never found a method to do this with graphics (perhaps someone can help?). I also have many times where a report can become disfunctional and no amount of reconnecting databases or clearing fields can save it. The only alternative is to start the report from scratch.
My question is...can anyone suggest an alternative method or product that would help me achieve such a report? The report needs to be printed onto A4 or A5 (preset) and I do not wish to use Word, etc. I would prefer it to be intergrated with visual studio.
Any help would be appreciated.