I don't care much for that "expensive" solution for creating crosstab reports. I use the solution at http://www.rogersaccesslibrary.com/forum/cross-tab_topic11.html which is more flexible and efficient.
"This Access 97 mdb demonstrates how to create a report from a crosstab query where the column headings will not be known until run-time. The report will accomodate any number of columns with extra columns "wrapping" under the first set of columns.
This type of report could be used to display salesperson orders and dates as row headings and customers as column headings. The method I developed will dynamically create columns to match each different salesperson. If a salesperson has 2 or 20, the report will accommodate them all. This method runs fairly quickly and requires only about 20 lines of code."
I haven't tried this with Access 2010 but it should work just as well. If you need me to convert the file and post it in the files section.
Duane Hookom
MS Access MVP
> To: MS_Access_Professionals@yahoogroups.com
> From: ozairkhalid@hotmail.com
> Date: Mon, 13 Aug 2012 06:18:20 +0000
> Subject: [MS_AccessPros] CrossTab Query in 2010 [ report extremely slow on watermark image]
>
>
> Hi,
>
> I created a report in Access 2003 which is based on http://support.microsoft.com/kb/328320
>
> The report runs on a reasonably good speed at Access 2003 and Access 2007. But it is stalled when it runs on Access 2010.
>
> Detail...
> I need to use an image as watermark. Code from Microsoft's above example shows ZEROS when the current textbox is empty.
>
> I want to hide those ZEROS from the watermark image.
>
> So I wrote this...
>
> Private Sub Detail1_Format(Cancel As Integer, FormatCount As Integer)
>
> '*** to hide ZEROS on water marked logo starts
> If Me("Col1") < 1 Then
> Me("Col1").Visible = False
> Else
> Me("Col1").Visible = True
> End If
> '*** to hide ZEROS on water marked logo ends
>
> ' I have 26 columns -
> In short, the report runs good on 2003/2007 but fails in 2010.
> it works good if the above code is removed.
>
> Can someone help me with this?
>
> Best,
> Ozair
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar