Showing posts with label map. Show all posts
Showing posts with label map. Show all posts

Monday, March 19, 2012

Google Maps

Has anybody tried to display a Google Map inside a report using Reporting
Services?
Thank you,
Alain Quesnel
alainsansspam@.logiquel.comOn Jun 26, 9:43 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
wrote:
> Has anybody tried to display a Google Map inside a report using Reporting
> Services?
> Thank you,
> Alain Quesnel
> alainsanss...@.logiquel.com
You could add a textbox control to the report and give it a string
value and set it to a Google Maps URL (via: right-click the textbox
contol -> select Properties -> Navigation -> Jump to URL:). Hope this
is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant|||I'm already doing that, thanks. It's fine for a pdf file or for viewing the
report online. But once it's printed, thank link is no longer useful. I was
hoping to do something similar to a Windows app or a web page that has a
Google map frame in it.
Thanks,
Alain Quesnel
alainsansspam@.logiquel.com
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1183083791.675971.61680@.k79g2000hse.googlegroups.com...
> On Jun 26, 9:43 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
> wrote:
>> Has anybody tried to display a Google Map inside a report using Reporting
>> Services?
>> Thank you,
>> Alain Quesnel
>> alainsanss...@.logiquel.com
>
> You could add a textbox control to the report and give it a string
> value and set it to a Google Maps URL (via: right-click the textbox
> contol -> select Properties -> Navigation -> Jump to URL:). Hope this
> is helpful.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Friday, March 9, 2012

good matrix tutorial

Does anyone know of a good matrix tutorial which shows a finished report and how the choices for Page, Columns, Rows, and Details map to a finished report? Having a tough time wrapping my head around the direct impact, and for whatever reason, my sample data keeps triggering an "Out of memory" during preview mode.

Hello,

I don't know of any third party tutorials specifically, but have you seen the Books Online topic about Matrices?:

http://msdn2.microsoft.com/en-us/library/ms157334.aspx

Also, the AdventureWorks sample report "Company Sales" has a simple example of a matrix with nested toggleable groups on both rows and columns.

With regard to your Out of Memory error... how many rows are being returned from your DataSet?

If you have any specific questions, feel free to post them here.

-Chris

|||

I'm experiencing this out of memory error too: I have one database which I can connect to, which gives me around 300 rows, and that's fine. However, another database which returns around 6000 rows throws an out of memory exception when I try to run the report.

I'm guessing that a matrix report has to load all the data in to an internal list, and this is causing the problem. Seems a bit of a weakness to me though: for my application, most of our clients are likely to produce a large number of rows for this report, so I'll have to come up with another solution (or a different report).

Does anyone know if there is any way to change the memory available to the report? It would be nice to have an idea of how much is required, too.

good matrix tutorial

Does anyone know of a good matrix tutorial which shows a finished report and how the choices for Page, Columns, Rows, and Details map to a finished report? Having a tough time wrapping my head around the direct impact, and for whatever reason, my sample data keeps triggering an "Out of memory" during preview mode.

Hello,

I don't know of any third party tutorials specifically, but have you seen the Books Online topic about Matrices?:

http://msdn2.microsoft.com/en-us/library/ms157334.aspx

Also, the AdventureWorks sample report "Company Sales" has a simple example of a matrix with nested toggleable groups on both rows and columns.

With regard to your Out of Memory error... how many rows are being returned from your DataSet?

If you have any specific questions, feel free to post them here.

-Chris

|||

I'm experiencing this out of memory error too: I have one database which I can connect to, which gives me around 300 rows, and that's fine. However, another database which returns around 6000 rows throws an out of memory exception when I try to run the report.

I'm guessing that a matrix report has to load all the data in to an internal list, and this is causing the problem. Seems a bit of a weakness to me though: for my application, most of our clients are likely to produce a large number of rows for this report, so I'll have to come up with another solution (or a different report).

Does anyone know if there is any way to change the memory available to the report? It would be nice to have an idea of how much is required, too.